Mastodawn

Learn the key differences between SMP and MPP databases, and when to use each for OLTP transactions or large-scale analytical workloads. https://hackernoon.com/traditional-vs-mpp-databases-architecture-scaling-and-workload-tradeoffs #databasearchitecture

Traditional vs. MPP Databases: Architecture, Scaling, and Workload Tradeoffs | HackerNoon

Learn the key differences between SMP and MPP databases, and when to use each for OLTP transactions or large-scale analytical workloads.

Giovanni Martinez Mar 15

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

HackerNoon Feb 3

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.

Giovanni Martinez Nov 29

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

HackerNoon Sep 23, 2025

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

HackerNoon Sep 23, 2025

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.

Hacker News May 30, 2025

Bridged Indexes in OrioleDB: architecture, internals and everyday use?

https://www.orioledb.com/blog/orioledb-bridged-indexes

#HackerNews #BridgedIndexes #OrioleDB #DatabaseArchitecture #DataInternals #EverydayUse

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.

Zuri (he/him) ❌️👑 | 🕐 CET Jan 30, 2025

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