🐘 Database

[nichoth]

database

SQL

• CockroachDB
• Neon

---

• Why SQLite? Why Now? 🐇

---

• ImmortalDB — a resilient key-value store for the browser
• Verdant — An IndexedDB-powered database and data sync solution for sustainable, human, local-first web apps.
• CozoDB — A transactional, relational-graph-vector database that uses Datalog for query.
  • github
• Fireproof — Live database for the web
• convex

---

• Electric SQL — Build reactive, realtime, local-first apps directly on Postgres.
• PartyKit, meet TinyBase
• tinybase demo

TinyBase, a reactive data store for local-first apps. It lets you store structured data and application state in memory, and provides a reactive UI so that you can build fast web experiences that work both online and offline.

This integration allows you to enjoy the benefits of both a “local-first” architecture and a “sharing-first” platform.

---

• simple-graph

---

neon

• Change Data Capture with Serverless Postgres — Change Data Capture with Serverless Postgres. Announcing Logical Replication in Neon

the nile

• nile — Serverless Postgres for modern SaaS

cache

• polyscale

[nichoth]

data structures

• magma

• itsy-bitsy-data-structures.js

• Bikeshedding my DAG feed format
  tldr — keep metadata separate from content. This is good because we can encrypt the content — see @ssc-half-light/post for something similar using encryption.

  ---

• CRDTs for Non Academics — A nice youtube explanation.

• An Interactive Intro to CRDTs

  operation-based CRDTs impose constraints on the communication channel: messages must be delivered exactly once, in causal order, to each peer.

  There are also delta CRDTs, or hybrid CRDTs, which allow peers to negotiate the subset of the state they need to send each other. That’s one example of blending operation-based and state-based CRDTs. But the fundamental tradeoff remains: sending less data between peers means more constraints on communication.

[nichoth]

"streams"

• WarpStream — Apache Kafka® compatible data streaming platform built directly on top of object storage
• Arroyo — Transform, filter, aggregate, and join streams using SQL
• Digital Ocean + Kafka article
• Aiven for Apache Kafka — "Apache Kafka managed service, deployed in the cloud of your choice with a full set of capabilities to build your event-driven architecture and streaming data pipelines."