News for hackers. Stuff that matters.
Re:PostgreSQL: Jsonb has committed by illuminated on Monday March 24, 2014 @05:17AM (#7457319)
I only hope it won't be too long before various "drivers" and frameworks start supporting it, otherwise the acceptance rate will be too low. And Jsonb deserves to be accepted as fast as possible.
Re:PostgreSQL: Jsonb has committed by masklinn on Monday March 24, 2014 @05:58AM (#7457413)
I'd suggest opening bugs on drivers (that's the most important one) right now since the feature is officially in the development version. If it doesn't already work that is.

That's how it was done for 9.3's expanded diagnostics[0], and as a result both Python's psygopg2[1] and Ruby's ruby-pg[2] (and maybe others) added extended diagnostics support before 9.3 was even released[3], and working from day 1.

[0] http://www.depesz.com/2013/03/07/waiting-for-9-3-provide-dat...

[1] http://psycopg.lighthouseapp.com/projects/62710/tickets/149

[2] https://bitbucket.org/ged/ruby-pg/issue/161/add-support-for-...

[3] http://www.postgresql.org/about/news/1481/

Re:PostgreSQL: Jsonb has committed by guptaneil on Monday March 24, 2014 @05:44AM (#7457373)
Considering Postgres is the first relational database to support jsonb, portability (which is the main benefit of drivers) doesn't really apply. Any decent driver or framework should let you write native psql commands, so you should be able to start using this as soon as it's released.
Re:PostgreSQL: Jsonb has committed by illuminated on Monday March 24, 2014 @05:49AM (#7457389)
Being able to use Jsonb through a framework and fully utilize it (through it) are not the same things. I will be definitely use it soon, but unless it's fully supported in frameworks (...) it won't be widely accepted.
Re:PostgreSQL: Jsonb has committed by lmb on Monday March 24, 2014 @05:57AM (#7457409)
Seems like there is room for a PostgreSQL-only ORM that specifically makes all these nice features available. Anyone heard of such a thing?
Re:PostgreSQL: Jsonb has committed by masklinn on Monday March 24, 2014 @06:04AM (#7457437)
Most "frameworks"/ORM can provide database-specific features, and it's especially easy for field types. e.g. http://docs.sqlalchemy.org/en/rel_0_9/dialects/postgresql.ht... (data types local to SQL Alchemy's Postgres dialect) or https://github.com/djangonauts/django-hstore (hstore in Django)
Re:PostgreSQL: Jsonb has committed by lucian1900 on Monday March 24, 2014 @06:26AM (#7457492)
There isn't really a need, though. SQLAlchemy exposes all of SQL, most unique things dialects offer and it makes it very easy to add types too.
Re:PostgreSQL: Jsonb has committed by blakn on Monday March 24, 2014 @06:03AM (#7457432)
Not exactly a PostgreSQL-only ORM

The excellent slick-pg library which extends the FRM library slick. https://github.com/tminglei/slick-pg

Re:PostgreSQL: Jsonb has committed by zapov on Monday March 24, 2014 @06:09AM (#7457453)
Not really an ORM but highly integrated with Postgres: https://github.com/ngs-doo/revenj
Re:PostgreSQL: Jsonb has committed by jeltz on Tuesday March 25, 2014 @10:36PM (#7471203)
There are ORMs like SQLAlchemy (Python) and Sequel (Ruby) which try to expose as much as possible of the features of all supported databases. It is common for Sequel to add support for new PostgreSQL features while the new PostgreSQL version is still in beta testing.
Re:PostgreSQL: Jsonb has committed by MartinMond on Monday March 24, 2014 @06:36AM (#7457516)
Rails already has support for Postgres' json type, I don't doubt that they'll add jsonb support asap.
Re:PostgreSQL: Jsonb has committed by jherdman on Monday March 24, 2014 @11:39AM (#7458807)
What's involved in supporting JSONB in Rails? Given that you probably want access to the entire JSON blob at the Rails level, aren't you good to go already?
Re:PostgreSQL: Jsonb has committed by njharman on Monday March 24, 2014 @11:14AM (#7458646)
Abstraction layers (such as drivers) have significant utility beyond portability.
Re:PostgreSQL: Jsonb has committed by acjohnson55 on Monday March 24, 2014 @09:13AM (#7457981)
Sure, but it's also nice to have a layer of abstraction over psql. I personally really enjoy working with Django's ORM, for example, over writing native queries.
Re:PostgreSQL: Jsonb has committed by andybak on Monday March 24, 2014 @12:08PM (#7459003)
Re:PostgreSQL: Jsonb has committed by sfjailbird on Monday March 24, 2014 @06:33AM (#7457510)
TeamPostgreSQL, the PostgreSQL web interface, has a JSON builder/editor built in which makes browsing JSON data very nice.
Re:PostgreSQL: Jsonb has committed by lamby on Monday March 24, 2014 @06:44AM (#7457539)
Mm, I agree. As an example, historically, Django has been quite weak at this due to its Field.get_internal_type() system.