SQLite Forum

Writing arrays

Writing arrays

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

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 [link] [source]

You could use the JSON extension for this.