Querying blobs

[boruok]

Is that right way to store and retrieve blobs in table? Trying to store array of dicts in table and retrieve it.

If i understand correctly blobs are stored as string and you must convert String to Bytes and Bytes to actual data.

extends Node

func _ready() -> void:
	var db = SQLite.new()
	db.path = ":memory:"
	db.open_db()

	var list := [{"id": "sword"}, {"id": "potion"}]
	db.query("
		CREATE TABLE IF NOT EXISTS actors (
	    	id INTEGER PRIMARY KEY AUTOINCREMENT,
	    	name TEXT NOT NULL,
	    	items BLOB NOT NULL);
		INSERT INTO actors (name, items)
		VALUES ('Bob', '%s');
	" % var_to_bytes(list))

	db.query("SELECT * FROM actors")
	print(bytes_to_var(str_to_var(db.query_result[0].items)))

	db.close_db()

This part feels clunky:

	bytes_to_var(str_to_var(db.query_result[0].items))