Backups must be restored and verified—I measured the conditions under which SQLite, PostgreSQL, and MySQL fail to restore and created a verification script

When judging whether a backup can be restored based solely on exit codes and integrity checks, I found conditions in SQLite, ...

How Identical Are 'Identical Characters' in Japanese? Measuring MySQL and PostgreSQL Collations and Full-Width Character Handling to Create a Duplicate Insp…

When applying UNIQUE constraints to Japanese names or addresses, or matching them via JOIN, the database collation determines ...