Good SQLite DB management

[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!

[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/

[Kiffi]

my favourite tool is TsSQLite:

http://reddog.s35.xrea.com/wiki/TkSQLite.html

Greetings ... Kiffi

[Polo]

my favourite tool is TsSQLite:

http://reddog.s35.xrea.com/wiki/TkSQLite.html

Greetings ... Kiffi

Looks good, no Mac version however?

[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

[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!

[Kiffi]

Looks good, no Mac version however?

There is also a TCL Script that should running on a Mac

Greetings ... Kiffi

[skywalk]

Hi Kiffi,
Looks interesting, but this is a lot of Requirements
Not exactly in the PureBasic spirit. Does the installer handle these?

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.

[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

[Kiffi]

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

[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?

[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

[Kiffi]

No offense intended Kiffi.

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.

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

[Polo]

Oh, too bad

[infratec]

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