Puppy Database

Under development: PCMCIA, wireless, etc.
Post Reply
Message
Author
Swarup
Posts: 219
Joined: Wed 21 May 2008, 01:28

#101 Post by Swarup »

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.

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

#102 Post by WhoDo »

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
[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
Colonel Panic
Posts: 2171
Joined: Sat 16 Sep 2006, 11:09

#103 Post by Colonel Panic »

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.

aragon
Posts: 1698
Joined: Mon 15 Oct 2007, 12:18
Location: Germany

#104 Post by aragon »

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

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

#105 Post by Lobster »

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?
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

Thee_oddball
Posts: 9
Joined: Sun 19 Oct 2008, 22:57

#106 Post by Thee_oddball »

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!

DMcCunney
Posts: 889
Joined: Tue 03 Feb 2009, 00:45

#107 Post by DMcCunney »

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

DMcCunney
Posts: 889
Joined: Tue 03 Feb 2009, 00:45

#108 Post by DMcCunney »

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

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

#109 Post by WhoDo »

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
[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
charlie6
Posts: 1230
Joined: Mon 30 Jun 2008, 04:03
Location: Saint-Gérard / Walloon part of Belgium

#110 Post by charlie6 »

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

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

#111 Post by Colonel Panic »

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 8)

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

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#112 Post by smokey01 »

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

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

#113 Post by gposil »

?...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... :(
[img]http://gposil.netne.net/images/tlp80.gif[/img] [url=http://www.dpup.org][b]Dpup Home[/b][/url]

User avatar
cklammer
Posts: 28
Joined: Sat 26 Apr 2008, 14:12
Location: Abu Dhabi, United Arab Emirates

/rdb, NoSQL and SHQL and other unix test file dbs

#114 Post by cklammer »

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

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

#115 Post by Colonel Panic »

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

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

#116 Post by tlchost »

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

jmbowman
Posts: 1
Joined: Sun 09 May 2010, 02:18

#117 Post by jmbowman »

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.

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

#118 Post by Colonel Panic »

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 .
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
Colonel Panic
Posts: 2171
Joined: Sat 16 Sep 2006, 11:09

#119 Post by Colonel Panic »

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

Pelo

sqliteman tested ok on here below distros

#120 Post by Pelo »

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

Post Reply