Databases
Homepage / Notes / Computer Science / Databases
All
CLI tools
SQLite
CLI tool
https://www.sqlite.org/cli.html
JSON
https://www.sqlite.org/json1.html
Session Extension
https://www.sqlite.org/sessionintro.html
Generated columns
https://antonz.org/generated-columns/
Litestream
https://litestream.io/ https://fly.io/blog/all-in-on-sqlite-litestream/
CSV
Query CSVs in one line
https://til.simonwillison.net/sqlite/one-line-csv-operations
Import CSV into a SQLite table
https://www.sqlitetutorial.net/sqlite-import-csv/
Export SQLite table to CSV
https://www.sqlitetutorial.net/sqlite-export-csv/
MySQL
Vitess
A database clustering system for horizontal scaling of MySQL
Managed
PostgreSQL
https://www.narrator.ai/blog/using-postgresql-as-a-data-warehouse/
Citext: https://www.postgresql.org/docs/9.1/citext.html Lowercase values. Useful for comparing emails for example.
Supabase
Realtime
Listen to your to PostgreSQL database in realtime via websockets. Built with Elixir. https://github.com/supabase/realtime
Edge Functions
https://supabase.com/edge-functions
PostgresML
https://postgresml.org/ End-to-end machine learning solution. Train and deploy industry-standard or completely custom machine learning models, directly powered by your business data, into your production stack, with an open source Postgres extension.
Neon
Serverless Postgres The multi-cloud fully managed Postgres with a generous free tier. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
Resources
DuckDB
Can directly query CSV and Parquet files.
Can be compiled with wasm and be used directly in the browser. https://duckdb.org/2021/10/29/duckdb-wasm.html
Useful for data analysis. https://duckdb.org/2021/05/14/sql-on-pandas.html
Harlequin
A drop-in replacement for the DuckDB CLI.
Datalog
Datalog is a declarative logic programming language that syntactically is a subset of Prolog. It is often used as a query language for deductive databases.
Redis
https://redis.io/ "The open source, in-memory data store used by millions of developers as a database, cache, streaming engine, and message broker."
Dragonfly
https://github.com/dragonflydb/dragonfly Faster Redis?
GraphQL
A query language for your API
gqt
https://github.com/eerimoq/gqt
Build and execute GraphQL queries in the terminal.
FerretDB
A truly Open Source MongoDB alternative, built on PostgreSQL, and released under the Apache 2.0 license.
Vector Databases
https://www.pinecone.io/learn/vector-database/
Resources
Things You Should Know About Databases
https://architecturenotes.co/things-you-should-know-about-databases/