This post provides SQLite DB resources. (Check here for other DB resources.)
This post provides resources about PostgreSQL DB. (Check here for other DB resources.)
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.
PostgreSQL psql Commands:
The primary front-end for PostgreSQL is the
psql command-line program, which can be used to enter SQL queries directly, or execute them from a file. In addition, psql provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks; for example tab completion of object names and SQL syntax.
- 17 Practical psql Commands That You Don’t Want To Miss (PDF)
- PostgreSQL command line cheatsheet (psql part PDF)
- Psql and commonly used commands on Postgres Guide — PDF
PostgreSQL with JSON:
- Unleash the Power of Storing JSON in Postgres (2018-02-27
by Leigh Halliday) — PDF
- PostgreSQL JSON (postgresqltutorial.com) — PDF
- Fast CSV and JSON Ingestion in PostgreSQL with COPY (April 03, 2018) — PDF
This post provides resources to DBs.
- Postgres vs. MongoDB for Storing JSON Data – Which Should You Choose? (November 22, 2017) — PDF