​​Just Use Postgres for Everything:

▪️ Redis -> Postgres with UNLOGGED tables and TEXT as a JSON
▪️ Kafka -> Postgres with SKIP LOCKED
▪️ MongoDB -> Postgres with JSONB
▪️ ElasticSeacrh -> Postgres
▪️ Data warehouse -> Postgres with Timescale
▪️ Analytics -> Postgres with pg_analytics
▪️ CRON -> Postgres with pg_cron
▪️ Geospacial -> Postgres with PostGIS
▪️ Audit -> Postgres with pgaudit
▪️ GraphQL -> Postgres with a GraphQL adapter

https://www.amazingcto.com/postgres-for-everything/

#PostgreSQL

Релиз PostgreSQL 17 на AWS:

https://aws.amazon.com/about-aws/whats-new/2024/09/postgresql-170-amazon-rds-database-preview-environment/

Спустя 6 часов после официального анонса:

https://www.postgresql.org/about/news/postgresql-17-released-2936/

Что нового в 17-й версии:

▫️ up to 20x less memory for Vacuum
▫️ up to 2x better write I/O for highload
▫️ JSON Support 👇
▪️ JSON_TABLE - сonvert JSON data into standard PostgreSQL tables
▪️ New functions JSON, JSON_SCALAR, JSON_SERIALIZE, JSON_EXISTS, JSON_QUERY, JSON_VALUE
▫️ sslnegotiation option for direct TLS handshakes using ALPN
▫️ pg_basebackup now supports incremental backups

#PostgreSQL

🆕 Aurora PostgreSQL + Local write forwarding

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-postgresql-write-forwarding.html

With write forwarding, your applications can simply send both read and write requests to a read replica, and Aurora will take care of forwarding the write requests to the writer instance in your cluster.

#Aurora #PostgreSQL

PostgreSQL 18 on AWS 🎉

https://aws.amazon.com/about-aws/whats-new/2025/09/postgresql-180-amazon-rds-database-preview-environment/

https://www.postgresql.org/about/news/postgresql-18-released-3142/

- AIO (Asynchronous I/O
- virtual/generated columns
- OAuth2/SSO support

⚠️ page checksums enabled by default (use --no-data-checksums option when using pg_upgrade).

#RDS #PostgreSQL