I’m thrilled to join the AWS Community Builders 2026 cohort! 🎉☁️
My first official deep dive is live. "Postgres=tables, Mongo=docs" is a myth. At scale, it's really about MVCC write amplification vs. WiredTiger Copy-on-Write.
Read the internal trade-offs here: https://dub.sh/L60SfSH
#AWSCommunityBuilders #AWS #PostgreSQL #MongoDB #DatabaseArchitecture
A retrospective of Riak database, covering its Dynamo design, Erlang implementation, consistency options, MapReduce support, and Bitcask storage engine. https://hackernoon.com/riak-as-a-reference-implementation-of-dynamo-style-leaderless-databases #databasearchitecture
Riak as a Reference Implementation of Dynamo-Style Leaderless Databases | HackerNoon

A retrospective of Riak database, covering its Dynamo design, Erlang implementation, consistency options, MapReduce support, and Bitcask storage engine.

Hello Mastodon! 👋 I’m Gio, a DBA in Florida at CoverMyMeds, transitioning into AI database architecture and ML engineering.
Building IqToolkit—an AI platform for PostgreSQL and MongoDB to solve real problems for database professionals.
Passionate about technology and community feedback. Let’s connect! 🚀
#Introduction #DatabaseArchitecture #PostgreSQL #MongoDB #AI #DBA
What TSDBs are, why they exist, and how they beat general DBs for high-ingest, and time-window queries https://hackernoon.com/the-database-zoo-inside-time-series-engines-influxdb-prometheus-timescale #databasearchitecture
The Database Zoo: Inside Time-Series Engines (InfluxDB, Prometheus, Timescale) | HackerNoon

What TSDBs are, why they exist, and how they beat general DBs for high-ingest, and time-window queries

Discover how SQL and NoSQL shaped modern data—and why specialized databases are rising to meet today’s diverse, high-scale workloads. https://hackernoon.com/the-database-zoo-sql-nosql-and-the-rise-of-specialized-engines #databasearchitecture
The Database Zoo: SQL, NoSQL, and the Rise of Specialized Engines | HackerNoon

Discover how SQL and NoSQL shaped modern data—and why specialized databases are rising to meet today’s diverse, high-scale workloads.

Bridged Indexes in OrioleDB: architecture, internals & everyday use? | OrioleDB

Since version beta10 OrioleDB supports building indexes other than B-tree. Bridged indexes are meant to support these indexes on OrioleDB tables.

When using a #MySQL database, is it possible in one go, when adding a new column to an existing table, to use one default value for existing columns (initial migration, so to speak), but another for every new row going forward (real default)?

Scenario: I want to set the value in pre-existing columns to true, but in all subsequent rows to false by default.

#amCoding #amProgramming #softwareDevelopment #softwareEngineering #databaseEngineering #databaseArchitecture #dbms #SQL

Hard to Kill: Why Auto-Increment Primary Keys Can Make Data Sync Die Harder | Joche Ojeda

🎯 2024 LinkedIn Rewind: A year of database education & architecture!

📊 Year in Numbers:
• 214 posts sharing database knowledge
• 1,670 community interactions
• 15,885 amazing followers

💡 Mission: Making database complexity simple

"Complex problems don't always need complex solutions. PostgreSQL proves this daily."

Generate your own journey card at coauthor.studio/rewind!

#DatabaseArchitecture #PostgreSQL #TechEducation #DataEngineering

Relational Databases Explained

How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.

Architecture Notes