Puppy Personal Database
Thanks so much.gposil wrote:The default dbf format is Visual dBaseVII but next version will have the ability to choose your format as either dBaseIII+, dBaseIV, Visual dBaseVII or Foxpro.
Does it "auto remember" the path to the most recently used file, or do we need to tell it to use that? Would it be possible to specify the default path?
Thom
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Just a question
Do we want this to grow into a full blown free form database creator/editor or should the RDBMS be a separate project.
[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:
RDBMS = Relational database management system
(had to look it up)
More interested in the smaller version of the Database
Will it be as good as this one? Hope so
My instinct is to stick with simplicity (Puppy Powered after all . . .)
but I have only used one relational database extensively (Access)
I found it extraordinary how easy it was to mess
and mash data when confronted by that bug that no developer can
seem to get rid of (the end user)
Be interesting how others advise you.
I know those needing a database are very pleased with your contribution, as I am.
(had to look it up)
More interested in the smaller version of the Database
Will it be as good as this one? Hope so
My instinct is to stick with simplicity (Puppy Powered after all . . .)
but I have only used one relational database extensively (Access)
I found it extraordinary how easy it was to mess
and mash data when confronted by that bug that no developer can
seem to get rid of (the end user)
Be interesting how others advise you.
I know those needing a database are very pleased with your contribution, as I am.
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
Version 0.4a
Latest version 0.4a posted at top of thread.
Changes
1.) Export open database to a number of formats including Excel/OO/Gnumeric csv file, Latex, M$ rtf (yes Abiword will read it), XML and SQL.
2.) Working online update in Help menu.
Remember if you want PDF or HTML output you can do that at the Print Preview Screen...
Changes
1.) Export open database to a number of formats including Excel/OO/Gnumeric csv file, Latex, M$ rtf (yes Abiword will read it), XML and SQL.
2.) Working online update in Help menu.
Remember if you want PDF or HTML output you can do that at the Print Preview Screen...
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
Re: Just a question
I think you need both versions....for many, the simple one you have will fit the bill. There are others, like myself, that would really appreciate and use an RDBMS,gposil wrote:Do we want this to grow into a full blown free form database creator/editor or should the RDBMS be a separate project.
You might consider making the RDBMS an sfs file, so as not to bloat.
Thom
- gposil
- Posts: 1300
- Joined: Mon 06 Apr 2009, 10:00
- Location: Stanthorpe (The Granite Belt), QLD, Australia
- Contact:
tlchost said
Why didn't I think of that...the RDBMS will be a separate app and I will sfs it. That should make everyone happy, and for those that have hdd install they can convert sfs to pet and install...You might consider making the RDBMS an sfs file, so as not to bloat.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]
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!