Citus Newsletter

Good news: PostgreSQL expert Dimitri Fontaine joins Citus Data

So this month we announced that Dimitri Fontaine is JOINing our team. Dimitri is a Major Contributor to the PostgreSQL development project and has authored (and still maintains) key components in the PostgreSQL ecosystem, including the extension framework that Citus uses. We look forward to scaling out with Dimitri! :)
Why we’re so happy about this  →  

Creating a scalable time series database with Postgres, pg_partman, & Citus

With Postgres 10 came native time partitioning, and because Citus is an extension to Postgres that means anyone using Citus gets to take advantage of time-based partitioning as well. You can now create tables that are distributed across nodes by ID and partitioned by time on disk.
Read the pg_partman post  →  

All the things in Citus 7.2: distributed Postgres w/CTEs & complex subqueries

7.2 is the latest release of our extension to Postgres. If you care about Common Table Expressions, complex subqueries, set operations, joins between distributed and local tables, pg_partman… then this announcement from our CTO is right up your alley.
Read Ozgun’s Citus 7.2 announcement   →

10 most-read Citus Data blog posts last year

Out of the 47 new posts we published last year, posts on sharding were super popular. But other topics made the cut too, including Rails and multi tenant applications, complex SQL queries, distributed deadlocks, and of course our post on how to scale out PostgreSQL on AWS.
Did your favorite make the list?   →  

Database sharding explained in plain English

In building Citus, we’ve picked up a thing or two about sharding. And our engineers are often asked to walk people through what sharding is, and how it works. Here’s how Craig explains it. In plain English.
More about database sharding   →  

Multi-tenant web applications with ASP.NET Core & Postgres

ASP.NET Core is open source, cross-platform, and runs anywhere you need it to: Windows, Mac, Linux, Docker. Guest blogger Nate Barbettini shows us a way to scale your multi-tenant app with ASP.NET.
Read Nate Barbettini’s guest post   →  

Building HIPAA-compliant applications with Citus Cloud & Postgres

Some good news: you can now use our database as a service, Citus Cloud, to manage protected health information (PHI) and to build HIPAA-compliant applications on top of Postgres.
About Citus Cloud and HIPAA   →  

New on our website, all about multi-tenant apps

Our designers and product people recently redesigned our Use Case pages, including this page about using Citus for multi tenant applications. See what you think—and if you’re a fan, please tell your friends so more developers know about Citus. :)
Take a peek   →  

ICYMI: Building real-time analytics dashboards w/ Postgres & Citus

More and more, developers are using the Citus database to power customer-facing, real-time analytics dashboards, even when dealing with billions of events per day. Especially when they have to deliver sub-second responses to a large number of concurrent users. See why.
Building real-time analytics dashboards   →  

Overheard in January

• 8 observations about Postgres

• Tapoueh.org: Working at Citus Data

• HackerNoon: Five data models for sharding and which is right

• ICYMI: Why old-school Postgres is so hip again

• Q&A on Twitter: What’s your favorite hidden gem in Postgres?

Is Citus right for you?

Want to explore whether Citus is right for you and your use case ? Learn more about the Citus product , check out the documentation , or let us know if you want to book a demo .