Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-12 Thread Keith Christian 
Jan,

Good catch: I was in the tea/ directory, building the DLL for use with
TEA on Cygwin at the outset of this thread.  When I ran my test TCL
script with the 'load libsqlite3.8.4.dll SQLite3' line, the dll was
there, but sqlite3.exe wasn't.

So, I started looking over things to see why the sqlite3.exe
executable was missing and found changes in the Makefile from 3.8.3 to
3.8.4.

At that point, I decided to post this message and ask.  Richard Hipp
suggested that I download the amalgamation and run a gcc command  that
he provided.  Thatproduced a sqlite3.exe.  I'd like to track down why
the Makefile changes in 3.8.4 don't produce a sqlite3.exe file when
compiling in the tea/ directory.


Thanks for the new 3.8.4.1 for Cygwin.


Keith



On Tue, Mar 11, 2014 at 2:54 PM, Jan Nijtmans jan.nijtm...@gmail.com wrote:
 2014-03-11 17:45 GMT+01:00 Keith Christian keith1christ...@gmail.com:
 Will have to troubleshoot the details of the makefile changes between
 the autoconf version from 3.8.3 to 3.8.4, to see why on this Cygwin
 environment a sqlite3.exe wasn't created.  That will be awhile,
 pretty busy at $WORK (not a bad thing.)

 Don't know, but in my Cygwin enviroment everything works fine. The
 diff's in your first mail indicate the changes in the TEA makefiles,
 which were adapted to the latest versions in this commit:
http://www.sqlite.org/src/info/b81ba7a4bc
 those are used to build the sqlite3 Tcl extension, apparently
 not what you are after. It works fine for me.

 Anyway, I just uploaded the SQLite 3.8.4.1 build for Cygwin, it
 just depends on the mirrors how fast they pick it up.

 Regards,
  Jan Nijtmans
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-11 Thread Keith Christian 
A few days ago, I successfully compiled the previous version of the
autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
sqlite3.exe file was produced on a Cygwin environment.

This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked,
ran 'make clean' and 'make', but no sqlite3.exe file was produced.

I believe the issue is in some changes in the Makefiles produced
between 3080300 and 3080400.

Makefile.am and Makefile.in are identical between 3080300 and 3080400.

The cygwin environment on the machine has not been updated since
3080300 was compiled on 7 Mar.

See the output of 'wdiff' below.  Recent versions of the VIM editor
have a nice syntax mode for wdiff, copy the output below into VIM and
then type syn on and set filetype=wdiff at the colon prompt.



wdiff -s ../../sqlite-autoconf-3080300/tea/Makefile
../../sqlite-autoconf-3080400/tea/Makefile|grep \[-.*-\]|sed 'G;G'


PKG_LIB_FILE= [-libsqlite3.8.3.dll-] {+libsqlite3.8.4.dll+}


PKG_STUB_LIB_FILE = [-libsqlitestub3.8.3.a-] {+libsqlitestub3.8.4.a+}


INSTALL = [-/usr/bin/install-] {+$(SHELL)
$(srcdir)/tclconfig/install-sh+} -c


PACKAGE_VERSION = [-3.8.3-] {+3.8.4+}


#DEFS   = $(TCL_DEFS) -DPACKAGE_NAME=\sqlite\
-DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
{+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\ [-3.8.3\-]
{+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
{+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
-DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
-DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
-DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
-DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
-D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
-DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
-DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
-DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
$(PKG_CFLAGS)


DEFS= -DPACKAGE_NAME=\sqlite\
-DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
{+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\ [-3.8.3\-]
{+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
{+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
-DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
-DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
-DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
-DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
-D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
-DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
-DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
-DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
$(PKG_CFLAGS)



Keith
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-11 Thread Richard Hipp 
On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian
keith1christ...@gmail.comwrote:

 A few days ago, I successfully compiled the previous version of the
 autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
 sqlite3.exe file was produced on a Cygwin environment.

 This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked,
 ran 'make clean' and 'make', but no sqlite3.exe file was produced.



I'm sorry you are having trouble.

I don't know what is wrong because everything works fine when I try it.

As an alternative, consider downloading sqlite-amalgamation-3080400.zip and
then running:

 gcc -o sqlite3.exe -I. sqlite3.c shell.c






 I believe the issue is in some changes in the Makefiles produced
 between 3080300 and 3080400.

 Makefile.am and Makefile.in are identical between 3080300 and 3080400.

 The cygwin environment on the machine has not been updated since
 3080300 was compiled on 7 Mar.

 See the output of 'wdiff' below.  Recent versions of the VIM editor
 have a nice syntax mode for wdiff, copy the output below into VIM and
 then type syn on and set filetype=wdiff at the colon prompt.



 wdiff -s ../../sqlite-autoconf-3080300/tea/Makefile
 ../../sqlite-autoconf-3080400/tea/Makefile|grep \[-.*-\]|sed 'G;G'


 PKG_LIB_FILE= [-libsqlite3.8.3.dll-] {+libsqlite3.8.4.dll+}


 PKG_STUB_LIB_FILE = [-libsqlitestub3.8.3.a-] {+libsqlitestub3.8.4.a+}


 INSTALL = [-/usr/bin/install-] {+$(SHELL)
 $(srcdir)/tclconfig/install-sh+} -c


 PACKAGE_VERSION = [-3.8.3-] {+3.8.4+}


 #DEFS   = $(TCL_DEFS) -DPACKAGE_NAME=\sqlite\
 -DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
 {+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\ [-3.8.3\-]
 {+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
 {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
 -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
 -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
 -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
 -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
 $(PKG_CFLAGS)


 DEFS= -DPACKAGE_NAME=\sqlite\
 -DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
 {+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\ [-3.8.3\-]
 {+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
 {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
 -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
 -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
 -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
 -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
 $(PKG_CFLAGS)



 Keith
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users




-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-11 Thread Keith Christian 
Richard,

Thanks for the reply.  Your instructions produced a working
sqlite3.exe in the Cygwin environment, using
sqlite-amalgamation-3080401.zip.

The resulting file is quite large, almost 14 times the size of the
sqlite3 version 3.8.3 packages with Cygwin:


ls -l /usr/bin/sqlite3.exe
-rwxr-xr-x 1 kchris Domain Users 60957 Feb  4 04:45 /usr/bin/sqlite3.exe

ls -l ./sqlite3.exe
-rwxr-xr-x 1 kchris Domain Users 845353 Mar 11 10:05 ./sqlite3.exe


But it works!

./sqlite3.exe
SQLite version 3.8.4.1 2014-03-11 15:27:36
Enter .help for usage hints.
Connected to a transient in-memory database.
Use .open FILENAME to reopen on a persistent database.
sqlite .quit


Keith



On Tue, Mar 11, 2014 at 8:30 AM, Richard Hipp d...@sqlite.org wrote:
 On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian
 keith1christ...@gmail.comwrote:

 A few days ago, I successfully compiled the previous version of the
 autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
 sqlite3.exe file was produced on a Cygwin environment.

 This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked,
 ran 'make clean' and 'make', but no sqlite3.exe file was produced.



 I'm sorry you are having trouble.

 I don't know what is wrong because everything works fine when I try it.

 As an alternative, consider downloading sqlite-amalgamation-3080400.zip and
 then running:

  gcc -o sqlite3.exe -I. sqlite3.c shell.c






 I believe the issue is in some changes in the Makefiles produced
 between 3080300 and 3080400.

 Makefile.am and Makefile.in are identical between 3080300 and 3080400.

 The cygwin environment on the machine has not been updated since
 3080300 was compiled on 7 Mar.

 See the output of 'wdiff' below.  Recent versions of the VIM editor
 have a nice syntax mode for wdiff, copy the output below into VIM and
 then type syn on and set filetype=wdiff at the colon prompt.



 wdiff -s ../../sqlite-autoconf-3080300/tea/Makefile
 ../../sqlite-autoconf-3080400/tea/Makefile|grep \[-.*-\]|sed 'G;G'


 PKG_LIB_FILE= [-libsqlite3.8.3.dll-] {+libsqlite3.8.4.dll+}


 PKG_STUB_LIB_FILE = [-libsqlitestub3.8.3.a-] {+libsqlitestub3.8.4.a+}


 INSTALL = [-/usr/bin/install-] {+$(SHELL)
 $(srcdir)/tclconfig/install-sh+} -c


 PACKAGE_VERSION = [-3.8.3-] {+3.8.4+}


 #DEFS   = $(TCL_DEFS) -DPACKAGE_NAME=\sqlite\
 -DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
 {+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\ [-3.8.3\-]
 {+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
 {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
 -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
 -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
 -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
 -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
 $(PKG_CFLAGS)


 DEFS= -DPACKAGE_NAME=\sqlite\
 -DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
 {+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\ [-3.8.3\-]
 {+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
 {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
 -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
 -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
 -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
 -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
 $(PKG_CFLAGS)



 Keith
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users




 --
 D. Richard Hipp
 d...@sqlite.org
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-11 Thread Hick Gunter 
That is because you are statically linking the SQLite shell and the SQLite 
library into a single executable file instead of having the shell (sqlite3.exe) 
and the library (sqlite3.dll?) in separate files.

-Ursprüngliche Nachricht-
Von: Keith Christian [mailto:keith1christ...@gmail.com]
Gesendet: Dienstag, 11. März 2014 17:11
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] sqlite3.exe file not produced by 
sqlite-autoconf-3080400.tar.gz on Cygwin

Richard,

Thanks for the reply.  Your instructions produced a working sqlite3.exe in the 
Cygwin environment, using sqlite-amalgamation-3080401.zip.

The resulting file is quite large, almost 14 times the size of the
sqlite3 version 3.8.3 packages with Cygwin:


ls -l /usr/bin/sqlite3.exe
-rwxr-xr-x 1 kchris Domain Users 60957 Feb  4 04:45 /usr/bin/sqlite3.exe

ls -l ./sqlite3.exe
-rwxr-xr-x 1 kchris Domain Users 845353 Mar 11 10:05 ./sqlite3.exe


But it works!

./sqlite3.exe
SQLite version 3.8.4.1 2014-03-11 15:27:36 Enter .help for usage hints.
Connected to a transient in-memory database.
Use .open FILENAME to reopen on a persistent database.
sqlite .quit


Keith



On Tue, Mar 11, 2014 at 8:30 AM, Richard Hipp d...@sqlite.org wrote:
 On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian
 keith1christ...@gmail.comwrote:

 A few days ago, I successfully compiled the previous version of the
 autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a
 sqlite3.exe file was produced on a Cygwin environment.

 This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked,
 ran 'make clean' and 'make', but no sqlite3.exe file was produced.



 I'm sorry you are having trouble.

 I don't know what is wrong because everything works fine when I try it.

 As an alternative, consider downloading
 sqlite-amalgamation-3080400.zip and then running:

  gcc -o sqlite3.exe -I. sqlite3.c shell.c






 I believe the issue is in some changes in the Makefiles produced
 between 3080300 and 3080400.

 Makefile.am and Makefile.in are identical between 3080300 and 3080400.

 The cygwin environment on the machine has not been updated since
 3080300 was compiled on 7 Mar.

 See the output of 'wdiff' below.  Recent versions of the VIM editor
 have a nice syntax mode for wdiff, copy the output below into VIM and
 then type syn on and set filetype=wdiff at the colon prompt.



 wdiff -s ../../sqlite-autoconf-3080300/tea/Makefile
 ../../sqlite-autoconf-3080400/tea/Makefile|grep \[-.*-\]|sed 'G;G'


 PKG_LIB_FILE= [-libsqlite3.8.3.dll-] {+libsqlite3.8.4.dll+}


 PKG_STUB_LIB_FILE = [-libsqlitestub3.8.3.a-] {+libsqlitestub3.8.4.a+}


 INSTALL = [-/usr/bin/install-] {+$(SHELL)
 $(srcdir)/tclconfig/install-sh+} -c


 PACKAGE_VERSION = [-3.8.3-] {+3.8.4+}


 #DEFS   = $(TCL_DEFS) -DPACKAGE_NAME=\sqlite\
 -DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
 {+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\
 [-3.8.3\-] {+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
 {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
 -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
 -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
 -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
 -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
 $(PKG_CFLAGS)


 DEFS= -DPACKAGE_NAME=\sqlite\
 -DPACKAGE_TARNAME=\sqlite\ [--DPACKAGE_VERSION=\3.8.3\-]
 {+-DPACKAGE_VERSION=\3.8.4\+} -DPACKAGE_STRING=\sqlite\
 [-3.8.3\-] {+3.8.4\+} -DPACKAGE_BUGREPORT=\\ -DPACKAGE_URL=\\
 {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1
 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1
 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1
 -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1
 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1
 -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1
 -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long
 -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
 $(PKG_CFLAGS)



 Keith
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users




 --
 D. Richard Hipp
 d...@sqlite.org
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-11 Thread Tim Streater 
On 11 Mar 2014 at 16:11, Keith Christian keith1christ...@gmail.com wrote: 

 The resulting file is quite large, almost 14 times the size of the
 sqlite3 version 3.8.3 packages with Cygwin:

 ls -l /usr/bin/sqlite3.exe
 -rwxr-xr-x 1 kchris Domain Users 60957 Feb  4 04:45 /usr/bin/sqlite3.exe

 ls -l ./sqlite3.exe
 -rwxr-xr-x 1 kchris Domain Users 845353 Mar 11 10:05 ./sqlite3.exe

That's about what I get under OS X if I link to an amalgamation instead of the 
OS-supplied .dylib. The advantage is that you know which library you are using, 
unlike if you dynamically link to a library. The application uses just as much 
memory once linked, either way. These days the extra disk space used for the 
app is of no consequence (unless you have millions of apps, I suppose).

--
Cheers  --  Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-11 Thread Keith Christian 
Hick, Tim,

Thanks, I thought it was something like that.  Couldn't remember the
exact gcc switches as to whether the debug code may have been included
or not in Richard's command line, which was my first thought.  But at
least with Richard's command line I have a working, up to date sqlite3
executable!

Will have to troubleshoot the details of the makefile changes between
the autoconf version from 3.8.3 to 3.8.4, to see why on this Cygwin
environment a sqlite3.exe wasn't created.  That will be awhile,
pretty busy at $WORK (not a bad thing.)


Keith

On Tue, Mar 11, 2014 at 10:23 AM, Tim Streater t...@clothears.org.uk wrote:
 On 11 Mar 2014 at 16:11, Keith Christian keith1christ...@gmail.com wrote:

 The resulting file is quite large, almost 14 times the size of the
 sqlite3 version 3.8.3 packages with Cygwin:

 ls -l /usr/bin/sqlite3.exe
 -rwxr-xr-x 1 kchris Domain Users 60957 Feb  4 04:45 /usr/bin/sqlite3.exe

 ls -l ./sqlite3.exe
 -rwxr-xr-x 1 kchris Domain Users 845353 Mar 11 10:05 ./sqlite3.exe

 That's about what I get under OS X if I link to an amalgamation instead of 
 the OS-supplied .dylib. The advantage is that you know which library you are 
 using, unlike if you dynamically link to a library. The application uses just 
 as much memory once linked, either way. These days the extra disk space used 
 for the app is of no consequence (unless you have millions of apps, I 
 suppose).

 --
 Cheers  --  Tim

 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

2014-03-11 Thread Jan Nijtmans 
2014-03-11 17:45 GMT+01:00 Keith Christian keith1christ...@gmail.com:
 Will have to troubleshoot the details of the makefile changes between
 the autoconf version from 3.8.3 to 3.8.4, to see why on this Cygwin
 environment a sqlite3.exe wasn't created.  That will be awhile,
 pretty busy at $WORK (not a bad thing.)

Don't know, but in my Cygwin enviroment everything works fine. The
diff's in your first mail indicate the changes in the TEA makefiles,
which were adapted to the latest versions in this commit:
   http://www.sqlite.org/src/info/b81ba7a4bc
those are used to build the sqlite3 Tcl extension, apparently
not what you are after. It works fine for me.

Anyway, I just uploaded the SQLite 3.8.4.1 build for Cygwin, it
just depends on the mirrors how fast they pick it up.

Regards,
 Jan Nijtmans
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users