Is it possible to save JS objects into a Sqlite database?

Question

I have a node server that receives a user input from the browser, and passes it through a python script that outputs an object.

My question is, is it possible to then take this object and save it to an sqlite table? Not with its key/value pairs as rows/columns etc. but the whole object as a single entry? I was thinking of converting into a string and then doing this but I'm not sure if this is the best approach.

Any help relating to the issue would be great.

That's probably the only option. SQLite has a very simple type system. Only TEXT and BLOB could store complex data — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Apr 17, 2019 at 14:27

RomanHDev · Accepted Answer · 2019-04-17 14:29:01Z

1

Not sure if this is what you intend, but you could simply stringify your JSON and then put it into your table

answered Apr 17, 2019 at 14:29

RomanHDev

1045 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to save JS objects into a Sqlite database?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related