I rarely use sqlite, but I have to say it is a pretty handy database that in my opinion works very well. Last time I used it I was on windows, but this go ’round I was using Ubuntu. I was searching for a nice admin tool and none seemed to suite me as I needed to edit an SQLite 2 file but its always nice to be up to date and administer SQLite 3. I found none better than to use the same windows program with Wine. SQLite Administrator seems to me to be a pretty complete tool. Here’s a screenshot of it running through Wine:

Of course this isn’t as pretty as on Windows, but hey, I’m not going for looks here! I do realize there are SQLite tools out there like this for Linux, but there were requirements to compile and install them, and well, I think we’re getting a little too old for requirements with Linux. Its almost easier to install Windows applications with Wine. I guess this is the one place proprietary software has a slight advantage… Any one aware of any other database administration tools out there for Linux/Ubuntu for various databases that exceed the standard tools(other than MySQL Query Browser and PGAdmin)?
Related posts:




5 Responses
wine » Blog Archive » SQLite Administration on Ubuntu
20|Jan|2008[...] Read the rest of this great post here [...]
Andreas Y N
03|Sep|2008Thank you so much…
I have tried all i know in Ubuntu : sqlitebrowser,sqliteman,sqlitestudio,sqlitetool..
But none of them work simple and fine with my sqlite version 2 database.
When i read your post and bang!! Wonderfull idea.. i never think of this before..
Sqlite Administrator works great in Ubuntu using wine. Simple run, no need to install at all..
Damion
02|Feb|2009Thanks, solved exactly the same problem of trying to find a linux sqlite 2 editor; I’d like to upgrade the punBB sqlite2 db to 3 but can’t (that’s a whole other project)
Merci,
D.
jwcalderon
15|Nov|2010Hi Trent,
Another tool is SQLite Expert Personal, is free for Personal use and run under wine (Ubuntu 10.10).
Best Regards
Akhi Syaiful
10|Feb|2011ok sangat membantu