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).