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

21–30 of 140 posts

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

#21

Post by brightball »

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.

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.

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

#22

Post by mdemare »

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 psql you can just edit your last command in your $EDITOR.

Cool! How?

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

#23

Post by neverminder »

brightball wrote: post #21
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.

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.

You should also check out https://www.jetbrains.com/dbe/

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

#24

Post by comrade1 »

Are they using Postgres for content, or for data? (at a place where I can't really watch a movie)

There are some great content management tools out there, my favorite being apache jackrabbit, and on top of that, apache sling for displaying/accessing the content. It requires a different way of thinking than the standard mvc process - it is a more content focused display process.

I don't know... if you're using Postgres to store non-relational data you may want to reassess your strategy. You may find you're doing the right thing still, but I think most people would be better served with a system like jackrabbit/sling, which is is used by publishers, fashion houses, etc (via Adobe's product that is built on sling) to store and display their content.

(that said, you can use postgres on the back-end with sling)

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

#25

Post by xd »

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.

Autocomplete is in MySQL you might just need to enable it with -A or in the config comment out no-auto-rehash.

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

#26

Post by masklinn »

mdemare wrote: post #22
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.

> In psql you can just edit your last command in your $EDITOR. Cool! How?

`\e` will edit whatever is in the query buffer (`\p` shows the content of the query buffer)

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

#27

Post by turrini »

mdemare wrote: post #22
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.

> In psql you can just edit your last command in your $EDITOR. Cool! How?

Just type \e [ENTER]

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

#28

Post by sancha_ »

comrade1 wrote: post #24

Are they using Postgres for content, or for data? (at a place where I can't really watch a movie) There are some great content management tools out there, my favorite being apache jackrabbit, and on top of that, apache sling for displaying/accessing the content. It requires a different way of thinking than the standard mvc process - it is a more content focused display process. I don't know... if you're using Postgre…

Apache Jackrabbit is not a content management tool. It is an implementation of JCR, a content repository. But yes I agree that it might suit some usecases better than a relational db. That being said, you still need something like postgres for data storage, even if you use JCR.

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

#29

Post by jsmeaton »

neverminder wrote: post #23
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.

You should also check out https://www.jetbrains.com/dbe/

I'm fairly sure I signed up for the early access program months ago and still haven't heard back. It's possible that I meant to and didn't though.

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

#30

Post by [deleted] »

mdemare wrote: post #22
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.

> In psql you can just edit your last command in your $EDITOR. Cool! How?

[deleted]
Post reply on HN