Tag: database
All the articles with the tag "database".
-
How I Spent Half a Day Fixing a WordPress Charset Problem (and What I Learned)
Kruno Golubić
A WooCommerce site with an ERP integration in progress. The external developer reported a mixed encoding in the database: latin1, utf8mb3, and utf8mb4. ALTER TABLE looked like the right move. But it wasn't so.
-
Optimizing Graph Databases through Denormalization
Kruno Golubić
How and why to denormalize graph databases to improve performance: identifying candidates for denormalization, strategies (data duplication, aggregation, path materialization), and trade-offs.
-
Understanding Database Snapshots
Kruno Golubić
A deep dive into database snapshots: how they work, copy-on-write vs redirect-on-write, how Memgraph handles snapshots, advantages, pitfalls, and best practices.
-
What is a Key-Value Database?
Kruno Golubić
An introduction to key-value databases: how they work, their benefits (speed, horizontal scaling, flexible data models), potential drawbacks, and when to use them.