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…
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…
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…
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 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…
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…
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…
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…
Until now, lqo advise needed something to read: a file of SQL statements, or a PostgreSQL log with durations in it. On a managed database the log is often the hard part. It may be switched off, kept…
Until now, active mode skipped every statement an application sent inside its own transaction. That was most of the traffic from an ORM, since Django, Rails, Hibernate and SQLAlchemy all wrap their…