The Art of Eating Mortadella: Why Less Is More
The simplest way to enjoy mortadella may also be the best: freshly sliced, gently served, and paired with good bread.
Latest articles, page 22 of 58 ↓
ALTER TABLE Changes a Column One Way on PostgreSQL and Another on MySQL
A migration widens a column with ALTER TABLE products MODIFY name VARCHAR(80) , and it runs on MySQL and MariaDB. PostgreSQL wants ALTER COLUMN name TYPE VARCHAR(80) , and SQLite can’t change a…
AVG Returns Four Decimal Places on MySQL and Sixteen Digits on PostgreSQL
The average rating of a product with ratings 1, 2 and 2 is 1.6667 on MySQL and MariaDB and 1.6666666666666667 on PostgreSQL and SQLite. A test that compares the number exactly passes on one and fails…
BareSQL Audit Now Reads Every Database of a Server and Says What Row Security Lets Through
Roles in PostgreSQL belong to the whole server, and tables to one database. Until now an audit followed that split: one database per run. A login that could read customer emails in the shop database…
BareSQL Portable Now Flags Schema Changes and Reserved Words That Break on Other Engines
The first release of BareSQL Portable came with a list of differences it knew about and had no rule for yet. A migration that changes a column, a table with a column called rank , a dashboard that…
Column Names Like rank and key Are Reserved Words on Some SQL Engines
A leaderboard table with a column called rank works on SQLite, PostgreSQL and MariaDB. On MySQL 8 the CREATE TABLE fails, because rank became a reserved word when window functions arrived. BareSQL…
Bootstrapping Now Runs on MySQL and MariaDB and Posts Seed Plans on Pull Requests
Bootstrapping 0.3 is out. It now runs on MySQL 8.0 and later and MariaDB 10.6 and later, as well as SQLite and PostgreSQL. A reference can name its row by several columns. And the repository is now a…
Inorderly 0.2 Orders Events Straight From Kafka, NATS and Redis Streams
The events that need ordering mostly don’t live in files. They sit in a Kafka topic, a NATS stream or a Redis stream, and until now getting them through Inorderly meant a script in front of it and…
KeyValueStore Tools 0.2 Adds a Cluster Rebalancing Planner and Sizes Redis and Valkey Streams
Adding a primary to a Redis or Valkey cluster is the easy part. Then it sits there with no slots, and somebody has to decide which of the other primaries’ 16,384 slots go to it, move them, and not…
KeyValueStore Tools 0.2.1 Moves to the Newest Redis and Valkey Patches
Three of the tools answer from recordings of real servers: the Memory Calculator , the Config Checker and the ACL Builder . Each recording comes from one patch release, and patch releases are supposed…