Application Name | Snap DB |
Short Description | Simple, flat-file database/list app |
Supported OSes | Windows 7. Probably works, but not tested, on Windows XP/Vista/8. |
Web Page | Website (http://skwire.dcmembers.com/wb/pages/software/snap-db.php) |
Download Link | Download (http://skwire.dcmembers.com/apps/snap_db/SnapDB.zip) |
Author | Jody Holmes - Skwire Empire (http://skwire.dcmembers.com) |
Nice screenshot, Skwire. I like apps with a clean interface, that are simple to use, yet useful. Might be able to put this to work. I notice the file extension is .snp. Is it in essence a text file, or non-text but flat in the sense that there is no internal hierarchy of tables, etc., such as in a structured database? In other words, could the files created/used by the program be opened in a text editor?-kyrathaba (December 26, 2010, 10:18 PM)
- 1) on first use, in help file, and maybe even at bottom statusbar on startup it should explain "right-click on column titles to rename them"
- 2) have it auto-reload the last database file, OR the database file in the current directory if no config file entry for last database file exists; one reason this would be SO useful is because it would let users SHARE the exe+database with someone by sending it to them, and all they would have to do is run the exe to have the data loaded and ready.
-mouser (December 26, 2010, 10:18 PM)
This allows you to bundle the SnapDB.exe file and a .snp database file together for easy viewing.
This looks great on a first look skwire! I don't know how useful this would be but could it also import say a csv or txt file?-techidave (December 30, 2010, 04:08 PM)
whoops, may have found a glitch.
I added two columns after the default of 4 columns but there is no option to rename them or even add another new column on either side. If I add a column to the right of the 4th column, then I get the option to rename it.
Add on: I also cannot delete these columns-techidave (December 30, 2010, 04:47 PM)
Can you add an option to automatically place the cursor on the filter, with the filter option enabled and if possible with certain column already selected?
For now, don't include the config.ini file when you send it to a friend. Just the .snp and the SnapDB.exe file.-skwire (January 10, 2011, 10:16 AM)
On the request side, does a close current file/db sound reasonable?-Stoic Joker (January 11, 2011, 07:28 AM)
+ The listview font face, style and color are now configurable under the View >
Options dialog.
+ Made the "Load last database" feature an option under View > Options.
+ Option to keep a .bak backup after saving a database. (Thanks, mouser)
-skwire (January 11, 2011, 06:35 PM)
I also changed up the toolbar glyphs. What do you all think? Do you like these better or the original ones?-skwire (January 11, 2011, 06:35 PM)
I also changed up the toolbar glyphs. What do you all think? Do you like these better or the original ones?-skwire (January 11, 2011, 06:35 PM)
Suggestion: An option to close the 'Add record' dialogue by clicking the Enter key (like it works in most apps).-Nikita (January 11, 2011, 08:17 PM)
It will only auto-open a file if it's in the same folder as the SnapDB.exe. Personally, I create a \databases folder and put my .snp files in there.-skwire (January 11, 2011, 09:08 AM)
On the request side, does a close current file/db sound reasonable?-Stoic Joker (January 11, 2011, 07:28 AM)
Sure, can do, but I'm not sure what purpose it would serve?-skwire (January 11, 2011, 09:08 AM)
Understood, my curiosity was only in regard to it auto-opening a file in the same folder with the wrong (.snpk) file extension.-Stoic Joker (January 12, 2011, 06:34 AM)
Well, I did allow for the possibility that I was doing it wrong... :) ...But I was looking at the possibility of bouncing through multiple .csv files, and allowing for either combining them (which I believe already works), or ("closing" the "file" ) clearing them and starting over without having to close and reopen the program.-Stoic Joker (January 12, 2011, 06:34 AM)
One other confusing behavior, was the programs reaction to drag-n-droping a .csv file in the client window. While it appeared to (be trying to) process the file, the result was a blank ListView. Could a .csv/.tsv file drop be made to trigger an import?-Stoic Joker (January 12, 2011, 06:34 AM)
:: Double clicking in an empty row opened the 'add record' dialogue (whereas currently it opens the 'edit record' dialogue
:: There was the possibility to use a basic 'add and total' formula for any figures entered in a column-Beth UK (January 12, 2011, 08:38 AM)
Not sure if its a bug or user problem, but I made a list of my collection of cutlery-WobblyWombat (January 12, 2011, 03:31 PM)
:: Double clicking in an empty row opened the 'add record' dialogue (whereas currently it opens the 'edit record' dialogue
:: There was the possibility to use a basic 'add and total' formula for any figures entered in a column-Beth UK (January 12, 2011, 08:38 AM)
I think I was probably looking for something different with the formula thing - just a way to total all figures that might appear in a single column (e.g., 4+5+6+7+4 = 26). That way I could total up time spent on a task for instance, or quoted prices etc.-Beth UK (January 12, 2011, 06:22 PM)
I'm almost positive this is either a listview bug or a bug with how AutoHotkey handles the listview.-skwire (January 12, 2011, 05:57 PM)
I think I was probably looking for something different with the formula thing - just a way to total all figures that might appear in a single column (e.g., 4+5+6+7+4 = 26). That way I could total up time spent on a task for instance, or quoted prices etc.-Beth UK (January 12, 2011, 06:22 PM)
Hmmm...did you see the "Sum column" option when you right-click a column's header? That will pop up a message box with the total of any numbers in the column. Is that not what you wanted?-skwire (January 12, 2011, 06:28 PM)
Maybe temporarily create a second ListView with the updated (new) column arangement, and then stream the data into it before deleting the old control.-Stoic Joker (January 12, 2011, 06:29 PM)
No - I missed it completely! But now I have seen it! Is there a way that instead of the total popping up in a window it can be inserted into a cell at the bottom of column in question - perhaps beneath a divider line or something? That would make it perfect for what I need!-Beth UK (January 12, 2011, 06:34 PM)
Suggestion: An option to close the 'Add record' dialogue by clicking the Enter key (like it works in most apps).-Nikita (January 11, 2011, 08:17 PM)
No - I missed it completely! But now I have seen it! Is there a way that instead of the total popping up in a window it can be inserted into a cell at the bottom of column in question - perhaps beneath a divider line or something? That would make it perfect for what I need!-Beth UK (January 12, 2011, 06:34 PM)
My hesitation is that I didn't intend for Snap DB to become a spreadsheet at all. I mean, it's trivial to do what you want but then that summation line becomes part of the database information and its data would then be used in further calculations unless you were to delete that line. It just seems a bit kludgy. Does that make sense?-skwire (January 13, 2011, 08:56 AM)
a 'time logger' for a University course I am doingWith a little ingenuity you might be able to use skwire's Bestimate for this. Worth a look here's a link. (http://skwire.dcmembers.com/wb/pages/software/bestimate.php)-Beth UK (January 13, 2011, 12:30 PM)
I second Nikita's suggestion.
Though what I mean is that when I have selected a row, I'd like to edit it after hitting Enter.
I hate double clicking due to RSI.-TalksToPCs (January 13, 2011, 11:56 AM)
I'd like to be able to duplicate a row, too.
The way I'm using it, I have lots of similar entries that need to be manually entered (or via a few snippets that I have created for this purpose).-TalksToPCs (January 13, 2011, 11:56 AM)
I found this weird bug. When I right click the header of the ninth column, I don't have the option to "rename column", instead I got the "Add record.." context menu.-alexsan01 (January 17, 2011, 10:04 AM)
Also, it could be a good idea to have the option to use the first row as column headers when you import from a CSV file.-alexsan01 (January 17, 2011, 10:04 AM)
Thank you for the lastest updates.-alexsan01 (January 17, 2011, 10:04 AM)
I've implemented this in the next build with F2 as the hotkey (instead of Enter).-skwire (January 14, 2011, 11:43 AM)
I'd like to be able to duplicate a row, too.
The way I'm using it, I have lots of similar entries that need to be manually entered (or via a few snippets that I have created for this purpose).-TalksToPCs (January 13, 2011, 11:56 AM)
Can do. Would you want the duplicated row added to the bottom of the listview or directly below the row you're duplicating?-skwire (January 14, 2011, 11:43 AM)
Can do. Would you want the duplicated row added to the bottom of the listview or directly below the row you're duplicating?-skwire (January 14, 2011, 11:43 AM)
I haven't really thought about it. From the point of view of my needs, either solution seems fine.-TalksToPCs (January 20, 2011, 08:56 AM)
Thanks, I like Snap DB even more now!-TalksToPCs (January 20, 2011, 08:56 AM)
One other confusing behavior, was the programs reaction to drag-n-droping a .csv file in the client window. While it appeared to (be trying to) process the file, the result was a blank ListView. Could a .csv/.tsv file drop be made to trigger an import?-Stoic Joker (January 12, 2011, 06:34 AM)
Fixed and added in the above build. :D Lots of improvements to the CSV/TSV/TXT import routines. Please let me know if the functionality is what you had in mind.-skwire (January 12, 2011, 12:50 PM)
(Sorry it took me awhile to make it back here) Yes, perfect ... The dynamic column creation is also quite nice. Thank you.-Stoic Joker (January 21, 2011, 07:17 AM)
Is there any chance of adding an option to the import function to allow the (header row) first line of the file to be used as the column names? Similar to the radio button dialog the Excel sort function uses to keep the column names on top of a spread sheet.-Stoic Joker (January 21, 2011, 07:17 AM)
Is there any chance of adding an option to the import function to allow the (header row) first line of the file to be used as the column names? Similar to the radio button dialog the Excel sort function uses to keep the column names on top of a spread sheet.-Stoic Joker (January 21, 2011, 07:17 AM)
The "Convert record data to header names." sounds great (and much smoother), but it might be better to add it to the Edit menu where it can be found & used, and leave the context menu free for the other stuff that people are more apt to do frequently (Keep the menu less busy so they don't have to hunt for stuff).-Stoic Joker (January 21, 2011, 08:36 AM)
I took the easy (lazy?) way out and now only allow the appending of a new column to the end. Once appended, the user can drag the new column wherever they want.
I appended two columns, renamed each and drug them to the left between two existing columns. When I exported to a csv and brought them up in Excel, the appended columns were still on the right side. Not where I moved them to.-bob99 (January 21, 2011, 11:46 AM)
SnapDB is great! It's now much easier for me using it to get some lists into csv format than I was doing before.-bob99 (January 21, 2011, 11:46 AM)
I appended two columns, renamed each and drug them to the left between two existing columns. When I exported to a csv and brought them up in Excel, the appended columns were still on the right side. Not where I moved them to.-bob99 (January 21, 2011, 11:46 AM)
IIRC this is also typical ListView control behavior.
I'm thinking there is a function call/API to reindex the rows in a ListView control, but I can't think of it at the moment.-Stoic Joker (January 21, 2011, 01:12 PM)
The "Convert record data to header names." sounds great (and much smoother)-Stoic Joker (January 21, 2011, 08:36 AM)
Lovely piece of software again Skwire! :-* :up:-DeVamp (January 24, 2011, 05:21 AM)
Because what happens now is the following:
I create a new file, and I get 4 columns.
When I drop a CSV on it with 7 columns, I end up with all the records with only 5 columns.-DeVamp (January 24, 2011, 05:21 AM)
Oh, and could it be possible to define the "separator" per database?
So when I create a new database, I define ',' or ';' as separator. When I then drop a scv on it, it uses the configured separator.-DeVamp (January 24, 2011, 05:21 AM)
One more thing (probably a bug):
If I drop a scv on it, the status doesn't change to "edited", so when I close snapdb, it doesn't save the data from the scv. :'(-DeVamp (January 24, 2011, 05:21 AM)
For the CSV : sometimes programs export data to "CSV", but they use a ; instead of a ,-DeVamp (January 24, 2011, 10:39 AM)
And sometimes an export contains "strings" with quotes.-DeVamp (January 24, 2011, 10:39 AM)
Is there a maximum number of characters limit per field?-bob99 (January 24, 2011, 12:00 PM)
I appended two columns, renamed each and drug them to the left between two existing columns. When I exported to a csv and brought them up in Excel, the appended columns were still on the right side. Not where I moved them to.-bob99 (January 21, 2011, 11:46 AM)
Should be fixed in the most recent build. Please test and let me know. Thanks.-skwire (January 22, 2011, 12:27 PM)
Is there a maximum number of characters limit per field?-bob99 (January 24, 2011, 12:00 PM)
No, but only the first 260 characters are displayed in the listview though the entire field is saved. There is no limit to the number of rows but, keep in mind, that saving and loading times will increase with larger listviews. I have a test database of zip codes that is three columns and around 43,000 rows. It takes around fourteen seconds to fully load on my computer. Furthermore, there is a maximum of 200 columns allowed. Does this answer your question?-skwire (January 24, 2011, 12:43 PM)
I have run into an issue.
I seem to have closed SnapDB with a filter applied the last time I used it.
Now, all I have left from my entries are the items that I had last filtered, which are about 5 out of 30 or so.
I cannot find a way to get my whole dataset back.
It isn't too dramatic and I certainly have a back-up somewhere.
Any suggestions?-TalksToPCs (January 26, 2011, 03:29 PM)
Did you have the "Keep a .bak backup file after saving enabled" option enabled?Yeah, I did, but apparently i saved something else in the meanwhile.
Snap DB will then ask if you if you want to save (since the database has been modified) ... most folks will click yes and Snap DB erroneously saves the filtered data.I dimly remember doing something like this. Well, the universe is winning again...
For the CSV : sometimes programs export data to "CSV", but they use a ; instead of a ,-DeVamp (January 24, 2011, 10:39 AM)
Silly programs...that's not a CSV file then. =]-skwire (January 24, 2011, 11:09 AM)
But I've just came across a program that exports to CVS seperated by ;
It was Microsoft SQL Server Management Studio.
I've exported a bunch of invoices, and to preserve the amounts, it uses a ; as separator.
And I didn't found a setting to change the exportsettings in it. :'(-DeVamp (January 27, 2011, 07:42 AM)
Perhaps you can provide a "default" separator, just a general application setting, and then it's up to us, the users, to change it according to the file we want to drop or open or import.
Just an idea. :-)-DeVamp (January 27, 2011, 07:42 AM)
I know my complaining does as much good as pounding sand. :PYou do have a good point. But hey, its a microsoft program. they have their own standards ;)-skwire (January 27, 2011, 09:56 PM)
It's in the next build. :)Great! 8)-skwire (January 27, 2011, 09:56 PM)
Snap DB is a smart and good software. Thanks for it.-suigen (January 29, 2011, 08:31 PM)
But... How can I have a cell (field) multi-lines or wordWrap ?-suigen (January 29, 2011, 08:31 PM)
And... How can I have row cells more talls ?-suigen (January 29, 2011, 08:31 PM)
Sorry for my very bad english.-suigen (January 29, 2011, 08:31 PM)
Any chance you could allow to copy info from the selected row when in "Filter Mode"? maybe you can use the same window when updating a record, but with the "Update record" button disabled.-alexsan01 (January 31, 2011, 11:04 AM)
+ The 'Run' feature will attempt to execute data that meet the following
criteria:
# A file or folder e.g.: c:\path\to\my.exe, c:\path\to\image.png
# A URI/URL with "://" in it e.g. http://www.site.com
# 'mailto:' links e.g. mailto:[email protected]-skwire (February 01, 2011, 01:49 PM)
Hi skwire, really nice apps you have here.. :up: Thanks for the good job.-smartmushu (February 06, 2011, 09:19 AM)
I've used snapDB for many types tables, including one with date type data and memo type data. :D
However, I do have some questions / requests regarding snapDB. Is it possible if snapDB implement some kind of "sort by date" function? I sometimes need to sort my data based on date.-smartmushu (February 06, 2011, 09:19 AM)
And last, do you mind to provide any option to use comment box instead of text box to input/edit/read memo type data?-smartmushu (February 06, 2011, 09:19 AM)
The problem is that the listview columns sort alpha by default and must be changed programmatically to sort in different ways e.g. numerically/integer. The problem with dates is that they're neither. You would almost need to have a separate column that kept YYYYMMDDHH24MISS timestamps to be able to sort dates properly. All that being said, I have given some thought on how to allow configuration of sorting options on each column. I just haven't come up with a good solution (yet).-skwire (February 06, 2011, 06:28 PM)
I'm not sure what you mean by a comment box. Do you have a screenshot of another app that uses one?-skwire (February 06, 2011, 06:28 PM)
Sorry to make you confused, I mean some bigger text box (not just one line text box) with 2 or 3 rows space and maybe with scroll button, like the one we see in Donation Coder forum when we post reply.. :D So if I put some long text I could simply scroll up and down to see all of my text.-smartmushu (February 07, 2011, 03:05 AM)
Sorry to make you confused, I mean some bigger text box (not just one line text box) with 2 or 3 rows space and maybe with scroll button, like the one we see in Donation Coder forum when we post reply.. :D So if I put some long text I could simply scroll up and down to see all of my text.-smartmushu (February 07, 2011, 03:05 AM)
The hesitation I have in doing this is it would give the impression that SnapDB can display multi-line bits of information (which it can't). Saving and restoring mutil-line bits is easy enough but displaying them in a standard listview is not possible.-skwire (February 07, 2011, 10:25 AM)
well, okay then.. thanks skwire..-smartmushu (February 07, 2011, 09:02 PM)
I mean, there really is not a good place to put a multiline edit/text field on the main form without sacrificing listview space in some way (which I'm loathe to do).-skwire (March 24, 2011, 10:07 AM)
Skwire, thanks for your excellent program, I can see many uses.-timn (March 28, 2011, 03:00 PM)
I have some suggestions that would make it even more useful for me.
1. Don't clear the filter match field when you turn off filter mode - I often want to use it again.
2. A method to import a CSV file, use its first line as header names and delete that row in one operation.
3. More filter types like "doesn't equal", "doesn't contain", "greater than", "less than", regular expression match.-timn (March 28, 2011, 03:00 PM)
2. I understand the reasoning behind this. However, this would sort of break the mass import you can do by dropping a bunch of CSV onto the list (or multi-selecting them via the file choose dialog). Did you see the Edit/Context menu option to convert a row to the header? Maybe a solution/option would be if there was only one file dropped (or selected via the dialog), auto convert the first line into a header.Thanks for the quick reponse.-skwire (March 28, 2011, 03:49 PM)
I noticed some of the recurring themes on implementation of requests are limited by the ListView control. I am not much of a programmer, and even less wrt AHK, but perhaps a solution to many of these requests would be a second "read-only" mode that uses a different control for display?-steeladept (December 04, 2011, 04:59 PM)
What does "Run/execute cell data" do?-daddydave (December 05, 2011, 12:22 PM)
What does "Run/execute cell data" do?-daddydave (December 05, 2011, 12:22 PM)
It will attempt to "run" the contents of a cell. So, say you had folder path, it would launch that folder path. Or, the path to an exe, image file, etc. You can also put, say, email addresses in a cell and it will launch those, too. Kind of like a poor man's address book. Make sense?-skwire (December 05, 2011, 12:28 PM)
Yes, thanks. :)-daddydave (December 05, 2011, 12:40 PM)
I was going to ask if there were any plans to allow exporting while in filter mode-daddydave (December 29, 2011, 11:13 PM)
Downloaded the version and I don't see any change in behavior I was referring to.
I am referring to File > Export rows to CSV file. The whole File menu disappears when I click on the checkbox for Filter/Read-Only mode.
To clarify further, it would be nice to be able to export a subset of records based on the filtered rows that are displayed.-daddydave (December 30, 2011, 12:11 PM)
I like the Web Search. I set it to search pronunciations from Forvo: http://www.forvo.com/search-hi/$$1 It works great from the right click menu, but nothing happens when I press Ctrl-W (which I think is generally used for "close window", but I don't know if that matters.-daddydave (December 30, 2011, 12:11 PM)
Why not Alt-F4?
;D-rgdot (April 02, 2012, 02:57 PM)
Hi skwire!-lilsypha (June 03, 2012, 12:20 AM)
Is it possible that you might add the ability for multiple filters in the future?-lilsypha (June 03, 2012, 12:20 AM)
Is there a better way?-timn (August 30, 2012, 05:33 AM)
on resizing the SnapDB window, I've gotten three freezes so far-tomos (April 10, 2013, 07:51 AM)
I wanted to ask you why is the "Edit record" option greyed out when in "Filter" mode?-alexsan01 (March 19, 2013, 12:27 PM)
on resizing the SnapDB window, I've gotten three freezes so far-tomos (April 10, 2013, 07:51 AM)
I can reproduce this by grabbing the right side and shaking the hell out of it but not under normal circumstances. I'm going to guess the issue is in the Anchor() function that I use for positioning and resizing controls.-skwire (April 10, 2013, 10:15 AM)
This probably needs a new thread/program but I will ask any way. Is there any way Snap DB (or one like it) can have a checklist? I mean I am looking for a simple flat file DB with support for a yes/no field.-rgdot (April 24, 2013, 03:19 PM)
Yes, that's basically what I am after.
I know Snap DB doesn't do it. I am trying my best to avoid using one more program filled with to do and other data though. That's why I asked here in the Snap DB thread.-rgdot (April 24, 2013, 06:06 PM)
Great thanks for this excellent program.-Erekle (November 09, 2013, 07:11 AM)
Just one wish: Is it possible to add multi-line fields (in Table Pro by ZGS this is implemented with combination Ctrl + Enter, but Table Pro does not suppurt unicode :) )?-Erekle (November 09, 2013, 07:11 AM)
And one remark. If change the window's size from maximized to arbitrary and then back again - fields for records are no longer occupy the entire window.-Erekle (November 09, 2013, 07:11 AM)
Yes, problem is solved! :up:
Thank you.-Erekle (November 09, 2013, 03:31 PM)
It seems, the program adds tween records when duplicate with F5. :)
And deletes 2 records instead of one, if delete with "Del". :(-Erekle (November 12, 2013, 05:35 PM)
Yes, now it works like it should. Thanks a lot.-eNdi (December 28, 2013, 04:47 PM)
I can't have more than one note in an same file, Snap DB make a database by file :(-c-sanchez (April 05, 2018, 10:26 PM)
Snap DB just rename the last column, not selected one.-c-sanchez (April 05, 2018, 10:26 PM)
I can't have more than one note in an same file, Snap DB make a database by file-c-sanchez (April 05, 2018, 10:26 PM)
This appears to work fine for me. I can right-click any column header and rename it.haha weird, now works here too, I don't know what happens, but I'm sure I saw that problem :S-skwire (April 05, 2018, 11:48 PM)
Indeed I've send a message to MemPad developer requesting for this (make some option to save notes in tables)
Like this: https://s6.postimg.o...horizontal_list2.png-c-sanchez (April 06, 2018, 12:53 AM)
@c-sanchez: Thanks for taking the time to give Snap DB a try. Unfortunately, as wraith808 said, Snap DB probably isn't going to be the application for you. I have no plans to add a treeview or multiple database handling to Snap DB.I understand, it's not what Snap DB was designed for, is ok. Anyway thank you very much for your replies @skwire and @wraith808 :D :up:-skwire (April 06, 2018, 09:04 AM)
I think is better if is possible make a database for accounts, password, phones, and so with just one db file.I'm not sure if it is exactly what you want, but the closest-appearing thing I know of is TreeLine (http://treeline.bellz.org/index.html):
Indeed I've send a message to MemPad developer requesting for this (make some option to save notes in tables)
Like this: https://s6.postimg.org/xwx6a0p6p/mempad_horizontal_list2.png-c-sanchez (April 06, 2018, 12:53 AM)
Some would call TreeLine an Outliner, others would call it a PIM. Basically, it just stores almost any kind of information. A tree structure makes it easy to keep things organized. And each node in the tree can contain several fields, forming a mini-database. The output format for each node can be defined, and the output can be shown on the screen, printed, or exported to html.
And thanks for the bit about treeline... I hadn't heard of that.I dabbled with a very old version, years ago, and suggested it here because it seems to have the fields that @c-sanchez wanted (see the screenshots). It's a strange beast, hard to uninstall without using something like Revo, but it's multi-platform and now apparently portable.-wraith808 (April 08, 2018, 03:57 PM)
Is it possible to sort a column of dates?-smithralph (May 13, 2018, 05:35 AM)