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ć
Converting a WordPress database to utf8mb4 with ALTER TABLE garbled its Croatian characters, because the data had been stored as latin1 bytes for years. A latin1 dump and a utf8mb4 reimport fixed it.
-
Optimizing Graph Databases through Denormalization
Kruno Golubić
Denormalizing a graph database trades redundancy for speed: duplicate or aggregate data, materialize paths and restructure relationships where queries run slow. The price is more maintenance and a risk to data integrity.
-
Understanding Database Snapshots
Kruno Golubić
A database snapshot records the state of a database at one moment and then stores only the changes, unlike a full backup. Copy-on-write and redirect-on-write do this differently, and Memgraph uses full snapshots with write-ahead logging.
-
What is a Key-Value Database?
Kruno Golubić
Key-value databases store each record under a unique key, which makes them fast and easy to scale horizontally. They struggle with complex queries and with relationships between data, so they suit some workloads and not others.