
would be great to have an OS X command reference as there doesn’t seem to be one, and is a far more limited set than other editions found online. nice mini tutorial despite a few typos/syntax errors. So, if you want to backup your Mac Stickies, all you have to do is make sure you backup that one Mac Stickies database file. Answer (1 of 2): If youre looking for a native Mac application with a great user interface, then I recommend FileMaker Pro. One thought on How to create SQLite3 database using mac OS X Terminal.

This file is named StickiesDatabase, and it's located in the Library folder of your home directory.Īs an example, my home directory is named /Users/Al, and my Mac Stickies database file is located in this directory: Mac Stickies backup FAQ: I want to make sure my Mac Stickies are backed up where are the Mac Stickies files (or database) located?Īs I wrote about in an earlier article on How to save Mac Stickies, Mac Stickies (sticky notes) are saved in one database file.

Just follow these steps: Head over to and download the C source code file, named sqlite-autoconf. You can now hire Alvin Alexander for small Scala side projects!Ĭontact me at (al) at valleyprogramming (dot) com for details. Installing SQLite on your Mac is pretty straightforward.
