ANN: SQLiteStudio 1.1.3 released!
Googie
I'm proud to announce release of SQLiteStudio 1.1.3.
http://sqlitestudio.one.pl
WHAT IS SQLITESTUDIO?
It's advandced, cross-platform SQLite database manager written in Tcl
(using some extensions).
WHAT'S NEW?
- Port to FreeBSD! Binary for that system is at download page.
- New translations: Spanish and German.
- Many bugs fixed.
Full ChangeLog:
http://sqlitestudio.one.pl/index.rvt?act=changelog
SQLiteStudio is described in details on page:
http://sqlitestudio.one.pl/index.php?act=about
Screenshots can be found at:
http://sqlitestudio.one.pl/index.php?act=screenshots
Discussing forum is placed at:
http://forum.sqlitestudio.one.pl/
--
Regards,
Googie
Sp...@controlq.com
Googie,
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??
Cheers,
Rob Sciuk
terryowen
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.)
Thanks,
Terry Owen
Googie
>
> 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.
Regards,
Googie
Googie
> 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.
Regards,
Googie
rene
> Yes, It's the tclkit. I've done it with KBS (http://wiki.tcl.tk/
> 18146).
the current one and the proposed in <http://wiki.tcl.tk/23813> ?
Regards
rene
Googie
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?
--
Pozdrawiam (Regards)!
Googie
Robert H
A plug for the OSX version. = )
terryowen
I'll be looking forward to it.
Terry
rene
> 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.
- 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 }
}
- build kit file (build*/bin/mykit.kit):
Package mykit1.0 {
Require { Use kbskit8.5 sdx.kit treectrl2.2.8 sqlite3.6.12
mylib1.0 }
Source { Link my1.0/vfs }
Configure {}
Make { Kit mykit sqlite3.6.12 treectrl2.2.8 mylib1.0 }
Install { Kit mykit }
}
- build starpack (build*/bin/mypack):
Package mypack1.0 {
Require { Use kbskit8.5 sdx.kit treectrl2.2.8 sqlite3.6.12
mylib1.0 }
Source { Link my1.0/vfs }
Configure { Kit {source $::starkit::topdir/tksqlite.tcl} Tk }
Make { Kit mypack sqlite3.6.12 treectrl2.2.8 mylib1.0 }
Install { Kit mypack -vq-gui }
}
>
> 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.
Regards
rene
Googie
>> 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.
--
Pozdrawiam (Regards)!
Googie
rene
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.
Regards
rene