4 ms·
Oh hey, neat. http://www.sqlite.org/src/artifact/950ed4e8deb8ad4c http://www.sqlite.org/src/artifact/950ed4e8deb8ad4c So from looking at the test, you can get
by ioddly 11y ago
Oh hey, neat.
http://www.sqlite.org/src/artifact/950ed4e8deb8ad4c http://www.sqlite.org/src/artifact/950ed4e8deb8ad4c
So from looking at the test, you can get JSON out of select queries now, not a full blown JSON type like PostgreSQL.
- dfox 11y agoThe test is written in TCL, which has slightly non-obvious syntax. In essence it tests SQL functions json_array and json_object which seem to return JSON arrays and objects as string.
- alixaxel 11y agoIt's pretty straightforward to write a UDF that does exactly that actually, JSON type a-la Postgres would be amazing though. https://gist.github.com/alixaxel/5562152#file-y-php-L212-L231 https://gist.github.com/alixaxel/5562152#file-y-php-L212-L23...