The time now is Sun 22 Apr 2018, 12:44
All times are UTC - 4 |
Page 1 of 19 [271 Posts] |
Goto page: 1, 2, 3, ..., 17, 18, 19 Next |
Author |
Message |
Lobster
Official Crustacean

Joined: 04 May 2005 Posts: 15238 Location: Paradox Realm
|
Posted: Thu 24 May 2007, 04:51 Post subject:
Puppy Database Subject description: Maybe it is time to consider Pupbase? |
|
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?
_________________ YinYana AI Buddhism
Last edited by Lobster on Tue 02 Dec 2008, 10:27; edited 1 time in total
|
Back to top
|
|
 |
BarryK
Puppy Master

Joined: 09 May 2005 Posts: 8526 Location: Perth, Western Australia
|
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.
|
Back to top
|
|
 |
WhoDo

Joined: 11 Jul 2006 Posts: 4440 Location: Lake Macquarie NSW Australia
|
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.
_________________ Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com
|
Back to top
|
|
 |
2byte
Joined: 09 Oct 2006 Posts: 357
|
Posted: Thu 24 May 2007, 23:46 Post subject:
|
|
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
Last edited by 2byte on Fri 25 May 2007, 17:14; edited 1 time in total
|
Back to top
|
|
 |
WhoDo

Joined: 11 Jul 2006 Posts: 4440 Location: Lake Macquarie NSW Australia
|
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.
_________________ Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com
|
Back to top
|
|
 |
BarryK
Puppy Master

Joined: 09 May 2005 Posts: 8526 Location: Perth, Western Australia
|
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.
|
Back to top
|
|
 |
WhoDo

Joined: 11 Jul 2006 Posts: 4440 Location: Lake Macquarie NSW Australia
|
Posted: Fri 25 May 2007, 03:32 Post subject:
|
|
BarryK wrote: | 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. |
It could be a twin brother, Barry. Access refugees should take to it like a duck to water. Of course neither is all that easy to use, but both are quite powerful.
See the following screenshot:
_________________ Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com
|
Back to top
|
|
 |
DavidBell
Joined: 24 Nov 2006 Posts: 132
|
Posted: Fri 25 May 2007, 03:53 Post subject:
|
|
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.
|
Back to top
|
|
 |
Béèm

Joined: 21 Nov 2006 Posts: 11775 Location: Brussels IBM Thinkpad R40, 256MB, 20GB, WiFi ipw2100. Frugal Lin'N'Win
|
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.
|
Back to top
|
|
 |
Lobster
Official Crustacean

Joined: 04 May 2005 Posts: 15238 Location: Paradox Realm
|
Posted: Tue 05 Jun 2007, 09:28 Post subject:
|
|
is kexi any good?
http://www.kexi-project.org/about.html
_________________ YinYana AI Buddhism
|
Back to top
|
|
 |
DavidBell
Joined: 24 Nov 2006 Posts: 132
|
Posted: Wed 06 Jun 2007, 18:07 Post subject:
|
|
Kexi looks quite nice but seems to need KOffice (and KDE?) Maybe I will try on ubuntu. DB
|
Back to top
|
|
 |
BarryK
Puppy Master

Joined: 09 May 2005 Posts: 8526 Location: Perth, Western Australia
|
Posted: Thu 07 Jun 2007, 07:15 Post subject:
|
|
BarryK wrote: | 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. |
This is it:
http://sqlitedbms.sourceforge.net/index.htm
I had another look at it, still can't get it to work, it just serves a blank page. It's very frustrating, as it looks real good, and small.
What about testing it in another distro, to at least see it working and evaluate it?
|
Back to top
|
|
 |
Komodo
Joined: 30 Mar 2007 Posts: 20
|
Posted: Thu 07 Jun 2007, 09:43 Post subject:
|
|
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
|
Back to top
|
|
 |
WhoDo

Joined: 11 Jul 2006 Posts: 4440 Location: Lake Macquarie NSW Australia
|
Posted: Thu 07 Jun 2007, 19:21 Post subject:
|
|
Komodo wrote: | 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? |
Hi Komodo,
What I need, and I guess most of the Puppy users I deal with need, is to have someone create a nice, easy GUI frontend for SQLite3 so we don't have to use tcl/tk, gins, puppybasic, gtk et al to create forms and reports. I'll have a look at TkSQLite, but if it doesn't have those features out-of-the-box then it won't be enough for the average user.
Anyone who can come up with such a simple, easy-to-use and small DBMS for Puppy will be doing the whole community a HUGE favor IMHO.
_________________ Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com
|
Back to top
|
|
 |
raffy
Joined: 25 May 2005 Posts: 4839 Location: Manila
|
Posted: Thu 07 Jun 2007, 21:19 Post subject:
TCL, QT |
|
TkSQlite has been getting praises for over a year now, see
http://reddog.s35.xrea.com/wiki/TkSQLite.html
As to the comment:
Quote: | this script is useful, but 20mb TCL prerequisite..? |
- will that translate to around 7 MB compressed in Puppy?
Alternative GUI managers based on QT are:
LiteMan - http://igorkh.freeshell.org/en/software/liteman.html
SQliteMan - http://sqliteman.sourceforge.net/
|
Back to top
|
|
 |
|
Page 1 of 19 [271 Posts] |
Goto page: 1, 2, 3, ..., 17, 18, 19 Next |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|