rcmnd

NotionCompany

Connected workspace for notes, docs and projects

6 things

SnowflakeService

liked

We’ll continue to benefit from Snowflake’s operational and ecosystem ease by using it for most other workloads, particularly those that are insert-heavy and don’t require large-scale denormalized tree traversal.

Notion on keeping Snowflake alongside its new data lake

notion.com ↗·2024-07-01Wrong?

SQLiteSoftware

recommended

Using SQLite improved page navigation times by 20 percent in all modern browsers.

Notion on caching client data with WASM SQLite in the browser

notion.com ↗·2024-07-10Wrong?

PgBouncerSoftware

uses

Between our application web servers and the databases, a proxy layer (PgBouncer) pools connections to the databases.

Notion's database architecture, from its re-shard post

notion.com ↗·2023-07-17Wrong?

PostgreSQLSoftware

mixed

By mid-2020, it was clear that product usage would surpass the abilities of our trusty Postgres monolith, which had served us dutifully through five years and four orders of magnitude of growth.

Notion on its Postgres monolith before sharding it

notion.com ↗·2021-10-06Wrong?

CitusSoftware

mixed

During our initial research, we also considered packaged sharding/clustering solutions such as Citus for Postgres or Vitess for MySQL. While these solutions appeal in their simplicity and provide cross-shard tooling out of the box, the actual clustering logic is opaque, and we wanted control over the distribution of our data.

Notion on why it did application-level sharding instead of Citus

notion.com ↗·2021-10-06Wrong?

FivetranService

disliked

The overhead of monitoring and managing 480 Fivetran connectors, along with re-syncing them during Postgres re-sharding, upgrade, and maintenance periods, became extremely high, creating a significant on-call burden for team members.

Why Notion built its own data lake instead of 480 Fivetran connectors

notion.com ↗·2024-07-01Wrong?

Every entry is a verbatim quote and a link to the public post it came from. Nothing is paraphrased. If it is not on record somewhere public, it is not here.

The verdict is what they actually said: loved and liked are explicit; recommended means they told others to get it; uses means they only say they use it; read is a book on their public shelf with no verdict; mixed and disliked are kept too.

A dashed affiliate link, sponsored or their own label means the post disclosed a relationship. It is shown, never hidden.

The small bar beside a date shows how dated a recommendation is for its kind of thing.

The bar shows how dated a recommendation is, for its kind of thing. Full and green is recent. It drains, and turns amber and then grey, as the post gets older.

What counts as old depends on the thing. A laptop praised four years ago has been replaced twice; a book loved twenty years ago is probably still loved. The bar is empty after about:

A striped bar means the post carries no date and the date shown is an estimate. No date at all, no bar.