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:

#91 Post by gposil »

Ok..0.6b is up...a few quick bug fixes to address some issues raised on 0.6a...more to come.

Please test the Custom Databases area....

A question was asked by Minnesota I think...what is the refresh button for...well PPDB was designed as a fully multi user database out of the box, so if someone else on your network is working on the same database as you at the same time, refresh will update your view incorporating any changes made by other users. I have specifically not locked the database, only used record locking...that is only single user can edit a record at a time...if you attempt to change a record that someone else is working on it will give a message to the effect that this record is locked until the other user finishes with it...hope that explains that little feature.

This is a long process, but it will be worth it...5981 lines of code and counting.... :)
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
DaveS
Posts: 3685
Joined: Thu 09 Oct 2008, 16:01
Location: UK

#92 Post by DaveS »

The record lock feature is vital to allow the database to grow. I use a huge database I built in Lotus Approach to run a large Optical Practice. In this situation, we can have several people accessing a single record because the patient is present in the practice and several staff members are updating the record at once, so record lock is vital to prevent data loss.
I have been looking forward to getting to grips with PPD, and it now looks feature rich enough to get to work on. For commercial application, it will need to be relational, but flat form is good for testing.
After switching to Linux, I needed to use OOBase, which is very competent, but a fine example of unintuitive! It took me a couple of months to builsd a reasonable accounting system, and most of that was spent figuring out the damn program. Java base also leads to slow performance.
Spup Frugal HD and USB
Root forever!

Minnesota
Posts: 326
Joined: Thu 11 Sep 2008, 11:25

Questions

#93 Post by Minnesota »

Thanks for information on refresh, when I used it, nothing happened... or appeared to. You clarified.

Attached... first I defined an integer of 26 characters. I don't believe that is a valid integer. No error message. Attempted to enter data... and received an error. As a database may be defined days or weeks before use....wrong time for the error. Considering second example. Field defined for name as ten characters. NO error message when data entered over that number... simply truncation of the field.

MORE important question..... it appears that the define your own data base is a completely different format and "program". What are the plans for it...it should operator exactly the same as the PUPPY version.. same features same reports, same formats... only difference is the data fields are user defined.

Edit:
Forgot... when errors have occurred in several cases the option to CANCEL the operation.. is not really a cancel the operation it is KILL THE PROGRAM.. or exit entirely, requiring a restart from the menu.
Attachments
no truncate Error.jpg
(47.38 KiB) Downloaded 686 times
Inter Define Error.jpg
(70.8 KiB) Downloaded 683 times

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

#94 Post by gposil »

Hi Greg,

Minnesota said:
it appears that the define your own data base is a completely different format and "program". What are the plans for it...it should operator exactly the same as the PUPPY version.. same features same reports, same formats... only difference is the data fields are user defined.
No it's exactly the same procedures...just in an earlier stage of development...quick and dirty for testing with no error checking or field validation as yet...that will come. Yes it will have the same features, in fact more(it has to) than the standard Puppy Personal Database.

BTW: The valid range for integers is -2,147,483,648 to 2,147,483,647. If I decide to go 64bit it will be -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. Oh, if you need numbers larger than integer, floating point can use 50+ significant digits...

The 0.6c release will have range checking and field type validation.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
Lobster
Official Crustacean
Posts: 15522
Joined: Wed 04 May 2005, 06:06
Location: Paradox Realm
Contact:

#95 Post by 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...
Hi Guy and Puppy database aficionados

Barry seems unaware of the smaller database project
http://www.puppylinux.com/blog/?viewDetailed=00845
Is it nearing beta status?
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

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

#96 Post by tlchost »

Lobster wrote: Barry seems unaware of the smaller database project
http://www.puppylinux.com/blog/?viewDetailed=00845
Is it nearing beta status?
It would appear to me that Barry may be missing the boat....this database project brings a new level of practical use to puppy....and it also allows folks to create and use information that can be easily shared between various applications on various OS.

But, my views are jaundiced....I'd rather be productive than tinker.

Oh well.

Thom

User avatar
Colonel Panic
Posts: 2171
Joined: Sat 16 Sep 2006, 11:09

#97 Post by Colonel Panic »

Also, don't forget Portabase, which is a simple program that will meet many people's needs for a flat file database program. WhoDo did sterling work in adapting it for Puppy.
Gigabyte M68MT-52P motherboard, AMD Athlon II X4 630, 5.8 GB of DDR3 RAM and a 250 GB Hitachi hard drive running Ubuntu 16.04.6, MX-19.2, Peppermint 10, PCLinuxOS 20.02, LXLE 18.04.3, Pardus 19.2, exGENT 200119, Bionic Pup 8.0 and Xenial CE 7.5 XL.

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

#98 Post by gposil »

After reflecting on BarryK's comments on PPDB, I have decided to suspend development of the lite version of PPDB in favour of the real DBMS...which will continue, whilst not in Puppy Spirit, it fills a need for a real database management system for Puppy users that don't want to go full blown SQL or OOBase.

BTW...I have ported PPDB over to c++ instead of pascal to see if I could garner any size benefit...yes about 20%...the unupxed binary is reduced in size to about 4.3Mb as opposed to 5.4Mb...but I am not going to get away from the fact that the database engine is roughly 3Mb and whatever front end you put on it is not going to save a great deal...If any one is interested in why I chose to use a real database engine instead of Sqlite or Berkley(BDB), the reasons are manifold, but include such considerations as multi-user and network operability which both Sqlite and BDB have problems with...I will outline the philosophy on an upcoming page on my website....

Thanks for your attention.
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

muggins
Posts: 6724
Joined: Fri 20 Jan 2006, 10:44
Location: hobart

#99 Post by muggins »

Hi gposil,

just curious whether you have a link to BarryK's comments on PPDB, and also what is the real database engine you've decided to use. (Sorry if this is mentioned in previous threads, but I missed this info.)

User avatar
Lobster
Official Crustacean
Posts: 15522
Joined: Wed 04 May 2005, 06:06
Location: Paradox Realm
Contact:

#100 Post by Lobster »

I will outline the philosophy on an upcoming page on my website....
I look forward to that 8)

Barry may be putting this sqlite database manager in Puppy 4.16 which
will be available soon
http://www.puppylinux.com/blog/?viewDetailed=00846

Is it possible/ feasible that the front end (which I rather like)
could still work with sqlite in some future incarnation?

I feel a little sad that we have lost the small DB :cry:
You say suspended - do you feel it may continue later?
I am encouraged by your efforts on the more comprehensive database :)

Any ideas who is able to create a small DB in Genie?
m m m . . . maybe Nicolas has finished tweaking his excellent editor . . .
Last edited by Lobster on Mon 29 Jun 2009, 04:27, edited 1 time in total.
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

User avatar
BarryK
Puppy Master
Posts: 9392
Joined: Mon 09 May 2005, 09:23
Location: Perth, Western Australia
Contact:

#101 Post by BarryK »

Hi guys, I knew that my blog post would stir things up a bit.

I'm an electronic engineer, only know databases fairly superficially, but yes I do understand that multi-user/network usage is an important consideration, and I do recall reading that sqlite has problems in this area.

So, as I said in my blog, I have opted for SqliteManager (probably) for now but am open to being convinced that something bigger yet more capable is well worth it.

Ah yes, I remember where I read about the limitations of Sqlite. The author of Quisp mentioned it. Quisp is very interesting, and it was builtin to Puppy2, but noone took to it. Very easy to create web page frontends.

I did have an issue with compiling it, the author had it setup so the various modules compiled a main library statically, but they could be changed to have a single shared library.

Anyway we have a Quisp v1.28 PET package in the puppy-2 repo on ibiblio. It has a menu entry that brings up a demo web page.

The great thing about Quisp is the very small size.

http://quisp.sourceforge.net/qman/html/quisp_home.html
[url]https://bkhome.org/news/[/url]

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

PPDB Soldiers On....

#102 Post by gposil »

I think I need to answer a few questions that have been posed, Muggins, I haven't made clear at any time what the db engine is apart from the fact that most are aware of the xbase wrappers used for direct dbf interaction. The underlying engine in PPDB is Interbase/Firebird and its full functionality has not been introduced as yet, as PPDB is not ready to go relational-client/server yet...but my plans are that it will...

I agree with Barry that the current stable of Puppy database functionality is fine for small and toy databases...below are a few reasons why I haven't pursued development in that area.

Sqlite.

. No data type integrity or enforcement
. Only handles field types of INTEGER, REAL, TEXT, BLOB
. Not multi-user in any real sense (at best multi-read).
. Cannot record-lock...locks entire database for editing by single user.
. Cannot use multiple integer type primary keys.
. SQLite does not allow the "similar links" switch, fulltext searching or database backup for active databases.
. It does not scale well either.

Berkley(BDB)

. Berkeley DB environments are not portable.
. It does not operate over a network at all.
. No SQL support or any other query language for that matter.
. No data typing.
. No table support

I hope this explains why I haven't used the Puppy tools available. As I said in a previous post PPDB development is ongoing, so for those interested, the feedback is important. I will go into further detail on my website as soon as I finish setting up the blog software.

For what it's worth, those who are interested in simple databases, Barry's addition of the SeaMonkey plugin for Sqlite is a welcome addition...there is a small Qt3 front end to Sqlite3 which is good also, if anyone wants that, I will post it.

Cheers

Guy
[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:

Blog up

#103 Post by gposil »

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

User avatar
Lobster
Official Crustacean
Posts: 15522
Joined: Wed 04 May 2005, 06:06
Location: Paradox Realm
Contact:

#104 Post by Lobster »

Very easy to create web page frontends
:oops: I played with Quisp quite a bit when it was introduced and could not make head nor tails of it . . .
Never came across anyone who ever used it.
there is a small Qt3 front end to Sqlite3 which is good also, if anyone wants that, I will post it
Would like to look at that

This is my position on databases:
I would like one in Puppy.

Perhaps an analogy
I tend to download and use XaraLX
but when on occasion I am testing or using Puppy and need a structured drawing package Inkscape lite will allow that - it comes as a Puppy standard,
saves in SVG, that I can load into XaraLX when available . . .

If I create a database in Openoffice or the developing Puppy dbase and save it in a format that can be read from any Puppy, that would be fine.

Creation of data is one thing
but accessing that data is also important

I am looking forward to 4.16 and the new sql database (I went to the plug in site but it would not install - but Barry has tweaked it)

Just about to check the blog :)

Thanks guys :)
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

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

#105 Post by gposil »

Lobster, here is the Sqlite front end I was talking about...

I think devx is required if you want to create databases...I always install devx anyway
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
Lobster
Official Crustacean
Posts: 15522
Joined: Wed 04 May 2005, 06:06
Location: Paradox Realm
Contact:

#106 Post by Lobster »

Many thanks

Code: Select all

# sqlitebrowser
sqlitebrowser: error while loading shared libraries: libqt-mt.so.3: cannot open shared object file: No such file or directory
# 
that lib is not in the Puppy 4.15 package manager
Will look for it after using 'my personal trainer' on the Wii
I will be doing the yoga workout
- yep enlightenment from Nintendo - Pizzasgood would be proud . . . 8)
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

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

#107 Post by gposil »

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

User avatar
charlie6
Posts: 1230
Joined: Mon 30 Jun 2008, 04:03
Location: Saint-Gérard / Walloon part of Belgium

#108 Post by charlie6 »

Hi gposil,
Yeehh!
Have browsed and looked around (tksqlite, sqlitemanager, sqlitedbms...) to find a simple database GUI...this one looks great ! Many thanks to you!
Just point out that accentuated characters are else rendered.... "@©" for "é" in column titles ...yes...! in records a "dotted squre" for "é".

Editing a table/edit fied:
field 'col_1' can be renamed as 'name'...apply and it is done;
if afterwards I again want to rename 'name', when doing Apply, I get an error message telling: see screenshot hereunder.
Maybe did I a wrong manipulation?

If not, hope this could be fixed in a next ppdb version ..?

cheers
charlie
Attachments
edit.png
edit table/edit field
(18.42 KiB) Downloaded 1033 times

Pelo

ah enfin ! what i was looking for !

#109 Post by Pelo »

Merci. I look at it deeper. But sure it's what i want. Merci.
2009 : people are gone.
Use SQLiteman (Barry Kauler) with Qtlibrary

Pelo

OSMO is on all Puppies.Nobody deletes it

#110 Post by Pelo »

Who said that PPDB was dead. I have the package at home. I you need to create DBase databse Gposil application is waiting for you. It has been waiting too long !
I use OSMO, because OSMO is on all Puppies.Nobody deletes it, because so easy and useful.
"Hi gposil,
Yeehh!
Have browsed and looked around (tksqlite, sqlitemanager, sqlitedbms...) to find a simple database GUI...this one looks great ! Many thanks to you!
" Charlie 6 was happy. It seems to have been the only Puppy Man to use it. :)
Nevertheless, it was to say you i have the pet at home.
Attachments
DBase.jpg
You can change columns, of course
(71.54 KiB) Downloaded 392 times

Post Reply