Re: [GENERAL] Questions regarding JSON processing

2017-04-26 15:06 GMT+02:00 Glen Huang : > @Pavel > > Thanks for bringing PLV8 to my attention. Wasn't aware of it. Sounds like > the right tool to for the job. I'll try it out. Do you think it makes sense > to use PLV8 to also generate JSON? Can it beat SQL? > Hard to say -

Re: [GENERAL] Questions regarding JSON processing

@Pavel Thanks for bringing PLV8 to my attention. Wasn't aware of it. Sounds like the right tool to for the job. I'll try it out. Do you think it makes sense to use PLV8 to also generate JSON? Can it beat SQL? Good to know functions are executed under transaction, I think that should be enough

Re: [GENERAL] Questions regarding JSON processing

On 4/25/2017 9:21 PM, Glen Huang wrote: For updating db using JSON requests from clients, that I'm not so sure. Should I directly pass the request JSON to PostgreSQL and ask it to parse this JSON and execute a transaction all by itself, or should I parse it in the server and generate the

Re: [GENERAL] Questions regarding JSON processing

2017-04-26 6:21 GMT+02:00 Glen Huang : > Hi all, > > I have a RESTful API server that sends and receives JSON strings. I'm > wondering what might be the best way to leverage PostgreSQL's JSON > capability. > > For sending JSON responses to clients. I believe the best way is to

[GENERAL] Questions regarding JSON processing

Hi all, I have a RESTful API server that sends and receives JSON strings. I'm wondering what might be the best way to leverage PostgreSQL's JSON capability. For sending JSON responses to clients. I believe the best way is to ask PostgreSQL to generate the JSON string and then pass that directly