General database
Database concepts, industry news and topics that span every engine.
Articles and news that aren't tied to a single database engine: data management fundamentals, big data, the Microsoft data platform, security, data science and the wider database industry.
GeneralIntermediateAdjacency lists, materialized paths, nested sets and closure tables compared, and why a parent_id column plus a recursive CTE is the right default.
#data-modeling#schema-design
GeneralIntermediateSelect-then-insert breaks under concurrency. Use a unique constraint plus one atomic statement: ON CONFLICT, ON DUPLICATE KEY UPDATE, or UPDLOCK/SERIALIZABLE in SQL Server.
#concurrency#schema-design#transactions
GeneralBeginnerThe N+1 query problem: each query takes 1 ms, but there are 301 of them. How to spot it, fix it with eager loading and avoid the cartesian-explosion overcorrection.
#orm#performance#troubleshooting
GeneralBeginnerOmniDB, the browser-based database manager, has had no release since 2020. See what it offered, the risks of still running it, and which tools replace it.
GeneralBeginnerSee what a DBMS does internally, from query processor to storage engine and transaction log, compare the main types of DBMS, and learn how to choose one.
#db-administration
GeneralBeginnerSee where databases and SQL fit in data-science work, from profiling and feature tables to window functions, and avoid the joins and NULLs that skew results.
#data-science
GeneralBeginnerDecide between a relational and a NoSQL database by comparing schema enforcement, query flexibility, transactions, consistency and scaling, with a practical checklist.
#nosql#scalability
GeneralBeginnerLearn what the Paradox desktop database was, what its .db, .px and .mb files contain, and how to export legacy Paradox tables to CSV or SQL today.
GeneralBeginnerIn this article you will learn about the basics of SisoDB. SisoDb is a schema-less document-oriented provider for SQL Server.
#sisodb
GeneralBeginnerThis article will provide an insight to ThruDB, and the features and services provided by it. ThruDB is an open source database built on top of Apaches Thrift framework.
#thrudb
GeneralBeginnerUnderstand the four NoSQL families (key-value, document, wide-column and graph), see a working example of each, and learn what each one makes you give up.
#big-data#nosql
