Welcome Guest, Not a member yet? Register   Sign In
Is it possible to store json stuff in database as json type and doing CRUD operation other than PostgreSQL .. ??
#1

[eluser]Unknown[/eluser]
Hi all coders,
I am currently developing a project to CRUD json stuff in database as using codeigniter. I don't want to be database specific so I don't relay only on PostgreSQL. So is their a efficient way to manipulate .json stuff(json schema and json form structure data ) in database.
What would be the procedure.
I am a newbie in this so please help. 8-/
Thanks in advance..
#2

[eluser]Otemu[/eluser]
Quote:PostgreSQL 9.3 will come bundled with new functions that will allow for JSON generation and manipulation, as highlighted in this series of blog posts by PostgreSQL developer and VMware employee Michael Paquier.

The existing version of PostgreSQL, 9.2.x, already has support for a JSON field type, and the ability to make sure any data to be stored as JSON is well formed.

Source

For mySQL you would have to store the JSON as a single block.

CouchDB could be an option to look at
#3

[eluser]Otemu[/eluser]
duplicate deleted




Theme © iAndrew 2016 - Forum software by © MyBB