Page 1 of 2
Good SQLite DB management
Posted: Tue Oct 25, 2011 1:24 pm
by Polo
Hello,
I'm looking for a tool that allows SQlite DB editing, crossplatform, if possible with an easy to use interface like Access.
ATM I'm using SQLite Database Browser, but I'm not fully satisfied by its too simplistic interface.
Thanks!
Re: Good SQLite DB management
Posted: Tue Oct 25, 2011 1:43 pm
by the.weavster
There's a FireFox add-on called 'SQLite Manager', I haven't used it personally but it's got some quite good reviews:
https://addons.mozilla.org/en-US/firefo ... e-manager/
Re: Good SQLite DB management
Posted: Tue Oct 25, 2011 1:53 pm
by Kiffi
my favourite tool is TsSQLite:
http://reddog.s35.xrea.com/wiki/TkSQLite.html
Greetings ... Kiffi
Re: Good SQLite DB management
Posted: Tue Oct 25, 2011 1:54 pm
by Polo
Looks good, no Mac version however?
Re: Good SQLite DB management
Posted: Tue Oct 25, 2011 3:23 pm
by ColBoy
I personally use SQLiteExpert,
http://www.sqliteexpert.com but it's for Windows only. Anyone using SQLite on a Windows machine, should be using this tool, it's fantastic. A fairly capable lite version is available free. The full version is about $50 I think.
Colin
Re: Good SQLite DB management
Posted: Tue Oct 25, 2011 3:28 pm
by Polo
Thanks Colin, this screenshot shows what I'm searching for:
http://www.sqliteexpert.com/screenshot_data.html
Too bad it's windows only
I don't need anything fancy, I'm not interested in query builder or such as I'm used to do it myself, though a good table creation wizard and Access like table editing would be fantastic!
Re: Good SQLite DB management
Posted: Tue Oct 25, 2011 3:35 pm
by Kiffi
Polo wrote:Looks good, no Mac version however?
There is also a TCL Script that should running on a Mac
Greetings ... Kiffi
Re: Good SQLite DB management
Posted: Tue Oct 25, 2011 3:51 pm
by skywalk
Hi Kiffi,
Looks interesting, but this is a lot of Requirements
Not exactly in the PureBasic spirit. Does the installer handle these?
http://reddog.s35.xrea.com/wiki/TkSQLite.html#tef99b25 wrote:
Requirements
Tcl/Tk8.4+
Tile0.7+(not required for Tcl/Tk8.5)
tclsqlite and|or tclsqlite3
TkTable2.9+
Dict8.5+(not required for Tcl/Tk8.5)
Treectrl2.1+ (if tksqlite is 0.4, it requires Tablelist0.5+ instead of treectrl)
tkImg (required for reading image data. it is optional. if it is not installed, you can read GIF format only.)
Trf and Tcllib (required for MD5 , SHA1, DES, Base64 and other crypt functions. but it is optional.)
NOTE:
Tablelist4.5+ is still required by tksqlite 0.4. But tksqlite 0.5 requires Treectrl2.1+ instead of Tablelist.
ActiveTcl has all of these precompiled extensions. I really recommend to install it if you are not familiar with tcl/tk environment.
Re: Good SQLite DB management
Posted: Thu Oct 27, 2011 3:43 pm
by infratec
Hi,
do you know this:
http://www.purebasic.fr/english/viewtop ... 27&t=40594
maybe Xombie can compile it for Linux and Mac.
Or maybe he provide the sourcecode.
Bernd
Re: Good SQLite DB management
Posted: Thu Oct 27, 2011 4:29 pm
by Kiffi
skywalk wrote:Hi Kiffi,
Looks interesting, but this is a lot of Requirements
Not exactly in the PureBasic spirit.
yes, of course. But first: TkSQLite is not written by me.
And second: Polo is searching for a tool 'like Access' and not a tool written in PureBasic spririt.
Greetings ... Kiffi
Re: Good SQLite DB management
Posted: Thu Oct 27, 2011 5:47 pm
by skywalk
No offense intended Kiffi.
I was curious if the installer handles the prerequisite libs? Or do I have to install them one by one?
Re: Good SQLite DB management
Posted: Thu Oct 27, 2011 6:31 pm
by Polo
Kiffi, Access like means in terms of graphical interface, and being able to change the values without opening a new window each time.
This aside, I want a small/fast tool indeed
I'm curious to see the tool made by Xombie, I'll try it next time I use Windows
Re: Good SQLite DB management
Posted: Thu Oct 27, 2011 7:00 pm
by Kiffi
skywalk wrote:No offense intended Kiffi.
skywalk wrote:I was curious if the installer handles the prerequisite libs? Or do I have to install them one by one?
sorry, but i don't know how to install the required libs. Under
Windows there is only one standalone Exe-File without installer.
Polo wrote:I'm curious to see the tool made by Xombie, I'll try it next time I use Windows
Unfortunately the download-link is broken.
Greetings ... Kiffi
Re: Good SQLite DB management
Posted: Thu Oct 27, 2011 7:59 pm
by Polo
Oh, too bad
Re: Good SQLite DB management
Posted: Thu Oct 27, 2011 10:39 pm
by infratec
Kiffi wrote:Unfortunately the download-link is broken.
I have a copy on my disk.
The program was/is also on sourceforge:
http://sourceforge.net/projects/sqliteexplorer/
But it's totally empty.
But inside the 7z file is only the exe file.
Write me a PN with your e-mail address and I mail it to you.
Or better and/or write a PN to Xombie.
Bernd