Description: The best developer's and/or admin's GUI tool for Sqlite3 databases in the world. No joking here (or just a bit only) - it contains the most complette feature set of all tools available.
Sqliteman is real multiplatform software - it's reported to be run on Linux, MS Windows, MacOS, *BSD and more natively.
1.2.0 approaches after ten months of development, testing, and using the previously released 1.0.x and SVN snapshot versions. I'd like to send a big kudo to all people involved in this era. You know who you are.
Sourceforge.net contains only the source code and Windows/Mac binaries. Packaging of Sqliteman for your distribution is on your software vendor. But there are some packages prepared for you already (see below).
Windows Big Fat Note: Setup package will install Sqliteman into system via installer. Plain zip file can be unpacked anywhere and run without any installation. Yet Another
Another Note for MS Windows users: I do not use MS Windows extensively. If you are facing with any problem let me know to get it working.
Project homepage: http://sqliteman.com Feature requests and bugs: http://sqliteman.com/bugtracker Source code, MS Windows and MacOS binaries: http://sourceforge.net/projects/sqliteman/ Suse and Fedora packages URL: http://software.opensuse.org/download/home:/subik/
And what about future?
The development won't stop. Maybe it will be slower a little bit now just because Sqliteman can handle what I need from this software. Anyway there are some plans how to improve it more.
You can speed up your requests with your patches or e.g. technical (hardware/software) or financial support. See "Support development"Last changelog:
1.2.2, the bugfix release of 1.2.x series - #146: Views with spaces in name are not displayed correctly - #163: sqliteman 1.2.1 don't build with Qt 4.7 Linux: some binary packages for Suse and Fedora are already prebuilt in OpenSuse's build service: http://download.opensuse.org/repositories/home:/subik/
1.2.1, the bugfix release of 1.2.x series
- #143: Sqliteman crashes due to Signal 11 - #145: Snapshot disappear - fixed license for cmake find files - fixes in DE translation - new BG translation - new FR translation - update of IT translation
1.2.0
* Features: - full ALTER TABLE support (by step-by-step scripting) - extended Preferences for SQL Editor, Data Viewer and application startup - database PRAGMAs handling - implemented so called Table Populator (create testing data) - data export/import - complete user documentation - BLOBs handling: load/save/show size - real NULL values handling - extended direct tables content editation
* Look and Feel - new professionally designed icon - ability to integrate with KDE4 themes - updated translations
* Internals: - bugfixes - internal SQL parser is rewritten (merged with TOra code) - new SQL text editor (QScintilla based one) - Sqliteman can be used with Qt 4.2.x but the 4.3.x or later is stronlgy recomended.
If create database in php5 i can't open it in sqliteman.
I think sqliteman don't have sqlite2 support.
Why can't do that?.
I can transform a archive to sqlite3 from sqlite2 to edit it and back to sqlite2 again, but isn't a very efficent solution.
I think sqliteman will be the best manager software for sqlite, but, this is a problem to get the goal.
You're right sqlite v2 database files are not supported. Is there any reason why are you staying with sqlite2 in your project?
Ad adding sqlite2 support for it - well, I don't know. I don't use any sqlite2 db file. Personally I'm not sure if there is any support for v2 databases in my Qt4.
We will see... try to persuade me ;)
Ratings & Comments
10 Comments
sqliteman is great! I wish there would be a similar tool for embedded mysql (mysqle) databases.
Gentoo ebuild is here: http://repo.or.cz/w/kdeapps-overlay.git?a=blob;f=dev-db/sqliteman/sqliteman-1.0.1.ebuild;hb=HEAD
If create database in php5 i can't open it in sqliteman. I think sqliteman don't have sqlite2 support. Why can't do that?. I can transform a archive to sqlite3 from sqlite2 to edit it and back to sqlite2 again, but isn't a very efficent solution. I think sqliteman will be the best manager software for sqlite, but, this is a problem to get the goal.
You're right sqlite v2 database files are not supported. Is there any reason why are you staying with sqlite2 in your project? Ad adding sqlite2 support for it - well, I don't know. I don't use any sqlite2 db file. Personally I'm not sure if there is any support for v2 databases in my Qt4. We will see... try to persuade me ;)
Very well done. Simple, it just works. Perfect for my needs.
Thanks a lot, it really works fine !!!
ld cannot find -ldl
he? Can you provide a larger error output? Which OS and its version? Qt version?
That is the entire error message. Running Debian Sid, qt4 is up-to-date from Sid. Qt3.3 (if used) was built locally from konstruct.
strange. Do you have something like: /lib/libdl.so.2 ? I don't know the exact debian's package name.