#databasearchitecture — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #databasearchitecture, aggregated by home.social.
-
This Microsoft article explains how Azure HorizonDB can support AI-powered retrieval directly inside PostgreSQL by combining operational data, vector search, keyword search, filters, indexing, and relevance ranking in one platform.
#PostgreSQL #AzureHorizonDB #MicrosoftAzure #ArtificialIntelligence #GenerativeAI #RAG #VectorSearch #DatabaseArchitecture #DataEngineering
https://techcommunity.microsoft.com/blog/adforpostgresql/ai-powered-retrieval-in-postgresql-with-azure-horizondb/4540160?wt.mc_id=DP-MVP-4015656 -
Learn the difference between OLTP and OLAP databases, why PostgreSQL struggles with analytics, and how ClickHouse solves it https://hackernoon.com/oltp-vs-olap-why-your-app-database-isnt-built-for-analytics #databasearchitecture
-
Es gibt einen vereinfachten Satz, der mir das Thema Datenbanken seit Jahren erklärt: Die Struktur deines Datenspeichers sollte zur Struktur deiner Frage passen. Nicht zur Datenmenge, nicht zur Mode, nicht zum Hype. Zur Frage die zur Lösung deines Problems führt.
#database #coding #design #development #dev #databasearchitecture #dataanalysis #dataanalytics #question #databaseperformance #datascience #db
-
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
-
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
