Awesome Databases

Curating awesome database resources.

Resource

• Mastering Postgres indexes in 10 minutes
• country states database

Answers

• find the nearest location by latitude and longitude in postgresql
• change postgres enum type

ORM

• prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)

Offline

• rxdb - 🔄 A realtime Database for JavaScript Applications
• couchdb - Seamless multi-master syncing database with an intuitive HTTP/JSON API, designed for reliability
• localforage - 💾 Offline storage, improved. Wraps IndexedDB, WebSQL, or localStorage using a simple but powerful API.
• kinto - An Offline-First JavaScript Client for Kinto.
• puchdb - 🐨 - PouchDB is a pocket-sized database.

Tools

• sqlite playgound
• supabase/postgres - Unmodified Postgres with some useful plugins

Sqlite

• Sqllite httpvfs - Query Sqlite with static files
• Litestream - Streaming replication for SQLite.

Version

• Dolt - Dolt – It's Git for Data