# PostgreSQL

PostgreSQL is an open-source object-relational database system.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Write End-to-End Tests in Your Backend's Language

DevFeed: [Write End-to-End Tests in Your Backend's Language](<https://devfeed.tech/articles/write-end-to-end-tests-in-your-backend-s-language-41361.md>)

Original publisher: [Read original article](<https://spin.atomicobject.com/write-end-to-end-tests-in-your-backends-language/>)

Author: James McConkey

Published: 2026-09-17T12:00:42Z

Content type: tutorial

Language: en

Sources: [Atomic Object](<https://devfeed.tech/sources/atomic-object.md>)

Topics: [Testing](<https://devfeed.tech/topics/testing.md>), [Playwright](<https://devfeed.tech/topics/playwright.md>), [FastAPI](<https://devfeed.tech/topics/fastapi.md>), [Python](<https://devfeed.tech/topics/python.md>), [test data](<https://devfeed.tech/topics/test-data.md>), [Pydantic](<https://devfeed.tech/topics/pydantic.md>), [SQLAlchemy](<https://devfeed.tech/topics/sqlalchemy.md>), [ASP.NET Core](<https://devfeed.tech/topics/asp-net-core.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Docker Compose](<https://devfeed.tech/topics/docker-compose.md>)

Tags: [asp-net-core](<https://devfeed.tech/tags/asp-net-core.md>), [code](<https://devfeed.tech/tags/code.md>), [data](<https://devfeed.tech/tags/data.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [fastapi](<https://devfeed.tech/tags/fastapi.md>), [playwright](<https://devfeed.tech/tags/playwright.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [project-team-management](<https://devfeed.tech/tags/project-team-management.md>), [python](<https://devfeed.tech/tags/python.md>), [sqlalchemy](<https://devfeed.tech/tags/sqlalchemy.md>), [tests](<https://devfeed.tech/tags/tests.md>), [the-software-life](<https://devfeed.tech/tags/the-software-life.md>)

### AI overview

This article argues that end-to-end test-data setup is often the main design challenge, because tests must create consistent domain records while running alongside other tests. It recommends using browser-testing tools in the backend's language when possible, keeping meaningful relationships inline, and extracting small creation helpers without hiding scenario intent.

### Source excerpt

The browser is often the easiest part of an end-to-end test. Consider a test that verifies a user can complete an overdue task. The visible interaction is small: sign in, find the task, click Complete, and observe the new status. Before any of that can happen, the test needs a workspace, a user, a project, and [...] The post Write End-to-End Tests in Your Backend's Language appeared first on Atomic Spin.

## pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?

DevFeed: [pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?](<https://devfeed.tech/articles/pgbackrest-compression-how-much-cpu-is-a-smaller-backup-worth-35042.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/pgbackrest-compression-how-much-cpu-is-a-smaller-backup-worth/>)

Author: Agustín Gallego

Published: 2026-09-16T21:43:06Z

Content type: comparison

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Compression](<https://devfeed.tech/topics/compression.md>), [Algorithms](<https://devfeed.tech/topics/algorithms.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [postgresql 18](<https://devfeed.tech/topics/postgresql-18.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [algorithms](<https://devfeed.tech/tags/algorithms.md>), [backup](<https://devfeed.tech/tags/backup.md>), [compare](<https://devfeed.tech/tags/compare.md>), [compression](<https://devfeed.tech/tags/compression.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [percona](<https://devfeed.tech/tags/percona.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

This comparison measures pgBackRest compression algorithms and levels on Percona Distribution for PostgreSQL 18.4. It finds that low-level Zstandard offers a favorable balance between CPU use and backup size, with zst(3) near the efficiency curve's shoulder.

### Source excerpt

In this blog post, we'll compare pgBackRest's compression algorithms and levels to find where spending more CPU stops buying a meaningfully smaller backup. The short version of the answer, which we'll build up to with real numbers, is that Zstandard at a low level is the sweet spot, and its default (zst(3)) already sits right ... Continued The post pgBackRest Compression: How Much CPU Is a Smaller Backup Worth? appeared first on Percona.

## Running OpenBao on Kubernetes with a CloudNativePG PostgreSQL backend

DevFeed: [Running OpenBao on Kubernetes with a CloudNativePG PostgreSQL backend](<https://devfeed.tech/articles/running-openbao-on-kubernetes-with-a-cloudnativepg-postgresql-backend-30887.md>)

Original publisher: [Read original article](<https://www.cncf.io/blog/2026/09/16/running-openbao-on-kubernetes-with-a-cloudnativepg-postgresql-backend/>)

Author: Gabriele Bartolini (EnterpriseDB) and CNCF Ambassador, Rob Kenefeck (ControlPlane)

Published: 2026-09-16T11:30:00Z

Content type: tutorial

Language: en

Sources: [Cloud Native Computing Foundation](<https://devfeed.tech/sources/cloud-native-computing-foundation.md>)

Topics: [CloudNativePG](<https://devfeed.tech/topics/cloudnativepg.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [vendor lock-in](<https://devfeed.tech/topics/vendor-lock-in.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [cloudnativepg](<https://devfeed.tech/tags/cloudnativepg.md>), [docker](<https://devfeed.tech/tags/docker.md>), [hashicorp-vault](<https://devfeed.tech/tags/hashicorp-vault.md>), [helm](<https://devfeed.tech/tags/helm.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [linux-foundation](<https://devfeed.tech/tags/linux-foundation.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [secrets](<https://devfeed.tech/tags/secrets.md>), [vendor-lock-in](<https://devfeed.tech/tags/vendor-lock-in.md>)

### AI overview

A tutorial describes deploying OpenBao on Kubernetes with a three-instance CloudNativePG PostgreSQL cluster as its storage backend. It explains certificate-based authentication and a local Kind-based test environment.

### Source excerpt

Managing infrastructure secrets on Kubernetes needs a backend that is self-healing and free of vendor lock-in, and that is exactly what OpenBao (the Linux Foundation's open-source fork of HashiCorp Vault) and CloudNativePG give you: an entirely...

## pgAssistant 3.8.0 : continuous improvement loop for Postgres

DevFeed: [pgAssistant 3.8.0 : continuous improvement loop for Postgres](<https://devfeed.tech/articles/pgassistant-3-8-0-continuous-improvement-loop-for-postgres-30889.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgassistant-380-continuous-improvement-loop-for-postgres-3378/>)

Author: Pgassistant Dev Team

Published: 2026-09-16T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [recommendations](<https://devfeed.tech/topics/recommendations.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [real-time](<https://devfeed.tech/topics/real-time.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [measurements](<https://devfeed.tech/tags/measurements.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [recommendations](<https://devfeed.tech/tags/recommendations.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

pgAssistant 3.8.0 expands the PostgreSQL analysis and tuning tool into a continuous improvement platform. It adds historical workload and environment measurements, compares consecutive collections, tracks recommendations and configuration changes, and helps teams measure changes while distinguishing correlation from causation.

### Source excerpt

With this release, pgAssistant is evolving beyond PostgreSQL analysis and tuning to become a continuous PostgreSQL improvement platform. The new positioning is built around a continuous improvement loop: Observe -> Diagnose -> Prioritize -> Plan -> Implement -> Collect again -> Measure pgAssistant already helped identify what should be improved and turn recommendations into a prioritized Executive Plan with clear DEV and OPS ownership. Combined with pgAssistant Collector, version 3.8.0 goes further by adding historical workload and environment measurements. The objective is to answer four essential questions: What should we improve? What did we decide to do? What did we actually change? What was the result? Workload Insights compares consecutive collections and highlights: new and no-longer-detected recommendations; changes to the PostgreSQL version and configuration; workload evolution by statement type; changes in execution time and call volume; the queries with the greatest impact on the overall workload. The ambition is to correlate the application of pgAssistant recommendations and the Executive Plan with observed performance changes. Correlation is not causation, and a recommendation that is no longer detected does not necessarily prove that it was implemented. pgAssistant keeps these distinctions explicit while bringing the relevant evidence together in one place. pgAssistant is not intended to replace real-time monitoring. Monitoring shows what is happening now; pgAssistant helps teams decide what to improve next, organize the remediation work, and measure what changed afterwards. From recommendations to action--and from action to measurable evidence. pgAssistant 3.8.0: https://github.com/beh74/pgassistant-community pgAssistant Collector: https://github.com/beh74/pgassistant-collector pgAssistant Grafana : https://github.com/beh74/pgassistant-grafana

## Plan Advice in PostgreSQL 19

DevFeed: [Plan Advice in PostgreSQL 19](<https://devfeed.tech/articles/plan-advice-in-postgresql-19-34622.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2026/09/plan-advice-in-postgresql-19/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2026-09-15T16:27:53Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [version](<https://devfeed.tech/topics/version.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Docker Compose](<https://devfeed.tech/topics/docker-compose.md>)

Tags: [analyze](<https://devfeed.tech/tags/analyze.md>), [beta](<https://devfeed.tech/tags/beta.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [pg-plan-advice](<https://devfeed.tech/tags/pg-plan-advice.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

This tutorial explains PostgreSQL 19's pg_plan_advice and pg_stash_advice modules, which represent query-plan decisions as reusable advice and can apply that advice by query ID. It also describes reconstructing comparable plan advice from ordinary plan output on earlier PostgreSQL versions.

### Source excerpt

There is a conversation that happens in every PostgreSQL shop eventually. A query that has been fine for a year gets slow overnight. Nothing was deployed. The data grew a little, ANALYZE ran, and the planner -- entirely reasonably, on the numbers it had -- picked a different plan. The old plan was better. You would like it back. PostgreSQL 19 ships two new modules for exactly this: pg_plan_advice, which can read a plan back out as a string and enforce it later, and pg_stash_advice, which keeps those strings keyed by query id and applies them automatically. ▸ Every query below ran against the Lab, the free dataset bundle used throughout this blog, on PostgreSQL 19 Beta 3: POSTGRES_VERSION=19beta3 PG_MAJOR=19 docker compose up. Both modules are contrib, and the Lab image ships them; nothing below runs a LOAD to enable them, because the server already has them -- pg_plan_advice in session_preload_libraries, pg_stash_advice in shared_preload_libraries (it can survive a restart, which needs loading that way). One line each in postgresql.conf, or the equivalent server-start flag, and you're done. pg_stash_advice still needs its own CREATE EXTENSION, further down, for its SQL functions -- that's independent of how the module itself got loaded.

## Vondra: PostgreSQL development activity

DevFeed: [Vondra: PostgreSQL development activity](<https://devfeed.tech/articles/vondra-postgresql-development-activity-26597.md>)

Original publisher: [Read original article](<https://lwn.net/Articles/1094470/>)

Author: jzb

Published: 2026-09-15T13:20:30Z

Content type: news

Language: en

Sources: [LWN.net](<https://devfeed.tech/sources/lwn-net.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Development](<https://devfeed.tech/topics/development.md>)

Tags: [blog-post](<https://devfeed.tech/tags/blog-post.md>), [development](<https://devfeed.tech/tags/development.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

A PostgreSQL contributor's analysis examines development activity from the late 1990s to the present. It reports roughly 50 commits per week today, compared with about 25 per week around 2010, alongside an approximately twofold increase in active committers.

### Source excerpt

PostgreSQL contributor Tomas Vondra has published a blog post looking at development activity in the project, with data from the late 1990s to today. We're doing ~50 commits per week, give or take. In ~2010 we were doing maybe 25/week, and the trend seems to be a slow and consistent growth. The monthly average makes the trend a bit easier to spot. Which is good, although there's a lot of other important details (size of commits, are they new features or fixes, ...). It however nicely aligns with the number of active committers, which also grew ~2x between 2010 and today. So maybe that's working as expected.

## Kubernetes 1.36 restores a lost guarantee for database backups

DevFeed: [Kubernetes 1.36 restores a lost guarantee for database backups](<https://devfeed.tech/articles/kubernetes-1-36-restores-a-lost-guarantee-for-database-backups-26610.md>)

Original publisher: [Read original article](<https://thenewstack.io/kubernetes-volume-group-snapshots/>)

Author: Shubham Pampattiwar

Published: 2026-09-15T13:00:00Z

Content type: news

Language: en

Sources: [Kubernetes Overview, News and Trends | The New Stack](<https://devfeed.tech/sources/kubernetes-overview-news-and-trends-the-new-stack.md>), [The New Stack](<https://devfeed.tech/sources/the-new-stack.md>)

Topics: [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [backups](<https://devfeed.tech/tags/backups.md>), [cncf](<https://devfeed.tech/tags/cncf.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [post-contributed](<https://devfeed.tech/tags/post-contributed.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [snapshots](<https://devfeed.tech/tags/snapshots.md>), [sponsor-cncf](<https://devfeed.tech/tags/sponsor-cncf.md>), [sponsored-post-contributed](<https://devfeed.tech/tags/sponsored-post-contributed.md>), [stateful](<https://devfeed.tech/tags/stateful.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

The article explains how Kubernetes 1.36 restores coordinated snapshots for applications whose state spans multiple volumes, addressing inconsistent database backups caused by taking individual PersistentVolumeClaim snapshots at different times.

### Source excerpt

It's 2 a.m., and you're restoring a PostgreSQL cluster from last night's backup. Its data directory lives on one PersistentVolumeClaim The post Kubernetes 1.36 restores a lost guarantee for database backups appeared first on The New Stack.

## PostgreSQL 19 graph queries fail the 'would you ship this?' test

DevFeed: [PostgreSQL 19 graph queries fail the 'would you ship this?' test](<https://devfeed.tech/articles/postgresql-19-graph-queries-fail-the-would-you-ship-this-test-26619.md>)

Original publisher: [Read original article](<https://www.theregister.com/databases/2026/09/15/postgresql-19-graph-queries-fail-the-would-you-ship-this-test/5296343>)

Author: Lindsay Clark

Published: 2026-09-15T09:42:59Z

Content type: news

Language: en

Sources: [www.theregister.com - Articles](<https://devfeed.tech/sources/www-theregister-com-articles.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Graphs](<https://devfeed.tech/topics/graphs.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [bugs](<https://devfeed.tech/tags/bugs.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [databases](<https://devfeed.tech/tags/databases.md>), [graph](<https://devfeed.tech/tags/graph.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

The article reports that PostgreSQL 19's SQL/PGQ graph queries were rejected because of unresolved bugs. It also discusses concurrent REPACK as a way to reduce overnight maintenance calls for database administrators.

### Source excerpt

SQL/PGQ gets bounced over unresolved bugs as concurrent REPACK promises fewer midnight calls for DBAs

## What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog

DevFeed: [What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog](<https://devfeed.tech/articles/what-s-new-in-cypex-v2-0-0-tenancy-moves-from-the-query-to-the-catalog-26241.md>)

Original publisher: [Read original article](<https://www.cybertec-postgresql.com/en/whats-new-in-cypex-v2-0-0-tenancy-moves-from-the-query-to-the-catalog/>)

Author: Svitlana Lytvynenko

Published: 2026-09-15T06:06:05Z

Content type: article

Language: en

Sources: [CYBERTEC PostgreSQL | Services & Support](<https://devfeed.tech/sources/cybertec-postgresql-services-support.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [tenant data protection](<https://devfeed.tech/topics/tenant-data-protection.md>), [Security](<https://devfeed.tech/topics/security.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [cypex](<https://devfeed.tech/tags/cypex.md>), [data-protection](<https://devfeed.tech/tags/data-protection.md>), [database](<https://devfeed.tech/tags/database.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [news](<https://devfeed.tech/tags/news.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [product](<https://devfeed.tech/tags/product.md>), [schema](<https://devfeed.tech/tags/schema.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

CYPEX 2.0.0 moves tenant isolation from application-level query filters into PostgreSQL row-level security policies stored in the database catalog. The policies use JWT claims to apply organization-specific access rules to every connection and query.

### Source excerpt

This blog highlights the details of CYPEX 2.0, with each feature being explained in detail. Read to know more. The post What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog appeared first on CYBERTEC PostgreSQL | Services & Support.

## Appwrite Init 2026 recap: Everything we shipped

DevFeed: [Appwrite Init 2026 recap: Everything we shipped](<https://devfeed.tech/articles/appwrite-init-2026-recap-everything-we-shipped-26795.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/appwrite-init-2026-recap>)

Author: Aishwari Pahwa

Published: 2026-09-15T00:00:00Z

Content type: release

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [releases](<https://devfeed.tech/topics/releases.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Firewall](<https://devfeed.tech/topics/firewall.md>), [OAuth 2.0](<https://devfeed.tech/topics/oauth2.md>), [Self-hosted](<https://devfeed.tech/topics/self-hosted.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [firewall](<https://devfeed.tech/tags/firewall.md>), [init](<https://devfeed.tech/tags/init.md>), [oauth2](<https://devfeed.tech/tags/oauth2.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [recap](<https://devfeed.tech/tags/recap.md>), [release](<https://devfeed.tech/tags/release.md>), [releases](<https://devfeed.tech/tags/releases.md>), [s3](<https://devfeed.tech/tags/s3.md>), [self-hosted](<https://devfeed.tech/tags/self-hosted.md>)

### AI overview

An Appwrite Init 2026 recap covering five days of launches, including Appwrite 2.0, a redesigned Console, native PostgreSQL, VectorsDB, DocumentsDB, MySQL, S3-compatible Storage, Firewall, OAuth2, and Domains.

### Source excerpt

An Appwrite Init 2026 recap of all five days of launches, from Appwrite 2.0 and native PostgreSQL to VectorsDB, S3 support, Firewall, OAuth2, and Domains.

## What Managed Postgres Services Handle for Teams

DevFeed: [What Managed Postgres Services Handle for Teams](<https://devfeed.tech/articles/managed-postgres-what-lakebase-actually-takes-off-your-plate-26721.md>)

Original publisher: [Read original article](<https://www.databricks.com/blog/managed-postgres>)

Author: Databricks Staff

Published: 2026-09-14T23:36:59Z

Content type: article

Language: en

Sources: [Databricks](<https://devfeed.tech/sources/databricks.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database](<https://devfeed.tech/topics/database.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [databricks](<https://devfeed.tech/topics/databricks.md>), [AI Development](<https://devfeed.tech/topics/ai-development.md>)

Tags: [data-plus-ai-foundations](<https://devfeed.tech/tags/data-plus-ai-foundations.md>), [database](<https://devfeed.tech/tags/database.md>), [databricks](<https://devfeed.tech/tags/databricks.md>), [developer-tooling](<https://devfeed.tech/tags/developer-tooling.md>), [migration](<https://devfeed.tech/tags/migration.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [security](<https://devfeed.tech/tags/security.md>), [serverless](<https://devfeed.tech/tags/serverless.md>)

### AI overview

The article defines managed Postgres by the operational responsibilities a provider assumes, including patching, scaling, failover, and backups. It discusses how these responsibilities can vary between providers and describes Lakebase Postgres as a serverless offering with automatic scaling, PostgreSQL compatibility, recovery, and Databricks integrations.

### Source excerpt

Every Postgres vendor calls itself "managed." Few of them agree on what that word...

## Percona and HexaCluster: Faster, Safer Oracle Migration

DevFeed: [Percona and HexaCluster: Faster, Safer Oracle Migration](<https://devfeed.tech/articles/percona-and-hexacluster-faster-safer-oracle-migration-26240.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/percona-and-hexacluster-faster-safer-oracle-migration/>)

Author: Percona Team

Published: 2026-09-14T22:19:16Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Tooling](<https://devfeed.tech/topics/tooling.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-migration](<https://devfeed.tech/tags/database-migration.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [migration](<https://devfeed.tech/tags/migration.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [partners](<https://devfeed.tech/tags/partners.md>), [percona](<https://devfeed.tech/tags/percona.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [tooling](<https://devfeed.tech/tags/tooling.md>), [validation](<https://devfeed.tech/tags/validation.md>)

### AI overview

Percona and HexaCluster describe a partnership for moving organizations from Oracle, SQL Server, DB2, and Sybase ASE to supported open source databases, primarily PostgreSQL. HexaCluster provides assessment and migration engineering through DMAT and HexaRocket, while Percona provides distributions, operators, and long-term support. HexaRocket combines schema migration, data migration, validation, change data capture, live replication, and reverse replication in one platform.

### Source excerpt

Percona and HexaCluster have partnered to remove the hardest part of an open source database migration: getting off Oracle, SQL Server, DB2 or Sybase ASE with confidence, on a predictable timeline, without a multi-year consulting program. Percona brings open source expertise, its own distributions, operators and enterprise support. HexaCluster brings the assessment and migration engineering ... Continued The post Percona and HexaCluster: Faster, Safer Oracle Migration appeared first on Percona.

## Intelligence is yours. Let's keep it that way.

DevFeed: [Intelligence is yours. Let's keep it that way.](<https://devfeed.tech/articles/intelligence-is-yours-let-s-keep-it-that-way-19892.md>)

Original publisher: [Read original article](<https://www.digitalocean.com/blog/intelligence-is-yours>)

Author: Paddy Srinivasan

Published: 2026-09-14T21:11:13Z

Content type: opinion

Language: en

Sources: [DigitalOcean](<https://devfeed.tech/sources/digitalocean.md>)

Topics: [Open Source](<https://devfeed.tech/topics/open-source.md>), [Software](<https://devfeed.tech/topics/software.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [React](<https://devfeed.tech/topics/react.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [competition](<https://devfeed.tech/tags/competition.md>), [github](<https://devfeed.tech/tags/github.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [intellectual-property](<https://devfeed.tech/tags/intellectual-property.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [models](<https://devfeed.tech/tags/models.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [news](<https://devfeed.tech/tags/news.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [opencode](<https://devfeed.tech/tags/opencode.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [react](<https://devfeed.tech/tags/react.md>)

### AI overview

The article argues that founders should retain ownership and control of their companies' intelligence rather than depend on a single intelligence provider. It advocates an Open Intelligence movement built from open-source models, agents, harnesses, data technologies, and infrastructure, drawing comparisons with the adoption of Linux, PostgreSQL, MySQL, Kubernetes, and other open technologies.

### Source excerpt

Intelligence was yours. A founder's intellectual property, business logic, differentiation, their intelligence, was once theirs alone. You built it, you owned it, and no tools/platform vendor stood between you and your customers. This is no longer clear. It is starting to look like it is "theirs." Intelligence can now be manufactured: the models, the agents and the harnesses that drive them, and the compute they run on. Providers who own all these can produce the application, and the differentiation, in every industry. That power runs the risk of becoming increasingly concentrated in a handful of companies. The race for the application layer is not about interfaces or go-to-market; it is a fight over who owns the intelligence layer itself. We have seen this before but we must act before its too late. Linux started behind Unix and Windows and now runs most of the world's servers. PostgreSQL and MySQL started behind Oracle and now underpin most new software. Kubernetes arrived after proprietary orchestrators and made them irrelevant. Each began less capable and won anyway: builders could see inside it, run it anywhere, and never had to ask permission. The same is happening now. Open weight models have repeatedly reached the frontier this past year. Open harnesses like OpenCode have grown to tens of trillions of tokens a day. Hermes reached more than 200,000 GitHub stars in five months, a milestone that took React a decade to achieve. Along with the near total adoption of open source data technologies, this collection of open technologies power an Open Intelligence movement. Open Intelligence restores the order. It returns to founders ownership of what makes their companies theirs. Founders should be free to build without tying their future to a single intelligence provider: their choice of agents, harnesses, data technologies, models, and infrastructure, with open source transparency, control, and competition keeping every layer honest. The stakes go beyond business.

## Resolve Amazon Aurora PostgreSQL lock contention with Database Insights: Part 2

DevFeed: [Resolve Amazon Aurora PostgreSQL lock contention with Database Insights: Part 2](<https://devfeed.tech/articles/resolve-amazon-aurora-postgresql-lock-contention-with-database-insights-part-2-20842.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/resolve-amazon-aurora-postgresql-lock-contention-with-database-insights-part-2/>)

Author: Sameer Kumar

Published: 2026-09-14T16:02:16Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Database](<https://devfeed.tech/topics/database.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [AWS CloudFormation](<https://devfeed.tech/topics/aws-cloudformation.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cloudformation](<https://devfeed.tech/tags/aws-cloudformation.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [simulation](<https://devfeed.tech/tags/simulation.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This tutorial explains how to diagnose and resolve lock contention in Amazon Aurora PostgreSQL using Amazon CloudWatch Database Insights. It demonstrates Lock Analysis and the Lock Tree visualization for identifying blocking sessions, then covers immediate fixes, configuration changes, optimistic concurrency control, asynchronous processing, SKIP LOCKED, and row splitting.

### Source excerpt

Part 1 showed how row lock contention degrades Amazon Aurora PostgreSQL throughput. In Part 2, use Amazon CloudWatch Database Insights and its Lock Tree to pinpoint blocking sessions, then resolve contention with query termination, timeout parameters, and architectural patterns such as SKIP LOCKED and row splitting that restore throughput.

## Troubleshooting row lock contention in Amazon Aurora PostgreSQL: Part 1 - Understanding row lock contention in PostgreSQL

DevFeed: [Troubleshooting row lock contention in Amazon Aurora PostgreSQL: Part 1 - Understanding row lock contention in PostgreSQL](<https://devfeed.tech/articles/troubleshooting-row-lock-contention-in-amazon-aurora-postgresql-part-1-understanding-row-lock-contention-in-postgresql-20843.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/troubleshooting-row-lock-contention-in-amazon-aurora-postgresql-part-1-understanding-row-lock-contention-in-postgresql/>)

Author: Sameer Kumar

Published: 2026-09-14T16:02:08Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [Extension](<https://devfeed.tech/topics/extension.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [availability](<https://devfeed.tech/tags/availability.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [database](<https://devfeed.tech/tags/database.md>), [database-performance](<https://devfeed.tech/tags/database-performance.md>), [extension](<https://devfeed.tech/tags/extension.md>), [locks](<https://devfeed.tech/tags/locks.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [production](<https://devfeed.tech/tags/production.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [troubleshooting](<https://devfeed.tech/tags/troubleshooting.md>)

### AI overview

This first part of a two-part series explains row lock contention in PostgreSQL and Amazon Aurora PostgreSQL. It covers how concurrent transactions competing for the same rows can reduce throughput and cause timeouts despite healthy CPU and I/O, then introduces PostgreSQL locking internals and monitoring techniques using system views, functions, the pgrowlocks extension, and log_lock_waits. The article notes that the same behavior and investigation approach apply to Amazon RDS for PostgreSQL.

### Source excerpt

Row lock contention can collapse database throughput during a flash sale even when CPU and I/O look healthy. In Part 1 of this series, learn how PostgreSQL row locking works and how to monitor lock contention in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using system views, the pgrowlocks extension, and the log_lock_waits parameter.

## PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum

DevFeed: [PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum](<https://devfeed.tech/articles/postgresql-monitoring-and-schema-linting-for-laravel-with-vacuum-22290.md>)

Original publisher: [Read original article](<https://laravel-news.com/vacuum-laravel-postgresql-monitoring>)

Author: Paul Redmond

Published: 2026-09-14T04:24:35Z

Content type: article

Language: en

Sources: [Laravel](<https://devfeed.tech/sources/laravel.md>)

Topics: [Laravel](<https://devfeed.tech/topics/laravel.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [ci](<https://devfeed.tech/topics/ci.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [ci](<https://devfeed.tech/tags/ci.md>), [github](<https://devfeed.tech/tags/github.md>), [laravel](<https://devfeed.tech/tags/laravel.md>), [laravel-packages](<https://devfeed.tech/tags/laravel-packages.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

Vacuum is a PostgreSQL monitoring and schema-linting package for Laravel. It analyzes PostgreSQL statistics, reports issues such as bloat, wraparound, dead tuples, unused indexes, slow statements, and unindexed foreign keys, and provides SQL remediation guidance, health scores, dashboards, CI commands, history, and explainers.

### Source excerpt

Vacuum checks PostgreSQL in Laravel apps for bloat, wraparound, and unused indexes, and flags unindexed foreign keys in migrations during CI. The post PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum appeared first on Laravel News. Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.

## Encore for Python

DevFeed: [Encore for Python](<https://devfeed.tech/articles/encore-for-python-17794.md>)

Original publisher: [Read original article](<https://encore.dev/blog/encore-py>)

Author: Ivan Cernja

Published: 2026-09-14T00:00:00Z

Content type: article

Language: en

Sources: [Encore Updates](<https://devfeed.tech/sources/encore-updates.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [FastAPI](<https://devfeed.tech/topics/fastapi.md>), [AWS IAM](<https://devfeed.tech/topics/aws-iam.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Terraform](<https://devfeed.tech/topics/terraform.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>)

Tags: [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [coding-agents](<https://devfeed.tech/tags/coding-agents.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [git](<https://devfeed.tech/tags/git.md>), [iam](<https://devfeed.tech/tags/iam.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [terraform](<https://devfeed.tech/tags/terraform.md>)

### AI overview

Encore is introducing Encore.py, an upcoming beta that brings Encore's type-safe infrastructure primitives to Python and works alongside frameworks such as FastAPI. The article describes how application-level resource declarations can drive infrastructure provisioning while platform teams retain control over environment-specific settings in AWS, GCP, Terraform, or existing infrastructure. It also highlights preview environments where coding agents can implement and verify features against infrastructure configured to resemble production.

### Source excerpt

An early look at Encore for Python, entering beta soon.

## \[$\] PostgreSQL 19's "scary patch contest"

DevFeed: [\[$\] PostgreSQL 19's "scary patch contest"](<https://devfeed.tech/articles/postgresql-19-s-scary-patch-contest-8492.md>)

Original publisher: [Read original article](<https://lwn.net/Articles/1092003/>)

Author: jzb

Published: 2026-09-10T17:29:06Z

Content type: news

Language: en

Sources: [LWN.net](<https://devfeed.tech/sources/lwn-net.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [patches](<https://devfeed.tech/topics/patches.md>), [Testing](<https://devfeed.tech/topics/testing.md>), [bug](<https://devfeed.tech/topics/bug.md>)

Tags: [beta](<https://devfeed.tech/tags/beta.md>), [bug](<https://devfeed.tech/tags/bug.md>), [patches](<https://devfeed.tech/tags/patches.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [stable](<https://devfeed.tech/tags/stable.md>), [testing](<https://devfeed.tech/tags/testing.md>)

### AI overview

The PostgreSQL 19 release faced concerns about the readiness of several patches after unusually many bug fixes and ongoing revisions. One patch was reverted, and an extra beta release was scheduled for additional testing.

### Source excerpt

PostgreSQL 19 was expected to be released in September, in keeping with the database project's longstanding tradition of a major release every year. However, some late-breaking concerns about several of the features slated for inclusion has some developers worried about the quality of the release. On August 25, PostgreSQL contributor Robert Haas sent an email with the subject "scary patch contest" about several patches that have required an unusually large number of bug fixes leading up to the release, which has raised questions about their readiness for a stable release. One of the patches has been reverted, but several are still under heavy revision, and an extra beta release has been slotted in to allow for additional testing.

## Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging

DevFeed: [Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging](<https://devfeed.tech/articles/percona-operator-for-postgresql-3-1-0-transparent-data-encryption-logical-replicas-and-persistent-logging-14108.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/percona-operator-for-postgresql-3-1-0-transparent-data-encryption-logical-replicas-persistent-logging/>)

Author: Slava Sarzhan

Published: 2026-09-09T16:08:31Z

Content type: release

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Encryption](<https://devfeed.tech/topics/encryption.md>), [Logging](<https://devfeed.tech/topics/logging.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [hashicorp-vault](<https://devfeed.tech/tags/hashicorp-vault.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [logging](<https://devfeed.tech/tags/logging.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operator](<https://devfeed.tech/tags/operator.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-operator-for-postgresql](<https://devfeed.tech/tags/percona-operator-for-postgresql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [replication](<https://devfeed.tech/tags/replication.md>), [security](<https://devfeed.tech/tags/security.md>), [slavasarzhan-pg](<https://devfeed.tech/tags/slavasarzhan-pg.md>)

### AI overview

Percona Operator for PostgreSQL 3.1.0 adds transparent data encryption with pg_tde, logical replicas for read-only workloads, and persistent logging across Pod restarts. The release also adds official RKE2 support and full ARM64 images.

### Source excerpt

Percona Operator for PostgreSQL 3.1.0 takes on three things that decide whether a PostgreSQL platform passes review: is the data encrypted at rest, can it serve reads without straining the primary, and are the logs there when you need them. This release answers all three inside the custom resource, so none of them is a ... Continued The post Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging appeared first on Percona.

## Use Drizzle ORM with Appwrite Postgres

DevFeed: [Use Drizzle ORM with Appwrite Postgres](<https://devfeed.tech/articles/use-drizzle-orm-with-appwrite-postgres-16474.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/drizzle-orm-appwrite-postgres>)

Author: Atharva Deosthale

Published: 2026-09-08T00:00:00Z

Content type: tutorial

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [Drizzle](<https://devfeed.tech/topics/drizzle.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Object-relational mapping](<https://devfeed.tech/topics/orm.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [TypeScript](<https://devfeed.tech/topics/typescript.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [data](<https://devfeed.tech/tags/data.md>), [drizzle](<https://devfeed.tech/tags/drizzle.md>), [migration](<https://devfeed.tech/tags/migration.md>), [migrations](<https://devfeed.tech/tags/migrations.md>), [orm](<https://devfeed.tech/tags/orm.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [tutorials](<https://devfeed.tech/tags/tutorials.md>), [typescript](<https://devfeed.tech/tags/typescript.md>)

### AI overview

A tutorial showing how to connect Drizzle ORM to Appwrite Postgres, define tables and queries in TypeScript, generate and apply SQL migrations, seed data, and evolve a schema while preserving existing records.

### Source excerpt

Connect Drizzle ORM to Appwrite Postgres, query data with TypeScript, and apply SQL migrations as your schema changes.

## Use Prisma ORM with Appwrite Postgres

DevFeed: [Use Prisma ORM with Appwrite Postgres](<https://devfeed.tech/articles/use-prisma-orm-with-appwrite-postgres-16503.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/prisma-orm-appwrite-postgres>)

Author: Atharva Deosthale

Published: 2026-09-08T00:00:00Z

Content type: tutorial

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [Prisma](<https://devfeed.tech/topics/prisma.md>), [Object-relational mapping](<https://devfeed.tech/topics/orm.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [TypeScript](<https://devfeed.tech/topics/typescript.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [migration](<https://devfeed.tech/tags/migration.md>), [migrations](<https://devfeed.tech/tags/migrations.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [prisma](<https://devfeed.tech/tags/prisma.md>), [schema](<https://devfeed.tech/tags/schema.md>), [tutorials](<https://devfeed.tech/tags/tutorials.md>), [typescript](<https://devfeed.tech/tags/typescript.md>)

### AI overview

A practical guide to using Prisma ORM with Appwrite Postgres in a TypeScript project. It covers creating the PostgreSQL database, configuring the connection and TLS settings, defining models, generating and applying migrations, generating Prisma Client, and connecting to the database through a driver adapter.

### Source excerpt

Model your data with Prisma ORM, generate a typed client, and test schema migrations against Appwrite Postgres.

## Appwrite 2.0 is now available for self-hosting

DevFeed: [Appwrite 2.0 is now available for self-hosting](<https://devfeed.tech/articles/appwrite-2-0-is-now-available-for-self-hosting-16450.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/appwrite-2-self-hosted>)

Author: Atharva Deosthale

Published: 2026-09-07T00:00:00Z

Content type: release

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [Self-hosted](<https://devfeed.tech/topics/self-hosted.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Containers](<https://devfeed.tech/topics/containers.md>)

Tags: [containers](<https://devfeed.tech/tags/containers.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [products](<https://devfeed.tech/tags/products.md>), [self-hosting](<https://devfeed.tech/tags/self-hosting.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>)

### AI overview

Appwrite 2.0 is available for self-hosting. It introduces a rebuilt Console, PostgreSQL as the default database for new installations, a coroutine-based server engine, and a combined worker topology that reduces the default instance from 33 to 16 containers. Existing installations retain their current database when upgraded.

### Source excerpt

Appwrite 2.0 brings a rebuilt Console, PostgreSQL as the default database, and a combined worker topology that runs your instance on 16 containers instead of 33.

## Getting Ready for PostgreSQL 19

DevFeed: [Getting Ready for PostgreSQL 19](<https://devfeed.tech/articles/getting-ready-for-postgresql-19-34621.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2026/09/getting-ready-for-postgresql-19/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2026-09-03T13:09:30Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [upgrade](<https://devfeed.tech/topics/upgrade.md>), [Release notes](<https://devfeed.tech/topics/release-notes.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Docker Compose](<https://devfeed.tech/topics/docker-compose.md>), [Docker](<https://devfeed.tech/topics/docker.md>), [Linux](<https://devfeed.tech/topics/linux.md>)

Tags: [beta](<https://devfeed.tech/tags/beta.md>), [compatibility](<https://devfeed.tech/tags/compatibility.md>), [docker](<https://devfeed.tech/tags/docker.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [linux](<https://devfeed.tech/tags/linux.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release-notes](<https://devfeed.tech/tags/release-notes.md>), [sql](<https://devfeed.tech/tags/sql.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [version](<https://devfeed.tech/tags/version.md>)

### AI overview

This article reviews PostgreSQL 19 Beta 3 ahead of its general availability, focusing on upgrade-relevant compatibility changes and useful SQL additions. It highlights changes involving JIT defaults, authentication, GiST indexing, naming restrictions, and configuration capacity, and includes queries tested against a PostgreSQL 19 Beta 3 instance.

### Source excerpt

PostgreSQL 19 Beta 3 shipped on August 13, 2026, and the release notes have been filled in as of 2026-07-18 -- still marked subject to change, and the GA date isn't announced yet, but following the project's usual September/October cadence general availability should land within the next few weeks. That makes now the right time to read through what's changing, the same way I did for PostgreSQL 11 through 18 a few weeks ago. This is not a changelog dump. It's the subset of PG 19 I think is worth knowing about before you upgrade: a handful of compatibility breaks that will bite people who don't read release notes, and the SQL-level additions I found genuinely useful once I started poking at them. Every query below ran against a real PostgreSQL 19 Beta 3 instance -- no hand-waving about syntax that might work. ▸ Every query in this article ran against the Lab, the same free dataset bundle used in the rest of this blog (F1 data, geopolitical data, music data, and more), pinned to a real PostgreSQL 19 Beta 3 instance. PG 19 support isn't the Lab's default yet, but there is a prebuilt beta image on the registry, for both linux/amd64 and linux/arm64 -- so POSTGRES_VERSION=19beta3 PG_MAJOR=19 docker compose up pulls it rather than building anything, and every query below reproduces on it exactly as printed. (PG_MAJOR only matters if Compose ends up building; it costs nothing to set.) Plain docker compose up still pulls the PG 16 image, and stays the default until 19 reaches general availability.

## Appwrite announces native PostgreSQL databases

DevFeed: [Appwrite announces native PostgreSQL databases](<https://devfeed.tech/articles/appwrite-now-speaks-postgres-16452.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/appwrite-now-speaks-postgresql>)

Author: Jake Barnby

Published: 2026-09-01T00:00:00Z

Content type: release

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Security](<https://devfeed.tech/topics/security.md>), [SDKs](<https://devfeed.tech/topics/sdks.md>)

Tags: [announcements](<https://devfeed.tech/tags/announcements.md>), [database](<https://devfeed.tech/tags/database.md>), [drizzle](<https://devfeed.tech/tags/drizzle.md>), [hosting](<https://devfeed.tech/tags/hosting.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [prisma](<https://devfeed.tech/tags/prisma.md>), [replication](<https://devfeed.tech/tags/replication.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

Appwrite announces native PostgreSQL databases that can be provisioned inside an Appwrite project and accessed like any PostgreSQL server. The managed service includes operational features such as backups, replication, failover, scaling, connection pooling, and TLS.

### Source excerpt

Run a managed PostgreSQL instance inside your Appwrite project and connect to it with psql, your ORM, and the entire PostgreSQL ecosystem.

[Next page](<https://devfeed.tech/topics/postgresql.md?cursor=WyIyMDI2LTA5LTAxVDAwOjAwOjAwKzAwOjAwIiwgIjhhYjJiNjMyLTRhNmMtNGVhYS04NDQ1LWRiYzU0ZDhlNWFjNyJd>)