PostgreSQL

PostgreSQL

https://www.postgresql.org/

Overview

• https://webapp.io/blog/postgres-is-the-answer/
• https://rbranson.medium.com/10-things-i-hate-about-postgresql-20dbab8c2791
• https://www.shayon.dev/post/2022/17/why-i-enjoy-postgresql-infrastructure-engineers-perspective/

Development Tools

• https://www.pgadmin.org/
• https://atlasgo.io/
• https://dbschema.com/
• https://www.postgrescompare.com/

Internals

https://www.interdb.jp/pg/index.html

Indexing

• https://blog.crunchydata.com/blog/postgres-indexes-for-newbies

Searching

• https://www.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database

Tuning/Admin/Tips

• https://blog.crunfive-tips-for-a-healthier-postgres-database-in-the-new-year
• https://www.shayon.dev/post/2022/17/why-i-enjoy-postgresql-infrastructure-engineers-perspective/

hierarchical-structures

• https://hoverbear.org/blog/postgresql-hierarchical-structures/

Timezones

• https://blog.yugabyte.com/postgresql-timestamps-timezones/

Spatial Data

• https://www.sqlshack.com/getting-started-with-spatial-data-in-postgresql/

Rest API

• https://github.com/PostgREST/postgrest
• https://www.tutlinks.com/fastapi-with-postgresql-crud-async/
• https://github.com/tjoudrey/JavaRESTcli

GraphQL

• https://supabase.com/blog/2021/12/03/pg-graphql

Machine Learning

• https://postgresml.org/ - Train and deploy models to make online predictions using only SQL, with an open source extension for Postgres
• https://www.crunchydata.com/blog/recommendation_engine_in_postgres_with_pandas_and_python