On: The data model behind Notion's flexibility

[burlesona]

Very interested in your data store. How do you store, query, and search across documents?

Also, are you adding presentational tables any time soon? :)

[jitl → burlesona]

Our source-of-truth data store is Postgres, with a Memcached cache on top.

Most of our queries are "pointer chasing" - we follow a reference from one record in memory to fetch another record from the data store. To optimize recursive pointer-chasing queries, we cache the set of visited pointers in Memcached.

We use Elasticsearch for search features like QuickFind.

> Also, are you adding presentational tables any time soon? :)

Sorry, can't talk about future plans like that :)