Ask HN: PostgreSQL or MySQL? • Hacker News Board

Re: Ask HN: PostgreSQL or MySQL?

#31

Post by OldHand2018 » Sun, Sep 22, 2019, 1:40 PM UTC

For point 3 (Is it possible to convert XML(XMI) schema to SQLite schema automatically?), are you asking about a tool that takes an XML schema and gives you back an SQL schema?

I haven't heard of anything, but I would imagine it exists. I have, on the other hand, done a fair amount of XML to SQL conversion and have found that generating a good schema involves understanding the data so you know what to denormalize. You don't really want to have thousands of tables, each representing an XML tag. That would make your database very hard to use.

Trial and error, and a good knowledge of what kind of questions you are going to be asking your database to answer...

Re: Ask HN: PostgreSQL or MySQL?

#32

Post by namewasmypw » Sun, Sep 22, 2019, 1:41 PM UTC

MySQL is simply garbage that shouldn't be used under any circumstance.

1. No transactional DDL 2. Implicit, confusing coercions 3. Terrible Unicode handling 4. the list goes on

Re: Ask HN: PostgreSQL or MySQL?

#33

Post by rayrrr » Sun, Sep 22, 2019, 1:46 PM UTC

MySQL: Wait a sec, what do I use for this table, InnoDB or MyISAM? What are the tradeoffs again? Oh, right, do I want ACID transactions or fulltext search? Man, this tradeoff sucks.

PostgreSQL: Wait a sec, which schema (namespace) should I put this table in? Man, it's nice to have namespaces within a DB.

Re: Ask HN: PostgreSQL or MySQL?

#34

Post by mighty_bander » Sun, Sep 22, 2019, 1:51 PM UTC

For very simple usage, you won't see a lot of difference, but I would go with postgres. It has a lot of features that MySql doesn't, and isn't any harder to set up and use.

Point 2: as long as you also write software to deal with it, I guess so. Postgres has a JSON type. This question makes me want to ask what you are trying to accomplish.

Point 3: Yes, probably, and for all I know there's something out there to do it for you. I'm assuming basic usage; there is undoubtedly some weird corner of xmi that makes it a Turing-complete language or something equally ill-advised. So writing a schema converter for very basic stuff is probably quite easy, but really filling in all the junk is possibly less so.

4 appears to be a repeat of 2.

Re: Ask HN: PostgreSQL or MySQL?

#35

Post by Thaxll » Sun, Sep 22, 2019, 1:53 PM UTC

rayrrr wrote: post #33

MySQL: Wait a sec, what do I use for this table, InnoDB or MyISAM? What are the tradeoffs again? Oh, right, do I want ACID transactions or fulltext search? Man, this tradeoff sucks. PostgreSQL: Wait a sec, which schema (namespace) should I put this table in? Man, it's nice to have namespaces within a DB.

No one has been using MyISAM for the last 10 years.

Re: Ask HN: PostgreSQL or MySQL?

#36

Post by LordHeini » Sun, Sep 22, 2019, 1:56 PM UTC

I would also recommend Postgres for the features alone. Like the full text search.

One reason not mentioned often is the vast amount of plugins which can do lots of useful things.

Like PostGis or TimescaleDb which all work really well.

Re: Ask HN: PostgreSQL or MySQL?

#37

Post by rayrrr » Sun, Sep 22, 2019, 1:57 PM UTC

Thaxll wrote: post #35

rayrrr wrote: post #33

MySQL: Wait a sec, what do I use for this table, InnoDB or MyISAM? What are the tradeoffs again? Oh, right, do I want ACID transactions or fulltext search? Man, this tradeoff sucks. PostgreSQL: Wait a sec, which schema (namespace) should I put this table in? Man, it's nice to have namespaces within a DB.

No one has been using MyISAM for the last 10 years.

Funnily enough, I have not been using MySQL for the last 10 years either, because I switched to Postgres and never went back.

Re: Ask HN: PostgreSQL or MySQL?

#38

Post by NightlyDev » Sun, Sep 22, 2019, 1:58 PM UTC

rayrrr wrote: post #33

MySQL: Wait a sec, what do I use for this table, InnoDB or MyISAM? What are the tradeoffs again? Oh, right, do I want ACID transactions or fulltext search? Man, this tradeoff sucks. PostgreSQL: Wait a sec, which schema (namespace) should I put this table in? Man, it's nice to have namespaces within a DB.

InnoDB got fulltext search support nearly 7 years ago if I remember correctly...

Re: Ask HN: PostgreSQL or MySQL?

#39

Post by johannes1234321 » Sun, Sep 22, 2019, 2:00 PM UTC

rayrrr wrote: post #33

MySQL: Wait a sec, what do I use for this table, InnoDB or MyISAM? What are the tradeoffs again? Oh, right, do I want ACID transactions or fulltext search? Man, this tradeoff sucks. PostgreSQL: Wait a sec, which schema (namespace) should I put this table in? Man, it's nice to have namespaces within a DB.

InnoDB has Fulltext search for about 10 years now. Also in other regards InnoDB has all MyISAM funcionality for a while and is faster in by far most realistic scenarios.

Re: Ask HN: PostgreSQL or MySQL?

#40

Post by estsauver » Sun, Sep 22, 2019, 2:00 PM UTC

baragiola wrote: post #26

jstewartmobile wrote: post #2

#1: depends on your scenario. Postgres is more like Oracle--there are types of query it can do natively that would have to be externally assisted with MySQL. MySQL is simpler, has all kinds of warts, but scales decently. Here's why uber moved to MySQL: https://eng.uber.com/mysql-migration/ #2-4: My use of SQLite has always been very basic, so no idea. Per SQLite's author: " SQLite does not compete with client/server…

That's a very interesting article. Does anybody knows if Postgres 10 and 11 addressed any of those issues?

https://news.ycombinator.com/item?id=14222721 is a continued discussion of the response.