Puppy Linux Discussion Forum

charlie6 · Joined: 30 Jun 2008 Posts: 1148 Location: South of Belgium

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

Colonel Panic · Joined: 16 Sep 2006 Posts: 1892

smokey01 · Joined: 30 Dec 2006 Posts: 2578 Location: South Australia

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

gposil · Posted: Sun 24 May 2009, 04:11 Post subject:

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

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

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

Colonel Panic · Joined: 16 Sep 2006 Posts: 1892

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.

tlchost · Posted: Sun 07 Feb 2010, 19:07 Post subject:

jmbowman · Joined: 08 May 2010 Posts: 1

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.

Colonel Panic · Joined: 16 Sep 2006 Posts: 1892

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 .

Colonel Panic · Joined: 16 Sep 2006 Posts: 1892

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.

Pelo

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