From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Which data type to use for UTF8 JSON and perl/PHP: varchar, text or bytea? |
Date: | 2012-04-26 20:53:33 |
Message-ID: | CAHyXU0xyymMBnZGB8YhvVkc4OsJ+cy+VvQhhCvbOoVxB-J+=vA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Apr 26, 2012 at 3:46 PM, Alexander Farber
<alexander(dot)farber(at)gmail(dot)com> wrote:
> Hello,
>
> On Thu, Apr 26, 2012 at 10:11 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>>> Does anybody have an advice on what data type
>>> to use best for such a JSON "string"?
>>>
>>> Should I take varchar, text or bytea.
>>>
>>> And for the latter - how to handle it in Perl
>>> if I currently use DBI and DBD::Pg?
>>>
>>> For PHP I probably should use pg_(un)escape_bytea?
>>>
>>> (And does this all work with "?" placholders?)
>>
>> upgrade your database and use the new json type/features.
>
> do you mean PostgreSQL 9.x?
>
> I don't see anything "json" at
> http://www.postgresql.org/docs/9.0/static/datatype.html
> or in the search (besides something in "contrib")?
>
> And does it work well with Perl 5.10 and PHP 5.3?
>
> My hoster offers CentOS 6.x only
it's in core for 9.2. for 9.1 you have to compile and install it as
an extension:
http://people.planetpostgresql.org/andrew/index.php?/archives/255-JSON-for-PG-9.2-...-and-now-for-9.1!.html
also
http://people.planetpostgresql.org/andrew/index.php?/archives/244-Under-the-wire.html
barring the above, I'd definitely use the 'text' type (or varchar,
which is the same thing). all should play well with php.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-04-26 23:33:20 | Re: Bug? Query plans / EXPLAIN using gigabytes of memory |
Previous Message | Alexander Farber | 2012-04-26 20:46:57 | Re: Which data type to use for UTF8 JSON and perl/PHP: varchar, text or bytea? |