#databasearchitecture — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #databasearchitecture, aggregated by home.social.
-
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