5 ms·
Todo lists stored in a database seem like a bad idea because it becomes much more difficult to share and sync it between computers. I wrote a todo list manager
by minhajuddin 11y ago
Todo lists stored in a database seem like a bad idea because it becomes much more difficult to share and sync it between computers. I wrote a todo list manager in ruby (https://github.com/minhajuddin/taskr)[1] https://github.com/minhajuddin/taskr)[1] back in the day and used plain text files to store the data and timestamps for ids and Dropbox to sync it between computers. It works really nicely. Also, every person's workflow is different so getting your own todo list manager or tweaking an existing one seems like a good idea.
[1] https://github.com/minhajuddin/taskr https://github.com/minhajuddin/taskr
- datashaman 11y agothese are also the guiding principles behind Gina Trapani's http://todotxt.com/ http://todotxt.com/ (an excellent piece of software)
- dannyrosen 11y agoI use this along with https://play.google.com/store/apps/details?id=nl.mpcjanssen.simpletask https://play.google.com/store/apps/details?id=nl.mpcjanssen.... and https://syncthing.net/ https://syncthing.net/ for syncing.
- watmough 11y agoThis is a great point. I do love sqlite, it really is awesome, but you had better need what it provides, since you are taking a 50x performance hit versus simply dumping an object tree to a binary file. If anyone is interested, I could try and dig up my notes from switching from sqlite to NSArchive.
- Something1234 11y agoI would be interested in those notes.
- watmough 11y agoSorry, I simply haven't been able to find them. However, the upshot was that in my FemCal app, loading several months of entered fertility cycles went from 100's-1000's of milliseconds to just a few 100's. The overall speedup when loading was about 50x, when using NSArchive versus sqlite3. Neither implementation was or has been optimized, though I did try to write the sqlite3 code as efficiently as possible, since it was clearly a source of slowness from day 1.