#database — Public Fediverse posts

MySQL's Fake UTF-8: Why Your Database is Truncating Emojis and Text — hands-on guide for sysadmins. #database #mysql #mariadb

https://www.valtersit.com/guides/databases/mysqls-fake-utf-8-why-your-database-is-truncating-emojis-and-text/

UUID v4 inserts land at random leaf pages. Cache misses stack up & the index bloats.

One million rows: v4 = 38 MB, 49.9% fragmented. v7 = 30 MB, zero fragmentation.

UUID v7 (RFC 9562) puts a 48-bit timestamp at the front of the key. New inserts always sort to the right edge of the B-tree. #Postgres 18 ships uuidv7() natively.

Bonus: uuid_extract_timestamp() turns the primary key into created_at.

Shaun Thomas's full breakdown: 📖 https://www.pgedge.com/blog/the-time-traveler-s-primary-key

#PostgreSQL #Database #OpenSource #DBA

📢 New #updates · 22 Aug #1.1

· AudioMuse-AI v3.4.0 — Improved accuracy of Energy, Tempo, Key and Scale calculations

More self-hosted updates → https://selfhost.directory

#homeserverlife #breaking #database #opensource

📢 New #updates · 21 Aug #15.1

· Big-AGI v2.1.0 — Added six vendors, updated models, and added transcription framework
· Homarr v1.76.0
· Convoy v26.7.3 — Postgres added as queue provider, rebuild indexes from dashboard

Browse everything at https://selfhost.directory

#homelab #database #docs #monitoring

«rustkvd — Production-grade Distributed Key-Value Store in Rust:
A battle-hardened distributed KV store built from scratch in Rust - Raft consensus, custom LSM tree, consistent hashing, MVCC, and gRPC API. Six crates. Zero compromises.»

Know this which of you and do you use it productively, what is your impression and experience with it?

🦀 https://vignesh2027.github.io/rustkvd/

#rustlang #database #keyvaluestore #api #rust #coding #kvdb #lsmtree #mvcc #db #grpc #question #askfedi

@vyruss shipped pg_statviz 1.2 with #PostgreSQL 19 support - tested against beta3, covering PG 13-19.

New blocking locks analysis module records blocked/blocking sessions by lock type using pg_blocking_pids(), soft blocks included. OpenAI provider joins Anthropic & Google options.

Zero external dependencies by default. AI analysis is fully opt-in - no external calls unless you ask.

Read the release notes: 📖 https://vyruss.org/blog/pg_statviz-1.2-released-postgresql-19-support.html

#OpenSource #Database #DataVisualization #pgstatviz #stats

🙋 Wil jij ook wat meer van je informatie/data/collecties structuren en de informatie vindbaar maken, maar ben je geen database-guru? Je bent niet de enige. Wellicht de is dan dit een prachtige optie: recutils.

⁉️ Wat is het?

- Een simpele database opgeslagen als een bestand met platte tekst
- Open source software, vrij en gratis
- Draait op Linux 🐧 en is een heel licht programma (geen achtergrondprogramma's, geen zware database)
- Helemaal op maat te maken naar jouw wens, al dan niet met scripts. Bijvoorbeeld interactief zoeken of juist eenvoudig houden.

In plaats van slechts een beschrijving heb ik het artikel meteen voorzien van een eerste database-voorbeeld.

Share 🔁, Like 👍️ and Subscribe 🔔 enzo 🙂

https://opensource.vooreenbeginner.nl/software/recutils-eenvoudige-databases-in-platte-tekst/

#database #opensource #Linux

The Redis SAVE Command: How to Accidentally DDoS Your Own Application — hands-on guide for sysadmins. #database #redis #performance

https://www.valtersit.com/guides/databases/the-redis-save-command-how-to-accidentally-ddos-your-own-application/

De blogpost is bijna klaar...

Nog even wat leuke opties erbij maken, zodat je bijvoorbeeld interactief kan zoeken in je data en actieve item tonen. Daarmee wordt het gebruik van je data ook leuker.

Wat is het?

- Een simpele database, die bijna iedereen kan maken
- Draait op Linux, geen achtergrondprogramma's, geen zware database
- Interactief zoeken gebeurt met fzf (optionele stap)

Is dit alleen voor bookmarks/bladwijzers? Nee, andere voorbeelden zijn je eigen adresboek met al je vrienden zijn, of je pakken opgedronken sinaasappelsap, of je collectie cassettebandjes.

#database #Linux

It seems like my blog (originally intended to be) has turned into more of an app with a lot of information related to me. Thanks to Ghost CMS's HTML card and another separate SQLite-based PocketBase backend.

https://the.kalvin.click

#tech #technology #webdev #coding #developer #ghostcms #pocketbase #sqlite #database #software #backend #frontend #tools #indieweb #blogging #design #ui

Stop Using pg_dump for Production Backups: The Case for WAL Archiving — hands-on guide for sysadmins. #database #postgresql #backups

https://www.valtersit.com/guides/databases/stop_using_pg_dump_for_production_backups-the_case_for_wal_archiving/

📢 New #updates · 21 Aug #3

· Onyx Community Edition v4.6.0 — Document index migration required before upgrading
· Wekan v11.06
· scalar release-2026-08-20-1e5ab85
· mStream v6.22.0 — Binary releases now support auto-update

More self-hosted updates → https://selfhost.directory

#homelab #docs #database

More details on the upcoming #duckdb version:

"DuckDB v2.0: Your #Database Deserves a Better #Parser"
https://duckdb.org/2026/08/20/duckdb-20-peg-parser

#SQL #OpenSource

Come chat #opensource observability with us at the Coroot Booth during Percona Live, Sept. 9 - 11!

Join the conference to meet global members of the open source database community and learn from expert keynote speakers. Register with PERCONALIVEAMS20 for 20% off: https://perconalive.com/2026-amsterdam/

#postgres #dba #devops #observability #monitoring #cloud #tech #ai #kubernetes #docker #opensource #database #cloudnativepg #postgresql #linux #perconalive #percona #coroot

I’m past the five minute mark on an SQL query. Everything should be fine, as I’m take a database online, backing it up, verifying that the backup worked, then taking it back offline.

But I’m nervous about it!
#sql #database

New Blog Post: pg_statviz 1.2 is out, with PostgreSQL 19 support, a new blocking locks module, and an AI provider for OpenAI API:

https://vyruss.org/blog/pg_statviz-1.2-released-postgresql-19-support.html

#PostgreSQL #Postgres #extension #pg_statviz #database #stats #statistics #visualization

A search engine is also cooking... another time. #database

Watch Now: https://zurl.co/pXxiY

Understanding Left Exclusive (Outer) Join | SQL Joins Explained with Examples

#SQL #SQLJoins #LeftJoin #LeftOuterJoin #LeftExclusiveJoin #SQLTutorial #LearnSQL #SQLForBeginners #Database #SQLQueries #DataAnalytics #Programming #TechTutorial #SQLInterview #DatabaseManagement

MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, & More

https://devblogs.microsoft.com/azure-sql/vscode-mssql-august2026/

#sqlserver #vscode #database #azuresql #mssql #data #devtools

📢 New #updates · 20 Aug #2

· firecrawl v1.11.0
· chatwoot v4.17.0 — Enhanced WhatsApp and Captain features with Rails upgrade
· e2b [email protected] — Updated server catalog with new additions and removals
· lightdash 1.210.0 — Merge queries by UUID for combined results

More self-hosted updates → https://selfhost.directory

#privacymatters #database #import #api

📢 New #updates · 19 Aug #16

· Ghost v6.59.0 — Fixed migrations and navigation markup issues, updated themes
· fluxer [email protected]
· Kaneo v2.20.0 — Improved error tracking and monitoring with Sentry integration

Full changelogs → https://selfhost.directory

#homeautomation #opensource #docs #database

📢 New #updates · 19 Aug #13

· Langfuse v4.15.0 — Enhanced sandbox tools, compact timeline, in-app agent foundation
· fluxer [email protected]
· lightdash 1.203.0 — Enhanced OAuth page with user and organization details
· inngest v1.42.0 — Added scores and experiments pages to dev server

More self-hosted updates → https://selfhost.directory

#homeserver #database #ai #auth

📢 New #updates · 19 Aug #12

· nocodb 2026.08.1 — Grid now shows real-time user presence and availability
· Wekan v11.05
· minecraft 2026.8.1 — Simplified API key handling and added version file warning
· fluxer [email protected]
· GrafanaMimir mimir-3.2.0 — Enhanced performance and added new features and fixes
· Bambuddy v1.2.6b1-daily.20260819

Browse everything at https://selfhost.directory

#datahoarder #docker #database #monitoring

🚀 Behold the Holy Grail of databases! 🤔 According to this revolutionary think piece, #PostgreSQL can do everything except make your coffee. ☕️ Who knew all other tech could just be tossed aside like yesterday's leftovers? 🍽️
https://www.raphaelbauer.com:443/posts/postgresql-everything/ #HolyGrail #Database #TechRevolution #CoffeeLovers #HackerNews #HackerNews #ngated

PostgreSQL for Everything

https://www.raphaelbauer.com:443/posts/postgresql-everything/

Comments: https://news.ycombinator.com/item?id=49361279

#HackerNews #PostgreSQL #Database #Development #DataScience #OpenSource #TechTrends

Testing code against idealized mock data validates the expected case but completely misses the chaotic entropy of a true production environment.

Databases accumulate real-world complexity over time like character encoding anomalies and query patterns that can trigger full table scans.

Closing the gap between a clean QA environment and production scale data is how you achieve true release confidence.

👉 https://upsun.com/blog/production-data-testing-vs-mock-data/ #PlatformEngineering #DevOps #Database #SoftwareTesting

Welcome ClickHouse as a Silver sponsor of PGConf.EU 2026 in Valencia!

https://2026.pgconf.eu/sponsors/

#postgres #pgconfeu #valencia #opensource #database