Puppy Personal Database
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
ppdblite
Just thought i'd give you an update on the Lite version of ppdb...here's a screenshot...first release soon, and should be under 50k in size.
- Attachments
-
- ppdblite.jpg
- Screenshot
- (47.9 KiB) Downloaded 675 times
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
- Colonel Panic
- Posts: 2171
- Joined: Sat 16 Sep 2006, 11:09
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Update
Version 0.5a posted at top of thread...bug fixes and the start of custom database creator...getting there...
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
- Lobster
- Official Crustacean
- Posts: 15522
- Joined: Wed 04 May 2005, 06:06
- Location: Paradox Realm
- Contact:
Re: ppdblite
Woof might have a databasegposil wrote:first release soon, and should be under 50k in size.
Woof! Woof! - sounds and looks ideal for Puppy 5
Be aware that the early netbooks have a small screen size - maybe a toggle button for the images field?
had a look at thisstart of custom database creator
tried the creator (not working yet?) totally obvious and straightforward
in layout
Good to see my graphic made it
testing databae ppdb-0.5.pet
Help.. cursor in top section... had two original records in old data base... put cursor I think in second field to see if I could modify.. at the top section... hit random keys.. and blew out the two records.. record count stayed... but current record indicator went to negative number... so something blew big time. Prior, next, first.. nothing will show old records.
Adding (insert) additional records start at three... so record count saved.. but impossible to get back to old records... reloading from open put me at count two... no data.. so you must be updating the disk file immediately...live?
From a standpoint of operator cursor movement... once you Insert a NEW record... and complete the input of date... YOU must stop your data entry.. get the mouse and move to the TOP to save the record.. extremely inconvenient... a data entry operator would have your hide...
Cursor needs to move to the save button....preferably on the input portion of the screen.
Of course once you save.. cursor should go back to first field for next record input.
Questions... you can enter any data in the phone fields.. indicate there is not any error checking for data type? Correct? Same for fax or mobile..
IS a spelling checker in the works?
Tried to create a database from scratch... took db name, took file location... tried to enter a field, took name and type then... nothing.. tried to save db.. nothing...
Will continue to test.
Greg
Adding (insert) additional records start at three... so record count saved.. but impossible to get back to old records... reloading from open put me at count two... no data.. so you must be updating the disk file immediately...live?
From a standpoint of operator cursor movement... once you Insert a NEW record... and complete the input of date... YOU must stop your data entry.. get the mouse and move to the TOP to save the record.. extremely inconvenient... a data entry operator would have your hide...
Cursor needs to move to the save button....preferably on the input portion of the screen.
Of course once you save.. cursor should go back to first field for next record input.
Questions... you can enter any data in the phone fields.. indicate there is not any error checking for data type? Correct? Same for fax or mobile..
IS a spelling checker in the works?
Tried to create a database from scratch... took db name, took file location... tried to enter a field, took name and type then... nothing.. tried to save db.. nothing...
Will continue to test.
Greg
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Programmers aren't real people
Greg said
It's great you're testing it Greg and the feed back speeds up ironing out bugs. The random keys effect has to do with key combinations equaling delete record (Ctrl+d etc)...the simple fix will be rollback, coming in 0.5b
Shows you the difference between programmers and real people...hitting random keys(from Previous post)...who'd have thought...Help.. cursor in top section... had two original records in old data base... put cursor I think in second field to see if I could modify.. at the top section... hit random keys.. and blew out the two records.. record count stayed... but current record indicator went to negative number... so something blew big time. Prior, next, first.. nothing will show old records.
It's great you're testing it Greg and the feed back speeds up ironing out bugs. The random keys effect has to do with key combinations equaling delete record (Ctrl+d etc)...the simple fix will be rollback, coming in 0.5b
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
-
- Posts: 452
- Joined: Thu 20 Mar 2008, 01:48
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Master_wrong said
Yes birthday record and pschedule link will be in upcoming version.one more feature needed --- > birthday record and option to auto remind it, perhaps link it with pschedule, at command or crontab... ?
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
File Location
Is it possible/can it be done to set the default path of the database?
I use ChoicePup and have 3 savefiles.... one for day to day use, one for web development and one for testing. Rather than install the program and data in each of the versions, I would like to have it on my usb drive.
I've tested it, works fine on /mnt/home I'd like to tell the program to always look on /mnt/home/ppdb for the data files. Not only will it save space in the save files, but I can access the database(s) from windows when not running ChoicePup.
Thanks
Thom
I use ChoicePup and have 3 savefiles.... one for day to day use, one for web development and one for testing. Rather than install the program and data in each of the versions, I would like to have it on my usb drive.
I've tested it, works fine on /mnt/home I'd like to tell the program to always look on /mnt/home/ppdb for the data files. Not only will it save space in the save files, but I can access the database(s) from windows when not running ChoicePup.
Thanks
Thom
radom keys
Just for the record.... keys I am certain I hit.. were fasdfasfasfasf.... possibly one row lower...as That is the set I use for entering random data into fields for many years...very fast to put in... Will check again.... Been writing user oriented programs since 1968 ). Operators will do almost anything, trust me!Shows you the difference between programmers and real people...hitting random keys(from Previous post)...who'd have thought... Laughing
It's great you're testing it Greg and the feed back speeds up ironing out bugs. The random keys effect has to do with key combinations equaling delete record (Ctrl+d etc)...the simple fix will be rollback, coming in 0.5b
_
Keep up the good work.. it is not easy making a program with complete error checking and all the features. It takes time to figure out what can go wrong, what can't go wrong and what WILL STILL GO WRONG! ERROR checking is one half of a program.
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
tlchost said
Minnesota said
Yes, version 0.6(not released yet) already has the setting available in Options/Preferences menu.Is it possible/can it be done to set the default path of the database?
Minnesota said
Hit the nail on the head...maybe it's 75% of development time...what can't go wrong and what WILL STILL GO WRONG! ERROR checking is one half of a program.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
screen shots of fdadfasfasf
attached base test data base with two records.
second screen... entered afsdfasfasf or fafsfasdf into the name field... and you can see the record count and missing data... oh well....
))
second screen... entered afsdfasfasf or fafsfasdf into the name field... and you can see the record count and missing data... oh well....
))
- Attachments
-
- Entered top with fasfasfasf 5 26 09.jpg
- (28.49 KiB) Downloaded 702 times
-
- test db wtih two records.jpg
- (52.74 KiB) Downloaded 477 times
blow by blow
Brought up old database
It needs to have data.. I first used the original test db yesterday.
Today for the pictures I sent, I used test I had built with ver .4 Blue highlighted box is where I entered the random field data. Might blow on any data? I simply tried entering anything in the field....Just to see if I could still update the top pane. That is all I tried....
Move the cursor to the name field at the TOP window...
Hit a bunch of the home keys... sdfasfasfasfas or asfasfafasfasf or fsdffsafaas.... and it all blew up....Home keys with left hand.
If you still can not duplicate this.... I will try building again from scratch and give it another shot... sending the pieces...
OK?
Just guessing.... Key field.. first field is locked at the top.... second - name field was not... Did not try first address field.. as data was gone... Can build other test DB.. to test other fields if you need me to do so.
It needs to have data.. I first used the original test db yesterday.
Today for the pictures I sent, I used test I had built with ver .4 Blue highlighted box is where I entered the random field data. Might blow on any data? I simply tried entering anything in the field....Just to see if I could still update the top pane. That is all I tried....
Move the cursor to the name field at the TOP window...
Hit a bunch of the home keys... sdfasfasfasfas or asfasfafasfasf or fsdffsafaas.... and it all blew up....Home keys with left hand.
If you still can not duplicate this.... I will try building again from scratch and give it another shot... sending the pieces...
OK?
Just guessing.... Key field.. first field is locked at the top.... second - name field was not... Did not try first address field.. as data was gone... Can build other test DB.. to test other fields if you need me to do so.
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Update
Version 0.5b uploaded...
Major additions and changes:
1.) Grid is now read only
2.) Right click context menu in grid ( See Screenshot)
3.) Ability to see deleted records(in red) or not
4.) Undelete facility(provided you haven't packed the database)
5.) Sort database view on key field (last Name)
6.) Addition of calculator and calendar tools
7.) Preferences now active with default database location etc
8.) Context menu choices for email or WWW on selected record.
Freeform database creation will not be included till version 0.6. Also, for the time being the database view grid will be read only, as a glitch has turned up that cannot be addressed with Puppy's current version of Gtk2+.(This will be addressed, but I see it as no great inconvenience for the time being)
Please keep suggestions coming...
NB. Please uninstall all previous versions prior to install of 0.5b as number of changes will conflict with older versions.
Major additions and changes:
1.) Grid is now read only
2.) Right click context menu in grid ( See Screenshot)
3.) Ability to see deleted records(in red) or not
4.) Undelete facility(provided you haven't packed the database)
5.) Sort database view on key field (last Name)
6.) Addition of calculator and calendar tools
7.) Preferences now active with default database location etc
8.) Context menu choices for email or WWW on selected record.
Freeform database creation will not be included till version 0.6. Also, for the time being the database view grid will be read only, as a glitch has turned up that cannot be addressed with Puppy's current version of Gtk2+.(This will be addressed, but I see it as no great inconvenience for the time being)
Please keep suggestions coming...
NB. Please uninstall all previous versions prior to install of 0.5b as number of changes will conflict with older versions.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
similar problem
Sorry to report.. .but upper gird still open and same problem exists.
See attached.
Questions.
I attempted to Unload the old versions.. I had 0.4 and 0.5 loaded to Puppy 4.10 on a stick... was apparently able to unload .5 but 0.4 would not do a thing... so simply loaded .5b...and tried test. Blew up... so took new CD of 4.2.1 final.. - clean start. as you can see... same issue.
Now of course I can show deleted records... so for some reason top gird is 1) still unlocked... and 2) entering data to the name filed will blow out the db... which is quite interesting actually...
Is there a special method to uninstall a pet.. I have never tried it before.
Also learning more about how to use paint for capture )) with text.
Will test other features. This problem can be fixed later.
Keep with it.
See attached.
Questions.
I attempted to Unload the old versions.. I had 0.4 and 0.5 loaded to Puppy 4.10 on a stick... was apparently able to unload .5 but 0.4 would not do a thing... so simply loaded .5b...and tried test. Blew up... so took new CD of 4.2.1 final.. - clean start. as you can see... same issue.
Now of course I can show deleted records... so for some reason top gird is 1) still unlocked... and 2) entering data to the name filed will blow out the db... which is quite interesting actually...
Is there a special method to uninstall a pet.. I have never tried it before.
Also learning more about how to use paint for capture )) with text.
Will test other features. This problem can be fixed later.
Keep with it.
- Attachments
-
- pb 5b 52709 b.jpg
- (33.1 KiB) Downloaded 630 times
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
To remove pet go to Puppy Package Manager in Setup menu and remove from there.
The only thing I came up with is that the 'd' key is a shortcut to delete record in the grid...I can remove that...but that's it at this stage...remember database records are only really deleted from a table when the database is packed and re-indexed, otherwise they are just hidden in normal view...hence the toggle for show deleted or not.
Keep up the good work...it helps a great deal.
PS. Fixed that keying problem...grid now recognizes no key strokes...will upload fix tomorrow.
The only thing I came up with is that the 'd' key is a shortcut to delete record in the grid...I can remove that...but that's it at this stage...remember database records are only really deleted from a table when the database is packed and re-indexed, otherwise they are just hidden in normal view...hence the toggle for show deleted or not.
Keep up the good work...it helps a great deal.
PS. Fixed that keying problem...grid now recognizes no key strokes...will upload fix tomorrow.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
Thank you
Thank you Sir:
Will keep playing this end .
Any possibility of validity checking the fields.. at least for Alpha verses Numeric? Unless phone numbers have alpha still some locations in the world? Humm... forgot about that... as I think Canada has Alpha in zip?
Will keep playing this end .
Any possibility of validity checking the fields.. at least for Alpha verses Numeric? Unless phone numbers have alpha still some locations in the world? Humm... forgot about that... as I think Canada has Alpha in zip?
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Minnesota said
Yes the validity checking is somewhat problematic...UK also has alpha in zip and a number of country's numerical zips differ in length...The phone numbers are a real problem, the US format just doesn't match anywhere else but I am working on some validity checking...
Any possibility of validity checking the fields.. at least for Alpha verses Numeric? Unless phone numbers have alpha still some locations in the world? Humm... forgot about that... as I think Canada has Alpha in zip?
Yes the validity checking is somewhat problematic...UK also has alpha in zip and a number of country's numerical zips differ in length...The phone numbers are a real problem, the US format just doesn't match anywhere else but I am working on some validity checking...
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]