3 ms·
I remember someone mentioning the Acorn image editor on Mac uses sql files to store image data. It probably makes backwards compatibility much easier to work wi
by seanalltogether 11mo ago
I remember someone mentioning the Acorn image editor on Mac uses sql files to store image data. It probably makes backwards compatibility much easier to work with.
- dchest 11mo agoIt does, here's a schema from an image I just saved with the latest version. Pretty simple. CREATE TABLE image_attributes ( name text, value blob); CREATE TABLE layers (id text, parent_id text, sequence integer, uti text, name text, data blob); CREATE TABLE layer_attributes ( id text, name text, value blob); Also, document-based apps that use Apple's Core Data framework (kinda ORM) usually use SQLite files for storage.
- setr 11mo agoMessages uses it too on Mac; was using it to do some convoluted text search on my history
- dchest 11mo agoNot as an application file format discussed in the link, though. Lots of software use it as a database (as intended) it's also a base for Apple's Core Data.