• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: PostgreSQL announcement ?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: PostgreSQL announcement ?


  • Subject: Re: PostgreSQL announcement ?
  • From: John Huss <email@hidden>
  • Date: Thu, 13 Sep 2012 09:20:29 -0500

Not really.  The JSON support really just does two things:

1) validates that what you are saving is actually valid JSON
2) allows you to convert a row(s) to json

The conversion could be useful because it is likely to be much faster and memory efficient by doing it in the DB rather than in memory.  However, you would have to write raw SQL to use that feature, and you lose the ability to modify the JSON in your app.

But the overall performance improvements in 9.2 sound great!

John

On Thu, Sep 13, 2012 at 5:36 AM, Theodore Petrosky <email@hidden> wrote:
does this actually do anything for webobojects? (I am of course referring to the JSON support)

The PostgreSQL Global Development Group today released PostgreSQL 9.2, which offers index-only scan, cascading replication, range types and more, resulting in dramatic performance improvements. The newly introduced JSON support meets the need of web developers by allowing storage and retrieval in JSON formats.
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >PostgreSQL announcement ? (From: Theodore Petrosky <email@hidden>)

  • Prev by Date: PostgreSQL announcement ?
  • Next by Date: Problems changing eomodel
  • Previous by thread: PostgreSQL announcement ?
  • Next by thread: Problems changing eomodel
  • Index(es):
    • Date
    • Thread