+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Is it possible to store json stuff in database as json type and doing CRUD operation other than PostgreSQL .. ?? (/showthread.php?tid=59224)
Is it possible to store json stuff in database as json type and doing CRUD operation other than PostgreSQL .. ?? - El Forum - 09-06-2013
[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..
Is it possible to store json stuff in database as json type and doing CRUD operation other than PostgreSQL .. ?? - El Forum - 09-07-2013
[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
Is it possible to store json stuff in database as json type and doing CRUD operation other than PostgreSQL .. ?? - El Forum - 09-07-2013
[eluser]Otemu[/eluser]
duplicate deleted