(old)Puppy Linux Discussion Forum

This much I can say-- Portabase rocks. My guess is that for 90% of Puppy users wanting a DB, Portabase will meet their needs. It's easy to use, tiny sized, stable, and fast as lightning.

All you have to do is create or import your table. Portabase automatically supplies data entry forms and all commonly needed functions. I find that many of the commonly needed tasks are more easily done in Portabase than in Kexi even. --And Kexi is great. But for example, if you want to alter the structure of a table after it has been made and populated with data, it is a piece of cake in Portabase. Need to add a column? Need to rearrange the order of columns in the table? With Portabase, these tasks are incredibly simple and fast. In Kexi these are not part of routine operations and there are no out of the box commands for them. And in OO Base, such tasks are a mere dream-- or perhaps more aptly termed for those who have attempted it, a nightmare. Portabase turns the common, daily DB needs of general users into a simple pleasure. It is highly recommended.

Swarup wrote:This much I can say-- Portabase rocks. My guess is that for 90% of Puppy users wanting a DB, Portabase will meet their needs. It's easy to use, tiny sized, stable, and fast as lightning.

Yep. It has my vote as a standard include in Puppy, although BarryK might object since it also means including Qt-3.3.8 or similar. Pity really. Between Abiword, Gnumeric and Portabase Puppy standard has a complete and functional suite of office apps. Maybe chihuahua (3.10CE standard ed.) is the place it belongs.

Cheers

muggins wrote:Colonel,

try removing the qt-3.3.8 .pet, and instead install the pup2 qt-3.3.6 .pet.

Thanks for the advice, I will.

UPDATE: It worked! (after a reboot). Now all I have to do is import my data files from their native format (CSV). Fortunately, there aren't many of them.

Thanks to everyone who has helped.

for those of you who are running firefox

http://code.google.com/p/sqlite-manager/

might be interesting.

I think it is not for a beginner, but maybe someone ist interested.

The xpi is 86 kb!

cheers
aragon

I think it is not for a beginner

It also runs on Seamonkey
. . . but I am not sure if it comes with a front end or you have to write it?

aragon wrote:for those of you who are running firefox

http://code.google.com/p/sqlite-manager/

might be interesting.

I think it is not for a beginner, but maybe someone ist interested.

The xpi is 86 kb!

cheers
aragon

I have pup4.1 and that prog requires seamonkey 2.0 ( i have 1.1) and the firfox version required is 3.0- and pup-get only has a 2.? version , i have been reading for the past couple nights about setting up a MYSQL DB and PHP and have read this post
http://www.murga-linux.com/puppy/viewtopic.php?t=37109

and have tested hiawatha but now i am trying se if there is a native solution to MySql , i SQLite3 mentioned but cannot find it under PETget, but i see puppybasic2 is installed ......im just getting more and more confued :)...ill get it sorted

S!

aragon wrote:for those of you who are running firefox

http://code.google.com/p/sqlite-manager/

might be interesting.

I think it is not for a beginner, but maybe someone ist interested.

The xpi is 86 kb!

I have the XPI installed in FF3 on Windoze. Note that it can't diddle the place.sqlite file FF3 uses to store boomarks, as that file is locked while in use by FF, but it can investigate and diddle other SQLite DB files.
______
Dennis

Thee_oddball wrote:

aragon wrote:for those of you who are running firefox

http://code.google.com/p/sqlite-manager/

might be interesting.

I think it is not for a beginner, but maybe someone ist interested.

The xpi is 86 kb!

I have pup4.1 and that prog requires seamonkey 2.0 ( i have 1.1) and the firfox version required is 3.0- and pup-get only has a 2.? version

That's because Firefox 3 and Seamonkey 2 use an SQLite database to store bookmarks instead of bookmarks.html, and use SQLite databases for a few other things. The XPI would be pointless in FF 2 or SM 1.

There's a pet for Firefox 3.03 here at puppylinux.ca, , and you can get SM 2.0 alpha 2 for Linux from Mozilla here.
(It runs on Puppy 4.12 here.)

but now i am trying se if there is a native solution to MySql , i SQLite3 mentioned but cannot find it under PETget, but i see puppybasic2 is installed ......

There's a pet for SQLite 3.4.2 here at ibiblio.org.
______
Dennis

DMcCunney wrote:There's a pet for SQLite 3.4.2 here at ibiblio.org.
______
Dennis

Actually, Puppy 4.xx Dingo series has SQLite included - DeepThought 4.2 has SQLite-3.4.2 inbuilt.

Hope that helps

Hi
on Toutou4.1.2 k2.6.25.16 frugal / (= french translation of Puppy 4.1.2)
I installed tksqlite 0.4.5 from the Pet Manager (from Puppy3 list; there isn't any in Puppy 4 pet list) ;
the dependencies were automatically installed one after the other;
I restarted jwm and X;
There is well a menu entry under 'Personal';
but it won't work ..?
I have made the dependencies check: they 'seems' all being installed.

Can somebody give me some help?

Thanks in advance
Cheers
Charlie

update Ooupss ! Now my question is solved ! Please, just disregard it.
Having a look at the previous posts from the beginning I notice that tile-0.7.8.pet was missing ...Just had to load it from the pet manager, restart jwm and X and it is done.

I 'll now try to use that database with abiword to perform Mail merge.

Not enough 'many thanks!' to all the developpers (of Puppy and also its french translation 'Toutou') for such a nice tool !
Cheers
Charlie

re-update ...again...too fast spoken!
trying to open sqlite2_test.db (or sqlite3_test.db) I get a message asking

...install tclsqlite2...(or tclsqlite3)

I am now looking for tclsqlite2 and 3. Do .pet packages exist?


Cheers
Charlie

re-re-update

..looking for tclsqlite2 and 3...

I did not find them.
I found here (see previous post of 2byte on 15 dec 2007)
http://reddog.s35.xrea.com/software/tks ... bin.tar.gz
I " tar -xzvf " it and got tksqlite working (I could create a table and import another .csv one).
(...with tksqlite-0.4.5.pet already installed...I think i've made some jam...!?)

I 'm trying now to uninstall tksqlite-0.4.5.pet but do not succed in; using the Pet Manager to uninstall it gives no result for tksqlite and its dependencies as well.

I tried with Pet-be-Gone which seems only applicable for programs delivered with the Puppy live-cd.
How could I uninstall it?

Thanks for any idea.

Cheers
Charlie

WhoDo wrote:

scheck.r wrote:I don't know much about databases but I recall people using portabase or treeline as very simple database software on the Zaurus pda.
Both require Qt. No Sqlite. They are available also on the desktop. Very user friendly apps.

See http://portabase.sourceforge.net/index.html
and http://treeline.bellz.org/index.html

Thanks, scheck.r - treeline needs Python which kinda defeats the Puppy ethic, but portabase looks interesting. I have downloaded the tarball and will attempt a compile in Puppy. If successful I'll post the dotpet result here. At 256kb the download looks distinctly promising if QT is the only dependency.

The thread was really aimed at getting a fully-relational database for Puppy, but something this small might be enough for most people IF it is easier to use than TkSQlite for example.

Update: Compile from source failed due to missing directory but I downloaded the debian binary and that works. I have repacked as a dotpet here. Small, quick and relatively easy to use IMHO. Surprising how much it can do for such a little app. Good find, scheck.r

Thanks for this one, I downloaded it today and spent three-quarters of an hour or so converting my existing databases over so that Portabase could use them. I'm very impressed, it does everything I need from a database and is easy to understand and use.

I have looked at the GLOM database web site and I must admit it looks pretty good.

Has anyone managed to compile this for Puppy?

Apparently it is based on File Maker Pro which is very popular.

For any body who has compiling skills the source can be found at:
http://ftp.gnome.org/pub/GNOME/sources/glom/

GLOM home Page:
http://www.glom.org/wiki/index.php?title=Main_Page

A .PET would be nice that included all the dependencies.

I have tried to use the Database application in Open Office 2.4 and 3.0. It keeps telling me it needs JRE but it also says it is already installed.

I have tried PortaBase which is quite good but I need a little more functionality such as relationships and the ability to create forms.

For those who have the skills a GLOM PET or SFS would be very useful and appreciated I'm sure, by the Puppy community.

Regards

Smokey

?...The depends alone for glom are almost as large as puppy itself...I don't think that's the way to go...

I'm working on a RDBMS for Puppy but it's not going to happen overnight...

A long time ago I wrote an integration application using unix text file tools (if I remember correctly it was under SGI IRIX 6.5). Everything worked well until some of the input data became arabic (unicode) characters .... it wasn't pretty let me tell you. I was new to the whole unicode thingy then.

Anyway: Before you read my following warning please bear in mind I admit that I did not look at the latest versions of /rdb, NoSQL and SHQL and such but:

/rdb, NoSQL and other similar tools all use to some the available unix text file utilities (which may or may not have problems supporting unicode fully) and you really want make sure that Unicode is properly supported before you put them into production (either for just for yourself or for others). All the the unix text databases were created in under old unix initially living in a pure ASCII world - so if you have Unicode data then TEST, TEST, TEST EVERYTHING!!!

If people find this post offensive because they feel stepped on their toes then I am sorry - this is most certainly not my intention.

cklammer

Hi. Just revisiting this thread and I'd like to say I think Portabase could usefully be included in an official release; it's as far as I know unique to Puppy.

The other Linux distros I've looked at and used certainly don't have anything like it.

I'm still using it for addresses and 'phone numbers as well as for a local history project I've been doing about the local dialect of my home area.

Well done Warren, it's a fine app.

CP.

gposil wrote: I'm working on a RDBMS for Puppy but it's not going to happen overnight...

Any progress? Your previous efforts were very promising.

Thom

Hello, I thought you guys might like to know that there's now an updated version of PortaBase available, 2.0 beta 1 (I'm the author). It's finally been ported to Qt 4, so it should be easier to install alongside modern software without dragging in ancient versions of Qt. Other changes are summarized on the history page. This beta version has a few minor regressions from 1.9 that were discovered after the release, but those have already been fixed in the Git repository. Let me know if you find any other problems with it, or have suggestions for improvement.

Thanks for this one, I'll try it soon.

I really appreciate all the work you've done in putting together an open source personal database; there's absolutely nothing else out there for Linux which does the same job, and precious little for any other OS which does either (do you really want to have to power up Access just to be able to access your address book, for example, or your database of dialect words?).

I started a thread on the Vector Linux (which I also use) forum about Portabase, and one of the devs there has promised to have a go at building a Portabase package for that distro.

Best,

CP .

I've just looked at this and I think it's one for the devs. It needs QT4, which is a big package, and also the dev_x sfs which I don't have.

The alternative, if it's possible, is if someone's got a way of "processing" the deb file to extract the binary, as Warren said he was able to (earlier in the thread).

It's not a big deal in any case since Portabase 1.9 works fine.

Racy, Passagio-es, lxpup : ok
Lucid 5.2.8 : negative