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

“Fashion Is Hard. PostgreSQL Is Easy” [video]

tech.zalando.com

Post reply on HN
Print view View original

61–70 of 140 posts

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#61

Post by _ea1k »

fweespeech wrote: post #52
ibotty wrote: post #17

Earlier quoted context omitted.

You are the first person I read saying they like the mysql cli. Ctrl-c kills the whole shell. great, but not what I expect. Want to fix a small typo in your big query? In psql you can just edit your last command in your $EDITOR. Useful (but not perfect) autocomplete is also not in mysql.

> Ctrl-c kills the whole shell. great, but not what I expect. That is actually exactly what you should expect. SIGINT cancels most things you run in the CLI. Interrupt a ping because you forgot a count parameter? Ctrl+C Honestly, the reason I don't use Postgres has nothing to do with the CLI and everything to do with the ecosystem for Multi-Master being inferior to Galera. But yeah, I'm happy with mysql-cli as well a…

In Postgres' psql, Ctrl-C cancels the current statement. That's a more useful behavior than killing the entire psql process, IMO.

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#62

Post by bshimmin »

noir_lord wrote: post #54
realusername wrote: post #31

Earlier quoted context omitted.

That's also the problem I have, \dt,\c just don't make sense at all and I never remember them whereas 'SHOW TABLES' does not even need explanations. It's also the same thing with the unix users, I never fully understood how postgres handles user permissions. I would say that Postgres itself is really really good but the tooling around is just not there yet.

I just remembered it as \d as display and \dt as display tables. I often invent mnemonics that only mean something to me until muscle memory kicks in.

Here's a nice one-page cheat sheet, of which about 75% you will probably never need to use: http://www.postgresonline.com/downloads/special_feature/post...

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#63

Post by meritt »

ibotty wrote: post #17
lmm wrote: post #3

Earlier quoted context omitted.

As someone who's used to MySQL, I keep trying to use PostgreSQL (better standards compliance, better behaviour in the face of bad data) - and I keep going back. The psql interface is awkward (too many magic backslash commands to memorize instead of SHOW CREATE TABLE) and always feels slightly laggy somehow.

You are the first person I read saying they like the mysql cli. Ctrl-c kills the whole shell. great, but not what I expect. Want to fix a small typo in your big query? In psql you can just edit your last command in your $EDITOR. Useful (but not perfect) autocomplete is also not in mysql.

In MySQL type \e and you can edit your query just the same.

https://dev.mysql.com/doc/refman/5.6/en/mysql-commands.html

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#64

Post by marcosdumay »

escherize wrote: post #34
brightball wrote: post #19

Earlier quoted context omitted.

That's probably the best way of looking at it. PostgreSQL is generally going to be the best solution for 90% of your data, short of having a subset that's write heavy to the point of streaming.

What is a good space to look at when you get write heavy data to the point of streaming?

The filesystem.

Ok, that not completely serious, but almost completely.

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#65

Post by antsar »

fweespeech wrote: post #52
ibotty wrote: post #17

Earlier quoted context omitted.

You are the first person I read saying they like the mysql cli. Ctrl-c kills the whole shell. great, but not what I expect. Want to fix a small typo in your big query? In psql you can just edit your last command in your $EDITOR. Useful (but not perfect) autocomplete is also not in mysql.

> Ctrl-c kills the whole shell. great, but not what I expect. That is actually exactly what you should expect. SIGINT cancels most things you run in the CLI. Interrupt a ping because you forgot a count parameter? Ctrl+C Honestly, the reason I don't use Postgres has nothing to do with the CLI and everything to do with the ecosystem for Multi-Master being inferior to Galera. But yeah, I'm happy with mysql-cli as well a…

Ping isn't a CLI, its a single command that expects no further input. A database shell is more like bash than ping. And Ctrl-C does not exit out of bash.

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#66

Post by marcosdumay »

lmm wrote: post #3
tempodox wrote: post #2

That title is really great, and also rings true. And of all open-source SQL DBs, PostgreSQL is superbly executed and a breeze to work with. I can only recommend it.

As someone who's used to MySQL, I keep trying to use PostgreSQL (better standards compliance, better behaviour in the face of bad data) - and I keep going back. The psql interface is awkward (too many magic backslash commands to memorize instead of SHOW CREATE TABLE) and always feels slightly laggy somehow.

Count another vote for the pgadmin.

I hate the backslash commands of postgres, about as much as I hate the show commands of mysql (what's not nearly as much as I hate the oracle introspection tools).

Why couldn't SQL standardize database introspection?

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#67

Post by dolel13 »

jkestner wrote: post #32
brightball wrote: post #21

Earlier quoted context omitted.

Admittedly, I haven't used the PG or MySQL cli in years. Coughed up money for a Navicat Premium license about 5 years ago and never looked back.

Same here. I muddled along with pgAdmin for a while, but now use Valentina Studio. Excellent free app (has an in-app purchase for some advanced features but doesn't feel crippled at all).

Same here. The Valentina Studio free app is very helpful and somewhat smoothens the learning curve

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#68

Post by cwyers »

JohnBooty wrote: post #60
cwyers wrote: post #46

Earlier quoted context omitted.

> I don't know... if you're using Postgres to store non-relational data you may want to reassess your strategy. What kind of data lacks any relations whatsoever? Yes, there are cases where fitting data to the relational model is more awkward than others. But I would be really, really cautious about thinking that I could design on my own a data model that's better than the relational model. Relational databases are in…

> What kind of data lacks any relations whatsoever? You're right: all data has some kind of relation - when we say "non-relational data" we almost always really mean "loosely related." But some data is much more strongly related than others. Think of a traditional RDBMS application such as an ordering system where there are strong relational constraints that need to be enforced before committing your data: ie, your o…

There are times where you really don't need an RDBMS, yes. Hard real-time embedded systems are their own bag, I certainly wouldn't want to tell the people who design the systems inside a car how to do their job. As for server logs... they're their own bag, too, although if you decide to roll your own setup there without fully investigating syslog and journald or whatever else, I think you're probably making a mistake here.

But if you're running a website and you have fewer than 100 servers and you think you need to start rethinking the entire relational data model, you may very well be getting ahead of yourself.

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#69

Post by baq »

marcosdumay wrote: post #66
lmm wrote: post #3

Earlier quoted context omitted.

As someone who's used to MySQL, I keep trying to use PostgreSQL (better standards compliance, better behaviour in the face of bad data) - and I keep going back. The psql interface is awkward (too many magic backslash commands to memorize instead of SHOW CREATE TABLE) and always feels slightly laggy somehow.

Count another vote for the pgadmin. I hate the backslash commands of postgres, about as much as I hate the show commands of mysql (what's not nearly as much as I hate the oracle introspection tools). Why couldn't SQL standardize database introspection?

it did.

https://en.wikipedia.org/wiki/Information_schema

Re: “Fashion Is Hard. PostgreSQL Is Easy” [video]

#70

Post by icebraining »

pavlov wrote: post #36
kaufland wrote: post #8

Hmm, looking a bit at their site[1]: Addidas jogging pants -- 59,95 € Volcom T-shirt print -- 17,45 € Under Armour T-shirt -- 39.95 € Like really now -- who needs this stuff? Especially when you can just go to Aldi or Tchibo (or any of a number of other discount retailers readily visible at nearly every shopping mall in Germany) and buy essentially same stuff (minus the logos, of course) for 1/10th of the price. So p…

A t-shirt for 1.75 € is so cheap that it's practically guaranteed to have been manufactured in dangerous conditions in a place like Bangladesh or Ethiopia. Big brands like Adidas or Under Armour don't have a clean track record either, but at least they are somewhat accountable to consumers because their #1 asset is their reputation. To fix global trade, it's better to do a bit of research into what kind of company yo…

You mean the money is actually going to poor people? Sounds like a plus to me.
Post reply on HN