3 ms·
This is an interesting idea, though I cringe a little at using a relational database as a key/value store (as in the case of layer_attributes). I wonder whethe
by Semiapies 14y ago
This is an interesting idea, though I cringe a little at using a relational database as a key/value store (as in the case of layer_attributes).
I wonder whether it would be more useful to just represent the whole thing as a big JSON structure with base64 blobs. Each layer can be an object in the "layers" array with the attributes as keys.
- gilgoomesh 14y agoLayered images can easily grow to gigabytes in size. You do not want to store that much information in a format like JSON that must be opened into memory, parsed and stored in native objects. SQLite is RAM efficient and quick to open, even at large file sizes.
- Semiapies 14y agoFair enough - I rarely work much with images, so didn't even think of size.