BareSQL Audit lists every column each PostgreSQL login can read, with the route that gets it there, and marks the personal data. BareSQL Portable finds the SQL that answers differently on SQLite, PostgreSQL, MySQL and MariaDB and says what to write instead. Both come in one small program.
58
SQL differences BareSQL Portable checks, each run on all four engines
1,212
Answers recorded from the real SQLite, PostgreSQL, MySQL and MariaDB engines
2.3 s
To audit 1,000 tables and 50 logins, sampling values, on 2 CPUs
13
Database server versions every change is tested on, PostgreSQL 13 to 18 among them
Answers recorded on SQLite 3.45.1, PostgreSQL 16.15, MySQL 8.0.46 and MariaDB 10.11.14; the audit timing on PostgreSQL 16.15, 2 CPUs. The recorded runs are in the code repository on GitHub.
SQL differences
Searching for the text 50_off with LIKE '50\_off' works on PostgreSQL, MySQL and MariaDB, where the backslash escapes the underscore. SQLite treats the backslash as an …
SQL differences
A Windows path written as 'C:\temp\new' reads back on MySQL and MariaDB with a tab and a line break in it. PostgreSQL and SQLite keep the backslashes as typed. 'C:\\temp' …
case studies
This case study runs on the sample shop database that BareSQL’s tests build, so the shop is made up, and the outputs are what BareSQL printed. The shop reviews database …
case studies
This case study runs on the sample shop database that BareSQL’s tests build, so the shop is made up, and the outputs are what BareSQL printed. Its support team looks …
SQL differences
due_date + 1 reads like the day after, and on PostgreSQL that is what it gives. On MySQL, MariaDB and SQLite the answer is a plain number. MySQL and MariaDB turn the date …
SQL differences
MySQL examples often quote every name in backticks, as in SELECT `name` FROM `people`. Copied into a PostgreSQL project, the query fails. `name` is MySQL’s way of quoting …
BareSQL
BareSQL is a free, open-source command-line program with two tools in it. BareSQL Audit lists every column each PostgreSQL login can read, with the route that gets it …
SQL differences
CAST(order_id AS CHAR) looks like a safe way to turn a number into text. On PostgreSQL CHAR without a length means one character, so order 123 comes back as '1'. …
SQL differences
Filtering orders with CAST(created_at AS DATE) = '2024-05-06' works on PostgreSQL, MySQL and MariaDB. SQLite has no date type, turns the CAST into a number and keeps only …
If BareSQL nearly fits your database or your project, or you'd like a check it doesn't do yet, write in.