We shrank our TimescaleDB chunks from 30 days to 7

https://tech.wmg.com/why-we-shrank-our-timescaledb-chunks-from-30-days-to-7-07cab8afefc5

#HackerNews #TimescaleDB #database #optimization #dataengineering #chunking #performance

We shrank our TimescaleDB chunks from 30 days to 7

https://tech.wmg.com/why-we-shrank-our-timescaledb-chunks-from-30-days-to-7-07cab8afefc5

#HackerNews #Tech #Database

What is CRUD Operations? Complete Beginner Guide | Create Read Update Delete Explained

#CRUD #Database #Python #WebDevelopment #BackendDevelopment #MongoDB #SQL #MySQL #PostgreSQL #Django #FastAPI #NodeJS #Programming #Coding #SoftwareEngineering #Developer #LearnProgramming #ComputerScience #TechEducation #PythonDeveloper

https://youtube.com/shorts/YZWQdESiMJQ?si=C9NMx453YqGbbrXJ

Final bit of cleanup/building in the ol' homelab for today: got the DB backups running through Databasus (the successor to Postgresus), and moved the mini rack off the same switch as the EMC disk shelf.

#homelab #nas #backups #database

PostgreSQL 18 delivers major VACUUM & ANALYZE improvements: async I/O, dynamic autovacuum scaling, eager freezing & better observability. Shashikant Shakya (Microsoft) covers what changed & how it affects real-world workloads at POSETTE 2026, a free & virtual developer event.

Mark your calendar for POSETTE Livestream 4 on Thu 18 Jun https://posetteconf.com/2026/talks/vacuuming-enhancements-in-postgresql-18-faster-smarter-more-predictable/

#PosetteConf #PostgreSQL #Postgres #Database #Community #Microsoft #OpenSource #Vacuum #AutoVacuum #Performance #PG18

The perils of UUID primary keys in SQLite

https://andersmurphy.com/2026/06/05/the-perils-of-uuid-primary-keys-in-sqlite.html

#HackerNews #Tech #Database

Full Guide to #PostgreSQL #Database Management in #cPanel Here's a comprehensive guide on PostgreSQL database management in cPanel accounts, designed for developers, sysadmins, or site owners using cPanel-managed hosting.
What is PostgreSQL?
PostgreSQL is an open-source, object-relational database management system (ORDBMS) known for its robustness, feature set, and standards compliance.
Key Points:

Open Source: Free to use, modify, and distribute. ...
Continued 👉 https://blog.radwebhosting.com/full-guide-to-postgresql-database-management-in-cpanel/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social

🚀 Just 1 week until SouthEast #Linux Fest 2026! We're thrilled to be a 🏅 Gold Sponsor.
Join #VictoriaMetrics, the high-performance, #OpenSource time series #database built to tackle your toughest workloads 💪
We deliver speed, efficiency, and scale to #observability.
Let’s connect at Sonesta Charlotte Lower South End, North Carolina, June 12-14! 🌟

https://bit.ly/4wW8ifS
#TechConference #TimeSeriesDatabase #MonitoringSolutions

Shaun Thomas shows how easy (?) it is to create a #PostgreSQL extension at PG DATA 2026!

#Postgres #PGDATA2026 #extensions #OpenSource #Database

pg_durable: Microsoft open sources in-database durable execution

https://github.com/microsoft/pg_durable

#database #github #microsoft