Mastodawn

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

pgconfnyc 5h ago

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

pgconfnyc 11h ago

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

Show thread

gary 21h ago

@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

Eduardo Medina 🇪🇸1d ago

Por qué #Postgres es la mejor #BaseDeDatos. https://www.youtube.com/watch?v=xkDJlLWvF9Y

#PostgreSQL #SGBD #BasesDeDatos #SQL #NoSQL

Por qué Postgres es la mejor base de datos

YouTube

Douglas J Hunley 1d ago

#Postgres query plan visualization tools - pgMustard https://www.pgmustard.com/blog/postgres-query-plan-visualization-tools

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

Раджа 1d ago

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

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

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

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

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

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

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

#ttrss #postgres #mariadb

pgconfnyc 1d ago

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

Douglas J Hunley 1d ago

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

pgEdge Distributed PostgreSQL 1d ago

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