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

A list of PostgreSQL libraries, tools and resources

github.com

Post reply on HN
Print view View original

21–30 of 30 posts

Re: A list of PostgreSQL libraries, tools and resources

#21

Post by jakobegger »

jbranchaud wrote: post #14

Does anyone know of sample PostgreSQL databases? Something akin to Northwind ( https://northwinddatabase.codeplex.com/ )?

Some time ago I converted Northwind to PostgreSQL for testing. I should still have that somewhere. If you'd like an SQL dump of that, drop me a line: jakob@eggerapps.at

Re: A list of PostgreSQL libraries, tools and resources

#22

Post by copperx »

jmount wrote: post #12
copperx wrote: post #10

Is there a PostgreSQL that anyone here can recommend?

You can try Postgres "zero install" with Postgres.app for OSX, otherwise docker. http://www.win-vector.com/blog/2016/02/databases-in-containe...

Thank you! But I meant book, a PostgreSQL book; but somehow I didn't type that :(

Re: A list of PostgreSQL libraries, tools and resources

#23

Post by datawrangler »

copperx wrote: post #22
jmount wrote: post #12

Earlier quoted context omitted.

You can try Postgres "zero install" with Postgres.app for OSX, otherwise docker. http://www.win-vector.com/blog/2016/02/databases-in-containe...

Thank you! But I meant book, a PostgreSQL book; but somehow I didn't type that :(

The PostgreSQL manual [1] is pretty good IMO. Have you looked at that?

[1] http://www.postgresql.org/docs/manuals

Re: A list of PostgreSQL libraries, tools and resources

#24

Post by thejosh »

datawrangler wrote: post #23
copperx wrote: post #22

Earlier quoted context omitted.

Thank you! But I meant book, a PostgreSQL book; but somehow I didn't type that :(

The PostgreSQL manual [1] is pretty good IMO. Have you looked at that? [1] http://www.postgresql.org/docs/manuals

The PostresSQL manual & documentation are one of my favourite things about PostresSQL, especially when I was first starting out :).

Re: A list of PostgreSQL libraries, tools and resources

#25

Post by adamzegelin »

jbranchaud wrote: post #14

Does anyone know of sample PostgreSQL databases? Something akin to Northwind ( https://northwinddatabase.codeplex.com/ )?

MusicBrainz is powered by Postgres. You can download a snapshot of their database here: https://musicbrainz.org/doc/MusicBrainz_Database

It's a few gigabytes of data, compressed.

Re: A list of PostgreSQL libraries, tools and resources

#26

Post by jeltz »

copperx wrote: post #22
jmount wrote: post #12

Earlier quoted context omitted.

You can try Postgres "zero install" with Postgres.app for OSX, otherwise docker. http://www.win-vector.com/blog/2016/02/databases-in-containe...

Thank you! But I meant book, a PostgreSQL book; but somehow I didn't type that :(

Here are some books: http://www.postgresql.org/docs/books/

I can't vouch for the quality of most, but I know that Schönig's books usually are good.

Re: A list of PostgreSQL libraries, tools and resources

#27

Post by vacri »

davidw wrote: post #2

Can't it just be a 'list' of Postgres stuff? Do we really expect that it's generated by an algorithm if someone doesn't write 'curated'? If it's a good list, I'm going to find it interesting no matter how it was created.

'Curated' implies ongoing maintenance, and not just a brain-dump.

Re: A list of PostgreSQL libraries, tools and resources

#29

Post by garyclarke27 »

copperx wrote: post #10

Is there a PostgreSQL that anyone here can recommend?

I have read every book on Postgres, they are literaly all crap, boring, tedious and simplistic. On contrast, the on-line docs on the postgres web site, are superb, matching the very high quality of Postgres itself. It is possible to write interesting books with personality even for a dry topic such as Sql eg Itzik Ben-Gan for sql server for general sql Joe Celko opinionated but entertaining, Stephane Faroult one if the best ever sql books "The Art of SQL" , Use the Index luke is great - even Chris Date's academicy books are more interesting than any single postgres book which is a shame since Postgres is truly amazing application.

Re: A list of PostgreSQL libraries, tools and resources

#30

Post by jmount »

copperx wrote: post #22
jmount wrote: post #12

Earlier quoted context omitted.

You can try Postgres "zero install" with Postgres.app for OSX, otherwise docker. http://www.win-vector.com/blog/2016/02/databases-in-containe...

Thank you! But I meant book, a PostgreSQL book; but somehow I didn't type that :(

It isn't PostgreSQL, but I like "SQL for smarties."
Post reply on HN