JSON SQlite3 Create table with JSON

Question

I'm trying to create a database table using the sqlite3 npm package. I'd like the table to have two columns, number and colour. Number should be an integer and colour should contain json data.

Is there anyway to explicitly set the data type to json in sqlite3?

Something like this below:

db.run('CREATE TABLE table1 ( number integer, colour json)');

As of sqlite version 3.45 (pending), there will be JSONB support (like PostgreSQL) See: sqlite.org/jsonb.html — alercelik
– alercelik, Commented Jul 9, 2024 at 9:56

Shawn · Accepted Answer · 2018-11-01 18:06:02Z

6

While sqlite has functions for working with JSON data (Assuming the standard JSON1 extension is enabled in the instance of the library that you're using, of course), it does not have an actual JSON type. Instead, use TEXT columns to hold JSON text like you would any other string.

More reading on the data types that sqlite supports and how unknown types are treated in table defintions.

answered Nov 1, 2018 at 18:06

Shawn

53.8k3 gold badges29 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

JSON SQlite3 Create table with JSON

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related