Puppy Personal Database

A home for all kinds of Puppy related projects
Message
Author
User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

Puppy Personal Database

#1 Post by gposil »

With prompting from Lobster i'm working on a small personal database app for inclusion in Puppy, which is nearing completion, but I thought you'd like to have a look at a Personal Database where size is not a consideration...

It uses xBase tables and with very little extra can be converted from flatfile to full Relational status using dBase, Foxpro or Paradox database tables.

Just thought you'd like a look

updated June 18 2009 v 0.6b...Custom Database creation/viewing and editing.
Attachments
ppdb-0.5b.jpg
Screenshot
(106.6 KiB) Downloaded 1402 times
Last edited by gposil on Thu 18 Jun 2009, 05:15, edited 10 times in total.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
WhoDo
Posts: 4428
Joined: Wed 12 Jul 2006, 01:58
Location: Lake Macquarie NSW Australia

Re: Puppy Personal Database

#2 Post by WhoDo »

gposil wrote:With prompting from Lobster i'm working on a small personal database app for inclusion in Puppy, which is nearing completion, but I thought you'd like to have a look at a Personal Database where size is not a consideration...

It uses xBase tables and with very little extra can be converted from flatfile to full Relational status using dBase, Foxpro or Paradox database tables.

Just thought you'd like a look
WOW! Now this is something we've needed for a long, long time, Guy! We've had a lash at Tksqlite, portabase and I've even flirted with compiling Glom (a nightmare, believe me)! Most of those who need a database have had to load OOO or K-office to get sbase or kexi! And then you come along with this little gem! What can I say but ... thank you, thank you, THANK YOU! :P
[i]Actions speak louder than words ... and they usually work when words don't![/i]
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

User avatar
James C
Posts: 6618
Joined: Thu 26 Mar 2009, 05:12
Location: Kentucky

#3 Post by James C »

Just installed to my Woof alpha 7 installation.Installed without a hitch.

Looks like a pretty handy app......

Great job!!!

User avatar
Eyes-Only
Posts: 1043
Joined: Thu 10 Aug 2006, 06:32
Location: La Confederation Abenaquaise

#4 Post by Eyes-Only »

.
Last edited by Eyes-Only on Thu 12 Nov 2009, 18:41, edited 1 time in total.
*~*~*~*~*~*
Proud user of LXpup and 3-Headed Dog. 8)
*~*~*~*~*~*

davec51
Posts: 530
Joined: Thu 13 Apr 2006, 22:31
Location: Virginia

Database-Can't Type

#5 Post by davec51 »

MacpupFoxy 4.2.1: I installed the pet, the blank form comes up, but I can't type anything on it. Am I missing a dependency or something?

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#6 Post by gposil »

Two answers:

Eyes-Only said
Are those perhaps viable ideas that could likely be somehow incorporated into your programme? Just curious of course. -scratches chin-
Already done in update to come out today...keep watching...

davec51 said
MacpupFoxy 4.2.1: I installed the pet, the blank form comes up, but I can't type anything on it. Am I missing a dependency or something?
Try using menu choice to create New... database or Open... to view existing. Let me know...
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

Update

#7 Post by gposil »

See top of thread for latest version...

Changes...
1.) Now has database search facility.
2.) Pack table function...removes deleted records and re-indexes database.
3.) Buttons to email contact or visit their website if applicable.
4.) Print Preview will allow you to save report as PDF or HTML

A comprehensive help file will be included in next version..
NB. When you do a search remember to turn off database filtering when you are finished...In search menu.

The search facility will allow you to not only find single records but all records that match search criteria. eg Find all records in a particular Town or Postcode. The print facility will also obey what filter is set.

Any suggestions...please let me know
.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
WhoDo
Posts: 4428
Joined: Wed 12 Jul 2006, 01:58
Location: Lake Macquarie NSW Australia

Re: Update

#8 Post by WhoDo »

gposil wrote:2.) Pack table function...removes deleted records and re-indexes database.
Looking good, Guy. Tried on the latest Puppy-4.2.1 and it seems to run fine with one minor exception. I created a new record (ok), edited the record (ok), added an image (ok) then deleted the record (ok). Only problem is that the sample file now shows 3 records, including the deleted one, and pack table is greyed out so I can't compress the file to remove the deleted record.

Hope the feedback helps. This is a most worthwhile project and should find its way into the standard Puppy release IMHO.
[i]Actions speak louder than words ... and they usually work when words don't![/i]
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#9 Post by gposil »

Close database and Pack selection will be available in Tools menu... :)
The help system is nearly finished, it uses dillo as the reader so no extra bloat.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
WhoDo
Posts: 4428
Joined: Wed 12 Jul 2006, 01:58
Location: Lake Macquarie NSW Australia

#10 Post by WhoDo »

gposil wrote:Close database and Pack selection will be available in Tools menu... :)
The help system is nearly finished, it uses dillo as the reader so no extra bloat.
Could it be made to use Gtkmoz? Reason is that 4.2 doesn't include Dillo but does include Gtkmoz as the base html reader. That's what menu>utility>man uses, for example, to display man pages from the web.

Makes sense to have the file closed in order to pack it. I should have recognised that from my years playing with FileMaker Pro (my favourite database of all time bar none)!
[i]Actions speak louder than words ... and they usually work when words don't![/i]
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#11 Post by gposil »

Whodo said
Could it be made to use Gtkmoz? Reason is that 4.2 doesn't include Dillo but does include Gtkmoz as the base html reader. That's what menu>utility>man uses, for example, to display man pages from the web.
Certainly...no problem
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

tlchost
Posts: 2057
Joined: Sun 05 Aug 2007, 23:26
Location: Baltimore, Maryland USA
Contact:

Re: Puppy Personal Database

#12 Post by tlchost »

gposil wrote:With prompting from Lobster i'm working on a small personal database app for inclusion in Puppy
Interesting.....I installed it on ChoicePup and noticed that while I can navigate through the fields with the mouse, I can not enter any data from the keyboard. I am using a usb mouse....it works fine with other applications.

Thom

User avatar
WhoDo
Posts: 4428
Joined: Wed 12 Jul 2006, 01:58
Location: Lake Macquarie NSW Australia

Re: Puppy Personal Database

#13 Post by WhoDo »

tlchost wrote:
gposil wrote:With prompting from Lobster i'm working on a small personal database app for inclusion in Puppy
Interesting.....I installed it on ChoicePup and noticed that while I can navigate through the fields with the mouse, I can not enter any data from the keyboard. I am using a usb mouse....it works fine with other applications.
Did you use the sample database? Or did you create your own database file first? I'm using a USB mouse too, with no problem in entering data.

I've been entering data, deleting data etc without problems. That said, I notice the tab order isn't set for the input fields so hitting Tab takes you about 5 fields away and hitting Tab again will bring you back 3 fields (for example).

@gposil - can we have a Save button? I'm not sure "Post" is intuitive for the average user.
[i]Actions speak louder than words ... and they usually work when words don't![/i]
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

User avatar
trapster
Posts: 2117
Joined: Mon 28 Nov 2005, 23:14
Location: Maine, USA
Contact:

#14 Post by trapster »

gposil wrote:Whodo said
Could it be made to use Gtkmoz? Reason is that 4.2 doesn't include Dillo but does include Gtkmoz as the base html reader. That's what menu>utility>man uses, for example, to display man pages from the web.
Certainly...no problem
maybe use /usr/local/bin/defaulthtmlviewer to make it more universal between puppy versions?
trapster
Maine, USA

Asus eeepc 1005HA PU1X-BK
Frugal install: Slacko
Currently using full install: DebianDog

User avatar
WhoDo
Posts: 4428
Joined: Wed 12 Jul 2006, 01:58
Location: Lake Macquarie NSW Australia

#15 Post by WhoDo »

trapster wrote:maybe use /usr/local/bin/defaulthtmlviewer to make it more universal between puppy versions?
Absolutely. Should have suggested that myself. Thanks, Trapster. :idea:
[i]Actions speak louder than words ... and they usually work when words don't![/i]
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

tlchost
Posts: 2057
Joined: Sun 05 Aug 2007, 23:26
Location: Baltimore, Maryland USA
Contact:

Re: Puppy Personal Database

#16 Post by tlchost »

WhoDo wrote: Did you use the sample database? Or did you create your own database file first? I'm using a USB mouse too, with no problem in entering data.
Dummy me....I had not selected either database....so it might be good for braindead folks like me to have selections greyed out until a database has been selected.

I used to be a beta tester for Ashton-Tate(now you can guess my age)....and learned a lot about databases.

This app is great, since it uses the dbf format...the data is portable. Now, the next step in my mind would be being able to modify the fields(number and names) and modify the screen layout.

The fact that you can specify the location of the database file is a real plus....I use a bootable USB drive....so I try to save as much as I can outside the puppysave file.

Once the application is finalized...it would be nice to have it as an sfs file.

It's really nice to see an application that works and is practical!

For consideration:
I remember some applications that Ashton-Tate developers created to allow you to paint a screen and the application would not only create the database fields...but also create the code. I still have one of them and use it for quick database creation.

Thom
Last edited by tlchost on Sun 17 May 2009, 13:10, edited 1 time in total.

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

#17 Post by gposil »

1.)The defaulthtmlviewer will be set..yes
2.)Tab order fixed..yes
3.) Form painter on the cards...I used to use dBaseIII ...I remember(shows my age)
4.)Selections grayed till database opens...done

I should have these changes(excluding form painter) done by tomorrow as well as help file...

Keep those suggestions rolling in.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

davec51
Posts: 530
Joined: Thu 13 Apr 2006, 22:31
Location: Virginia

Can't Type in Form -- SOLVED!

#18 Post by davec51 »

My problem was solved by making a new file. Thanks for the help.

tlchost
Posts: 2057
Joined: Sun 05 Aug 2007, 23:26
Location: Baltimore, Maryland USA
Contact:

#19 Post by tlchost »

gposil wrote: 3.) Form painter on the cards...I used to use dBaseIII ...I remember(shows my age)
We can start the Puppy for Ancient Ones thread

User avatar
gposil
Posts: 1300
Joined: Mon 06 Apr 2009, 10:00
Location: Stanthorpe (The Granite Belt), QLD, Australia
Contact:

Version 0.3a

#20 Post by gposil »

Latest version 0.3a at top of thread...

Changes:
1.) Help file opens in default system viewer
2.) Input fields active only when new or existing database are opened
3.) Substituted Save for Post
4.) Tab order now correct.

Keep those suggestions coming...if anyone wants to help with help file or translations, let me know
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

Post Reply