Before I describe the problem I would like to thank you for the super good product.

I have an application which uses transactions.
(begin transaction;
operation 1;
operation 2;
.......
operation n;
commit;)
If I open SQLiteman and run simple SELECT statement, your application put SHARED lock on DB, but when I try to run my application after that I have a problem to run commit, but all other operations like Begin transaction or Rollback I can execute. It seems for me SHARED lock on DB has never been cleared. I might be wrong.

Thanks, Dmitri

Hi, nice tool... is there a way to "upload" and "download" data for the BLOB type?

thanks

I can't find how to add comments to tickets in Trac, these modern tools are not for humans imho.
Well, i recompiled with cmake -DWANT_DEBUG=1 .
Backtrace:
(gdb) r /usr/local/bin/sqliteman
Starting program: /usr/local/bin/sqliteman /usr/local/bin/sqliteman
Failed to read a valid object file image from memory.
[Thread debugging using libthread_db enabled]
[New Thread -1229732160 (LWP 12964)]
Qt: gdb: -nograb added to command-line options.
Use the -dograb option to enforce grabbing.
[New Thread -1235186800 (LWP 12967)]
[New Thread -1243579504 (LWP 12968)]
[Thread -1235186800 (LWP 12967) exited]
[Thread -1243579504 (LWP 12968) exited]
QSqlDatabasePrivate::addDatabase: duplicate connection name 'sqliteman-db', old connection removed.
[New Thread -1243579504 (LWP 12971)]
[New Thread -1235186800 (LWP 12972)]
[Thread -1243579504 (LWP 12971) exited]
[Thread -1235186800 (LWP 12972) exited]

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread -1229732160 (LWP 12964)]
0xb769a80f in ?? () from /usr/lib/libX11.so.6

Hi,

when I write in the sql editor the following
UPDATE tableX SET TnID=18 WHERE TnID=1895;

I have an error
unrecognized token: ":" SQL statement not found

Can you tell me why the statement doesn't work.

Thanx

No GUI tool can be "the best" if it is based on QT. I have never met a QT-based app that I have liked.

No GUI tool can be "the best" if it is based on Gtk|Tk|wx|msvc|whatever. I have never met a Gtk|Tk|wx|msvc|whatever-based app that I have liked.

do you understand, you moron?

and btw QT is a video format. Qt is that cool library, dear troll.

I tried sqliteman-0.99-20070509.dmg for PPC.

The application gives "Unable to open or create file xxxx. It is probably not a database" dialogue box whenever I try "New" or "Open" from the File menu. What might trigger this error message ? Thanks!

I am using G5 with OS 10.4.9 with sqlite3.1.3 and python 2.5.1.

I built the OSX version that is available on the download page, but I only have access to an Intel Mac, so it hasn't been tested on PPC. It IS built as a Universal binary, and the included Qt libraries are also Universal, so that should all be fine.

I don't believe that sqliteman even uses python, but the only difference I see is that I'm running python 2.4.4.

Have you tried building sqliteman from source? Installing Qt4 and cmake is trivial as they both have OSX installers availabe, and as long as you have the XCode tools installed you can build and test sqliteman. Just follow the standard unix build instructions that come with the source. If that build works for you, please send me the output of "otool -L sqliteman" so I can look for any oddities.

Caleb Shay
caleb(at)webninja.com

Hi Caleb:

Thanks. I tried what you suggested and building from source worked. Below is the output from otool -L for the working build:

-Robert

imac-g5de-imac-g5:/usr/local/bin imac$ otool -L sqliteman
sqliteman:
QtGui.framework/Versions/4/QtGui (compatibility version 4.3.0, current version 4.3.0)
/System/Library/Frameworks/Carbon.framework/Versions/A/Carbon (compatibility version 2.0.0, current version 128.0.0)
/System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime (compatibility version 1.0.0, current version 200.0.0)
QtSql.framework/Versions/4/QtSql (compatibility version 4.3.0, current version 4.3.0)
QtCore.framework/Versions/4/QtCore (compatibility version 4.3.0, current version 4.3.0)
/usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.3)
/System/Library/Frameworks/ApplicationServices.framework/Versions/A/ApplicationServices (compatibility version 1.0.0, current version 22.0.0)
/usr/lib/libstdc++.6.dylib (compatibility version 7.0.0, current version 7.4.0)
/usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 1.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 88.4.1)

I don't see it mentioned anywhere, so I just thought I would point out that I grabbed the binary builds of QT4 and cmake for OSX from their respective sites, grabbed the svn tarball of sqliteman and ran "cmake .; make; sudo make install" and sqliteman is working flawlessly on my Intel Mac for managing my development sqlite databases. So, you can add that to your list of platforms it is known to run on.

Cheers,
caleb(at)webninja.com

it's cool! More on mail sent.

Petr

I try to build Sqliteman (SVN-20070509) on Slackware 11 with qt-4.2.2 cmake-2.4.5 (and 2.4.6) as suggested in README, but it fail on linking stage with unresolved externals obviously related to glib. Then i add -lglib-2.0 to file build.make and create binary fine. With some Google-search i found this stuff: http://public.kitware.com/pipermail/cmake-commits/2007-February/000879.html
Why two build systems used?
Do Sqliteman project needs russian translation?

P.S. Sorry for my bad English.
Dmitry (usd@srkb.ru)

hi Dmitry,

On čt 7. června 2007, sqliteman@tools.assembla.com wrote:
> I try to build Sqliteman (SVN-20070509) on Slackware 11 with qt-4.2.2
> cmake-2.4.5 (and 2.4.6) as suggested in README, but it fail on linking
> stage with unresolved externals obviously related to glib. Then i add
> -lglib-2.0 to file build.make and create binary fine. With some
> Google-search i found this stuff:
> http://public.kitware.com/pipermail/cmake-commits/2007-February/000879.html

I'll look at it. Anyway - it's strange as it can be built on all systems I
have installed. Well, maybe it's time to install slackware into vmware...

> Why two build systems used?

It uses cmake for Un*x - as I'm familiar with it etc.
And qmake for windows because of I cannot get cmake working on it. And I do
not want to waste my time with Windows.

> Do Sqliteman project needs russian translation?

It could be great if you can do some ;)

> P.S. Sorry for my bad English.

Who cares about English? Your cannot be worse than mine.

All the best
Petr

Yoo-Hoo everybody,
I downloaded the tar file and extracted it.
As SU I issued the command cmake . and then make. I am shown error messages, but don't know what to make of them. My os is Debian etch:
Here's the error/shortcomings:
earth:/home/frank/sqliteman/sqliteman1# cmake .
-- Sqliteman 0.99.0svn will be built to install into /usr/local
-- *** Release build (use -DWANT_DEBUG=1 for debug one) ***
-- Found Qt-Version 4.2.1
-- Configuring done
-- Generating done
-- Build files have been written to: /home/frank/sqliteman/sqliteman1
earth:/home/frank/sqliteman/sqliteman1# make
[ 1%] Building CXX object sqliteman/CMakeFiles/sqliteman.dir/litemanwindow.o
/home/frank/sqliteman/sqliteman1/sqliteman/litemanwindow.cpp: In member function 'void LiteManWindow::rebuildRecentFileMenu()':
/home/frank/sqliteman/sqliteman1/sqliteman/litemanwindow.cpp:307: error: 'PreferencesDialog' has not been declared
/home/frank/sqliteman/sqliteman1/sqliteman/litemanwindow.cpp: In member function 'void LiteManWindow::preferences()':
/home/frank/sqliteman/sqliteman1/sqliteman/litemanwindow.cpp:944: error: 'PreferencesDialog' was not declared in this scope
/home/frank/sqliteman/sqliteman1/sqliteman/litemanwindow.cpp:944: error: expected `;' before 'prefs'
/home/frank/sqliteman/sqliteman1/sqliteman/litemanwindow.cpp:945: error: 'prefs' was not declared in this scope
make[2]: *** [sqliteman/CMakeFiles/sqliteman.dir/litemanwindow.o] Error 1
make[1]: *** [sqliteman/CMakeFiles/sqliteman.dir/all] Error 2
make: *** [all] Error 2

humpf, strange. Do you have qt4 devel packages intalled (sorry I don't know its exact debian name)? Can you provide some contact on you to solve it faster, please?

I do have qt4-dev-toos installed.
my email is m005e@catamount.org