Library
150 results
MySQLIntermediateIn MySQL's InnoDB, the table is the primary key index. That single fact shapes insert speed, index size and how you should pick primary keys.
#indexing#internals#schema-design
The core modeling decision in MongoDB, with simple rules of thumb for one-to-few, one-to-many and many-to-many relationships.
#data-modeling#nosql#schema-design
RedisBeginnerPut Redis in front of your database the right way — choose a caching pattern, set sane TTLs, and avoid stampedes and stale data.
#caching#nosql#performance
SQLiteIntermediateSQLite can serve real production traffic. Here's how WAL mode changes concurrency, which PRAGMAs to set, and where the limits are.
#concurrency#internals#performance
Apache CassandraIntermediateForget normalization. In Cassandra you model one table per query, choose partition keys carefully and keep partitions bounded.
#data-modeling#nosql#schema-design
Oracle DatabaseIntermediateIn this article, we will see what the newly launched Eighth Generation of Oracle SPARC platform has to offer.
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.
Oracle DatabaseBeginnerCreate, find, drop, disable and enable primary keys in Oracle, including composite keys, identity columns, the index behind the constraint and the ORA errors you will hit.
MySQLBeginnerHow NULL behaves in MySQL comparisons, functions, aggregates, sorting, constraints and indexes, with the queries that silently drop rows and how to fix them.
PostgreSQLBeginnerInstall a current PostgreSQL release on Windows, Debian or Ubuntu, RHEL-family Linux or Docker, make the first connection and fix the usual post-install errors.
#installation
MySQLBeginnerLearn what MySQL Enterprise has to offer to developers and enterprises to build and manage scalable, reliable, and highly available database.
