Tag: database

  • Hddb: Search Done Quickly

    Hddb: Search Done Quickly

    Hddb

    Hddb is another option for those seeking to have a lightweight search utility. Hddb stands for Hard disk database and similar to Locate32 in that it builds a database and uses it to present results. The program interface is similar to Everything however.

    At first start a database is built and this takes seconds only. There is an option to rebuild the database any time and also to clean it as if to start over. Folders can be set to be ignored by Hddb by adding an empty file called _hddbignore in them. In Tools —> Options —> Database there is an option to exclude files by name. The search itself supports searching paths (use \ to start a search) and using wild cards. Probably the most notable feature of Hddb is the Named Searches accessed via the Search menu. This narrows down the search to file, folder, picture, executable, office, book, video, audio, archive, code or text formats. For example a search for “@video milan” returns only video files which have milan in their title. These can be configured to add or include other file types and extensions.

    Hddb has options to show folder sizes and to show file info via a tool tip, see the Results List tab of the program options to enable these features.

    The program remembers recent searches. The non portable version of the program can add itself to the system’s right click context menu. Hddb is available in exe and portable versions for both 32 and 64 bit machines.

  • TagBook: Cross Platform Bookmarking Utility

    TagBook: Cross Platform Bookmarking Utility

    TagBook (Version: 0.1 beta 2) is a young beta software with a simple yet useful feature. It bills itself as a “cross-platform desktop bookmarking utility” but with a reminder that it can store any text information. Whether the text storage potential works for the average user will depend on the user of course but also on the progress TagBook makes.

    TagBook

    Download the jar file and run it. Click on the Database menu to create a new database. Add a new item using the Bookmark menu. The Edit window that comes up requires a Name, Description, Address, Notes and Tag(s). Tags can be added on the fly and applied using the same window or use F3 (View—>Tag Manager) to add tags separately.

    Bookmarks can also be added by dragging and dropping text into the Edit window or by pasting the contents of the clipboard using Ctrl+V and Ctrl+Shift+V or Bookmark—>Paste. Search and Filter as you type using Ctrl+F and Ctrl+Shift+F.

    TagBook can be locked into a read only mode by clicking the lock button to the far top right. It can export whole or selected items to csv, xml and html formats and attempt to import them from the same file formats too.

    Using the filter sometimes causes errors with a disappearing database, this requires reloading or reopening a database, not unexpected for an early beta.

    TagBook has potential and worth keeping an eye on. It requires java and is cross platform.

  • Smereka TreeProjects: Powerful Personal Database

    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.

    Smereka TreeProjects

    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.

    Smereka TreeProjects

    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.

  • Snap DB: Keep Your Info In This Simple Database

    Snap DB: Keep Your Info In This Simple Database

    Snap DB is one of the 2011 entries in Donationcoder’s N.A.N.Y. (New Apps For The New Year) challenge. It is a simple database program that holds and organizes lists and information in a text like or flat structure. It is minimalist by design.

    The uses for Snap DB are pretty much infinite. Keep a list of albums, software or books or anything else all with many a column to hold information about them. Open the program right click on the columns to rename them and to add additional columns as necessary. Then double click on a row and start entering the information. Import a Comma Separated Values (CSV) or tab delimited file to use with Snap DB or export the data to a CSV file. Activate the Filter mode (View—>Filter Mode) to search the data and get results as you type.

    Snap DB has a few built in shortcuts to make entering information easier. For example use F2 to edit a record or F5 to duplicate a record. The usual Ctrl-C Windows copy key combination will copy whole row(s) of data in SnapDB ready to be pasted anywhere with each column separated by a tab. Conversely copying some tab delimited text and using Ctrl-V in SnapDB pastes them into columns. Also notice that when adding or inserting data there is Run button, that button will execute if the corresponding field has a URL, mailto or path to a file or folder in it.

    Snap DB is freeware, portable, no install and is less than 700KB unzipped. Watch the screencast on the program’s site to see it in action and follow the thread and suggest other features in its DonactionCoder forums thread (linked above).