(old)Puppy Linux Discussion Forum

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.

Thanks for this one, which I've just downloaded. I'm pretty happy with Portabase (covered elsewhere) as my needs for a database are quite modest and Portabase does everything I want, but I'll give it a try soon.

Like the avatar btw.

Version 0.5a posted at top of thread...bug fixes and the start of custom database creator...getting there...

gposil wrote:first release soon, and should be under 50k in size.

Woof might have a database
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?

start of custom database creator

had a look at this
tried the creator (not working yet?) totally obvious and straightforward
in layout
Good to see my graphic made it

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

Greg said

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.

Shows you the difference between programmers and real people...hitting random keys(from Previous post)...who'd have thought...
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

finally personal databases for pc...

one more feature needed --- > birthday record and option to auto remind it, perhaps link it with pschedule, at command or crontab... ?

interesting, I haven't seen anything like this

Master_wrong said

one more feature needed --- > birthday record and option to auto remind it, perhaps link it with pschedule, at command or crontab... ?

Yes birthday record and pschedule link will be in upcoming version.

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

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
_

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!

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.

tlchost said

Is it possible/can it be done to set the default path of the database?

Yes, version 0.6(not released yet) already has the setting available in Options/Preferences menu.

Minnesota said

what can't go wrong and what WILL STILL GO WRONG! ERROR checking is one half of a program.

Hit the nail on the head...maybe it's 75% of development time...

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....

))

Minnesota, I have tried to duplicate the problem you're having but can't, could you give me a blow by blow so I can see what's happening.

Thanks

Guy

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.

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.

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.

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.

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?

Minnesota said

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...

gposil wrote: Yes the validity checking is somewhat problematic.

One could call a rule for postal code and phone after the country is selected.

Of course the rule set could live in a seperate database.