Welcome Guest.   Make a donation to an author on the site April 17, 2014, 07:35:11 AM  *

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.
 
View the new Member Awards and Badges page.
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: Customize Snap DB?  (Read 1269 times)
garyreif
Participant
*
Posts: 4


View Profile Give some DonationCredits to this forum member
« on: July 12, 2012, 02:07:59 PM »

Is it possible to customize snap DB (hopefully here!) to the extent to removing or disabling  certain commands,(or at least add a yes/no confirmation)  such as:

DEL record
Convert Row data to header names
Find/replace

I think I need a little protection of existing data from some of the users.  An undo command would be nice too.
Thanks!
Logged
skwire
Charter Member
***
Posts: 3,897



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #1 on: July 12, 2012, 03:27:52 PM »

With the exception of the undo request, the others are certainly doable.  Did you happen to read my reply to your original post, though?

http://www.donationcoder....31594.msg293486#msg293486
Logged

garyreif
Participant
*
Posts: 4


View Profile Give some DonationCredits to this forum member
« Reply #2 on: July 13, 2012, 07:34:15 AM »

Yes, I saw your reply  to my original post:



1) I've tested it with around 80,000 records but, as the number of records grows, it's slower to load the file.  The largest database that I, personally, use it with has a few thousand records.
***** I will probably use it for less than 10,000 records, so this is good.
2/3) Sure, a single user could store the files on a network share (I do that with mine).  That said, I wouldn't recommend using it simultaneously in a shared environment as Snap DB is not multi-user aware whatsoever
***** We use Excel right now (setup as one tab per part number, which is really not working, as we add a lot of new part numbers), which does lock  the file so a second user gets read only mode. But SnapDB is so much simpler and has better search and data entry I would like to use it if possible.

A quick check did not show any bad results from 2 users accessing at the same time. If they both were on the same record, the last one 2 save or change seems to be the one that had the data recorded his way. It is unlikely my users would be on the same record.

Any suspected problems I need to test for in using with multiple users on a network?
Any chance of using some simple form of file locking (of the database file on the server) which starts for the first user to open the file?

Thanks!
Logged
skwire
Charter Member
***
Posts: 3,897



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: July 13, 2012, 09:22:30 AM »

***** I will probably use it for less than 10,000 records, so this is good.

You should be fine with this number of records.

A quick check did not show any bad results from 2 users accessing at the same time. If they both were on the same record, the last one 2 save or change seems to be the one that had the data recorded his way.  It is unlikely my users would be on the same record.

Keep in mind that Snap DB doesn't have any concept of saving individual records, i.e., it's a single flat file.  That single SNP file gets written, in full, each time you save it.  You have to think of this like two people having the same text file open.  Both can open the file and make independent changes but the last person to save will overwrite any and all changes made previously by either person.  Does that make sense?

Any suspected problems I need to test for in using with multiple users on a network?

Yes, what I just described above.

Any chance of using some simple form of file locking (of the database file on the server) which starts for the first user to open the file?

No, since I feel that's out of design scope for this app.  I didn't design it, at all, with the idea of supporting multiple users.

If I seem unreceptive to the idea of your multiple-user scenario, I apologise.  I'm just trying to let you know that you're going to run into trouble if you allow multiple users to modify an SNP file at the same time.  If you simply plan to allow multiple users to use the database for lookups, that is, no modifications, you should be okay.
Logged

Ath
Supporting Member
**
Posts: 2,131



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #4 on: July 13, 2012, 09:54:21 AM »

If I can throw in a suggestion: Have a look at Data Crow, that's for keeping 'collections' with a lot of bells and whistles, but would be a fine candidate here, imho.
Logged

skwire
Charter Member
***
Posts: 3,897



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: July 13, 2012, 10:06:37 AM »

Data Crow is a really well done application.  I use it as well.   Thmbsup
Logged

garyreif
Participant
*
Posts: 4


View Profile Give some DonationCredits to this forum member
« Reply #6 on: July 13, 2012, 12:15:08 PM »

Thanks, I will take a closer look at Datacrow. My hope was originally of finding a modern version of old PC-File which was just complex enough to do most things. Upon more thinking another option is to go with one Word doc per part number, and all the PN docs in one folder.
Logged
Ath
Supporting Member
**
Posts: 2,131



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #7 on: July 13, 2012, 01:28:36 PM »

Upon more thinking another option is to go with one Word doc per part number, and all the PN docs in one folder.
Then Data Crow or any other database management tool (even MS Access undecided) is definitely a better solution!
Logged

Pages: [1]   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.031s | Server load: 0.09 ]