Mac PIM with Multi-Database Search / Highlighting

< Next Topic | Back to topic list | Previous Topic >

Pages: < 1 2 3 4

Posted by Fredy
Jun 23, 2009 at 10:16 AM

and MS Word, not MS Works, of course, gosh, my excuses !

Posted by Alexander Deliyannis
Jun 23, 2009 at 10:24 AM

UltraRecall is not the only outliner using an SQL infrastructure. In my view this has started to become quite common in information management software, even if the user interface looks similar to older versions that had other kinds of infrastructure. A case in point is ClipMate, the advanced clipboard manager. Another is Surfulater.

I think developers have good reason to go the SQL-way, particularly when trustworthy embeded solutions such as SQLite are available. No need to re-invent the wheel.

I use UR and other SQL-base software with no problem. The only thing I watch out for is making sure that a program is closed before backing up its database files. Contrary to documents and similar files, a database file may be backed up while in use, but this is not necessarily a good thing.

Alexander

Posted by Pierre Paul Landry
Jun 23, 2009 at 01:07 PM

>Contrary to documents and similar files, a database file may be backed up while in use, but this is not necessarily a good thing

This issue is well documented. SQLite (used by URp, Firefox bookmarks, and may others) is NOT a multi-user database engine, so users must close the application before backing up. True multi-user DB engines (Jet, SQL Server, mySQL, etc) do not have this issue.

Pages: < 1 2 3 4

Back to topic list