-
I love postgres for most things but these days (Especially while my product is in development, embedded, or just not internet-facing) sqlite is amazingly workable.
Killer postgres features however: Row-level security (Amazing when you're using something like postgrest for rapid application development [1]), and its built in fulltext search engine is 'good enough' for use cases like when you have an enormous users table and need to index something simple enough, like email addresses for quick login.
[1] https://postgrest.org/
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
-
Messaging is the first use-case given by the Kafka docs [1] and is the first core capability they mention on the Kafka landing page [2].
1. https://kafka.apache.org/documentation/#uses_messaging
2. https://kafka.apache.org/
I think use (and think of) Kafka as a message bus, with distributed commit logging being the mechanism for how it accomplishes that task.
-
My favorite route right now is running a postgres operator on Kubernetes & letting it do all the work for me.
Zalando's operator use Patroni under the hood, to create a cluster over streaming replication. It also has Spilo, which orchestrates pg_basebackup or WAL-E for point-in-time backup. https://github.com/zalando/postgres-operator#postgresql-feat...
CrunchyData operator seems to have built their own streaming replication system coordinated by Raft. https://access.crunchydata.com/documentation/postgres-operat...
-
As always: it depends. For some workloads something like Citus [1] might allow you stay within the PostgreSQL ecosystem even when you are trying to do OLAP.
[1] https://github.com/citusdata/citus
-
-
postgresql handles queues well. the trick is skip lock.
https://github.com/jmscott/talk/blob/master/ams-pgopen-20150...
-
Stream
Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.