Mar 2019 Newsletter from Citus Data (now part of Microsoft)

How to evaluate your next database

Choosing a database isn’t something you do every day. You generally choose it once for a project, then don’t look back. In choosing a database there are a few key things to consider. Here’s a checklist. Spoiler alert, Postgres checks out strongly in each of these categories. Of course!
Read Craig’s post →

Fun with SQL: Text and system functions

Postgres has a rich array of functions to help with converting or formatting data. These built-in functions save you from having to do the logic elsewhere or write your own functions. In other words you have to do less work because Postgres has already done it for you. :-)
More on Postgres text and system functions →

Citus is coming to Azure. Want to stay updated as things happen?

Want to know what’s happening with Citus on Microsoft Azure? We’ve made it easy for you to sign up on our website, so you can stay in the loop, as things happen.
Sign up to join the Citus on Azure interest list →

A new demo: Using Postgres & Citus for lightning fast analytics, also featuring Rollups

In this newest demo—recorded on video—Sai shows how you can use Postgres and Citus to deliver faster response times for analytics queries: He runs queries, creates b-tree and GIN indexes, and this time, he also shows how rollups can speed up your queries.
Watch Sai’s demo on analytics queries →

#Throwback post: Fun with SQL: functions in Postgres

There are several hundred handy functions built into Postgres. Craig walks us through a small sampling of SQL functions that can be extremely handy in PostgreSQL. So, next time you need to perform some operation on data—before you jump to writing a custom function, before you create custom logic in your app—see if Postgres already has your answer.
Deets on functions in Postgres →

With Citus Cloud, ConvertFlow has tracked ~1B visitor interactions

ConvertFlow is tracking data from over 200 million visitors, for nearly 4,000 companies, with up to 40,000+ concurrent visitor sessions. Citus Cloud allows ConvertFlow to continue using Postgres, shard their database by customer, and work with much more RAM. Read their story to see how queries that used to take 15-30+ seconds have been reduced to less than 500 milliseconds.
60X faster query responses →

Postgres news from our new teammates at Microsoft: Azure Data Studio for Postgres

When you are working with a database, your experience can be enhanced or hindered by the tools you use to interact with it. Postgres’s own psql terminal-based front-end, but some people prefer a graphical UI. Microsoft’s Azure Data Studio now has preview-level support for Postgres. Hip Hip.
Read Rachel’s post for more info →

Preventing SQL injections from @tapoueh

Anyone who cares about databases, including databases like Postgres, may want to learn more about SQL injection. Dimitri Fontaine, one of our Citus database engineers, posted this article on preventing SQL injection on his personal blog. We thought you might find it useful.
How to prevent SQL injections with Postgres →

ICYMI: The most useful Postgres extension: pg_stat_statements

In the PostgreSQL devroom at FOSDEM in February, one Postgres extension was recommended over and over: pg_stat statements. If you use Postgres and you haven’t used pg_stat_statements, it’s time to add it to your toolbox. And if you are familiar, maybe it’s worth a revisit.
More about pg_stat_statements →

RailsConf, PyCon, pgDays, and more

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.