Welcome Guest.   Make a donation to an author on the site December 20, 2014, 06:28:20 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: Prev 1 2 3 4 [5] 6 7 8 Next   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: NANY 2011 Release: Snap DB  (Read 69455 times)
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #100 on: February 06, 2011, 06:28:06 PM »

Hi skwire, really nice apps you have here.. thumbs up Thanks for the good job.

You're welcome.  Thanks for the kind words and welcome to DonationCoder.

I've used snapDB for many types tables, including one with date type data and memo type data.  cheesy

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.

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

And last, do you mind to provide any option to use comment box instead of text box to input/edit/read memo type data?

I'm not sure what you mean by a comment box.  Do you have a screenshot of another app that uses one?
Logged

smartmushu
Participant
*
Posts: 3


View Profile Give some DonationCredits to this forum member
« Reply #101 on: February 07, 2011, 03:05:23 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).

Okay, got it, thanks..  thumbs up

I'm not sure what you mean by a comment box.  Do you have a screenshot of another app that uses one?

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.. cheesy So if I put some long text I could simply scroll up and down to see all of my text.
Logged
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #102 on: February 07, 2011, 10:25:02 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.. cheesy So if I put some long text I could simply scroll up and down to see all of my text.

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

smartmushu
Participant
*
Posts: 3


View Profile Give some DonationCredits to this forum member
« Reply #103 on: February 07, 2011, 09:02:16 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.. cheesy So if I put some long text I could simply scroll up and down to see all of my text.

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.

well, okay then.. thanks skwire..
Logged
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #104 on: February 09, 2011, 10:35:32 AM »

well, okay then.. thanks skwire..

Sorry to disappoint you.   Sad  I hope you can still find some use in Snap DB.  smiley

Website | Download
v1.1.7 - 2011-02-09
    ! Fixed a small graphical glitch with the enable filter checkbox.
Logged

skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #105 on: February 09, 2011, 07:26:25 PM »

Website | Download
v1.1.8 - 2011-02-09
    + Passing in a CSV or TSV/TXT file via the commandline is now supported.
      (Thanks, camerb)
Logged

cameronbaustian
Participant
*
Posts: 1

View Profile Give some DonationCredits to this forum member
« Reply #106 on: February 10, 2011, 08:49:58 AM »

Excellent work, Skwire! I'm able to launch your app using the command line, passing it a csv/tsv/txt file. Looks great, and I'm pretty impressed with how clean your GUI is as well. Simple, straightforward and understandable.
Logged
mouser
First Author
Administrator
*****
Posts: 33,790



see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #107 on: February 10, 2011, 08:51:09 AM »

Just a friendly normal reminder to people -- if you like what a coder on the site is doing, consider making a little donation to them to say thanks.
Logged
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #108 on: February 10, 2011, 09:02:15 AM »

Thanks for the kind words, camerb.  smiley  I'm glad you find Snap DB useful.
Logged

skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #109 on: February 10, 2011, 11:25:37 PM »

Website | Download
v1.1.9 - 2011-02-10
    + Added 'Copy cell contents' to the list context menu.  This will copy, to
      the clipboard, the text of the cell you right-clicked on to bring up the
      context menu.
    + Added 'Copy column data' entry to the header context menu.  This will
      copy, to the clipboard, the entire column's contents.
Logged

skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #110 on: February 11, 2011, 04:41:22 PM »

Website | Download
v1.2.1 - 2011-02-11
    + Added 'Run/execute cell contents' to the list context menu.  This will
      attempt to run/execute text of the cell you right-clicked on to bring up
      the context menu.  You can also hover over a cell and use the Ctrl-R
      hotkey.
    + To copy a cell's contents, you can now simply hover over a cell and use
      the Ctrl-Shift-C hotkey.
Logged

skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #111 on: February 12, 2011, 01:28:34 PM »

Website | Download
v1.2.2 - 2011-02-12
    ! Add/Update/Insert & Options dialogs should now always come up on top of
      the main Snap DB interface instead of centered on the main monitor.
Logged

skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #112 on: February 13, 2011, 11:59:21 PM »

Website | Download
v1.2.3 - 2011-02-14
    ! 'Copy column data' option didn't always copy all the column's data.
Logged

skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #113 on: March 24, 2011, 01:43:16 AM »

Website | Download
v1.2.4 - 2011-03-16
    ! Alt-tab icon was pixelated when using the Unicode build.

v1.2.5 - 2011-03-24
    + Added simple Find/Replace functionality.  Access it via the Edit menu, the
      toolbar button or the Ctrl-H hotkey.  (Thanks, ApathyS)
Logged

kfitting
Charter Member
***
Posts: 574


View Profile Give some DonationCredits to this forum member
« Reply #114 on: March 24, 2011, 09:16:59 AM »

One thing I have done in the past to get around the multiline issue is to use a textbox for a given field... obviously this opens just a bunch more questions.  In my case I only had one multiline field, and I only needed to see one record's field at a time. 

Assuming these requirements are met, you could have a textbox that displays "multiline field X" for the selected record.


(For those wondering, I was replicating a "task manager" type tool with excel (as my task list) and word (as my task note/comment) using VBA to bridge the gap.  Yes there are many tools that do this type of thing (TodoList) and yes it's painful... and yes computer security rules at work suck.)
Logged
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #115 on: March 24, 2011, 10:07:51 AM »

Thanks for the feedback, kfitting; I appreciate it.

I actually have written a set of functions that "encode" and "decode" multiline blocks of text for storage in and reading back of an INI file for some other apps of mine.  Snap DB's file format is much like an INI in that each record is stored on a single line.  However, I decided not to do multiline records because I feel it would take away from Snap DB's simple, elegant (IMHO) interface.  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).
Logged

kfitting
Charter Member
***
Posts: 574


View Profile Give some DonationCredits to this forum member
« Reply #116 on: March 24, 2011, 10:55:47 AM »

Understood!  If a user really need multiline maybe excel is the better choice.
Logged
Stoic Joker
Honorary Member
**
Posts: 5,449



View Profile WWW Give some DonationCredits to this forum member
« Reply #117 on: March 24, 2011, 11:27:04 AM »

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

There is the option to anchor an edit control window to the listview cell, that can be triggered (by double click or something) to open & display the full text, and then auto close when it looses focus. That way you can keep the clean single line view and still be able to peek at larger blocks of text as/if needed.
Logged
timn
Supporting Member
**
Posts: 5


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #118 on: March 28, 2011, 03:00:54 PM »

Skwire, thanks for your excellent program, I can see many uses.
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.
Logged
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #119 on: March 28, 2011, 03:49:20 PM »

Skwire, thanks for your excellent program, I can see many uses.

You're welcome and welcome to DonationCoder.   smiley

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.

  • Can do.  Added to the ToDo list.
  • 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.
  • I'll add these to the ToDo list as well.

Thanks for the feedback.   smiley
Logged

timn
Supporting Member
**
Posts: 5


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #120 on: March 30, 2011, 07:14:31 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.
Re 2, yes I have used 'Edit > Convert row to header' several times. I am using SnapDB to publish tables from an SQLite database because it is much easier to use. I havent attempted to load multiple CSV files. Your solution sounds good.
Further use has suggested another possible enhancement:
Numeric fields with different lengths don't sort as I expect. eg 2000 appears before 300 for an ascending sort.
It would be good if SnapDB could somehow recognise a numeric only column and sort it by numeric value.
If the data comes via a delimited file then digits only and no enclosing quotes could possibly be used to indicate numeric.
Logged
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #121 on: March 31, 2011, 03:47:04 AM »

Here you go, timn.  Minimal testing in this build so do your worst.  =]  I'll try to get the CSV header issue done in a future build.

Website | Download
v1.2.8 - 2011-03-31
    + Snap DB now tries to determine whether a column is numeric so it will sort
      properly.  The logic is as follows:
        # A column with strictly integers will sort as integer.
        # A column with strictly floats will sort as float.
        # A column with both integers and floats will sort as float.
        # A column with ANY non-numeric text will sort as logical text.
    + Added the following filter types:
        # Does NOT contain
        # Does NOT equal
        # Greater than
        # Greater than or equal to
        # Less than
        # Less than or equal to
        # Regular expression
        (Thanks, timn)
    * Filter text is re-used when enabling the filter.  (Thanks, timn)
« Last Edit: March 31, 2011, 03:49:14 AM by skwire » Logged

skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #122 on: April 15, 2011, 11:44:17 PM »

Website | Download
v1.3.0 - 2011-04-15
    ! Minor statusbar change.

v1.2.9 - 2011-04-07

    ! Duplicate and Edit record functions were erroneously available while in
      filter mode.
Logged

TalksToPCs
Supporting Member
**
Posts: 21

View Profile Give some DonationCredits to this forum member
« Reply #123 on: September 21, 2011, 09:26:22 AM »

Just in case anybody wondered if SnapDB can be used on a mac: Yet it can, with Crossover.
Works quite nicely with a few minor bugs, but perfectly usable.
Logged
skwire
Global Moderator
*****
Posts: 4,180



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #124 on: September 21, 2011, 09:29:15 AM »

Good to know.  Thanks, TalksToPCs.
Logged

Pages: Prev 1 2 3 4 [5] 6 7 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.056s | Server load: 0.15 ]