If your business users want to raise the bar, then federated queries are the quickest way to business gold. Nexus is the best federated query tool in the world.

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

We want to be sure everyone who attends PGConf NYC 2025 has the best experience possible. Click below to find out how we are handling accessibility and accommodation:

https://2025.pgconf.nyc/inclusion/

@PostgreSQL #postgres #conference

Your company can contribute to the PostgreSQL community by sponsoring events like PGConf NYC 2025! We have sponsorship opportunities available, so talk to us today!

https://2025.pgconf.nyc/sponsors/

@PostgreSQL #postgres #conference

@geerlingguy what db are you and rsj running and what do you think of the vector db and ai for builders and smb sector? #postgres #ansible wireguard playbook. why wouldn't everybody go to clustering db for better scalable performance #torrent protocol - the more you buy the more you save
Por qué Postgres es la mejor base de datos

YouTube
Postgres query plan visualization tools - pgMustard

When you’ve got a slow Postgres query, EXPLAIN and its parameters are incredibly useful for working out why. However, the information returned can be difficult (and time-consuming) to interpret, especially for more complex queries. Over the years, people have built quite a few tools for visualizing

pgMustard

Мудохался два дня, чтобы перенести базу TTRSS с MariaDB на Postgres. Копирую данные с помощью pgloader, переименовываю схему и получаю ошибки 50x и ничего рабочего.

Сегодня попробовал просто создать новую пустую базу. Потом сделал копию всего каталога TTRSS, изменил конфиг на Postgres, добавил в nginx ещё один сайт, чтобы в браузере за клоном следить.

Потом сделал экспорт и импорт подписок, экспорт и импорт постов, поменял пароль, и всё просто заработало.

Пришлось только файлы с фавиконками переименовывать, потому что у фидов id в базе изменились.

Там, конечно, есть ещё тонкости, но это надо консолидировать всё и в бложик записать, наверное.

Ну и бекап базы переделать.

Экспорт и импорт постов часа два заняли примерно.

#ttrss #postgres #mariadb

Early Bird tickets are still available, but don’t wait! Our Early Bird promotion ends in 3 days, so get your ticket to PGConf NYC 2025 today!

https://2025.pgconf.nyc/tickets/

@PostgreSQL #postgres #conference

PG-Capture – a better way to sync #Postgres with Algolia (or #Elastic) | Hacker News https://news.ycombinator.com/item?id=43217546
Show HN: PG-Capture – a better way to sync Postgres with Algolia (or Elastic) | Hacker News

Major version upgrades can be complicated to manage in any #database system. Of course, this operation becomes more complex when seeking to maintain zero downtime and avoid sacrificing high availability! In #PostgreSQL, luckily, several techniques have been developed over the years to avoid such issues. Learn from Shaun Thomas how it can be done:

https://www.pgedge.com/blog/always-online-or-bust-zero-downtime-major-version-postgres-upgrades

#dev #developer #devcommunity #opensource #foss #oss #data #postgres #datamanagement #dba #linux #tech #technology #coding

×

Hi from #Jinan, #China @ Highgo Open World (#PostgreSQL & #IvorySQL Eco Conference") 🐘

> With the mission of "linking the world with open source", Highgo emphasizes the core role of open source technology in the field of database basic software, and is committed to promoting industry development through sharing and cooperation, while connecting and empowering global users.

https://ivorysql.io/

#tech #technology #developer #dev #devcommunity #opensource #foss #oss #oracle #postgres #HOW2025