Re: [sqlite] sqlite-3.7.6.1 coredump/hang

2011-04-15 Thread Dan Kennedy
On 04/15/2011 05:35 PM, Thomas Klausner wrote: > On Fri, Apr 15, 2011 at 04:32:08PM +0700, Dan Kennedy wrote: >> How are you building sqlite3? Using configure/make from the >> sqlite-autoconf-3070601.tar.gz package on the website? > > Yes, using pkgsrc. What happens if you just try to build sqlite

Re: [sqlite] [3070601] Makefile to cross-compile?

2011-04-15 Thread Gilles Ganault
On Fri, 15 Apr 2011 09:23:10 +0200, Gilles Ganault wrote: >I need to write a Makefile to cross-compile amalgamation-3070601 to >generate the static and shared libraries. For the benefit of other newbies who might need this: BASE=/opt/toolchain CC=bfin-linux-uclibc-gcc AR=bfin-linux-uclibc-ar rcu

[sqlite] 3.7.6.1 build error on platforms without pread/pwrite

2011-04-15 Thread Brad House
It appears there is a bad check when setting up the pread (and pwrite) callback: #if defined(USE_PREAD) || defined(SQLITE_ENABLE_LOCKING_STYLE) { "pread",(sqlite3_syscall_ptr)pread, 0 }, #else { "pread",(sqlite3_syscall_ptr)0, 0 }, #endif SQLite forces SQLIT

Re: [sqlite] sqlite-3.7.6.1 coredump/hang

2011-04-15 Thread Thomas Klausner
On Fri, Apr 15, 2011 at 07:45:58AM -0400, Richard Hipp wrote: > Can you recompile with all optimization turned off and let us know if that > changes anything. If you are still crashing, perhaps the backtrace will > provide better information. I've added -O0 to the flags and removed -O2. Now, sqli

Re: [sqlite] sqlite-3.7.6.1 coredump/hang

2011-04-15 Thread Richard Hipp
On Fri, Apr 15, 2011 at 5:08 AM, Thomas Klausner wrote: > On Fri, Apr 15, 2011 at 01:42:00PM +0700, Dan Kennedy wrote: > > Are there any other threads in the process? > > My program is not using threads. > sqlite3 is linked against libpthread. I don't think it's using threads > (you probably know

Re: [sqlite] (UML) Visualisation of a SQLite schema ?

2011-04-15 Thread Gary_Gabriel
Hi Fredrik, > I'm looking for a tool that would generate a visualisation (UML?) of > the SQLite database schema I'm using, with table constraints and > references between tables if possible. Is there such a tool (for Mac)? > If you are interested in doing something yourself- then this might be a

Re: [sqlite] sqlite-3.7.6.1 coredump/hang

2011-04-15 Thread Thomas Klausner
On Fri, Apr 15, 2011 at 04:32:08PM +0700, Dan Kennedy wrote: > How are you building sqlite3? Using configure/make from the > sqlite-autoconf-3070601.tar.gz package on the website? Yes, using pkgsrc. > Some > other method? Can you post the output of the build process? # make => Bootstrap dependen

Re: [sqlite] sqlite-3.7.6.1 coredump/hang

2011-04-15 Thread Dan Kennedy
On 04/15/2011 04:08 PM, Thomas Klausner wrote: > On Fri, Apr 15, 2011 at 01:42:00PM +0700, Dan Kennedy wrote: >> Are there any other threads in the process? > > My program is not using threads. > sqlite3 is linked against libpthread. I don't think it's using threads > (you probably know that better

Re: [sqlite] sqlite-3.7.6.1 coredump/hang

2011-04-15 Thread Thomas Klausner
On Fri, Apr 15, 2011 at 01:42:00PM +0700, Dan Kennedy wrote: > Are there any other threads in the process? My program is not using threads. sqlite3 is linked against libpthread. I don't think it's using threads (you probably know that better) but the c library behaves differently when libpthread i

[sqlite] (UML) Visualisation of a SQLite schema ?

2011-04-15 Thread Fredrik Karlsson
Hi, I'm looking for a tool that would generate a visualisation (UML?) of the SQLite database schema I'm using, with table constraints and references between tables if possible. Is there such a tool (for Mac)? I've looked into SQL::Translator (produces reasonable output, but does not cover the ent

[sqlite] [3070601] Makefile to cross-compile?

2011-04-15 Thread Gilles Ganault
Hello I need to write a Makefile to cross-compile amalgamation-3070601 to generate the static and shared libraries. Is this the right way? == #Path added to PATH CC=bfin-linux-uclibc-gcc AR=bfin-linux-uclibc-ar rcu CFLAGS=-O2 -Wall -I/usr/src/baps/uClinux-dist/linux-2.6.x/include LDF