← Back to context

Comment by seanalltogether

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

2 comments

seanalltogether

Reply
setr  16 minutes ago

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

dchest  1 hour 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.