Puppy Linux Discussion Forum

Lobster · Last edited by Lobster on Tue 02 Dec 2008, 10:27; edited 1 time in total

If I needed a database I would probably use google base or open office
http://base.google.com/base/dashboard?hl=en_US

Maybe it is time to consider Pupbase?
A community project perhaps?

We have excellent search code menu / filesystem / pfind

What we need is input data, present sort and search

Are you using a database? Do you use Wine and and a Windows product? Is there a Linux database suitable for Puppy?

Anyone interested in coding / adapting something for Puppy?

BarryK · Posted: Thu 24 May 2007, 20:02 Post subject:

There is a GTK2 product that uses Sqlite3, looks good for Puppy, but it didn't work when I tried it -- but I might have done something wrong.
I can't remember its name, but I did discuss it a couple of months ago on this forum.

WhoDo · Posted: Thu 24 May 2007, 20:31 Post subject:

Personally I'm partial to FileMaker Pro in Windows, and I run it under Wine in Puppy, BUT Hendrikus once mentioned a FileMaker clone called GLOM that might be ported to Puppy.

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

I tried compiling it for Puppy, but at the time my skills in that area were underdeveloped and there were a heap of dependencies that I struggled to meet. Maybe that has changed and the time is now right for someone to try again.

2byte · Joined: 09 Oct 2006 Posts: 357

Here's some food for thought. http://www.gnome-db.org/ It compiles in Puppy and uses any of SQLite3, MySQL, or PostgreSQL . All it took to compile was gtk+-2.8.17.pet.

It would be great if this could be used with MU's GTKbasic!

2byte

WhoDo · Posted: Fri 25 May 2007, 00:17 Post subject:

I guess I also have to ask, "What's wrong with sbase from Open Office?" It works, as long as you have JRE installed along with Open Office, and it's no more complex than (yech!) Acce$$.

Just wonderin' is all. Wink

BarryK · Posted: Fri 25 May 2007, 03:19 Post subject:

WhoDo, does the OpenOffice database have similar look-and-feel to Access? Does it make Access-refugees feel at-home? If so, that would be a point in its favour.

WhoDo · Posted: Fri 25 May 2007, 03:32 Post subject:

DavidBell · Joined: 24 Nov 2006 Posts: 132

Last time I tried using Base for a real project (with OOo 2.0.## windows) I found it very difficult. Simple things in Access97 like subforms were virtually impossible, and it crashed often. Also from my point of view I like to use Access format, because if I get stuck in OOo I can often do something extra with the Access tools ... but it doesn't seem to support the format anymore.

Another negative for puppy users may be that OOo is quite a large program and not really in the same 'small is good' line of thinking as basic puppy.

On a positive for OOo Base the integration with Calc & Write is excellent and works well for example with single table mail merges. Anything over that though and Access was miles ahead when I tried, but maybe it's improved since then 2.0 series, I did DL 2.2 but haven't really tried yet.

I think the linux world is really lacking quick and dirty development tools like Access & VB. Love or hate them they can do things sooo simply provided you stay within their limits. I know lots of people here and in linux world generally are working on equivalents but at this point they still aren't quite there as far as I can see.

DB

PS. GLOM does look quite nice.

Béèm · Posted: Fri 25 May 2007, 04:02 Post subject:

I use sbase also and it looks nice.
But sbase is unable to produce a report with subtotals and unfortunately that's what I need.
In fact the only sql function in a report (or query) which can be defined is 'count'. (not very exciting)

So I am interested in an alternative solution.

Lobster · Posted: Tue 05 Jun 2007, 09:28 Post subject:

is kexi any good?
http://www.kexi-project.org/about.html

DavidBell · Joined: 24 Nov 2006 Posts: 132

Kexi looks quite nice but seems to need KOffice (and KDE?) Maybe I will try on ubuntu. DB

BarryK · Posted: Thu 07 Jun 2007, 07:15 Post subject:

Komodo · Joined: 30 Mar 2007 Posts: 20

Excuse me for butting in here. Has everyone forgotten that Puppy already has a good database? SQLite3 can be used in Puppy from the terminal, puppybasic, murgalua, perl, etc. If you want a GUI database manager there is TkSQLite. GUI forms can be created with tcl/tk, gins, puppybasic, gtk and others. A basic html report engine should be relatively easy to code with any of these languages. What more do you need?

Komodo

WhoDo · Posted: Thu 07 Jun 2007, 19:21 Post subject:

raffy · Joined: 25 May 2005 Posts: 4812 Location: Manila

TkSQlite has been getting praises for over a year now, see
http://reddog.s35.xrea.com/wiki/TkSQLite.html

As to the comment: