Export notes from Notes.app on OS X

-- 10.10 Yosemite: ~/Library/Containers/com.apple.Notes/Data/Library/Notes/NotesV4.storedata
-- 10.11 El Capitan (Legacy): ~/Library/Containers/com.apple.Notes/Data/Library/Notes/NotesV5.storedata
-- You should also save attachments from this folder: ~/Library/Containers/com.apple.Notes/Data/Library/CoreData/Attachments/

-- You should commit the changes in the -wol file:
PRAGMA wal_checkpoint(RESTART); VACUUM;

SELECT a.ZDATECREATED, a.ZDATEEDITED, a.ZTITLE, b.ZHTMLSTRING
FROM ZNOTE AS a
LEFT JOIN ZNOTEBODY AS b ON a.ZBODY=b.Z_PK
-- or ON a.Z_PK=b.ZNOTE
ORDER BY a.ZDATEEDITED;



-- 10.11 El Capitan: ~/Library/Group\ Containers/group.com.apple.notes/NoteStore.sqlite
SELECT a.ZCREATIONDATE, a.ZMODIFICATIONDATE1, a.ZTITLE1, b.ZDATA FROM ZICCLOUDSYNCINGOBJECT AS a LEFT JOIN ZICNOTEDATA AS b ON a.ZNOTEDATA=b.Z_PK ORDER BY a.ZMODIFICATIONDATE1;

-- !! Note that ZDATA is a blob (also gzipped). Do something like this in bash:
sqlite3 ~/Library/GROUP\ Containers/GROUP.com.apple.notes/NoteStore.sqlite "SELECT writefile('object0.gz', ZDATA) FROM ZICNOTEDATA WHERE Z_PK = 128;" && gunzip object0.gz

-- Attachments are in ~/Library/Group\ Containers/group.com.apple.notes/Media and ~/Library/Group\ Containers/group.com.apple.notes/Previews