Welcome Guest.   Make a donation to an author on the site April 20, 2014, 09:03:33 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
Read the Practical Guide to DonationCoder.com Forum Search Features
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1] 2 3 4 5 6 ... 8 Next   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: NANY 2011 Release: Snap DB  (Read 60842 times)
skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« on: December 26, 2010, 10:07:22 PM »

NANY 2011 Entry Information

Application Name Snap DB
Short Description Simple, flat-file database/list app
Supported OSes Unicode version (WinXP and up), ANSI version (Win2k and below)
Web Page Website
Download Link Download
Author Jody Holmes - Skwire Empire

Description
Simple, flat-file database app.

Screenshots




Usage
Installation
Download the zip file and extract its contents into a new folder.  Run SnapDB.exe to start the application.

Using the Application
Pretty self-explanatory; right-click things and use the menu and toolbar buttons.  

Uninstallation
Delete the folder you unzipped it to.  The application doesn't write to the registry.

Known Issues
This is an app I wrote a while back and use for lists of almost everything (games I own, books to read, etc.).  I decided to pretty it up for a NANY 2011 release.  The feature-set is hardly finished and I plan to further develop this.
« Last Edit: April 02, 2012, 01:57:00 PM by skwire » Logged

kyrathaba
N.A.N.Y. Organizer
Honorary Member
**
Posts: 2,975



while(! dead_horse){beat}

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #1 on: December 26, 2010, 10:18:17 PM »

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?
Logged

Win 7 Home Premium 64bit-SP1 AMD Athlon II X2 220 Socket AM3 (938) @ 2.1GHz 6GB RAM Firefox 26.0
_________________________________________________________________________________________

I'm fighting against patent trolls. Join me and tell your representative to support the #SHIELDAct: https://eff.org/r.b6JJ /via @EFF

My DC page: http://kyrathaba.dcmembers.com | My blog: http://williambryanmiller.com/ | Proofreading Service: http://bit.ly/1fQSqQP

mouser
First Author
Administrator
*****
Posts: 32,674



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #2 on: December 26, 2010, 10:18:33 PM »

looks fantastic.

couple of quick suggestions:

  • 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.
Logged
skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #3 on: December 26, 2010, 10:28:04 PM »

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?

Yes, the format is pretty simple to figure out.  The app was inspired by a couple of apps.  One is called List² and the other was called Table Tool which, sadly, no longer exists though you can still download the app from web.archive.org.  The format is very similar to what those apps use(d).

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

Can do.
« Last Edit: December 26, 2010, 10:30:28 PM by skwire » Logged

Ath
Supporting Member
**
Posts: 2,132



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #4 on: December 27, 2010, 06:06:11 AM »

It's great Thmbsup
One (big, in size) feature request would be to be able to sequentially output the records to print in some form, so I could enter my christmas card addresses into SnapDB and print them nicely (for next years cards ofcourse)
Logged

skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #5 on: December 27, 2010, 11:05:42 PM »

@Ath: Thanks for the feedback; basic printing is on the roadmap.
Logged

mouser
First Author
Administrator
*****
Posts: 32,674



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #6 on: December 28, 2010, 11:26:47 AM »

minor suggestion:
maybe justify columns on data should really justify on max(data,column) or offer a third chioce for justify on both.
Logged
mouser
First Author
Administrator
*****
Posts: 32,674



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #7 on: December 28, 2010, 11:34:34 AM »

I agree printing would be a really nice feature, but it might be hard to implement.

I can think of two options:
  • 1) there may be a standalone free commandline printing tool specialized for tables -- hey if there isn't, then that is a GREAT idea for someone to code.
  • 2) perhaps more realistically, a reasonable solution would be to export an html file, and open it, and let user print from there (you could even triger the printing automatically probably using javascript); nice side benefit would be html export feature could be useful in and of itself for people who want to post their db on the web.
Logged
skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #8 on: December 28, 2010, 11:45:45 AM »

Any printing I add will be very simple text output...maybe a simple HTML output, too.  However, the file format is such that anybody and any language can parse it and come up with their own exports.
Logged

skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #9 on: December 28, 2010, 11:57:17 AM »

Website | Download
v1.0.1 - 2010-12-28
        ! Fixed toolbar glyph issue under Windows 7.  (Thanks, mouser)
Logged

skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #10 on: December 30, 2010, 03:49:08 PM »

Website | Download
v1.0.2 - 2010-12-28
    + Last loaded database is automatically loaded after application startup.
    + Snap DB will automatically load an .snp file if both of the following are true:
          1) No config.ini file is present.
          2) There is a .snp file in the same folder as the SnapDB.exe file.
      This allows you to bundle the SnapDB.exe file and a .snp database file
      together for easy viewing.  (Thanks, mouser)
Logged

mouser
First Author
Administrator
*****
Posts: 32,674



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #11 on: December 30, 2010, 03:54:24 PM »

Quote
This allows you to bundle the SnapDB.exe file and a .snp database file together for easy viewing.

great!
Logged
techidave
Supporting Member
**
Posts: 937


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #12 on: December 30, 2010, 04:08:37 PM »

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?

I must hurry home to play with it some more  thumbs up
Logged
techidave
Supporting Member
**
Posts: 937


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #13 on: December 30, 2010, 04:47:05 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
« Last Edit: December 30, 2010, 04:52:37 PM by techidave » Logged
skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #14 on: December 30, 2010, 10:06:29 PM »

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?

Yes, both are easy to do and are on the immediate roadmap.

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

I can't seem to reproduce.  Can you give your exact sequence of right-clicks and such (and the position of your clicks)?
Logged

techidave
Supporting Member
**
Posts: 937


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #15 on: December 30, 2010, 10:15:46 PM »

i will try to give a screenshot but let me see if I can clarify it first.

by default snapdb gives you 4 columns.  If you create a new column to the left of any of the 4 original columns, then it works like it should.

if you add a new column to the right of the 4th column, then that is when I had the problems.
Logged
techidave
Supporting Member
**
Posts: 937


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #16 on: December 30, 2010, 10:19:15 PM »

I was just playing with it again and if I make the window wider to get rid of the horizontal scroll bar then it works like it should.  how weird.
Logged
techidave
Supporting Member
**
Posts: 937


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #17 on: December 30, 2010, 10:42:00 PM »

ok, skwire here are some screenshots.  I decided to zip them to save space.  also included in the zip file are details of the screenshots.

* snapdb_image5.zip (677.26 KB - downloaded 776 times.)
Logged
skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #18 on: January 02, 2011, 07:11:15 PM »

Sorry about the delay, techidave.  I've been able to recreate this but I'm not sure I can fix it elegantly since this appears to be a listview bug and not something within my code.  I'll keep at it.  For now, resize the form or resize the columns as that appears to fix things.  Very strange issue.
Logged

skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #19 on: January 07, 2011, 12:06:18 PM »

Website | Download
v1.0.3 - 2011-01-07
    + Added tab-delimited text file import.
    + Added CSV file import.
    + Added ability to paste in tab-delimited data directly from the "Edit" menu.
    ! Last saved file didn't work from the "Recent" menu.
Logged

mouser
First Author
Administrator
*****
Posts: 32,674



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #20 on: January 07, 2011, 12:07:50 PM »

nice update  Thmbsup
Logged
alexsan01
Participant
*
Posts: 10


View Profile Give some DonationCredits to this forum member
« Reply #21 on: January 09, 2011, 10:32:55 PM »

Hey, I just saw your software on the NANY list. I have been looking for this exactly tool for a while. I got a Phone numbers list on Excel and I was trying to find for a tool that would let me filter the records and instantly find a number, kinda like the application "Everything" (check it out if you haven't, really useful), in which you just open the window and start typing the name of file you are looking for and it shows the result instantly.
Can I have a small request? 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? This would prove useful if you just want to open the application and inmediatly start typing what you are looking for. Or maybe you can add a "ALL COLUMNS" in the column selection so you can search for a specific text in any column, and have it selected by default.

Thank you for this useful application. Good luck in the NANY event.
Logged
mouser
First Author
Administrator
*****
Posts: 32,674



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #22 on: January 09, 2011, 10:39:13 PM »

Quote
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?

Maybe cleanest solution is to allow ctrl+F to put cursor in search box and enable the filter (and maybe ctrl+F again to toggle it off).
I like the ALL COLUMNS idea; and it could remember the last column selected in the filter.
Logged
skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #23 on: January 09, 2011, 10:43:41 PM »

The "any/all column" functionality was on my roadmap.  Alexsan01, would a ctrl-f hotkey to toggle the filter mode be an acceptable solution?
Logged

skwire
Charter Member
***
Posts: 3,905



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #24 on: January 09, 2011, 11:53:58 PM »

Website | Download
v1.0.4 - 2011-01-10
    + Added an extra choice in the Filter dropdown called "Any column."  This will
      allow you filter using a string that matches any column.
    + Added ability to save chosen filter per-database.  This means, to make use
      of this feature, you will need to set the filter and then save the database
      file on each database you wish to use this on.  (Thanks, alexsan01)
    + Added ctrl-f hotkey to toggle Filter mode.  (Thanks, mouser)
    + Added View > Filter mode menu option.


alexsan01, let me know if this will work for you.  Thanks.
Logged

Pages: [1] 2 3 4 5 6 ... 8 Next   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.049s | Server load: 0.05 ]