CODEWITHSUNDEEP
sqlite
Hugo
Hugo

Reputation: 1698

May I get a SQLite View on JSON format?

I am using Firefox SQLIte plugin and I have an option to export as CSV. Is it possible to do it on JSON?

Thank you

Upvotes: 2

Views: 1986

Answers (2)

Yini
Yini

Reputation: 711

I used sqlite studio to convert result to json. It is open source it does a good job! Although you might need to massage the json data a bit because it contains things like DDL, etc.

Upvotes: 1

thkala
thkala

Reputation: 86403

SQLite is a relational database and CSV is a natural textual representation of tabular data, as seen in the relational model. JSON is a textual represenation of an object. As such, it's not really suited for the representation of tabular data.

That said, you can use the CSV file produced from the SQLite database to generate JSON output.

Upvotes: 3

Related Questions