#databasearchitecture — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #databasearchitecture, aggregated by home.social.
-
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
-
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
-
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
-
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
-
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 and everyday use?
https://www.orioledb.com/blog/orioledb-bridged-indexes
#HackerNews #BridgedIndexes #OrioleDB #DatabaseArchitecture #DataInternals #EverydayUse
-
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 and everyday use?
https://www.orioledb.com/blog/orioledb-bridged-indexes
#HackerNews #BridgedIndexes #OrioleDB #DatabaseArchitecture #DataInternals #EverydayUse
-
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
