What is Nostr?
Nicolas Martyanoff /
npub17vs…jc6l
2023-12-12 12:05:37
in reply to nevent1q…yk32

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.
Author Public Key
npub17vstmkjpd25e72hqjjwu54krhav2nq2unhnm49g268a9drdzhqtqjmjc6l