Nicolas Martyanoff on Nostr: npub1fzx00…wt6h3 I'm not sure I understand your point of view on ...
npub1fzx00c36ny4whyuhg4ykx6987wxp885fmwmc784n27qcu6pavwzs3wt6h3 (npub1fzx…t6h3) I'm not sure I understand your point of view on "interoperability".
PostgreSQL is a SQL database which supports the SQL standard, and it is one of the most compliant SQL database out there. If you use standard SQL, Pg will be interoperable with any other compliant SQL database.
Pg also support incredibly useful extensions, and obviously other SQL databases do not support them. But you do not have to use them.
I'm not sure why it should imply that Pg "doesn't shine at all".
In addition to that, BOOLEAN is absolutely a standard type (SQL:1999).
For database transfer, have a look at pgloader, I know people having used it successfully for large and complex databases.
PostgreSQL is a SQL database which supports the SQL standard, and it is one of the most compliant SQL database out there. If you use standard SQL, Pg will be interoperable with any other compliant SQL database.
Pg also support incredibly useful extensions, and obviously other SQL databases do not support them. But you do not have to use them.
I'm not sure why it should imply that Pg "doesn't shine at all".
In addition to that, BOOLEAN is absolutely a standard type (SQL:1999).
For database transfer, have a look at pgloader, I know people having used it successfully for large and complex databases.