Skip to content

postgresql

10 pages
  • Mooncake is joining Databricks!

    By Mooncake Labs, Zhou Sun, Cheng Chen, Pranav Aurora In Engineering 433 words 3 min

    Mooncake LabsZhou SunCheng ChenPranav Auroraannouncementpg_mooncakelakehousepostgresql

    Mooncake is joining Databricks!

    Thirteen months ago, we started Mooncake to bring the data intelligence stack that powers giants like OpenAI to every vibe-coded app and developer. From first prompt to IPO. Today, we’re joining forces with Databricks. The mission continues: make …

    Thirteen months ago, we started Mooncake to bring the data intelligence stack that powers giants like OpenAI to every vibe-coded app and developer. From first prompt to IPO. Today, we’re joining forces with Databricks. The mission continues: make …

  • but, my Postgres (+ lakehouse) is free

    By Zhou Sun In Engineering 707 words 4 min

    Zhou Sunpostgresqliceberglakehousepg_mooncake

    but, my Postgres (+ lakehouse) is free

    Disclaimer: Your Postgres and Lakehouse are free and open too. You don’t need to be (or spend like) a giant to use them. Why Postgres + Lakehouse? Reason #1: If you believe in AI, this is the agent stack Agents need memory. Both working memory and …

    Disclaimer: Your Postgres and Lakehouse are free and open too. You don’t need to be (or spend like) a giant to use them. Why Postgres + Lakehouse? Reason #1: If you believe in AI, this is the agent stack Agents need memory. Both working memory and …

  • HTAP is Dead

    By Zhou Sun In Engineering 937 words 5 min

    Zhou Sunhtaplakehousepostgresqlmusings

    HTAP is Dead

    This blog is inspired by Jordan Tigani’s blog titled “Big Data is Dead”. Jordan and I actually spent some time building an HTAP database at SingleStore. The good old days (’80s) Back in the ’80s, one relational database did everything. Transactions …

    This blog is inspired by Jordan Tigani’s blog titled “Big Data is Dead”. Jordan and I actually spent some time building an HTAP database at SingleStore. The good old days (’80s) Back in the ’80s, one relational database did everything. Transactions …

  • What does Analytics in Postgres really mean?

    By Zhou Sun In Engineering 771 words 4 min

    Zhou Sunpostgresqlpg_mooncakeanalyticsmusings

    What does Analytics in Postgres really mean?

    Few areas in databases are hotter right now than extending Postgres to support analytics queries. This isn’t a particularly novel area either –– there have been plenty of attempts in the last decade: Here is what it means to our customers –– and why …

    Few areas in databases are hotter right now than extending Postgres to support analytics queries. This isn’t a particularly novel area either –– there have been plenty of attempts in the last decade: Here is what it means to our customers –– and why …

  • Clickbench says Postgres is a great analytics database

    By Zhou Sun In Engineering 423 words 2 min

    Zhou Sunpg_mooncakebenchmarkpostgresqlduckdb

    Clickbench says Postgres is a great analytics database

    TL;DR: We spent a few months optimizing PostgreSQL and made it to the Top 10 on ClickBench, a benchmark typically dominated by specialized analytics databases. What’s more, all compute is within Postgres, and all tables are managed directly by …

    TL;DR: We spent a few months optimizing PostgreSQL and made it to the Top 10 on ClickBench, a benchmark typically dominated by specialized analytics databases. What’s more, all compute is within Postgres, and all tables are managed directly by …

  • pg_mooncake 🤝 drizzle: typed SDKs for your analytic workloads

    By Pranav Aurora In Engineering 392 words 2 min

    Pranav Aurorapostgresqlpg_mooncakeanalyticsdrizzle

    pg_mooncake 🤝 drizzle: typed SDKs for your analytic workloads

    A thing that surprised us in the pg_mooncake launch was how much developers cared about ORMs for their analytical workloads. We saw two typical requests: “I have a bunch of Parquet files. I want full ORM support over them.” “I use Drizzle/Prisma for …

    A thing that surprised us in the pg_mooncake launch was how much developers cared about ORMs for their analytical workloads. We saw two typical requests: “I have a bunch of Parquet files. I want full ORM support over them.” “I use Drizzle/Prisma for …

  • pg_mooncake + Neon: serverless analytics in Postgres

    By Pranav Aurora In Engineering 449 words 3 min

    Pranav Aurorapostgresqlpg_mooncakeanalyticslakehouse

    pg_mooncake + Neon: serverless analytics in Postgres

    pg_mooncake launched in beta two months ago. It adds columnar storage and a vectorized engine to Postgres. Over the last two months, with our customers, we’ve realized we accidentally built the best serverless database for analytics. Here’s the …

    pg_mooncake launched in beta two months ago. It adds columnar storage and a vectorized engine to Postgres. Over the last two months, with our customers, we’ve realized we accidentally built the best serverless database for analytics. Here’s the …

  • pg_mooncake: Fast Analytics in Postgres with Columnstore Tables and DuckDB

    By Cheng Chen In Engineering 798 words 4 min

    Cheng Chenpostgresqlduckdbpg_mooncakeiceberg

    pg_mooncake: Fast Analytics in Postgres with Columnstore Tables and DuckDB

    pg_mooncake brings columnstore tables with DuckDB execution to Postgres for fast analytics. It supports transactional inserts, updates, and deletes, just like regular Postgres tables. Data is written with Delta Lake (and Apache Iceberg in v0.2+) …

    pg_mooncake brings columnstore tables with DuckDB execution to Postgres for fast analytics. It supports transactional inserts, updates, and deletes, just like regular Postgres tables. Data is written with Delta Lake (and Apache Iceberg in v0.2+) …

  • Mooncake: next-gen search and analytic systems

    By Mooncake Labs, Zhou Sun, Cheng Chen, Pranav Aurora In Engineering 667 words 4 min

    Mooncake LabsZhou SunCheng ChenPranav Auroralaunchpostgresqlpg_mooncakelakehouse

    Mooncake: next-gen search and analytic systems

    We are Zhou, Cheng, and Pranav. And we’ve spent the last decade building databases at MemSQL (now SingleStore). We love complex systems, deep-tech engineering, and naturally – physics 🙂 Data systems, much like physics, are built on certain …

    We are Zhou, Cheng, and Pranav. And we’ve spent the last decade building databases at MemSQL (now SingleStore). We love complex systems, deep-tech engineering, and naturally – physics 🙂 Data systems, much like physics, are built on certain …

  • Things we learnt

    By Pranav Aurora In Engineering 446 words 3 min

    Pranav Aurorapostgresqlicebergmusings

    Things we learnt

    The title should really be “Things we learnt, the hard way”. As we start this new journey, we spent some time thinking about the axioms of data today. These are things we (or no one for that matter) can dispute. 1. If Postgres can do it, Postgres …

    The title should really be “Things we learnt, the hard way”. As we start this new journey, we spent some time thinking about the axioms of data today. These are things we (or no one for that matter) can dispute. 1. If Postgres can do it, Postgres …