Ask HN: PostgreSQL or MySQL?

Re:Ask HN: PostgreSQL or MySQL? by madhadron on Sunday September 22, 2019 @11:51AM (#21041921)

1. Do you have experience running PostgreSQL or MySQL in production? Use what you know. Do you have friends or colleagues with that experience? Use what they know. Is the stack you end up using predominantly used with one or the other, so you have lots more people in the community who will have hit issues you might have? Use that one. Failing any of those? Default to PostgreSQL.

2. I think you mean SQL+JSON, and the answer is PostgreSQL's JSONB columns, or dumping blobs into rows in MySQL (just keep your row sizes below 4kb).

3. Possible? Yes. A good idea? Almost never. Trees and relations are quite mathematically different, and you will need to specify quite a bit of the mapping to make it come out in a way you would actually want to work with.

4. Not really...generally you would have a SQLite database. If you need stuff that doesn't go in well as a blob, you would put it in a file and include a reference in the database.

[ Parent | on HN ]

Re:Ask HN: PostgreSQL or MySQL? by shrimpx on Sunday September 22, 2019 @12:29PM (#21042207)

Mysql has json columns. You can select and create indexes on json fields.

[ Parent | on HN ]

Re:Ask HN: PostgreSQL or MySQL? by tmk1108 on Monday September 23, 2019 @11:44PM (#21056299)

Can you expand on the 4kb part of row sizes? I have been experimenting with storing json in MySQL tables and I'm curious about this limit

[ Parent | on HN ]

Re:Ask HN: PostgreSQL or MySQL? by madhadron on Tuesday September 24, 2019 @11:28AM (#21061209)

MySQL expects rows to be fairly small, which leads to decisions about how the system handles loading data. You can put larger blobs in, but it may have adverse performance implications.

[ Parent | on HN ]