SQLite Forum

Writing arrays
Login

Writing arrays

(1) By anonymous on 2021-05-22 06:01:01 [link]

Given an array, I can serialize it and write it to a BLOB column & deserialize it on reading it back.

Are there built-in SQLite3 functions for serialization/de-serialization?

(2) By Warren Young (wyoung) on 2021-05-22 16:44:56 in reply to 1

You could use [the JSON extension](https://www.sqlite.org/json1.html) for this.