Smereka TreeProjects: Powerful Personal Database
Smereka TreeProjects is a feature rich freeform database that can manage, hold and centralize all sorts of information. It can create one or more fully searchable collections of information each in a single portable file that can contain anything from simple or rich text to entire web pages to file attachments and even alarm reminders.
TreeProjects can be used to gather and organize data in a hierarchical way that also remains flexible where data or item(s) can be moved – right click and copy/paste or just drag items using the mouse – from one section, item or node to another. Each node or item can also be colored or assigned to one of the provided icons.
Tagging is another very powerful way of organizing personal data and TreeProjects offers tagging very much like the blogging method where under the details of an item or file one assign tags which are searchable and auto-complete as well.
Another important part of TreeProjects’ power is the revision feature. When saving an already existing item, a note for example, TreeProjects offers the user the option to keep the old version(s) as well.
The reminder feature (Items menu —> New:Reminder) lets the user work with alarm set to anything from once to yearly with not only a remind in advance feature but also a setting to make the alarm dependent to independent of time zones. This is useful because not only the program itself is portable – after installing just copy the whole program folder, for example, C:/Program Files/Smereka TreeProjects, to a USB key – but as mentioned the database is in a single file, so the program, including the alarms, are useful everywhere.
In my tests TreeProjects did very well in capturing a webpage (see image below) with links and images intact. Just create a New:HTML via the Items menu or right click a parent or node, name the item, type in the URL (or browse to a local .htm/.html file) and go. Capturing items like passages of text is also easy and useful for research purposes. Using Ctrl-Alt-v keys instead of the traditional Ctrl-v pastes the copied item into TreeProjects’ active item.
A spell checker is included as is a find as you type search feature which takes advantage of the SQLite foundation of the database. Transparent, behind the scenes indexing takes place and provides seconds away easy access to everything. SQLite allows for various views and sorting options that will always be available without destroying the ‘original’ view which the user may be comfortable with.
The Special monitored folder, see Tools menu, is another ease-of-use feature of TreeProjects. A folder, or the default provided by the program, can be monitored and items that are moved to it will be imported into the current item or database. Things like Word .doc files and .jpg images are imported as file attachments and ‘readable’ or supported ones such as .rtf files fully viewable and editable just like a new item created in the program.
One can set a whole series of keyboard shortcuts, see Tools menu, to things like opening a new item, capturing a new item and shifting between views.
TreeProjects is very impressive, it runs on Windows XP, Windows Vista and Windows 7. It is currently available in Dutch, English, German, Russian, Spanish and Ukrainian. It costs $49. A free, very usable ‘sister’ program is also available.