Support for json datatype about spine-database-api HOT 7 CLOSED

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

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

from spine-database-api.

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

from spine-database-api.

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.

from spine-database-api.

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

Seems good.

from spine-database-api.

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

from spine-database-api.

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.

from spine-database-api.

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.

from spine-database-api.