Puppy Linux Discussion Forum

craftybytes · Joined: 17 Nov 2006 Posts: 298 Location: QLD AUSTRALIA

.
Am looking at using Puppy's SQlite3 database for a small project but am stumped at the code for how to set up for data in the database.. Embarassed

In MySQL (log on as root) - it would be something like:

Ian · Posted: Wed 12 Dec 2007, 05:31 Post_subject:

What are you trying to set up exactly.

I can give you the code to set up databases & tables as I used Sqlite originaly in Puppy Money.

craftybytes · Joined: 17 Nov 2006 Posts: 298 Location: QLD AUSTRALIA

Hi Ian,

Actually what I'm trying to suss out is - I'm looking at Gambas to wack up a simple GUI for access to an SQlite3 database - have examples for MySQL & PostgreSQL - but none for SQlite.. Crying or Very sad

So to try and sort it - I thought of asking on this forum for possible guidance.. Wink

Thanks for any help..

crafty.
.

Ian · Posted: Wed 12 Dec 2007, 21:37 Post_subject:

All great minds think alike. I am trying to do the same with sqlite using tcl/TK, Xlibs and Perl/TK for a start.

The attachment contains the basic commands.

craftybytes · Joined: 17 Nov 2006 Posts: 298 Location: QLD AUSTRALIA

Thanks Ian.. Wink

I don't know about 'great minds' - I'm certain that mine is still trying to remember where it was yesterday..(ha..ha..ha..).. Laughing

With using Gambas to make the GUI - I wanted to keep possible dependencies to as low as necessary - thus just Gambas - (hopefully it can use Puppy's in-built Basic as a base to work with..) - I see you've got 'tcl/TK, Xlibs and Perl/TK'.. Rolling Eyes

Anyway - will look at what you've put in the attachment and see if it will be helpful.. Cool

TIA..

crafty.
.

MU · Posted: Thu 13 Dec 2007, 20:51 Post_subject:

MU · Posted: Thu 13 Dec 2007, 21:25 Post_subject:

2byte · Joined: 09 Oct 2006 Posts: 356

Hi crafty,

May I suggest TKSqlite for building the database? http://reddog.s35.xrea.com/wiki/TkSQLite.html
I use the single file binary, it has no other dependencies. http://reddog.s35.xrea.com/software/tksqlite-0.5.6-linux-ix86-bin.tar.gz

Gambas2 has two decent sqlite3 database examples, PictureDatabase and Database. The first one is simple and might be adaptable for your needs. The second one uses data-bound gtk widgets if you like that sort of thing.

Vern

craftybytes · Joined: 17 Nov 2006 Posts: 298 Location: QLD AUSTRALIA

Thanks guys - will look into it..!!

2byte -

Am d'ling the TKSqlite binary at the moment - will try it - BUT for my small project was trying to keep it as simple as I could for the GUI part - thus hoping that Gambas2 would make an 'stand-alone' executable GUI to use with SQlite3 databases.. Confused

As BK has removed TK/Tcl from the version 3.xx/4.xx Puppies (can be put in as dotpets however) - was hoping to come up with a more general GUI that would work in v2.xx/3.xx & v4.xx puppies (if this is possible).. Question

I may have to just use the QT GUI tools to do what I want.. Rolling Eyes

Anyway - will see what develops.. Wink

crafty.
.

muggins · Joined: 20 Jan 2006 Posts: 6663 Location: lisbon

Crafty,

I don't know if this is relevant to your quest, but the tksqlite binary, recommended by 2byte, doesn't require an external tcl/tk environment, as it contains it's own internal tcl/tk structure, plus sqlite, plus any tcl files required for it to run, so it should work on any puppy version.

2byte · Joined: 09 Oct 2006 Posts: 356

Right, tksqlite makes it super easy to build and test the database, tables, and sql that you might need for your program. You can do it all with gambas if you prefer. Tksqlite will output the sql used for the create table statements too, and that can be real handy if you want to recreate the database with your gambas program code.

Ian · Posted: Sun 16 Dec 2007, 17:52 Post_subject:

Puppy 3.0.1 still has tclsh & wish, Puppy 4.0 has them removed.

craftybytes · Joined: 17 Nov 2006 Posts: 298 Location: QLD AUSTRALIA

.
Thanks all for the great help.. Very Happy

Looks like tksqlite is the way to go.. Laughing

Much appreciated.. Surprised

Cheers.

crafty.
.