I have a system where we generate 'physical sql' targeting the different database for a 'logical sql'. We have a bunch of supported DBs where the physical sql is supported (Oracle, MySql, Postgres etc). I am adding SQLite as a new DB to be supported but we can reuse the physical sql generator. I guess my question is which generator would generate a sql which is closer to SQlite. Couple of options that I can think is either MYSQL or ORACLE DB.
Asked
Active
Viewed 111 times
0
-
Yes, MySQL has some similarities to SQLite. Best practice for _all_ of your database code would be to adhere to the ANSI SQL standard as closely as possible. – Tim Biegeleisen Jun 25 '20 at 04:53
-
Thanks a lot :) Will try to update this thread if I find anything glaringly incompatible! – Shash Jun 25 '20 at 08:34
-
SQLite sometimes uses PostgreSQL for inspiration, e.g. [UPSERT](https://www.sqlite.org/lang_upsert.html) – bwt Jun 26 '20 at 08:50