Lmst

Avoid UUID Version 4 primary keys https://lobste.rs/s/btqb5d #databases
https://andyatkinson.com/avoid-uuid-version-4-primary-keys

Will Turso Be The Better SQLite? via @dgv https://lobste.rs/s/l2icfd #video #databases #rust
https://www.youtube.com/watch?v=1JHOY0zqNBY

Disks Lie: Building a WAL that actually survives https://lobste.rs/s/ijq6dr #databases
https://blog.canoozie.net/disks-lie-building-a-wal-that-actually-survives/

🤔 Ah, the mind-blowing revelation that #exchanges are like databases! Who knew thousands of orders every #millisecond required complex systems? 🙄 Next, they'll uncover that water is wet.🌊
https://quant.engineering/exchange-order-book-distributed-logs.html #databases #complexity #mindblown #wateriswet #HackerNews #ngated

VACUUM Is a Lie: About Your Indexes

https://fed.brid.gy/r/https://boringsql.com/posts/vacuum-is-lie/

VACUUM Is a Lie: About Your Indexes via @fmeyer https://lobste.rs/s/zhfh4t #databases
https://boringsql.com/posts/vacuum-is-lie/

I was a guest this week on the FLOSS Weekly podcast (https://hackaday.com/2025/12/10/floss-weekly-episode-858-yottadb-sometimes-the-solution-is-bigger-servers/). The host, Jonathan Bennett, and I had an enjoyable discussion about YottaDB. #flossweekly #opensource #databases @FLOSS_Weekly

pg_exporter: A PostgreSQL metric exporter for Prometheus written in Rust https://lobste.rs/s/kxndle #databases
https://github.com/nbari/pg_exporter

Litestream VFS https://lobste.rs/s/p20st3 #databases
https://fly.io/blog/litestream-vfs/

☁️ 🐘 Learn how to manage complex cloud environments with #Coroot Co-Founder Peter Zaitsev’s keynote at @p2d2! https://p2d2.cz/en/

Join January 28th, 15:35–16:25 (GMT+1) to sharpen your cloud-native #postgres observability with topics such as #eBPF and automatic discovery mechanisms for High Availability postgres clusters.

#softwarelibre #opensource #freesoftware #DevOps #SRE #kubernetes #observability #cloud #databases #postgreSQL #highavailability

If your app’s memory usage is rising faster than gas prices in a Fast & Furious movie...

Learn how structure choice impacts memory and growth limits.

https://jeffbailey.us/blog/2025/12/06/fundamentals-of-data-structures/

#Data #Storage #Databases #Software #Technology #Programming #SoftwareDevelopment #Coding #SoftwareEngineering

🚀 **Cập nhật `pg_search`: Hỗ trợ tìm kiếm facet** với giao diện tùy chỉnh, kết hợp lập kế hoạch và quét trực tiếp để tối ưu hóa BM25 index (dựa trên Tantivy). Kết quả trả về JSON kèm thống kê nhanh nhờ cấu trúc cột. #pg_search #PostgreSQL #TìmKiếmTốiƯu #BM25 #FacetedSearch #CơSởDữLiệu #DevUpdate

(*tags: #postgresql #facetsearch #tantivy #databases #developernews*)

https://www.paradedb.com/blog/faceting

Why did we create snowflake sequences when UUIDs exist? ❄️

While they're very similar in purpose, snowflake sequences are more efficient because they encode information like the creation timestamp & the ID of the server that created it in half the size (8 bytes vs. 16 bytes).

They're a huge asset for unique ID management & key generation in distributed databases. Learn more about them here: https://www.pgedge.com/blog/introducing-snowflake-sequences-in-a-postgres-extension-2

#postgresql #postgres #programming #tech #databases #data #devops #opensource

You Don't Need an ORM https://lobste.rs/s/lrnk2e #video #databases #gleam
https://www.youtube.com/watch?v=XEJxk5VUSTs

Modern SQL: Beyond Relational https://lobste.rs/s/ppvzn7 #databases
https://modern-sql.com/

New patch release is out with updated dependencies, improved default configurations and minor concurrency fixes, release notes: https://github.com/orientechnologies/orientdb/releases/tag/3.2.47

#nosql #databases #database #dbms
#graphdb #OrientDB