4 ms·
I wish SQLite had a PostgreSQL compatibility layer. Right now, to add SQLite support to a Go project (or anything without an ORM), you have to rework all your
by candiddevmike 6y ago
I wish SQLite had a PostgreSQL compatibility layer. Right now, to add SQLite support to a Go project (or anything without an ORM), you have to rework all your queries and migrations. It's probably an impossible ask, but having a compatibility flag within SQLite so it would accept PostgreSQL formatted queries would be extremely helpful.
- smilliken 6y agoAbstracting over two complex and evolving systems is a bottomless well of bugs. Contributers would shy away from this sort of compatibility because it would encourage users to ignore the differences at first, and then complain loudly when they are discovered.
- justsomeuser 6y agohttps://www.jooq.org/translate/ https://www.jooq.org/translate/ This does simple syntax translation, have not used it though. Combine with a Golang AST lib and you might be able to make a CLI translate tool like `fix`.
- deleted 6y ago[deleted]