Add support to extention, like json1 (to have jsonb support)

Question

Add support to extention, like json1 (to have jsonb support)

xward opened this issue 5 years ago · 4 comments

xward commented 5 years ago

https://www.sqlite.org/json1.html

This would be awsome ! it is complicated ?

Thanks a lot for your work, I'm using it for a small project.

Regards,
X

Answer 1 · 2020-11-13T17:59:59.000Z

Leaving this for others who might need JSON with sqlite.

You can use sqlitex and build it to enable JSON1. However, you'll have to write your own SQL

In your mix.exs
defp deps
...
{:sqlitex, "~> 1.7", system_env: [{"ESQLITE_CFLAGS","-DSQLITE_ENABLE_JSON1"}]},
...

Answer 2 · 2021-03-22T18:27:13.000Z

@LordPraslea this is now enabled by default with the exqlite and ecto3 adapter

Answer 3 · 2021-03-23T07:09:04.000Z

@warmwaffles
Nice, I will take a look, I've already started to implement an ecto adapter and a server interface to allow ACTOR manipulation for a project where I need multiple db's open at once.

Answer 4 · 2021-03-23T14:48:12.000Z

Nice, I will take a look, I've already started to implement an ecto adapter and a server interface to allow ACTOR manipulation for a project where I need multiple db's open at once.

I have a project where I have thousands of smallish databases (~2GB a piece) that I am doing map reduce stuff with. I built that ecto3 and exqlite adapter to meet my needs.