Puppy Personal Database
Is this strictly a contacts database at this point or can I make my own fields?
I've been using OObase, but I would be interested in this project since OO is so large. But I would need to be able to design my own tables.
Related tables with subforms would really be beneficial, but I suppose that will be more in line with the RDBMS project.
I've been using OObase, but I would be interested in this project since OO is so large. But I would need to be able to design my own tables.
Related tables with subforms would really be beneficial, but I suppose that will be more in line with the RDBMS project.
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
hillside said
There will be an option in upcoming version to create and view/edit your own tables...flatfile only...table linking will be part of RDBMS.Is this strictly a contacts database at this point or can I make my own fields?
[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:
I was interested in one point at writing a database - tried a whole week of experiments in Javascript, XUL, C and Genie and Bash and realised I was not up to the task.
You seem to be doing OK - so in case it is of any use I enclose the graphic from those efforts
You seem to be doing OK - so in case it is of any use I enclose the graphic from those efforts
- Attachments
-
- pdblogo.jpg
- (11.69 KiB) Downloaded 1035 times
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Lobster
I love it...i'll use it as splash screen...BTW ppdblite is coming along nicely should have something to show you soon, and big brother ppdb will be able to import ppdblite databases for more advanced manipulation if required.
I love it...i'll use it as splash screen...BTW ppdblite is coming along nicely should have something to show you soon, and big brother ppdb will be able to import ppdblite databases for more advanced manipulation if required.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
Very GOOD
Good Morning:
Just ran into this thread... This looks great and promising!
Lots of questions.
First and foremost SORTING? Are their plans to sort the data for reports?
Please add to search options "Any Field".
If search returns with no selected records.. not obvious what to do with blank screen. No back buttons or similar directions on how to get back to initial screen.
Inserting or adding new records.
1) Not obvious that Insert means ADD new Records.
2) Once Insert is pressed cursor should start at the "Title Box" ready for input.
3) When inserting a new record Most of the data automatically fills in at the top... except the TITLE. That waits for a save.
Open the test database... .and I was able to change the First Name... when I did so... at the TOP pane. Doing so eliminated "Alfred"... never to be seen again.... unless I reloaded backup.....
More as we progress... LOOKING GOOD.. .KEEP up the good work!
Any way to change the format?
Just ran into this thread... This looks great and promising!
Lots of questions.
First and foremost SORTING? Are their plans to sort the data for reports?
Please add to search options "Any Field".
If search returns with no selected records.. not obvious what to do with blank screen. No back buttons or similar directions on how to get back to initial screen.
Inserting or adding new records.
1) Not obvious that Insert means ADD new Records.
2) Once Insert is pressed cursor should start at the "Title Box" ready for input.
3) When inserting a new record Most of the data automatically fills in at the top... except the TITLE. That waits for a save.
Open the test database... .and I was able to change the First Name... when I did so... at the TOP pane. Doing so eliminated "Alfred"... never to be seen again.... unless I reloaded backup.....
More as we progress... LOOKING GOOD.. .KEEP up the good work!
Any way to change the format?
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Hello Minnesota
To answer your questions:
1.) Sorting for reports will be available
2.) Search on any field will be available
3.) No record found message box will be instituted
4.) Insert/add new records problem already in 0.5a(not released yet)
5.) Title problem you mentioned is already fixed in 0.5a
6.) Wasn't able to duplicate your disappearing "Alfred" problem will look at it.
7.) With regards to format...there is already custom format being worked on for future release.
Please add any suggestions...
To answer your questions:
1.) Sorting for reports will be available
2.) Search on any field will be available
3.) No record found message box will be instituted
4.) Insert/add new records problem already in 0.5a(not released yet)
5.) Title problem you mentioned is already fixed in 0.5a
6.) Wasn't able to duplicate your disappearing "Alfred" problem will look at it.
7.) With regards to format...there is already custom format being worked on for future release.
Please add any suggestions...
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
Update top Pane
Am I supposed to be able to update the top display pane. It is OK, not a real problem..if it is by design.. it gives an easier way to update...
Are their plans for a Ctrl-z UNDO? In any way? If you make a mistake.. or accidentally hit a key in a field.. the field previous data is gone.
At least at the top pane.
Are their plans for a Ctrl-z UNDO? In any way? If you make a mistake.. or accidentally hit a key in a field.. the field previous data is gone.
At least at the top pane.
- Attachments
-
- Database change top pane.jpg
- (30.94 KiB) Downloaded 516 times
Version 0.5a
Looking forward to Version five. Sounds like a big update. Any time frame for when you will release it? Keep up the good work.From version 0.5a onwards, the top pane will be read only by default...but you will have the option to open it to writing...A Ctrl-z feature will be included.
Re: Just a question
OMG YES YES YES! Ever tried to work with OOBase? Nightmaregposil wrote:Do we want this to grow into a full blown free form database creator/editor or should the RDBMS be a separate project.
Spup Frugal HD and USB
Root forever!
Root forever!
- 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.