Puppy Personal Database

[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

[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

[gposil]

Ok blog is here http://www.gposil.com/blog

[Lobster]

Very easy to create web page frontends

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

[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

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

[gposil]

its in the puppy3 repo

http://distro.ibiblio.org/pub/linux/dis ... -3.3.8.pet

[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

[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]

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.

[Pelo]

Our Puppies include Qt-libs, include Qt-apps in you menu ! for a few MBs, symphytum will make nice your csv data.
Here with LXpup xenial
PPDB is still available, people don't like it, do they ?
PPDB is a nice database, perhaps for home-service, not for software management, that Symphytum will get easy. Size of cells with you mouse
In LXpup symphytum will cost you 5MB (installed)
symphytum-1.2|symphytum|1.2||Personal|4448K||

[Colonel Panic]

Pelo said;

"PPDB is still available, people don't like it, do they?"

Thanks for reviving this old thread,but for me Portabase, although simple, does what I want a database program to do and all my database files are in Portabase's .pob format so I don't really see the point of changing. I'd even like to see Puppy incorporate it as standard.

If PPDB had existed back in 2009 when I was looking for a database for Puppy, and could easily import and convert files from the formats my data was already in (.dbf or .csv), it might have been different.

[Pelo]

Never i succeed to insert a picture in Portabase under Puppy Linux
ppdb lets use create structure (dbf format) Dbase III
I worked wit DBase II in 1985 for my boss, with Logabax stand alone computer. All material available in line stations all around the word was entered by Pelo. Wheels, spark igniter, DFDR, but seals unions and rings too. Thousands of items. Rattle head trusted his line maintenance ground employere, in these lonely lonely times.