Puppy Database

Under development: PCMCIA, wireless, etc.
Message
Author
User avatar
JohnMurga
Site Admin
Posts: 555
Joined: Wed 04 May 2005, 04:26
Location: Far to the east
Contact:

#46 Post by JohnMurga »

WhoDo wrote:
JohnMurga wrote:As far as I am concerned it doesn't compare or compete - If you want a relational database, you use one.
Earlier in this thread I expressed what I thought we needed for Puppy, long and short term. Sqlite3, TkSqlite, your GUI frontend ... all offer a good short term solution for those familiar with SQL or not needing anything more powerful than an address book creator.

OTOH, long term we need an easy-to-use, fully relational database that can compete with 80% or more of what Microsoft Access can do and yet can be used by Window$ refugees who might not be able to use even Access but still need to create medium to large datasets. Something that does what FileMaker Pro does in Window$ and Mac environments. I believe GLOM is the answer for that, but compiling it for Puppy is a major task that is presently beyond my meager capabilities. What it offers is the ability to create SQL tables, forms and reports without knowing a single SQL command.

If someone of your stature and experience were to attempt it, we may stand a chance of success. Komodo stands willing to help. So do I. Maybe we could make this a new Puppy project. True relational database capability that is easy to use is all that stands between many Window$ users and a complete break from the Micro$oft stranglehold. What do you think?
Flattery will get you nowhere :-)

GLOM looks pretty amazing, but it's a bit heavy for Puppy (very), but the way Puppy's going you never know ...

My GUI front end is a demo for murgaLua that is constantly evolving ... And more gui like features are on the way. However, it is only ever going to support sqLite and it is a tiny part of a larger project with priorities that come from my main users.

As as far as my involvement with anything other than murgaLua at this point ... The fact remains that I've been homeless for a LONG TIME. I have found a house and will be moving in a couple of weeks, so once I have regular net access and don't have to do things from the hostels I've been staying in you might see a bit of more of me around here.

There are a LOT of things I want to do to Puppy :-)

Cheers
JohnM

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

#47 Post by WhoDo »

JohnMurga wrote:Flattery will get you nowhere :-)
Ar, rats! :P
JohnMurga wrote:GLOM looks pretty amazing, but it's a bit heavy for Puppy (very), but the way Puppy's going you never know ...
Yep. That PostgreSQL backend is the killer. Something similar for sqLite would be nice though .... (hint, hint, hint) :wink:
JohnMurga wrote:My GUI front end is a demo for murgaLua that is constantly evolving ... And more gui like features are on the way. However, it is only ever going to support sqLite and it is a tiny part of a larger project with priorities that come from my main users.
Well it wouldn't take much to bring up to a similar standard to TksqLite, would it? At this point I'm for anything that offers an excuse for murgaLua to find its way into Puppy. That would mean we can have the u beaut Control Panel that dvw86 put together some time back:
http://www.murga-linux.com/puppy/viewto ... 53&t=15931
JohnMurga wrote:As as far as my involvement with anything other than murgaLua at this point ... The fact remains that I've been homeless for a LONG TIME. I have found a house and will be moving in a couple of weeks, so once I have regular net access and don't have to do things from the hostels I've been staying in you might see a bit of more of me around here.

There are a LOT of things I want to do to Puppy :-)
Ooohh! Good news! I'm really glad you've found a place to call home. Are you sure I can't sweet talk you into writing a complete GUI frontend for sqLite that a newbie could use? :wink: :roll:
[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
JohnMurga
Site Admin
Posts: 555
Joined: Wed 04 May 2005, 04:26
Location: Far to the east
Contact:

#48 Post by JohnMurga »

WhoDo wrote:
JohnMurga wrote:GLOM looks pretty amazing, but it's a bit heavy for Puppy (very), but the way Puppy's going you never know ...
Yep. That PostgreSQL backend is the killer. Something similar for sqLite would be nice though .... (hint, hint, hint) :wink:
And Python, otherwise you "could" try to replace the database backend.
WhoDo wrote:
JohnMurga wrote:My GUI front end is a demo for murgaLua that is constantly evolving ... And more gui like features are on the way. However, it is only ever going to support sqLite and it is a tiny part of a larger project with priorities that come from my main users.
Well it wouldn't take much to bring up to a similar standard to TksqLite, would it? At this point I'm for anything that offers an excuse for murgaLua to find its way into Puppy. That would mean we can have the u beaut Control Panel that dvw86 put together some time back:
http://www.murga-linux.com/puppy/viewto ... 53&t=15931
It has surprised me that murgaLua is a core part of DSL but completely unused in Puppy, but it doesn't bother me - Once I hit my 1.0 functionality I'll concentrate on apps, and them maybe someone here will be interested.

As for TksqLite ... I am the wrong person as I have been biased against anything TCL based since before Puppy (as I had to some professional work with it some time back and didn't enjoy it).
WhoDo wrote:
JohnMurga wrote:As as far as my involvement with anything other than murgaLua at this point ... The fact remains that I've been homeless for a LONG TIME. I have found a house and will be moving in a couple of weeks, so once I have regular net access and don't have to do things from the hostels I've been staying in you might see a bit of more of me around here.

There are a LOT of things I want to do to Puppy :-)
Ooohh! Good news! I'm really glad you've found a place to call home. Are you sure I can't sweet talk you into writing a complete GUI frontend for sqLite that a newbie could use? :wink: :roll:
That's something that will probably happen at some point, just don't expect it too soon as it is a small priority in a big world ;-)

Cheers
JohnM

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

#49 Post by WhoDo »

JohnMurga wrote:It has surprised me that murgaLua is a core part of DSL but completely unused in Puppy, but it doesn't bother me - Once I hit my 1.0 functionality I'll concentrate on apps, and them maybe someone here will be interested.
I already am. How far away is that 1.0 functionality? We have guys here that are itching to get their teeth into programming applications for Puppy, but the breadth of development environments available seems to put off all but the most hardy.

Once I saw what dvw86 was able to quickly achieve with murgaLua, I was sold. It is only a matter of enthusing the "market". If what was done was designed to be compatible with IceWM, then I could introduce it through EZpup without impacting what happens in the mainstream version.

Frankly, I wish I knew more of programming ... especially in murgaLua. I'd have a lash at it myself. Unfortunately, my limited past experience with C and Basic barely qualifies me to write Hello World these days.

Keep plugging away John. Anything good is worth waiting for... just ask my wife! :wink:
[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
BarryK
Puppy Master
Posts: 9392
Joined: Mon 09 May 2005, 09:23
Location: Perth, Western Australia
Contact:

#50 Post by BarryK »

At this point I'm for anything that offers an excuse for murgaLua to find its way into Puppy.
MurgaLua is in Puppy, but as John says, it's not actually being used for anything ...yet. Looking at it from a fairly tough admin point of view, it would have to ultimately justify its inclusion, like some irresistable application that needs it.

raffy
Posts: 4798
Joined: Wed 25 May 2005, 12:20
Location: Manila

one application

#51 Post by raffy »

If we are looking at educating kids in cutting-edge programming, we don't even have to wait for version 1.0.

An example application or two that one can easily find in the Puppy menu and possibly modify at will should get things started. We can even call it "kiddie programming (KP)". (Then I can get my hands on it when no one is looking. :P )

How about a "create your Puppy" game? (create your unique Puppy from different colors and shapes)

andrei
Posts: 80
Joined: Wed 31 May 2006, 23:56

#52 Post by andrei »

The fonts in TkSqlite are way too small, very hard to read. I solved this problem by editing the configuration file:

/usr/lib/tile0.7.8/fonts.tcl

Now it looks much better.

User avatar
Flash
Official Dog Handler
Posts: 13071
Joined: Wed 04 May 2005, 16:04
Location: Arizona USA

#53 Post by Flash »

How did you edit it? Inquiring minds want to know. :lol:

andrei
Posts: 80
Joined: Wed 31 May 2006, 23:56

#54 Post by andrei »

See the attached file. Changes are in the x11 section.

Notice that I use the Courier New font which I downloaded from the Internet. I understand that it is legal to use Courier New because it was made available by Microsoft at some point. But I am not a lawyer.
Attachments
fonts.tar
modified /usr/lib/tile0.7.8/fonts.tcl
(10 KiB) Downloaded 764 times

Igo AtM
Posts: 25
Joined: Thu 16 Nov 2006, 14:36
Location: UK

Working SQLiteDBMS

#55 Post by Igo AtM »

Have just uploaded SQLiteDBMS it is a puppy hacked version and was originally put together as a low resource solution for sqlite3 access and motionMon or litemon with the sqlite db back end. I had seen this topic previously so I am posting a link to those that wish to try it. It is far from a final package but is working and I would appreciate feedback as I am currently re-writing the client. I felt it may also contribute to the ongoing discussion here link is
http://www.murga-linux.com/puppy/viewto ... 180#159180

Yet another interesting sqlite db management option I am uploading is a Gecko based sqlite manager which is very good at the pure db access level the problem with it is it requires seamonkey with the embedded sqlite engine so version 1.1 and above but it adds more fuel to the debate. It is not a pet as it is a native seamonkey extension. You should just be able to upload it unpack it and drag n drop it onto the browser and it should auto install md5 is below
6027224839339bf3d3a34084c11c3d34 sqlite_manager-0.2.8.3.tar.gz
You will need to unpack it as for security can not upload xpi to the forum
Attachments
sqlite_manager-0.2.8.3.tar.gz
archive of sqlite manager for seamonkey (ver 1.1 and above )
(62.74 KiB) Downloaded 758 times

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

#56 Post by Lobster »

http://www.knoda.org/

it uses kde and python (too big for Puppy)
but may suit some . . .

Anyone use it?
Last edited by Lobster on Fri 10 Apr 2009, 11:29, edited 1 time in total.
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

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

#57 Post by Lobster »

This is very nice
but a database online?
What happens when they sell to Microsoft, Google, Yahoo, NSA etc?
http://www.blist.com/index.html
Puppy Raspup 8.2Final 8)
Puppy Links Page http://www.smokey01.com/bruceb/puppy.html :D

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

#58 Post by tlchost »

Lobster wrote:This is very nice
but a database online?
What happens when they sell to Microsoft, Google, Yahoo, NSA etc?
http://www.blist.com/index.html
Hopefully there will be an alternative made for Puppy by then. The signup process is simple and you can easily import a .csv file.

Took a quick look at the support forum....there are not many entries, and the project manager appears to be very active answering user questions.

Apparently one can share a database with others on a read-only basis via email.

muggins
Posts: 6724
Joined: Fri 20 Jan 2006, 10:44
Location: hobart

#59 Post by muggins »

There hasn't been much activity on this front but, even though I've no use for a database, I thought I'd post this link to various sqlite frontends:

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

nic2109
Posts: 405
Joined: Mon 01 Jan 2007, 20:24
Location: Hayslope, near Middlemarch, Midlands, England

#60 Post by nic2109 »

Another approach to this issue would be to use the XAMPP package (which is huge) and make it an .sfs file. This would add everything to make Puppy into a Web server running sqlite apache perl and php.

You will still need to add a GUI and/or Report writer, which is where Muggins' link will come into its own.
[color=darkblue][b][size=150]Nick[/size][/b][/color]

scheck.r
Posts: 12
Joined: Wed 30 Apr 2008, 17:22

#61 Post by scheck.r »

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

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

#62 Post by WhoDo »

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
Last edited by WhoDo on Sun 04 May 2008, 11:23, edited 1 time in total.
[i]Actions speak louder than words ... and they usually work when words don't![/i]
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

Jactek
Posts: 37
Joined: Mon 11 Dec 2006, 00:43
Location: Hport NY

Database

#63 Post by Jactek »

At work I use an old DOS database QA4 by Symantec we have been using it since the early 90's and it works well, it works in Puppy using DosBox, also there is a program EZbase that work with DosBox. I bought a copy of Lotus Approch for Win3.1 but havnt been able to get to work with Wine or Dosbox

Jim

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

#64 Post by WhoDo »

Just finished playing with Portabase. For less than 600kb it is certainly very versatile (see screenshot in post above). As a simple, everyday flat file database, I think it would be a great asset to Puppy and make the base version software complete.

Any comments?

Here are some more shots of relevant input/view screens.

Image

Image
Last edited by WhoDo on Sun 04 May 2008, 11:57, edited 1 time in total.
[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

#65 Post by Colonel Panic »

Yeah, there's some good DOS database software out there. I sometimes use PC-File, a freeware database program, in DOSBox.

Portabase sounds good though.

Post Reply