when extracted the actual binary is about the same size as the .tar.gz file as it's made from
a tcl/tk starkit. it contains within itself sqlite, tcl/tk, tktable, and other libraries required for it's use. to see inside of it you need tclkit & sdx.kit:

http://www.equi4.com/pub/tk/8.5a4/tclkit-linux-x86.gz

http://www.equi4.com/pub/sk/sdx.kit

these can be renamed to tclkit & sdx respectively, both given executable permissions, then moved to /usr/bin. then if you're in the same directory as tksqlite & do:

Code:

sdx unwrap tksqlite

, this unwraps the result to directory tksqlite.vfs.

as puppy already has tcl/tk environment & sqlite, maybe we could remove some stuff from tksqlite.vfs & wrap it again, resulting in a smaller binary?

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.

Hello WhoDo. I'll second that. A form and report designer is a huge undertaking though. Even more so when the next requirement would be easy data binding to these. GnomeDB has this for forms and grids and can use SQLite3. A report designer is in the works but who knows when that will be ready. Then you still have to code with C or C++ to get a working application. Glom looks good but who can get it to work in Puppy? Plus it requires PostgreSQL.

Raffy,
Thanks for your excellent suggestion. I downloaded TkSQlite around 10:00 am and by lunch time, I had created a database, built three tables and populated them, and I am now already well on my way to completing a golf handicapping system for my league's tournaments. However, I will admit I had a head start on this task from developing the handicapping system a few years ago on Windows with Ocelot SQL DBMS. I really miss the absence of Ocelot on Puppy, but I believe that with extra effort I can accomplish the same result with TkSQlite.
Thanks again,
~Dick

I looked at the requirements for TkSqlite. Puppy already has most of it. Extra stuff needed are Tcl/Tk library packages:
Tile 0.7+, TkTable 2.9+, Dict 8.5+, TableList 4.5+, and optionally some bits out of Trf and Tclib.
All up, that shouldn't add much to the size.
Note, Tclib is a collection of libraries, and we can pull out the ones needed.

That's all you need for running in Puppy. Since they're not in the packages database for 2.16, you will have to download and click on them. (I have uploaded them to ibiblio pet_packages-2 directory)

In total, that would add about 0.4M to the live-CD.

Could someone do an install and test it? An evaluation of its usefulness as a possible standard app in Puppy would be good.
muggins has also posted another for us to compare, but of course with that one we would have to thrown in the Qt lib.

I looked at Muggins download. My impression is that it is entirely usable by a beginner to databasing and idiotic cructaceans. It seemed obvious and straightforward.

What I will do is unload Muggins download - set up Barrys. Then I will catalogue the packages available in the package manager - or at least make a start

Now we are talking . . . Does that make some sort of sense for a possible SQL enhancement to the package manager?

Suggested Fields

Category
Function
Version
Description
Links

Anyways I will see how I get on

Update

The program installed under "personal" on the menu (using IceWm)
When loading the database it tried to load "test2.db" - only on first load

Creating the database was easy but eh how do I add data?
Do I have to create it in a text editor? Do I use the SQLBrowser Muggins created, which seems to have an option to add records . . . ?_________________Puppy WIKI

Heh heh, a real time-waster that was, I shouldn't be going off on tangents when I've got so much else to do ...I compiled Qt 3.3.6 to create static library, then compiled sqlitebrowser against that ...the sqlitebrowser executable ended up at 6165K after stripping!

Lobster, how easy is it for an ordinary person to whip up a database using these products, then having done so, how easy to use it.

One issue though. These tools can create a personal database, but how is it shared? A product like sqlitedbms uses a web browser as both a creation and access tool so works over the Internet.
I don't know much about databases, but isn't this what we would want in such a tool, not just a little thing that creates a personal-only database?

Lobster, how easy is it for an ordinary person to whip up a database using these products, then having done so, how easy to use it.

I'm not Lobster, Barry, but I've had a quick look at the SQLite offerings and they don't look particularly easy or useful from a novice perspective. Sure I can create a simple data file, but for all its usefulness I could have done it much quicker and easier using scalc, for example, and had a far more usable outcome IMHO.

I'd like to take another run at Glom, but the list of dependencies for compiling appears a little daunting. On the plus side, it would run under MU's Gnome environment in Puppy, once compiled, and would be a much easier package for novices to use.

Just my $0.02c worth._________________Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

what i know about sql & relational databases would fit on 1/4 of a postage stamp...but i'm not sure what we're after here? i think either tksqlite or sqlitebrowser are both easier to use, for a novice, than doing it on commandline. but they don't have the browser capability that barry
mentions. (does the average user need such functionality? doesn't the OO dbase give this?)

i think the other two tclkit dbase files, linked to above, have browser capability.

warren, regarding glom, isn't it a front-end for PostgreSQL ? can it use sqlite?

what about this one:

http://www.dgroth.de/tcltk_dgsqlite.html

i just looked at that link again & saw last updated 2004, so maybe not very active.Edited_time_total

i think either tksqlite or sqlitebrowser are both easier to use, for a novice, than doing it on commandline. but they don't have the browser capability that barry
mentions. (does the average user need such functionality? doesn't the OO dbase give this?)

Yes on all accounts. sbase does have the capacity to create custom forms and reports, but it isn't as easy to use as it should be, and is evidently limited when dealing with datasets of any significant size.

muggins wrote:

i think the other two tclkit dbase files, linked to above, have browser capability.

Indeed, but unless you have an intimate knowledge of SQL commands, they don't allow you to create relationships, forms or reports. They just allow the creation of simple tables that are capable of indexing and sorting. If you want only that then scalc can easily handle that with autofilter.

muggins wrote:

warren, regarding glom, isn't it a front-end for PostgreSQL ? can it use sqlite?

Yes it needs PostgreSQL, and no it can't use SQLite at the moment (maybe never, who knows). It only reads PostgreSQL databases it has created, too, because it only uses a subset of a full PostgreSQL database command set. Still, it will create forms and reports MUCH more easily than anything else we've looked at so far, including sbase.

muggins wrote:

what about this one:

http://www.dgroth.de/tcltk_dgsqlite.html

Hmmmm...definitely not for the novice user I'm afraid.

As I see it there are 2 distinct questions here:

1. Can we get an easy-to-use database compiled for Puppy?

2. Can we get a small, light database that might be offered as standard in Puppy and is SQLite-based?

The answer to question 1 is yes, but not quickly or easily and certainly not without some overhead in terms of size and dependencies.

The answer to question 2 is yes, TkSQLite is already available, but what can it really do that makes it worth including in standard Puppy?

IMHO, the answer to "what can it do (sic)" is "not much". It would allow users to create SQL-based web pages that could query an SQLite database created with TkSQLite ... but IF the user had that sort of capability they probably wouldn't need TkSQLite to do the job!

For the average user, Gnumeric already supports autofiltering of a dataset, so I believe you could create a simple database much more quickly and easily using that than TkSQLite. Use it for storing your music file lists, or personal contacts or whatever. Why waste 0.4Mb of valuable Puppy real estate on TkSQLite if it can't really do anything more than that?

JMO, but I think we should be looking toward solving Problem 1 in the short to medium term, and ignoring Problem 2 as probably a wasted exercise for standard Puppy._________________Actions speak louder than words ... and they usually work when words don't!
SIP:whodo@proxy01.sipphone.com; whodo@realsip.com

Barry,
I installed the pet packages in puppy2.14 (HD install) and everything seems to work. I would vote yes to include it in the standard puppy release simply because it's a great tool for working with SQLite3 and many people would find it useful. If you decide not to do this then may I suggest that you make it a single file package a user could install from the Puppy package manager?

Warren,
If we could get Glom working for Puppy I would use it in a heart beat. Perhaps a dedicated thread could be started here or at the developer forum for this. I have a spare partition to use and would be willing to lend a hand.