Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ask HN: Is PostgreSQL better than MySQL?

news.ycombinator.com

Post reply on HN
Print view View original

81–83 of 83 posts

Re: Ask HN: Is PostgreSQL better than MySQL?

#81

Post by markusw »

Euphorbium wrote: post #53
Glench wrote: post #45

Earlier quoted context omitted.

Incorrect. Here are some actual numbers: https://blog.wesleyac.com/posts/consider-sqlite > Writing 512 byte blobs as separate transactions, in WAL mode with synchronous=normal3, temp_store=memory, and mmap enabled, I got 13.78μs per write, or ~72,568 writes per second.

Go on, trust the metrics. It locked up every time I had to do many writes without delay.

Then you did something wrong. SQLite has phenomenal performance for many workloads: https://www.golang.dk/articles/benchmarking-sqlite-performan...

Re: Ask HN: Is PostgreSQL better than MySQL?

#82

Post by autra »

sam_lowry_ wrote: post #65
taylodl wrote: post #49

Here's my experience with PostgreSQL: Coming from Oracle, I've been able to use PostgreSQL pretty much as though it were Oracle, including Oracle's optimistic locking strategy. Some of the SQL functions are a little different, but it seems the underlying philosophy is the same. In other words, PostgreSQL seems like Oracle, just a little different. MySQL has always felt completely foreign to me. Depending on your back…

Hah, I always felt the same about Postgres and I still prefer the MySQL cli. The concept of schema is also weird for MySQL users, although pervasive in some kind of Michael Stonebreaker' worldview.

I can understand it being weird, but when you get used to it, it's really really handy, for instance to manage user rights. I've read somewhere that actually, pg schemas compares more with mysql database, postgresql databases being an additional level wrapping it.

Re: Ask HN: Is PostgreSQL better than MySQL?

#83

Post by sam_lowry_ »

autra wrote: post #82
sam_lowry_ wrote: post #65

Earlier quoted context omitted.

Hah, I always felt the same about Postgres and I still prefer the MySQL cli. The concept of schema is also weird for MySQL users, although pervasive in some kind of Michael Stonebreaker' worldview.

I can understand it being weird, but when you get used to it, it's really really handy, for instance to manage user rights. I've read somewhere that actually, pg schemas compares more with mysql database, postgresql databases being an additional level wrapping it.

Exactly, every sysadmin wants to manage user rights in his own ingenious way through schemas.
Post reply on HN