FaunaDB was a great fit for our scrappy, fast-turnover, greenfield project. This post breaks down the developer-facing features we loved, and a few cons.
Records may have variable attributes that change over time. To find which variable attributes are effective for a given date, we maintain a few invariants.
It's a common architecture to have PostgreSQL and Redis serve as the backbone of your app, but PostgreSQL may be capable of everything you use Redis for.
If you use iMessage, you can access and query the database where all of the messages are stored. All you need is a Mac and some basic SQL skills to begin!
SQL queries dangerously couple software to the persistence layer. And as they grow in size, they capture more complexity—I've even found myself embedding key business rules.
We run our tool nightly to detect mismatches in records between the two systems. On the surface, this seems like a simple task. But the data structures between the two systems are