This is kind of a genius idea that can make your application extremely fast: Use a CDN for your database. ​ Think of it this way: ​ If the network is slow, cut it and bring the data with you. ​ Let's say you build and host an application in the cloud. Your system... See more

It turns out there's a handy feature in PostgreSQL called row constructor comparisons that allows me to compare tuples of columns. That's exactly what we need. Instead of doing CreateAt > ?1 OR (CreateAt = ?1 AND Id > ?2) , we can do ( CreateAt, Id) > (?1, ?2) . And the row constructor comparisons are lexicographical, meaning that it's... See more

• ClickHouse: It's a high performance columnar database that's great for real time queries. It enables querying and storing large amounts of data on commodity hardware. Some of my customers have millions of page views and I don't have an unlimited budget, so it's been very handy.


• PostgreSQL: My favorite database. Sane defaults, battle-tested, and well

... See more