SQL
PostgreSQL, MySQL, SQL Server, Oracle and SQLite Compared
One reference table for the differences that actually break code: paging, auto increment, strings, dates, upserts and the features each product lacks.
SQL Dialects
Where PostgreSQL, MySQL, SQL Server, Oracle and SQLite differ.
2 notes
Notes
SQL
Writing Portable SQL
How much portability is worth paying for, which constructs are safe everywhere, and how to isolate the parts that can never be portable.