Comment by seanalltogether

2 months 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.

3 comments

seanalltogether

Reply
dchest  2 months ago

It 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  2 months ago

Messages uses it too on Mac; was using it to do some convoluted text search on my history

  • dchest  2 months ago

    Not 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.