PostgreSQL 19 connects the dots with standardized graph queries
Baked-in SQL syntax arrives through multi-vendor collaboration, although indexing still needs to catch up
Search fresh public links, source activity, and ready-to-use post angles for Postgresql Compatible.
Fresh curated links around PostgreSQL compatible are collected here so marketers can spot useful updates and turn timely ideas into posts faster.
Recent items include:
Recent curated links from global sources. Generate one free draft from any story, then use SocialBu to schedule and refine your content calendar.
Baked-in SQL syntax arrives through multi-vendor collaboration, although indexing still needs to catch up
PostgreSQL 19 adds SQL/PGQ graph queries, a critical logical replication flaw is patched, and AWS DMS now uses AI agents for SQL Server migrations. Get the full breakdown. The post...
PGW: A PGBACKREST INTERLUDE:(Andreas Scherbaum, Jimmy Angelakos)Andreas Scherbaum and Jimmy Angelakos presented a quantitative analysis of the PostgreSQL CommitFest process using d...
Originally appeared on The Rails Tech Debt Blog.Heroku sent us an email about the database behind ips.fastruby.io, a small app we run for sharing benchmark-ips results. That databa...
SQL Server stored procedures can return multiple result sets from one call, but PostgreSQL cannot. This post presents two PostgreSQL-native alternatives to refcursors, session-scop...
PostgreSQL 19 removes SQL/PGQ, but REPACK CONCURRENTLY, Spinnaker's migration tools, Vacuum monitoring, and AlloyDB Omni orchestrator bring new capabilities for DBAs. The post Post...
PostgreSQL 19 adds native SQL/PGQ graph support, while a critical logical replication flaw (CVE-2026-6471) is patched in all versions. Learn what this means for your database. The...
PostgreSQL 19 is set to ship with native SQL/PGQ support for property graph queries, thanks to a multi-vendor collaboration. Here’s what it means for you and when to expect it. The...
SQL/PGQ gets bounced over unresolved bugs as concurrent REPACK promises fewer midnight calls for DBAs
Привет, Хабр! Меня зовут Андрей, я директор департамента внутренних систем ЮMoney. Эту статью я подготовил в соавторстве с Владиславом, руководителем группы разработки и сопровожде...
PostgreSQL news roundup: AWS DuckDB in Aurora, Babelfish FTS gaps, DBtune automation, Nebius managed clusters, Tom Lane architecture, Splunk CVE. The post PostgreSQL Ecosystem Expa...
You wanna learn PostgreSQL, and you wanna use a sample database with big real-world data, the same kinds of issues that pop up with real-life data distribution skew, and fun query...
Привет, Хабр. Я хочу рассказать историю, которую вы уже, наверняка, где-то слышали. Только с другой стороны.Пару месяцев назад я сидела на созвоне с техдиром стартапа, который дела...
PostgreSQL has released updates to address a security flaw that allows an account with the REPLICATION attribute to run arbitrary code as the operating-system user running the data...
Stop relying on slow LIKE queries. Learn how to implement Trigrams and Full Text Search in PostgreSQL for lightning-fast, pro-level results. The post Mastering Advanced Search Tech...
Завершаем цикл статей с обзором изменений 19-й версии. Предыдущие статьи были посвящены первым четырем коммитфестам: 2025-07, 2025-09, 2025-11, 2026-01.А сегодня начнем обзор марто...
Lindsay Clark / The Register: The PostgreSQL Global Development Group delays the general availability of PostgreSQL 19 after LLM-assisted code reviews uncovered architectural defec...
Продолжаем обзор мартовского коммитфеста 19-й версии. В третьей статье серии рассмотрим изменения, относящиеся к материалам курсов DBA3 и DBS.Напоминаю план статей о последнем комм...
PostgreSQL 19 slips to November as AI review finds more bugs; AWS prewarms RDS restores and Aurora adds DuckDB queries. The post PostgreSQL 19 delay, RDS restore tuning and AI-driv...
Database migrations can pass every check in development and still take production down, and the classic example is adding a NOT NULL column with no default to a table that already...
Disclosure: I build Schemity, a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: We put two real SQLite schemas, Campfire (Rails 8) and Jellyfin...
Продолжаем обзор мартовского коммитфеста 19-й версии. Во второй статье серии рассмотрим изменения, относящиеся к материалам курсов DBA1 и DBA2.Напоминаю план статей о последнем ком...
PostgreSQL является самой распространённой СУБД согласно исследованию StackOverflow. Но самостоятельный хостинг PostgreSQL сопряжён с риском потери данных и неоптимальной настройки...
Next week I’m at VS Live in San Diego (register and join me) and one of my talks is on the Data API Builder. I want to show how... The post PostgreSQL Support in the Data API Build...
Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.