search

tursodatabase / libsql

libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
https://turso.tech/libsql
MIT License
8.78k stars 235 forks source link

Improve compatibility with PostgreSQL dialect #80

Closed penberg closed 5 days ago

penberg commented 1 year ago

The SQL dialect in SQLite/libSQL is very similar to PostgreSQL, but there are some differences, which make porting apps between the two databases hard. For example, PostgreSQL supports dropping multiple tables in a SQL statement, whereas SQLite dialect does not. It would be great if libSQL attempted to narrow the gap between the SQL dialect differences, perhaps as a separate "PostgreSQL compatibility mode" to retain full SQLite compatibility by default. Types are perhaps the most difficult part, but I would just start with sticking to SQLite types.

Abdur-rahmaanJ commented 1 year ago

A special mode for postgres sounds awesome!

psarna commented 1 year ago

That's also a great umbrella issue! Pretty sure that https://github.com/libsql/libsql/issues/43 would also narrow the gap

penberg commented 1 year ago

Here's another issue that's under this umbrella: https://github.com/libsql/libsql/issues/107

penberg commented 5 days ago

We no longer are pursuing PostgreSQL compatibility so closing this.