{"id":2470,"date":"2011-02-03T10:32:31","date_gmt":"2011-02-03T15:32:31","guid":{"rendered":"http:\/\/www.rgdot.com\/bl\/?p=2470"},"modified":"2013-04-14T20:08:00","modified_gmt":"2013-04-15T01:08:00","slug":"snap-db-keep-your-info-in-this-simple-database","status":"publish","type":"post","link":"http:\/\/www.rgdot.com\/bl\/2011\/02\/03\/snap-db-keep-your-info-in-this-simple-database\/","title":{"rendered":"Snap DB: Keep Your Info In This Simple Database"},"content":{"rendered":"<p><a href=\"http:\/\/www.rgdot.com\/bl\/wp-content\/uploads\/2011\/02\/snapdb.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-2471\" title=\"snapdb\" src=\"http:\/\/www.rgdot.com\/bl\/wp-content\/uploads\/2011\/02\/snapdb-300x129.jpg\" alt=\"\" width=\"300\" height=\"129\" \/><\/a><\/p>\n<p><a title=\"Snap DB\" href=\"http:\/\/skwire.dcmembers.com\/wb\/pages\/software\/snap-db.php\" target=\"_blank\">Snap DB<\/a> is one of the 2011 entries in Donationcoder&#8217;s <a title=\"N.A.N.Y.\" href=\"http:\/\/www.donationcoder.com\/forum\/index.php?topic=25028\" target=\"_blank\">N.A.N.Y.<\/a> (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.<\/p>\n<p>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&#8212;&gt;Filter Mode) to search the data and get results as you type.<\/p>\n<p>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.<\/p>\n<p>Snap DB is freeware, portable, no install and is less than 700KB unzipped. Watch the screencast on the program&#8217;s site to see it in action and follow the thread and suggest other features in its DonactionCoder forums thread (linked above).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Snap DB is one of the 2011 entries in Donationcoder&#8217;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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2471,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[3],"tags":[198,427,277,41,11,47],"class_list":["post-2470","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-reviews","tag-csv","tag-database","tag-list","tag-organize","tag-pim","tag-text"],"_links":{"self":[{"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/posts\/2470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/comments?post=2470"}],"version-history":[{"count":6,"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/posts\/2470\/revisions"}],"predecessor-version":[{"id":2476,"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/posts\/2470\/revisions\/2476"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/media\/2471"}],"wp:attachment":[{"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/media?parent=2470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/categories?post=2470"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.rgdot.com\/bl\/wp-json\/wp\/v2\/tags?post=2470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}