Support for json datatype

[spine-o-bot]

In GitLab by @manuelma on Nov 7, 2018, 13:20

This comes with sqlite 3.8 or something. We need to figure out if we can use it.

[spine-o-bot]

In GitLab by @manuelma on Nov 7, 2018, 13:45

changed title from {-s-}upport for json datatype to {+S+}upport for json datatype

[spine-o-bot]

In GitLab by @manuelma on Jan 16, 2019, 13:51

This is becoming more important now, due to spine-tools/Spine-Toolbox#246 and spine-tools/SpineOpt.jl#81

[spine-o-bot]

In GitLab by @PvPer on Jan 23, 2019, 09:05

Looks like sqlalchemy will support the JSON1 extension of sqlite as of version 1.3: https://docs.sqlalchemy.org/en/latest/dialects/sqlite.html#sqlite-data-types

However still in beta stage, not sure how long until the actual release. they have 5 open and 50ish closed issues on their 1.3 milestone on github.

[spine-o-bot]

In GitLab by @manuelma on Jan 23, 2019, 13:57

Seems good.

[spine-o-bot]

In GitLab by @manuelma on May 30, 2019, 19:18

JSON1 is an SQLite loadable extension and we need to learn how to load it using sqlalchemy

[spine-o-bot]

In GitLab by @PvPer on Jun 3, 2019, 15:49

I tried a while back to get it running on windows, but it involved compiling code and replacing binaries in python, I couldn't get the extension loader to work and I never got it working correctly. Might be easier to get it working on some other OS.

[soininen]

Do we have issues with Python's JSON? Aren't we discussing about moving away from JSON altogether? In any case, this looks like a dead end if it is so difficult to work on Windows.