I remember someone mentioning the Acorn image editor on Mac uses sql files to store image data. It p...

seanalltogether • today at 3:56 PM • 2 replies • view on HN

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.

Replies

dchest • today at 4:06 PM

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 • today at 5:14 PM

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

➕ show 1 reply

alt Hacker News

Replies