I downloaded and tested the binary (just browsed the contents) using the FreeBSD (7.2R) version on a few of my existing databases, and I must say, you have done a remarkable job. As expected, performance of SQLite data sources is very good, but you have produced an intuitive, peformant and compelling tool here. I'll spend some time with it ...
BTW: is this a tclKit? How did you produce the FreeBSD binary??
This is a brilliant tool. I especially like the way you handle constraints - the seamless way the choices appear when the box is clicked is just lovely.
Perhaps this is covered in your forum (which I only briefly skimmed) but is there a way in form view to select a value from the table that is the FK constraint? (I've worked in Access too many years - I guess it shows.)
> I downloaded and tested the binary (just browsed the contents) using the > FreeBSD (7.2R) version on a few of my existing databases, and I must say, > you have done a remarkable job. As expected, performance of SQLite data > sources is very good, but you have produced an intuitive, peformant and > compelling tool here. I'll spend some time with it ...
> BTW: is this a tclKit? How did you produce the FreeBSD binary??
Thanks for kind words :)
Yes, It's the tclkit. I've done it with KBS (http://wiki.tcl.tk/ 18146). Unfortunetly I couldn't manage to compile SQLite2 on FreeBSD from plain sources (only compiling from ports works, but it doesn't apply for tclkit), so for FreeBSD only SQLite 3.x is supported for now. I hope to handle this issue in future.
On 5 Sie, 19:42, terryowen <terryo...@gmail.com> wrote:
> Perhaps this is covered in your forum (which I only briefly skimmed) > but is there a way in form view to select a value from the table that > is the FK constraint? (I've worked in Access too many years - I guess > it shows.)
Not yet. It's to be done in version 1.2, which I'm working from now on.
rene wrote: > On 6 Aug., 03:59, Googie <pawelsal...@gmail.com> wrote: >> Yes, It's the tclkit. I've done it with KBS (http://wiki.tcl.tk/ >> 18146). > So you have written your own package definition. Any opinions to > the current one and the proposed in <http://wiki.tcl.tk/23813> ?
I just wrote new definitions for recent version of SQLite3 and TreeCtrl, then I just built them and copied to sqlitestudio.vfs and I used sdx.kit to wrap it. I also used basic tclkit generated with KBS.
I'm suprised how great is to write kbs definitions! Really! It's very simple. I didn't come up with idea to define full batteries-included sqlitestudio kit. Maybe I will do it for next release - in fact it would be wonderful way to simplify deployment, which takes quiet much time for now.
I wonder if kbs definitions can be updated from some webpage, just like it downloads these definitions at the first run?
On Aug 5, 9:01 pm, Googie <pawelsal...@gmail.com> wrote:
> On 5 Sie, 19:42, terryowen <terryo...@gmail.com> wrote:
> > Perhaps this is covered in your forum (which I only briefly skimmed) > > but is there a way in form view to select a value from the table that > > is the FK constraint? (I've worked in Access too many years - I guess > > it shows.)
> Not yet. It's to be done in version 1.2, which I'm working from now > on.
On 6 Aug., 14:05, Googie <pawelsal...@gmail.com> wrote:
> I just wrote new definitions for recent version of SQLite3 and > TreeCtrl, then I just built them and copied to sqlitestudio.vfs and I > used sdx.kit to wrap it. I also used basic tclkit generated with KBS.
> I'm suprised how great is to write kbs definitions! Really! It's very > simple. I didn't come up with idea to define full batteries-included > sqlitestudio kit. Maybe I will do it for next release - in fact it > would be wonderful way to simplify deployment, which takes quiet much > time for now.
Here an example with kbs 0.3.1: - Assumption: sources/ my1.0/ generic/* -- sources of binary extension vfs/ -- sources of vfs tree main.tcl -- tclkit startup file - build your own binary extension like before. I call it here 'my1.0' Package mylib1.0 { Require { Use kbskit8.5 sdx.kit treectrl2.2.8 sqlite3.6.12 } Source { Link m1.0/generic } Configure { ... } Make { make } Install { make intall }
> I wonder if kbs definitions can be updated from some webpage, just > like > it downloads these definitions at the first run?
That is the goal behind the new package format. The package definitions should be included in the kbs.tcl script. So only these file is necessary for updates.
rene wrote: >> I wonder if kbs definitions can be updated from some webpage, just >> like >> it downloads these definitions at the first run? > That is the goal behind the new package format. The package > definitions > should be included in the kbs.tcl script. So only these file is > necessary for updates.
I thought that definitions are in sources/kbskit0.3.1/kbskit.kbs and this is where I put my definitions. It actually works.
On 7 Aug., 11:54, Googie <pawelsal...@gmail.com> wrote:
> rene wrote: > >> I wonder if kbs definitions can be updated from some webpage, just > >> like > >> it downloads these definitions at the first run? > > That is the goal behind the new package format. The package > > definitions > > should be included in the kbs.tcl script. So only these file is > > necessary for updates.
> I thought that definitions are in sources/kbskit0.3.1/kbskit.kbs and > this is where I put my definitions. It actually works.
Yes. But until now you have to download kbskit0.3.1 even if you do not need it. So I plan to move the definitions in the kbs.tcl script. btw. I found a solution without changing the current definition structure. Also the preferred way today and in the future is to use your own package definition file and give it on the command line or in the environment with '-pkgfile=your-def-file'. With the current versions you need in these file a line like: source [file join sources kbskit0.3.1 kbskit.kbs] That will go away in the next version.
