The goal of this repository made by Daniel Olshansky is to demonstrate how to use Postgres for everything. Topics include: Blog Posts & Articles, Cron Jobs, Embeddable Postgres, Message Queues, Analytics, GIS & Mapping, Audit Logs, Access Control & Authorization, Search, Time Series, Column Oriented, NoSQL, Graph Data, Foreign Data, HTTP, API Platforms, GraphQL and Alternative Query Languages, Events, Replication, CDC, Caching, Unit Tests, HTML & Applications, Migrations, Performance Tuning, Monitoring, Scaling & Storage, User Interfaces & Dashboards, Visualization, Package Management, Language Servers,Data Privacy & Security (or Data Masking)

SQL tips and tricks. Contribute to ben-n93/SQL-tips-and-tricks development by creating an account on GitHub.

Evidence is an open source, code-based alternative to drag-and-drop BI tools. Build polished data products with just SQL and markdown.

Detailed descriptions of the terms you’ll come across when using Postgres EXPLAIN, as well as performance advice and links to further reading.

A guide to Postgres roles and privileges

A really excellent educational document from Greg Wilson for folks who wanna learn sql.

Squel is a compact, lightweight Javascript library for building SQL query strings, usable with node.js or in the browser.

Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more. Featuring solid transaction support, relations, eager and lazy loading, read replication and more.