SQL

• Alphabetic order for fields in SELECT! The only maintainable solution.
• Do not use UNSIGNED; it is non-standard and not all that useful: https://stackoverflow.com/a/4452091
• MySQL: nullable columns always have a default value of NULL
• Dolt is Git for Data

SQL criticism

• Some opinionated thoughts on SQL databases (2021)
• Against SQL (2021)

Usage in C++

• Mapping generator (databasetool) (code)
• Real-world example: ThumbnailDatabase in Chromium