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

PostgreSQL 9.3 Beta 1 Released

postgresql.org

Post reply on HN
Print view View original

31–40 of 118 posts

Re: PostgreSQL 9.3 Beta 1 Released

#31

Post by masklinn »

btown wrote: post #27
masklinn wrote: post #9

The short log is missing one of the most important and awesome new feature to application writers: a bunch of new PQresultErrorFields[0] on constraint failure, providing access to (context-dependent) the raw schema name, table name, column name, constraint name and datatype involved. Previously these remained locked into the database and to get programmatically-useable info (for logging, better error messages or to t…

Where would one find out if anyone is working on a patch for ActiveRecord?

The Rails/ActiveRecord bug tracker?

edit: the underlying connector might be a better idea to start with, as it'll need to expose the fields somehow before an ORM can take advantage of them.

Re: PostgreSQL 9.3 Beta 1 Released

#32

Post by zapov »

masklinn wrote: post #24
zapov wrote: post #21

Earlier quoted context omitted.

Postgres supports native nested structures. Well, as long as your structures are not circular. JSON everywhere is really a bad choice for most data structures. It's like having no structure at all.

Which is pretty much what you want to build a schemaless nosql-on-postgres. Also, Posgres already has hstore (already mentioned) and XML columns, which are schemaless and "unstructured".

Well, I'm arguing that flexible schema is better than no schema. And in practice schemaless is only about schema defined outside of database. It's a solution to the wrong problem.

Re: PostgreSQL 9.3 Beta 1 Released

#33

Post by e1ven »

masklinn wrote: post #11
gbog wrote: post #6

Earlier quoted context omitted.

It seems you could easily get a nosql postgres if you limit yourself to one table with two columns (id, json). Snark apart, it would work quite ok, no?

the json support is fairly recent and doesn't support operating directly on the data yet (e.g. you have to create functional indexes through plv8js and you can't directly query on the document's content as you can with array, xml or hstore columns)

I'm using https://github.com/JerrySievert/mongolike to support Postgres using mongo-like queries.

I patched in a bunch of features I needed, and it works really well for me.

Re: PostgreSQL 9.3 Beta 1 Released

#34

Post by karavelov »

snaky wrote: post #25
gbog wrote: post #6

Earlier quoted context omitted.

It seems you could easily get a nosql postgres if you limit yourself to one table with two columns (id, json). Snark apart, it would work quite ok, no?

If there would be HandlerSocket or similar, yes.

Postgresql has prepared queries - they give you the same type of optimization (skip the query parsing on each execution) with more flexibility and with SQL standard syntax.

Re: PostgreSQL 9.3 Beta 1 Released

#35

Post by sickpig »

mintyfresh wrote: post #12
DrJokepu wrote: post #2

The PostgreSQL team just keeps on giving. There is nothing that can stop these guys.

In that spirit, what are the best resources for getting started and diving in to working with PostgreSQL?

Postgresql documentation is terrific, really [1]. Then you can also use pgsql wiki [2]. Other useful resources are the searchable mailing lists archive [3]. Have a look also to pgcon.org web site, it's fully packed of presentation material (mainly pdf slides) gathered since 2007, just to give you an example look at Tom Lane's "http://www.pgcon.org/2011/schedule/events/350.en.html [4]

Speaking of books a few of the best I'm aware of are:

- PostgreSQL 9 Admin Cookbook (Simon Riggs, Hannu Krosing)

- PostgreSQL 9.0 High Performance (Gregory Smith)

- Instant PostgreSQL Backup and Restore How-to (Shaun M. Thomas)

all them from Packt Publishing

[1] http://www.postgresql.org/docs/devel/static/

[2] http://wiki.postgresql.org/wiki/Main_Page

[3] http://www.postgresql.org/list/

[4] http://www.pgcon.org/2011/schedule/events/350.en.html

Re: PostgreSQL 9.3 Beta 1 Released

#36

Post by saosebastiao »

mintyfresh wrote: post #12
DrJokepu wrote: post #2

The PostgreSQL team just keeps on giving. There is nothing that can stop these guys.

In that spirit, what are the best resources for getting started and diving in to working with PostgreSQL?

As far as open source documentation goes, I consider Postgres to easily be the standard. The official docs are so good that a book writer would have to try hard just to not plagiarize them, let alone surpass their content.

Re: PostgreSQL 9.3 Beta 1 Released

#37

Post by petergeoghegan »

Ygg2 wrote: post #14
mintyfresh wrote: post #12

Earlier quoted context omitted.

In that spirit, what are the best resources for getting started and diving in to working with PostgreSQL?

I'd love to hear about them too. I've seen some O'Reilly books but they've been long time ago.

There is a really old O'Reilly book, I think, but there is also an O'Reilly book called "PostgreSQL: Up and Running" that came out last year that covers 9.2.

Re: PostgreSQL 9.3 Beta 1 Released

#38

Post by judofyr »

masklinn wrote: post #31
btown wrote: post #27

Earlier quoted context omitted.

Where would one find out if anyone is working on a patch for ActiveRecord?

The Rails/ActiveRecord bug tracker? edit: the underlying connector might be a better idea to start with, as it'll need to expose the fields somehow before an ORM can take advantage of them.

https://bitbucket.org/ged/ruby-pg

Re: PostgreSQL 9.3 Beta 1 Released

#39

Post by jeltz »

masklinn wrote: post #31
btown wrote: post #27

Earlier quoted context omitted.

Where would one find out if anyone is working on a patch for ActiveRecord?

The Rails/ActiveRecord bug tracker? edit: the underlying connector might be a better idea to start with, as it'll need to expose the fields somehow before an ORM can take advantage of them.

I think it can use either pg (wrapper around libpq) or postgres-pr (pure ruby), though I always use pg.

EDIT: Seems like they have dropped support for postgres.

EDIT2: Yes, I did mean postgres-pr.

Re: PostgreSQL 9.3 Beta 1 Released

#40

Post by masklinn »

jeltz wrote: post #39
masklinn wrote: post #31

Earlier quoted context omitted.

The Rails/ActiveRecord bug tracker? edit: the underlying connector might be a better idea to start with, as it'll need to expose the fields somehow before an ORM can take advantage of them.

I think it can use either pg (wrapper around libpq) or postgres-pr (pure ruby), though I always use pg. EDIT: Seems like they have dropped support for postgres. EDIT2: Yes, I did mean postgres-pr.

Do you mean postgres-pr? (postgres is marked as a deprecated gem to replace with pg)
Post reply on HN