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

Postgres 11 – A First Look

craigkerstiens.com

Post reply on HN
Print view View original

41–50 of 193 posts

Re: Postgres 11 – A First Look

#41

Post by johncolanduoni »

mrep wrote: post #37
kstrauser wrote: post #31

A million things like this are why PostgreSQL is the only relational database I consider for, well, pretty much anything. Their approach of “build it safe and then make it fast” has been paying off in spades for a couple of decades now. Thanks for everything you do, psql maintainers!

100% naive question: why is mysql and their similars so popular then? Spanner and AWS Aurora base off of more mysql than postregsql from what I can tell. Why?

Probably because compatability with MySQL is more valuable than comparability with Postgres from a product perspective.

Re: Postgres 11 – A First Look

#42

Post by tejtm »

mrep wrote: post #37
kstrauser wrote: post #31

A million things like this are why PostgreSQL is the only relational database I consider for, well, pretty much anything. Their approach of “build it safe and then make it fast” has been paying off in spades for a couple of decades now. Thanks for everything you do, psql maintainers!

100% naive question: why is mysql and their similars so popular then? Spanner and AWS Aurora base off of more mysql than postregsql from what I can tell. Why?

Will make an attempt to answer, hopefully without starting anything. Mysql aimed for lowering bar for non-dba-app-developers. Postgres did not. In some cases it matters, in many it does not, especially if you have the dba skills on hand to mind the gaps.

Re: Postgres 11 – A First Look

#43

Post by y4mi »

eitally wrote: post #39
dvlsg wrote: post #30

Earlier quoted context omitted.

I find myself pressing ctrl+c on windows.

ctrl+c also works on Crosh (Chrome Shell).

But not on Windows cmd

I think it worked in powershell however, can't test right now though

Also: chromeos is Linux. It's a safe bet they'll support standard signals

Re: Postgres 11 – A First Look

#44

Post by colanderman »

viraptor wrote: post #19
pkulak wrote: post #15

Earlier quoted context omitted.

You're wrong. I think the bike shed should be blue. ;)

This isn't really about alternatives. Bike shedding could be about exit-vs-quit or similar. Ctrl-d exists a layer above though. In a typical terminal / readline, your process will get an EOF / HUP signal which is treated like a clean-exit in most interactive cases and config-reload in many servers. Just like ctrl-c generates INT and ctrl-z generates STP. This is worth learning.

Don't forget Ctrl-\. For when you feel like Ctrl-C is too nice. (It sends SIGQUIT.)

Re: Postgres 11 – A First Look

#46

Post by ma2rten »

mrep wrote: post #37
kstrauser wrote: post #31

A million things like this are why PostgreSQL is the only relational database I consider for, well, pretty much anything. Their approach of “build it safe and then make it fast” has been paying off in spades for a couple of decades now. Thanks for everything you do, psql maintainers!

100% naive question: why is mysql and their similars so popular then? Spanner and AWS Aurora base off of more mysql than postregsql from what I can tell. Why?

MySQL used to be more popular. It was the M in the LAMP stack, which virtually everyone used to use.

It also used to be more scalable, because PG's replication story used to be poor. This is why Google and (I assume) Amazon used MySQL internally. This is all a long time ago, but I suspect this is the reason more people are familiar with MySQL than Postgres at these companies. Keep in mind that Spanner was developed and used internally at Google long before it was publicly announced.

Re: Postgres 11 – A First Look

#47

Post by manigandham »

mrep wrote: post #37
kstrauser wrote: post #31

A million things like this are why PostgreSQL is the only relational database I consider for, well, pretty much anything. Their approach of “build it safe and then make it fast” has been paying off in spades for a couple of decades now. Thanks for everything you do, psql maintainers!

100% naive question: why is mysql and their similars so popular then? Spanner and AWS Aurora base off of more mysql than postregsql from what I can tell. Why?

MySQL was easier to run.

Both for beginners where it was packaged with PHP and available with basically every webhost, and for advanced users that took advantage of the simple and reliable replication. There were a lot of problems with it, but the novice users didnt run into them and the advanced users knew how to deal with it. These decades of mainstream use carry a lot of momentum and many large companies continue to use it because they've always used it (like Youtube for example).

PostgreSQL only recently became much more usable after v9.5 and is now being recognized and growing in popularity.

Re: Postgres 11 – A First Look

#48

Post by freeopinion »

Jedd wrote: post #34
craigkerstiens wrote: post #22

Earlier quoted context omitted.

Original author here. Yes, it's great to learn Ctrl + D. But losing out on beginners that aren't familiar in favor of things that are naturally intuitive is a great way to make those who are new to programming and especially databases feel like they're dumb or not capable of it. I still recall the first time I was in vi and I couldn't figure out how to get out of the damn thing, and don't get me started on arrow keys…

You use the word intuitive a couple of times, and suggest there's a natural way to exit interactive cli programs (and it's not ctrl-d). Yet for me, ctrl-d is my usual first way of trying to exit any shell or cli utility. Whether it's natural or not, I couldn't say. Arguably the nipple is the first and only intuitive interface, everything after that is learned. After many years on my/maria I find the backslash shortcu…

CTRL+D works. You like it. Great use that. You don't think anybody needs an alternative? Or you don't think having an alternative will help at all? Fine. Think what you want. One thing's for (mostly) certain: it doesn't hurt. So there's really nothing to complain about.

Re: Postgres 11 – A First Look

#49

Post by welder »

shrumm wrote: post #36

I’m already loving PG10’s native partitioning support. PG11 closes the loop on a few convenience features like being able to set foreign and primary keys at the master table level. With PG10 I can’t use ON CONFLICT clauses - looking forward to upgrading and sorting that out.

Check out TimescaleDB, a Postgres extension that auto-creates partition tables for you while PG11 native partitioning you still need to manually run CREATE TABLE.

https://news.ycombinator.com/item?id=18026699

Re: Postgres 11 – A First Look

#50

Post by petre »

deytempo wrote: post #45

What are some reasons I might consider Postgres over MySQL when choosing a DB platform?

JSON support, ability to query it, JSONB support, real spatial extensions, timescale extensions, consistent behaviour, online backups. We now have to migrate from MySQL to Postgres because of these features. Instead of MySQL 8 we will be probably usng Pg 11. Now we are using MariaDB.
Post reply on HN