Re: [sqlite] Building SQLite DLL with Visual Studio 2015

[Keith Medcalf]

There are a few reasons for putting code in a DYNAMIC link library (linked at 
runtime) versus statically linked into the application (the same applies to all 
operating systems that support runtime linkage no matter what they call the 
runtime linked modules):

1)  You need to be able to replace the version of the DYNAMIC library code 
without rebuilding anything else

or

2)  You have multiple executables (A) (B) and (C) (for example) that will all 
use the same DYNAMIC library code and you are hard-up for memory such that you 
only want the DYNAMIC library code loaded once and used by all requestors in 
order to save memory.

or both.  Note that there is a third reason for using a dynamic (runtime) 
linked library and that is that it provides something that you want all comers 
to be able to use the same way.  Examples of this include the interfaces to the 
operating system and its platform libraries themselves which are always 
dynamically linked (this is the primary job of the program loader after all), 
and code which is "near to" such status such as widely used utility routines 
(such as zlib, X, etc).

You may use item (1) for example so that your application uses SQLite3 in a 
DLL.  Without making any change to your application at all, you can change the 
version of SQLite3 being used simply by changing the SQLite3.DLL.  This works 
well provided that the API contract does not change between versions of the DLL 
and that you are dependent on that API contract, not on the implementation 
details of the contract "under the hood" -- if it does (ie, you are 
version/implementation dependent) then you are in what is known as "DLL Hell" 
because your application is not actually dependent on the SQLite3 API, it is 
dependent on a certain VERSION of the SQLite3.DLL.  Mutatis mutandis to any DLL 
providing any API.

You may use item (2) for example so that your application uses a standard 
facility in a way that is compatible with item (1) in order to save loading the 
code into every process.  An example of this is the language/subsystem runtime 
libraries.  Since there may be many thousands of these executables running 
concurrently -- such as every single process requiring the use of the platform 
"C" library.  Rather than statically link the several megabytes of runtime into 
each and every executable (and loading A COPY of the same code with each 
executable), the library is only loaded ONCE and each process MAPS the loaded 
module into its own virtual address space thus perhaps saving gigabytes or 
terabytes of memory by only actually loading one copy of the code which 
everyone uses.

Putting something into a DLL "just cuz you can" is not a good reason for 
putting code in a DLL and unless you require the capabilities provided by (1) 
or (2) and are absolutely sure that you are dependent on the API contract and 
not the implementation contract, putting code in a DLL is almost always a bad 
idea.  It may be "cute" and "what the jonses are doing", but it serves no 
useful purpose other than add complication for complication sake.

That is to say that if you have to change anything other than just "copying 
over" the DLL to change the implementation of the API functionality that DLL 
provides to your application, then using a DLL was the wrong thing to do.

So, the only one who can answer your question is you by your knowledge of how 
your application works.

---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of John Smith
>Sent: Monday, 21 January, 2019 03:16
>To: SQLite mailing list
>Subject: [sqlite] Building SQLite DLL with Visual Studio 2015
>
>Hi,
>
>
>I need to build a data-layer DLL for a large project.
>
>My project is 64-bit built with Visual-Studio 2015.
>
>I want to ask about  what would be the preferred way to build SQLite:
>
>1. Build SQLite code as a separate DLL and use it from my data-layer
>DLL,
>
>2. Use the ready-built binary of 64-bit SQLite DLL for Windows
>(sqlite-dll-win64-x64-326.zip),
>
>3. Or, build my data-layer code with SQLite code as a single DLL.
>
>Thanks in advanced,
>
>John
>
>
>___
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



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

Re: [sqlite] Building SQLite DLL with Visual Studio 2015

[Chris Locke]

Just curious as to why you wouldn't choose option #2 - as that's what I use
with my VB .NET applications, which work quite well.  Just distribute the
.exe, then the two SQLite DLLs (well, three technically, as there are two
versions of the interop.dll)

Thanks,
Chris

On Mon, Jan 21, 2019 at 4:19 PM Simon Slavin  wrote:

>
>
> On 21 Jan 2019, at 11:16am, J Decker  wrote:
>
> > 4. Statically linked to and compiled with your datalayer code.
>
> What he said.  Also, you should be using the 'Amalgamation' download to do
> this, unless you need some compiler switches which are not supported by
> that source-set.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite DLL with Visual Studio 2015

[Simon Slavin]

On 21 Jan 2019, at 11:16am, J Decker  wrote:

> 4. Statically linked to and compiled with your datalayer code.

What he said.  Also, you should be using the 'Amalgamation' download to do 
this, unless you need some compiler switches which are not supported by that 
source-set.

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

Re: [sqlite] Building SQLite DLL with Visual Studio 2015

[J Decker]

On Mon, Jan 21, 2019 at 2:16 AM John Smith  wrote:

> Hi,
>
>
> I need to build a data-layer DLL for a large project.
>
> My project is 64-bit built with Visual-Studio 2015.
>
> I want to ask about  what would be the preferred way to build SQLite:
>
> 1. Build SQLite code as a separate DLL and use it from my data-layer DLL,
>
> 2. Use the ready-built binary of 64-bit SQLite DLL for Windows
> (sqlite-dll-win64-x64-326.zip),
>
> 3. Or, build my data-layer code with SQLite code as a single DLL.
>

4. Statically linked to and compiled with your datalayer code.


> Thanks in advanced,
>
> John
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Building SQLite DLL with Visual Studio 2015

[John Smith]

Hi,


I need to build a data-layer DLL for a large project.

My project is 64-bit built with Visual-Studio 2015.

I want to ask about  what would be the preferred way to build SQLite:

1. Build SQLite code as a separate DLL and use it from my data-layer DLL,

2. Use the ready-built binary of 64-bit SQLite DLL for Windows 
(sqlite-dll-win64-x64-326.zip),

3. Or, build my data-layer code with SQLite code as a single DLL.

Thanks in advanced,

John


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

[sqlite] Building sqlite-autoconf-3250000 with enable-rtree and enable-session

[death lock]

I'm building on Debian10

: warning: ISO C99 requires whitespace after the macro name
: error: missing binary operator before token "1"
sqlite3.c:308:5: note: in expansion of macro ‘SQLITE_ENABLE_RTREE’

* 'space' missing after $BUILD_CFLAGS

--- a/configure   2018-09-15 15:36:05.0 +0200
+++ b/sqlite-autoconf-325/configure2018-09-17
09:30:57.824054134 +0200

@@ -13638,7 +13638,7 @@
 fi

 if test x"$enable_session" = "xyes"; then
-  BUILD_CFLAGS="$BUILD_CFLAGS-DSQLITE_ENABLE_SESSION
-DSQLITE_ENABLE_PREUPDATE_HOOK"
+  BUILD_CFLAGS="$BUILD_CFLAGS -DSQLITE_ENABLE_SESSION
-DSQLITE_ENABLE_PREUPDATE_HOOK"
 fi
 #---
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Bob Friesenhahn]

On Thu, 21 Jun 2018, Dennis Clarke wrote:

Running "gmake" I see a few oddball warnings again :

"sqlite3.c", line 20826: warning: implicit function declaration: localtime_r 
(E_NO_IMPLICIT_DECL_ALLOWED)
"sqlite3.c", line 52491: warning: statement not reached 
(E_STATEMENT_NOT_REACHED)


"shell.c", line 11188: warning: implicit function declaration: strdup 
(E_NO_IMPLICIT_DECL_ALLOWED)


The strdup() function is also ABI dependent.  The Linux manual page 
ways it is dependent on


_SVID_SOURCE || _BSD_SOURCE || _XOPEN_SOURCE >= 500 || _XOPEN_SOURCE 
&& _XOPEN_SOURCE_EXTENDED || /* Since glibc 2.12: */ _POSIX_C_SOURCE 

= 200809L


You will need to add a preprocessor definition to your common build 
options, or use some other compiler mode in order for the header files 
to produce the prototypes for these two functions.


An Autoconf configure script which uses this macro:

AC_USE_SYSTEM_EXTENSIONS

will likely expose those prototypes.

Solaris has the __EXTENSIONS__ define (e.g. -D__EXTENSIONS__=1) to 
enable all extensions.  Otherwise you could try -D_XOPEN_SOURCE=500 
and see if that helps.


Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Warren Young]

On Jun 21, 2018, at 2:53 PM, Dennis Clarke  wrote:
> 
> n0$ diff Makefile.backup Makefile
> 70c70
> < TLIBS = -lz  $(LIBS)
> ---
> > TLIBS = -lz -lrt $(LIBS)
> n0$

Actually, you want this:



Index: configure.ac
==
--- configure.ac
+++ configure.ac
@@ -194,10 +194,11 @@
 AC_SUBST(SQLITE_THREADSAFE)
 
 if test "$SQLITE_THREADSAFE" = "1"; then
   AC_SEARCH_LIBS(pthread_create, pthread)
   AC_SEARCH_LIBS(pthread_mutexattr_init, pthread)
+  AC_SEARCH_LIBS(sched_yield, rt)
 fi
 
 ##
 # Do we want to support release
 #



Then run autoconf to re-generate the configure script, and re-configure.  
Unlike many FOSS projects, touching configure.ac in SQLite won’t do that for 
you on the next “make”.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Dennis Clarke]

On 06/21/2018 04:53 PM, Bob Friesenhahn wrote:

On Thu, 21 Jun 2018, Richard Hipp wrote:

.
sqlite3.c:
"sqlite3.c", line 20826: warning: implicit function declaration:
localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)


According to my manpage for localtime_r(), the only header file
required is , which you can clearly see is found on line
20342, above the declaration that offends your compiler.  Perhaps you
can suggest what is going wrong, because I have no clue.


It is most likely that sqlite is getting a preprocessor declaration for 
the requested ABI wrong.  The Linux manual page for localtime_r() says 
that its declaration depends on


_POSIX_C_SOURCE >= 1 || _XOPEN_SOURCE || _BSD_SOURCE || _SVID_SOURCE || 
_POSIX_SOURCE


but Solaris is proven to be Unix-compliant so the rules could be 
somewhat different.


I think you are on to something here. I keep detailed notes and logs on
every piece of software that I look at. The last time that I had built
sqlite and rolled it into production sites would be from the "autoconf"
pack sqlite-autoconf-3200100.[1] I still find it bizarre that sqlite has
multiple different tarballs and zip files with and without various bits
but that is a whole other discussion. Mostly I just want to be able to
compile from source and then verify with tests that the result is a good
result. There are pages of docs on this sort of topic on the sqlite site
but nothing clearly ( https://www.sqlite.org/testing.html ) says where
the tests are and exactly what to do in order to have them run for a
reasonable person. I have emails on this exact topic going back years
and Richard Hipp has been patient enough to tell me to not use the
tarball called "autoconf" because the tests are stripped out.  So that
explains why I use the full zip file.

So I am going to revert back to using the c99 compiler from the Oracle
Studio 12.6 compiler tools and also set POSIXLY_CORRECT=1 in the build
environment.  That is really harsh but from experience the sqlite code
is so squeaky clean that there shouldn't be a problem.

Also :

CC=/opt/developerstudio12.6/bin/c99

CFLAGS=-m64 -xarch=sparc -errwarn=%none -erroff=%none -errtags=yes
 -errfmt=error -errshort=full -xstrconst -xildoff -xmemalign=8s
 -xnolibmil -Xc -xcode=pic32 -xregs=no%appl -xlibmieee -mc -g -xs
 -ftrap=%none -Qy -xbuiltin=%none -xdebugformat=dwarf -xunroll=1

I won't go into a long discussion on why those flags makes good and
reasonable sense for a dev environment where I will want to debug or
single step my way through code. Suffice it to say that the results
have been tested to the n-th degree over a decade and I get very
very stable and very very conservative results.

n0$ ./configure --enable-shared --enable-static --enable-readline \
> --enable-threadsafe
checking build system type... sparc-sun-solaris2.10
checking host system type... sparc-sun-solaris2.10
checking for gcc... /opt/developerstudio12.6/bin/c99
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... no
checking whether /opt/developerstudio12.6/bin/c99 accepts -g... yes
checking for /opt/developerstudio12.6/bin/c99 option to accept ISO 
C89... none needed

checking for a sed that does not truncate output... /usr/local/bin/sed
checking for grep that handles long lines and -e... /usr/local/bin/grep
checking for egrep... /usr/local/bin/grep -E
checking for fgrep... /usr/local/bin/grep -F
checking for non-GNU ld... /usr/ccs/bin/sparcv9/ld
checking if the linker (/usr/ccs/bin/sparcv9/ld) is GNU ld... no
checking for BSD- or MS-compatible name lister (nm)... /usr/xpg4/bin/nm -p
checking the name lister (/usr/xpg4/bin/nm -p) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 786240
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking for /usr/ccs/bin/sparcv9/ld option to reload object files... -r
checking for objdump... no
checking how to recognize dependent libraries... pass_all
checking for ar... /usr/ccs/bin/ar
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/xpg4/bin/nm -p output from 
/opt/developerstudio12.6/bin/c99 object... ok
checking how to run the C preprocessor... 
/opt/developerstudio12.6/bin/c99 -E

checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking for /opt/developerstudio12.6/bin/c99 option to produce PIC... 
-KPIC -DPIC
checking if /opt/developerstudio12.6/bin/c

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Bob Friesenhahn]

On Thu, 21 Jun 2018, Richard Hipp wrote:

.
sqlite3.c:
"sqlite3.c", line 20826: warning: implicit function declaration:
localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)


According to my manpage for localtime_r(), the only header file
required is , which you can clearly see is found on line
20342, above the declaration that offends your compiler.  Perhaps you
can suggest what is going wrong, because I have no clue.


It is most likely that sqlite is getting a preprocessor declaration 
for the requested ABI wrong.  The Linux manual page for localtime_r() 
says that its declaration depends on


_POSIX_C_SOURCE >= 1 || _XOPEN_SOURCE || _BSD_SOURCE || _SVID_SOURCE 
|| _POSIX_SOURCE


but Solaris is proven to be Unix-compliant so the rules could be 
somewhat different.


Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,http://www.GraphicsMagick.org/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Warren Young]

On Jun 21, 2018, at 5:28 AM, Dennis Clarke  wrote:
> 
> So I then read ext/async/README.txt and took a look around whereupon
> I see these use "sched_yield" :
> 
> ./ext/async/sqlite3async.c
> ./src/test4.c
> ./src/test7.c
> ./test/crashtest1.c
> ./test/threadtest1.c
> ./test/threadtest2.c
> ./test/threadtest4.c
> 
> So this is ... just curious to me. I would think that everything I would
> need would be in libtclsqlite3.so or libsqlite3.so.0.

sched_yield(3) is a POSIX API function, since 2001.

It’s not explicit in the Solaris docs, but it appears it may require -lrt:

https://docs.oracle.com/cd/E88353_01/html/E37843/sched-yield-3c.html
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Dennis Clarke]

On 06/21/2018 12:06 PM, Richard Hipp wrote:

On 6/21/18, Dennis Clarke  wrote:


Seems to compile fine and yet "gmake test" failed with a less
then helpful "Error 2" :


.
.
.
sqlite3.c:
"sqlite3.c", line 20826: warning: implicit function declaration:
localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)


According to my manpage for localtime_r(), the only header file
required is , which you can clearly see is found on line
20342, above the declaration that offends your compiler.  Perhaps you
can suggest what is going wrong, because I have no clue.


Yep ... I looked there right away.  Saw the same thing and then started
over from scratch with more lenient CFLAGS.

Build completes just fine ... near as I can tell.


"sqlite3.c", line 52491: warning: statement not reached
(E_STATEMENT_NOT_REACHED)


Line 52491 is "assert(0);" which generates no code unless you compile
with -DSQLITE_DEBUG.  Once again, I have no explanation for the
warning.



Hr ... yep.  Does make me wonder.

I went out on a limb and figured that the tests were beig built and
linked by default against the previous sqlite libs installed in the
/usr/local/lib directory.  So I went ahead and installed the libs
freshly built and went back to run the "gmake test" and that was, at
the very least, interesting :

n0$ /usr/local/bin/gmake test 2>&1 | tee 
../sqlite-src-324_SunOS5.10_sparcv9.002.test.log
./fuzzcheck --limit-mem 100M 
/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/test/fuzzdata1.db 
/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/test/fuzzdata2.db 
/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/test/fuzzdata3.db 
/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/test/fuzzdata4.db 
/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/test/fuzzdata5.db 
/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/test/fuzzdata6.db

fuzzdata1.db: SQL fuzz as of 2015-06-20
fuzzdata1.db: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% - 9903 tests
fuzzdata2.db: SQL test cases contributed by Michal Zalewski on 2015-05-01
fuzzdata2.db: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% - 9959 tests
fuzzdata3.db: Database fuzz as of 2015-06-24
fuzzdata3.db: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% - 2316 tests
fuzzdata4.db: JSON1 test cases as of 2015-09-23
fuzzdata4.db: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% - 2574 tests
fuzzdata5.db: Test cases received from the OSS-FUZZ project
fuzzdata5.db: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% - 8818 tests
fuzzdata6.db: Test cases for UPSERT
fuzzdata6.db: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% - 3896 tests
fuzzcheck: 0 errors out of 37466 tests in 70.355 seconds
SQLite 3.24.0 2018-06-04 19:24:41 
c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199a87ca
./sessionfuzz run 
/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/test/sessionfuzz-data1.db

sessionfuzz-data1.db:  339 cases, 0 crashes
./srcck1 sqlite3.c
./libtool --mode=link /opt/developerstudio12.6/bin/cc 
-I/usr/local/include -D_TS_ERRNO -D_POSIX_PTHREAD_SEMANTICS 
-D_LARGEFILE64_SOURCE  -m64 -xarch=sparc -errwarn=%none -erroff=%none 
-errtags=yes -errfmt=error -errshort=full -xstrconst -xildoff 
-xmemalign=8s -xnolibmil -Xa -xcode=pic32 -xregs=no%appl -xlibmieee -mc 
-g -xs -ftrap=%none -Qy -xbuiltin=%none -xdebugformat=dwarf -xunroll=1 
-D_TS_ERRNO -D_POSIX_PTHREAD_SEMANTICS -D_LARGEFILE64_SOURCE 
-DSQLITE_OS_UNIX=1 -I. 
-I/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/src 
-I/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/ext/rtree 
-I/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/ext/icu 
-I/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/ext/fts3 
-I/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/ext/async 
-I/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/ext/session 
-D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/local/include 
-DSQLITE_THREADSAFE=1   -DSQLITE_HAVE_ZLIB=1  -L/usr/local/lib 
-DSQLITE_NO_SYNC=1 -DSQLITE_TEMP_STORE=1 -DSQLITE_TEST=1 
-DSQLITE_CRASH_TEST=1 -DTCLSH_INIT_PROC=sqlite3TestInit 
-DSQLITE_SERVER=1 -DSQLITE_PRIVATE="" -DSQLITE_CORE  -DBUILD_sqlite 
-DSQLITE_SERIES_CONSTRAINT_VERIFY=1 -DSQLITE_DEFAULT_PAGE_SIZE=1024 
-DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBPAGE_VTAB \

.
.
.
etc etc
.
.
.

and then whammo :

/usr/local/build/sqlite-src-324_SunOS5.10_sparcv9.002/src/tclsqlite.c:
sqlite3.c:
"sqlite3.c", line 52491: warning: statement not reached 
(E_STATEMENT_NOT_REACHED)

Undefined   first referenced
 symbol in file
sched_yield test4.o
ld: fatal: symbol referencing errors. No output written to testfixture
gmake: *** [Makefile:1161: testfixture] Error 2
n0$

Interesting.

n0$ grep -in "sched_yield" ./src/test4.c
80:  while( p->opnum<=p->completed ) sched_yield();
88:while( p->opnum<=p->completed ) sched_yield();
169:  while( p->opnum>p->completed ) sched_yield();
n0$


So I then read ext/async/README.txt and 

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Richard Hipp]

On 6/21/18, Dennis Clarke  wrote:
>
> Seems to compile fine and yet "gmake test" failed with a less
> then helpful "Error 2" :
>
>
> .
> .
> .
> sqlite3.c:
> "sqlite3.c", line 20826: warning: implicit function declaration:
> localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)

According to my manpage for localtime_r(), the only header file
required is , which you can clearly see is found on line
20342, above the declaration that offends your compiler.  Perhaps you
can suggest what is going wrong, because I have no clue.

> "sqlite3.c", line 52491: warning: statement not reached
> (E_STATEMENT_NOT_REACHED)

Line 52491 is "assert(0);" which generates no code unless you compile
with -DSQLITE_DEBUG.  Once again, I have no explanation for the
warning.

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

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Dennis Clarke]

On 06/21/2018 10:04 AM, Dan Kennedy wrote:

On 06/21/2018 02:34 PM, Dennis Clarke wrote:


Seems to compile fine and yet "gmake test" failed with a less
then helpful "Error 2" :


.
.
.
sqlite3.c:
"sqlite3.c", line 20826: warning: implicit function declaration: 
localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)
"sqlite3.c", line 52491: warning: statement not reached 
(E_STATEMENT_NOT_REACHED)

gmake: *** [Makefile:1161: testfixture] Error 2



Seems like the compiler is configured to be extra picky. Is this 
Solaris? Can you post the full output of [configure && gmake test]?


It is and yes it is a very strict compiler. Which is why I use it.

output from configure :

checking build system type... sparc-sun-solaris2.10
checking host system type... sparc-sun-solaris2.10
checking for gcc... /opt/developerstudio12.6/bin/cc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... no
checking whether /opt/developerstudio12.6/bin/cc accepts -g... yes
checking for /opt/developerstudio12.6/bin/cc option to accept ISO C89... 
none needed

checking for a sed that does not truncate output... /usr/local/bin/sed
checking for grep that handles long lines and -e... /usr/local/bin/grep
checking for egrep... /usr/local/bin/grep -E
checking for fgrep... /usr/local/bin/grep -F
checking for non-GNU ld... /usr/ccs/bin/sparcv9/ld
checking if the linker (/usr/ccs/bin/sparcv9/ld) is GNU ld... no
checking for BSD- or MS-compatible name lister (nm)... /usr/xpg4/bin/nm -p
checking the name lister (/usr/xpg4/bin/nm -p) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 786240
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking for /usr/ccs/bin/sparcv9/ld option to reload object files... -r
checking for objdump... no
checking how to recognize dependent libraries... pass_all
checking for ar... /usr/ccs/bin/ar
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/xpg4/bin/nm -p output from 
/opt/developerstudio12.6/bin/cc object... ok

checking how to run the C preprocessor... /opt/developerstudio12.6/bin/cc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking for /opt/developerstudio12.6/bin/cc option to produce PIC... 
-KPIC -DPIC
checking if /opt/developerstudio12.6/bin/cc PIC flag -KPIC -DPIC 
works... yes
checking if /opt/developerstudio12.6/bin/cc static flag -Bstatic 
works... yes

checking if /opt/developerstudio12.6/bin/cc supports -c -o file.o... yes
checking if /opt/developerstudio12.6/bin/cc supports -c -o file.o... 
(cached) yes
checking whether the /opt/developerstudio12.6/bin/cc linker 
(/usr/ccs/bin/sparcv9/ld -64) supports shared libraries... yes

checking dynamic linker characteristics... solaris2.10 ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... no
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for a BSD-compatible install... ./install-sh -c
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking for int8_t... yes
checking for int16_t... yes
checking for int32_t... yes
checking for int64_t... yes
checking for intptr_t... yes
checking for uint8_t... yes
checking for uint16_t... yes
checking for uint32_t... yes
checking for uint64_t... yes
checking for uintptr_t... yes
checking for sys/types.h... (cached) yes
checking for stdlib.h... (cached) yes
checking for stdint.h... (cached) yes
checking for inttypes.h... (cached) yes
checking malloc.h usability... yes
checking malloc.h presence... yes
checking for malloc.h... yes
checking for fdatasync... yes
checking for gmtime_r... yes
checking for isnan... yes
checking for localtime_r... yes
checking for localtime_s... no
checking for malloc_usable_size... no
checking for strchrnul... no
checking for usleep... yes
checking for utime... yes
checking for pread... yes
checking for pread64... no
checking for pwrite... yes
checking for pwrite64... no
checking for tclsh8.7... no
checking for tclsh8.6... no
checking for tclsh8.5... tclsh8.5
configure: Version set to 3.24
configure: Release set to 3.24.0
configure: Version number set to 3024000
checking whether to support threadsafe operation... yes
checking for l

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Dan Kennedy]

On 06/21/2018 02:34 PM, Dennis Clarke wrote:


Seems to compile fine and yet "gmake test" failed with a less
then helpful "Error 2" :


.
.
.
sqlite3.c:
"sqlite3.c", line 20826: warning: implicit function declaration: 
localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)
"sqlite3.c", line 52491: warning: statement not reached 
(E_STATEMENT_NOT_REACHED)

gmake: *** [Makefile:1161: testfixture] Error 2



Seems like the compiler is configured to be extra picky. Is this 
Solaris? Can you post the full output of [configure && gmake test]?


The second error is a bit strange. It's true that line 52491 is 
unreachable, but the line is "assert( 0 );". Are you building with 
SQLITE_DEBUG defined somehow? Is environment variable CC set?


If you just want to get something working, switching to the amalgamation 
package might do the trick.


Dan.




Configure was trivial and seems fine :

./configure --enable-shared --enable-static --enable-readline 
--enable-threadsafe


Not sure if perhaps I am doing something blatently wrong.

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



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

[sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

[Dennis Clarke]

Seems to compile fine and yet "gmake test" failed with a less
then helpful "Error 2" :


.
.
.
sqlite3.c:
"sqlite3.c", line 20826: warning: implicit function declaration: 
localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)
"sqlite3.c", line 52491: warning: statement not reached 
(E_STATEMENT_NOT_REACHED)

gmake: *** [Makefile:1161: testfixture] Error 2


Configure was trivial and seems fine :

./configure --enable-shared --enable-static --enable-readline 
--enable-threadsafe


Not sure if perhaps I am doing something blatently wrong.

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

[sqlite] Building SQLite autoconf on SCO 5.0.7v

[David Nadle]

I ran into some trouble building sqlite-autoconf-3081101 on SCO 5.0.7v with GNU 
tools. I'm not so good with autoconf scripts, but I can tell you what changes 
had to be made to sqlite3.c and the Makefile to get a successful build. I hope 
this can get into a future configure script somehow...

1. In sqlite3.c, I had to add #include .

2. In the Makefile produced by configure, I had to change AR = false to AR = 
gar.

3. Also in the Makefile, I had to set LIBS = /usr/lib/libpthread.so 
/usr/lib/libsocket.so

I can provide more info if needed.

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Bill & Steve
Thanks guys
I am trying to learn and  make some progress with the information you both
provided.

On Mon, Apr 27, 2015 at 9:57 AM, Steven M. McNeese <
steven.mcneese at freedomparkdfw.com> wrote:

> Jay,
>
> I don't do VB.Net development but it should be very similar to C#.Net in
> Visual Studio.  Try to follow these steps:
>
> 1. Add a Dataset Item to your project.  I think you have done this already.
> Once the Dataset is created you will get a blank dataset designer, create a
> connection to your Sqlite database on the server explorer panel.  Drag the
> tables/views you want into the dataset designer.
> 2. Once you save that dataset, you will see the Dataset and corresponding
> Table Adapter in your project components list on the toolbox
> 3. Drag your dataset and table adapter onto your form that contains the
> control that you want to bind to
> 4. In the toolbox under data controls, drag a Binding Source to your form
> 5. Select the binding source and on the properties, set the DataSource to
> your dataset added in step 1; set the data member to the table or view
> added
> to your dataset in step 1
> 6. For each form control you want to bind to a column from your dataset,
> select the control on properties under databindings, click the attribute
> (like Text for a textbox) and drill into the Binding Source created in step
> 4, then the data table and finally the column you want.
>
> Like I said, this is how you do it in C#.net and it is probably very
> similar
> if not exactly the same way for VB.net.
>
> Steve
>
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org
> [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Drago,
> William @ CSG - NARDA-MITEQ
> Sent: Monday, April 27, 2015 8:38 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] building SQLite DLL with Visual C++
>
> I'm afraid I can't help you with that, Jay. I don't use data bindings and
> all that other built-in visual studio db stuff because performance is slow
> and it's hard to maintain. I just read from the db into a data table. From
> there you can do whatever you want with the data.
>
> Search on line for VB.NET examples and I'm sure you'll find some examples.
>
> Good luck,
> --
> Bill Drago
> Senior Engineer
> L3 Narda-MITEQ
> 435 Moreland Road
> Hauppauge, NY 11788
> 631-272-5947 / William.Drago at L-3COM.com
>
>
> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > Sent: Sunday, April 26, 2015 3:44 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> >
> > Thanks Bill
> >
> > That worked
> >
> > BUT
> >
> > In my form when I go to "DataBindings" I get a Pop-up to "Add Project
> > Datasource" then the 2 screens to choose Datasource Type( I select
> > Database) then I choose DataSet. This is where it breaks down."Choose
> > Data Connection there are 4 choices "Access" and 3 server types, then
> > there is  which I select. And that leaves me with a single
> > "Data provider"
> > Microsoft OLE DB simple provider  This connection works, but is it
> > correct?
> > The connection is MSDAOSP
> >
> > Then I get to the screen "Choose your database objects" and an ERROR
> >
> > "Selecting Objects of type 'Table' is not supported.
> >
> > Then we get to the next part of the problem. I am in my late 70's and
> > have not done any SQL for over 15 years ( I was pretty good at one
> > time.) Where do I go from here.
> >
> > Jay
> >
> > On Sat, Apr 25, 2015 at 5:12 PM, Drago, William @ CSG - NARDA-MITEQ <
> > William.Drago at l-3com.com> wrote:
> >
> > > I don't know what error you're getting so I can't offer specific
> > help.
> > >
> > > This is what works for us:
> > >
> > > Open your project in Visual Studio.
> > >
> > > Click Tools > NuGet Package Manager > Manage NuGet Packages for
> > Solution...
> > >
> > > Select Online > nugget.org
> > >
> > > In the search box enter system.data.sqlite
> > >
> > > A list of packages should be displayed after a short wait.
> > >
> > > Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and
> > > Entity Framework support, select System.Data.SQLit

[sqlite] building SQLite DLL with Visual C++

[Drago, William @ CSG - NARDA-MITEQ]

I'm afraid I can't help you with that, Jay. I don't use data bindings and all 
that other built-in visual studio db stuff because performance is slow and it's 
hard to maintain. I just read from the db into a data table. From there you can 
do whatever you want with the data.

Search on line for VB.NET examples and I'm sure you'll find some examples.

Good luck,
--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com


> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> Sent: Sunday, April 26, 2015 3:44 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] building SQLite DLL with Visual C++
>
> Thanks Bill
>
> That worked
>
> BUT
>
> In my form when I go to "DataBindings" I get a Pop-up to "Add Project
> Datasource" then the 2 screens to choose Datasource Type( I select
> Database) then I choose DataSet. This is where it breaks down."Choose
> Data Connection there are 4 choices "Access" and 3 server types, then
> there is  which I select. And that leaves me with a single "Data
> provider"
> Microsoft OLE DB simple provider  This connection works, but is it
> correct?
> The connection is MSDAOSP
>
> Then I get to the screen "Choose your database objects" and an ERROR
>
> "Selecting Objects of type 'Table' is not supported.
>
> Then we get to the next part of the problem. I am in my late 70's and
> have not done any SQL for over 15 years ( I was pretty good at one
> time.) Where do I go from here.
>
> Jay
>
> On Sat, Apr 25, 2015 at 5:12 PM, Drago, William @ CSG - NARDA-MITEQ <
> William.Drago at l-3com.com> wrote:
>
> > I don't know what error you're getting so I can't offer specific
> help.
> >
> > This is what works for us:
> >
> > Open your project in Visual Studio.
> >
> > Click Tools > NuGet Package Manager > Manage NuGet Packages for
> Solution...
> >
> > Select Online > nugget.org
> >
> > In the search box enter system.data.sqlite
> >
> > A list of packages should be displayed after a short wait.
> >
> > Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and
> > Entity Framework support, select System.Data.SQLite (x86/x64), then
> > click Install (we use Core here)
> >
> > After installation you should see a little green checkmark next to
> the
> > package you selected.
> >
> > Click Close and you're done. Check on line for VB.NET code samples
> > using SQLITE.
> >
> > Good luck,
> >
> > --
> > Bill Drago
> > Senior Engineer
> > L3 Narda-MITEQ
> > 435 Moreland Road
> > Hauppauge, NY 11788
> > 631-272-5947 / William.Drago at L-3COM.com
> >
> >
> >
> > > -Original Message-
> > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > > Sent: Saturday, April 25, 2015 3:50 PM
> > > To: General Discussion of SQLite Database
> > > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> > >
> > > Hi Bill
> > >
> > > I have been trying for 2 days and I am totally lost.
> > >
> > > I have NuGet Package Manager. I don't know how to use it.
> > >
> > > From the  PM>   System.Data.SQLiteI get an error.
> > >
> > > Can you be a little more specific.
> > >
> > > Jay
> > >
> > > On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ
> > > < William.Drago at l-3com.com> wrote:
> > >
> > > > > -Original Message-
> > > > > From: sqlite-users-bounces at mailinglists.sqlite.org
> > > > > [mailto:sqlite- users-bounces at mailinglists.sqlite.org] On
> Behalf
> > > > > Of Jay Smith
> > > > > Sent: Thursday, April 23, 2015 3:47 PM
> > > > > To: General Discussion of SQLite Database
> > > > > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> > > > >
> > > > > Thank you Adam for responding to my post. I have the windows
> > > > > binaries downloaded.
> > > > >
> > > > > At this point I am just following the instructions in the book.
> > > > > And I really am not sure what I need the dll for.
> > &

[sqlite] building SQLite DLL with Visual C++

[Steven M. McNeese]

Jay,

I don't do VB.Net development but it should be very similar to C#.Net in
Visual Studio.  Try to follow these steps:

1. Add a Dataset Item to your project.  I think you have done this already.
Once the Dataset is created you will get a blank dataset designer, create a
connection to your Sqlite database on the server explorer panel.  Drag the
tables/views you want into the dataset designer.
2. Once you save that dataset, you will see the Dataset and corresponding
Table Adapter in your project components list on the toolbox
3. Drag your dataset and table adapter onto your form that contains the
control that you want to bind to
4. In the toolbox under data controls, drag a Binding Source to your form
5. Select the binding source and on the properties, set the DataSource to
your dataset added in step 1; set the data member to the table or view added
to your dataset in step 1
6. For each form control you want to bind to a column from your dataset,
select the control on properties under databindings, click the attribute
(like Text for a textbox) and drill into the Binding Source created in step
4, then the data table and finally the column you want.

Like I said, this is how you do it in C#.net and it is probably very similar
if not exactly the same way for VB.net. 

Steve  

-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Drago,
William @ CSG - NARDA-MITEQ
Sent: Monday, April 27, 2015 8:38 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] building SQLite DLL with Visual C++

I'm afraid I can't help you with that, Jay. I don't use data bindings and
all that other built-in visual studio db stuff because performance is slow
and it's hard to maintain. I just read from the db into a data table. From
there you can do whatever you want with the data.

Search on line for VB.NET examples and I'm sure you'll find some examples.

Good luck,
--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com


> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- 
> users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> Sent: Sunday, April 26, 2015 3:44 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] building SQLite DLL with Visual C++
>
> Thanks Bill
>
> That worked
>
> BUT
>
> In my form when I go to "DataBindings" I get a Pop-up to "Add Project 
> Datasource" then the 2 screens to choose Datasource Type( I select
> Database) then I choose DataSet. This is where it breaks down."Choose 
> Data Connection there are 4 choices "Access" and 3 server types, then 
> there is  which I select. And that leaves me with a single 
> "Data provider"
> Microsoft OLE DB simple provider  This connection works, but is it 
> correct?
> The connection is MSDAOSP
>
> Then I get to the screen "Choose your database objects" and an ERROR
>
> "Selecting Objects of type 'Table' is not supported.
>
> Then we get to the next part of the problem. I am in my late 70's and 
> have not done any SQL for over 15 years ( I was pretty good at one
> time.) Where do I go from here.
>
> Jay
>
> On Sat, Apr 25, 2015 at 5:12 PM, Drago, William @ CSG - NARDA-MITEQ < 
> William.Drago at l-3com.com> wrote:
>
> > I don't know what error you're getting so I can't offer specific
> help.
> >
> > This is what works for us:
> >
> > Open your project in Visual Studio.
> >
> > Click Tools > NuGet Package Manager > Manage NuGet Packages for
> Solution...
> >
> > Select Online > nugget.org
> >
> > In the search box enter system.data.sqlite
> >
> > A list of packages should be displayed after a short wait.
> >
> > Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and 
> > Entity Framework support, select System.Data.SQLite (x86/x64), then 
> > click Install (we use Core here)
> >
> > After installation you should see a little green checkmark next to
> the
> > package you selected.
> >
> > Click Close and you're done. Check on line for VB.NET code samples 
> > using SQLITE.
> >
> > Good luck,
> >
> > --
> > Bill Drago
> > Senior Engineer
> > L3 Narda-MITEQ
> > 435 Moreland Road
> > Hauppauge, NY 11788
> > 631-272-5947 / William.Drago at L-3COM.com
> >
> >
> >
> > > -Original Message-
> > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- 
> > > users-bounces at mailinglists.sql

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Thanks Bill

That worked

BUT

In my form when I go to "DataBindings" I get a Pop-up to "Add Project
Datasource" then the 2 screens to choose Datasource Type( I select
Database) then I choose DataSet. This is where it breaks down."Choose Data
Connection there are 4 choices "Access" and 3 server types, then there is
 which I select. And that leaves me with a single "Data provider"
Microsoft OLE DB simple provider  This connection works, but is it correct?
The connection is MSDAOSP

Then I get to the screen "Choose your database objects" and an ERROR

"Selecting Objects of type 'Table' is not supported.

Then we get to the next part of the problem. I am in my late 70's and have
not done any SQL for over 15 years ( I was pretty good at one time.) Where
do I go from here.

Jay

On Sat, Apr 25, 2015 at 5:12 PM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:

> I don't know what error you're getting so I can't offer specific help.
>
> This is what works for us:
>
> Open your project in Visual Studio.
>
> Click Tools > NuGet Package Manager > Manage NuGet Packages for Solution...
>
> Select Online > nugget.org
>
> In the search box enter system.data.sqlite
>
> A list of packages should be displayed after a short wait.
>
> Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and Entity
> Framework support, select System.Data.SQLite (x86/x64), then click Install
> (we use Core here)
>
> After installation you should see a little green checkmark next to the
> package you selected.
>
> Click Close and you're done. Check on line for VB.NET code samples using
> SQLITE.
>
> Good luck,
>
> --
> Bill Drago
> Senior Engineer
> L3 Narda-MITEQ
> 435 Moreland Road
> Hauppauge, NY 11788
> 631-272-5947 / William.Drago at L-3COM.com
>
>
>
> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > Sent: Saturday, April 25, 2015 3:50 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> >
> > Hi Bill
> >
> > I have been trying for 2 days and I am totally lost.
> >
> > I have NuGet Package Manager. I don't know how to use it.
> >
> > From the  PM>   System.Data.SQLiteI get an error.
> >
> > Can you be a little more specific.
> >
> > Jay
> >
> > On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ <
> > William.Drago at l-3com.com> wrote:
> >
> > > > -Original Message-
> > > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > > > Sent: Thursday, April 23, 2015 3:47 PM
> > > > To: General Discussion of SQLite Database
> > > > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> > > >
> > > > Thank you Adam for responding to my post. I have the windows
> > > > binaries downloaded.
> > > >
> > > > At this point I am just following the instructions in the book. And
> > > > I really am not sure what I need the dll for.
> > > >
> > > > Here's the scenario. I have created a program in vb2012. The
> > program
> > > > stores less than 20 fields of data. I am currently saving the data
> > > > in a html format. I just recently discovered SQLite. I am now in
> > the
> > > > process of changing over to a database to store data. I studied SQL
> > > > and Oracle
> > > > 10 years ago. I have almost completed the database for the project.
> > > > My problem is how to integrate the SQL db into my VB program.
> > >
> > > Your subject line says C++, but the line above says VB, so is your
> > > program written in C++ or VB?
> > > If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager,
> > > then search for System.Data.SQLite Core).
> > >
> > > -Bill
> > >
> > >
> > > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and
> > > any attachments are solely for the use of the addressee and may
> > > contain information that is privileged or confidential. Any
> > > disclosure, use or distribution of the information contained herein
> > is
> > > prohibited. In the event this e-mail contains technical da

[sqlite] building SQLite DLL with Visual C++

[Drago, William @ CSG - NARDA-MITEQ]

I don't know what error you're getting so I can't offer specific help.

This is what works for us:

Open your project in Visual Studio.

Click Tools > NuGet Package Manager > Manage NuGet Packages for Solution...

Select Online > nugget.org

In the search box enter system.data.sqlite

A list of packages should be displayed after a short wait.

Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and Entity 
Framework support, select System.Data.SQLite (x86/x64), then click Install
(we use Core here)

After installation you should see a little green checkmark next to the package 
you selected.

Click Close and you're done. Check on line for VB.NET code samples using SQLITE.

Good luck,

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com



> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> Sent: Saturday, April 25, 2015 3:50 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] building SQLite DLL with Visual C++
>
> Hi Bill
>
> I have been trying for 2 days and I am totally lost.
>
> I have NuGet Package Manager. I don't know how to use it.
>
> From the  PM>   System.Data.SQLiteI get an error.
>
> Can you be a little more specific.
>
> Jay
>
> On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ <
> William.Drago at l-3com.com> wrote:
>
> > > -Original Message-
> > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > > Sent: Thursday, April 23, 2015 3:47 PM
> > > To: General Discussion of SQLite Database
> > > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> > >
> > > Thank you Adam for responding to my post. I have the windows
> > > binaries downloaded.
> > >
> > > At this point I am just following the instructions in the book. And
> > > I really am not sure what I need the dll for.
> > >
> > > Here's the scenario. I have created a program in vb2012. The
> program
> > > stores less than 20 fields of data. I am currently saving the data
> > > in a html format. I just recently discovered SQLite. I am now in
> the
> > > process of changing over to a database to store data. I studied SQL
> > > and Oracle
> > > 10 years ago. I have almost completed the database for the project.
> > > My problem is how to integrate the SQL db into my VB program.
> >
> > Your subject line says C++, but the line above says VB, so is your
> > program written in C++ or VB?
> > If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager,
> > then search for System.Data.SQLite Core).
> >
> > -Bill
> >
> >
> > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and
> > any attachments are solely for the use of the addressee and may
> > contain information that is privileged or confidential. Any
> > disclosure, use or distribution of the information contained herein
> is
> > prohibited. In the event this e-mail contains technical data within
> > the definition of the International Traffic in Arms Regulations or
> > Export Administration Regulations, it is subject to the export
> control
> > laws of the U.S.Government. The recipient should check this e-mail
> and
> > any attachments for the presence of viruses as L-3 does not accept
> any
> > liability associated with the transmission of this e-mail. If you
> have
> > received this communication in error, please notify the sender by
> > reply e-mail and immediately delete this message and any attachments.
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Hi Bill

I have been trying for 2 days and I am totally lost.

I have NuGet Package Manager. I don't know how to use it.

>From the  PM>   System.Data.SQLiteI get an error.

Can you be a little more specific.

Jay

On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:

> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > Sent: Thursday, April 23, 2015 3:47 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> >
> > Thank you Adam for responding to my post. I have the windows binaries
> > downloaded.
> >
> > At this point I am just following the instructions in the book. And I
> > really am not sure what I need the dll for.
> >
> > Here's the scenario. I have created a program in vb2012. The program
> > stores less than 20 fields of data. I am currently saving the data in a
> > html format. I just recently discovered SQLite. I am now in the process
> > of changing over to a database to store data. I studied SQL and Oracle
> > 10 years ago. I have almost completed the database for the project.  My
> > problem is how to integrate the SQL db into my VB program.
>
> Your subject line says C++, but the line above says VB, so is your program
> written in C++ or VB?
> If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager, then
> search for System.Data.SQLite Core).
>
> -Bill
>
>
> CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any
> attachments are solely for the use of the addressee and may contain
> information that is privileged or confidential. Any disclosure, use or
> distribution of the information contained herein is prohibited. In the
> event this e-mail contains technical data within the definition of the
> International Traffic in Arms Regulations or Export Administration
> Regulations, it is subject to the export control laws of the
> U.S.Government. The recipient should check this e-mail and any attachments
> for the presence of viruses as L-3 does not accept any liability associated
> with the transmission of this e-mail. If you have received this
> communication in error, please notify the sender by reply e-mail and
> immediately delete this message and any attachments.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Thanks Bill
I got in a hurry and was trying to follow the book.
I have never used C++ so the subject line is wrong.
I am now looking into NuGet and will get back if I need more help (and I am
sure I will.)
Jay


On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:

> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > Sent: Thursday, April 23, 2015 3:47 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> >
> > Thank you Adam for responding to my post. I have the windows binaries
> > downloaded.
> >
> > At this point I am just following the instructions in the book. And I
> > really am not sure what I need the dll for.
> >
> > Here's the scenario. I have created a program in vb2012. The program
> > stores less than 20 fields of data. I am currently saving the data in a
> > html format. I just recently discovered SQLite. I am now in the process
> > of changing over to a database to store data. I studied SQL and Oracle
> > 10 years ago. I have almost completed the database for the project.  My
> > problem is how to integrate the SQL db into my VB program.
>
> Your subject line says C++, but the line above says VB, so is your program
> written in C++ or VB?
> If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager, then
> search for System.Data.SQLite Core).
>
> -Bill
>
>
> CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any
> attachments are solely for the use of the addressee and may contain
> information that is privileged or confidential. Any disclosure, use or
> distribution of the information contained herein is prohibited. In the
> event this e-mail contains technical data within the definition of the
> International Traffic in Arms Regulations or Export Administration
> Regulations, it is subject to the export control laws of the
> U.S.Government. The recipient should check this e-mail and any attachments
> for the presence of viruses as L-3 does not accept any liability associated
> with the transmission of this e-mail. If you have received this
> communication in error, please notify the sender by reply e-mail and
> immediately delete this message and any attachments.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Thanks Adam
I will take a look
Jay

On Thu, Apr 23, 2015 at 4:19 PM, Adam Devita  wrote:

> Good day,
> I don't work in VB, so I can't help you in specifics on that. A quick
> search on a search engine  pops up some videos on how to use sqlite in
> a Visual Basic project.  The archives of this list have a lot of
> questions where people are introduced to open, prep sql, (bind), step,
> fetch, finalize, close. It is often a good idea to specify which book
> you are working through for a question relating to a published
> tutorial, as some future person may be reading the same book and could
> find the thread helpful.  Some people on the list likely have a copy
> of the same book on their shelf.  Someone on  this list might even be
> the author.
>
> Adam
>
>
>
>
> On Thu, Apr 23, 2015 at 3:47 PM, Jay Smith  wrote:
> > Thank you Adam for responding to my post. I have the windows binaries
> > downloaded.
> >
> > At this point I am just following the instructions in the book. And I
> > really am not sure what I need the dll for.
> >
> > Here's the scenario. I have created a program in vb2012. The program
> stores
> > less than 20 fields of data. I am currently saving the data in a html
> > format. I just recently discovered SQLite. I am now in the process of
> > changing over to a database to store data. I studied SQL and Oracle 10
> > years ago. I have almost completed the database for the project.  My
> > problem is how to integrate the SQL db into my VB program.
> >
> > On Wed, Apr 22, 2015 at 10:16 AM, Adam Devita 
> wrote:
> >
> >> Good day,
> >>
> >>
> >> Why are you compiling a dll instead of using the pre-compiled windows
> >> binaries at http://www.sqlite.org/download.html?
> >>
> >> Are you adding some sort of extra wrapper?
> >>
> >> Why are you not adding the amalgamated c source in your project (turn
> >> off use pre-compiled headers for that file) ?
> >>
> >> If you insist on creating your own dll, try the vs wizard to create a
> >> dll project, then add code to it.
> >>
> >> regards,
> >> Adam DeVita
> >>
> >>
> >> On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik 
> >> wrote:
> >> > On 4/21/2015 11:01 AM, Jay Smith wrote:
> >> >>
> >> >> Before I sent the last message I had signed up to become a user.
> >> >> My previous message was bounced.  WHY
> >> >
> >> >
> >> > I, for one, have received both your original and this new message.
> >> > --
> >> > Igor Tandetnik
> >> >
> >> >
> >> > ___
> >> > sqlite-users mailing list
> >> > sqlite-users at mailinglists.sqlite.org
> >> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >>
> >>
> >>
> >> --
> >> --
> >> VerifEye Technologies Inc.
> >> 151 Whitehall Dr. Unit 2
> >> Markham, ON
> >> L3R 9T1
> >> ___
> >> sqlite-users mailing list
> >> sqlite-users at mailinglists.sqlite.org
> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >>
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> --
> --
> VerifEye Technologies Inc.
> 151 Whitehall Dr. Unit 2
> Markham, ON
> L3R 9T1
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] building SQLite DLL with Visual C++

[Drago, William @ CSG - NARDA-MITEQ]

> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> Sent: Thursday, April 23, 2015 3:47 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] building SQLite DLL with Visual C++
>
> Thank you Adam for responding to my post. I have the windows binaries
> downloaded.
>
> At this point I am just following the instructions in the book. And I
> really am not sure what I need the dll for.
>
> Here's the scenario. I have created a program in vb2012. The program
> stores less than 20 fields of data. I am currently saving the data in a
> html format. I just recently discovered SQLite. I am now in the process
> of changing over to a database to store data. I studied SQL and Oracle
> 10 years ago. I have almost completed the database for the project.  My
> problem is how to integrate the SQL db into my VB program.

Your subject line says C++, but the line above says VB, so is your program 
written in C++ or VB?
If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager, then 
search for System.Data.SQLite Core).

-Bill


CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] building SQLite DLL with Visual C++

[Adam Devita]

Good day,
I don't work in VB, so I can't help you in specifics on that. A quick
search on a search engine  pops up some videos on how to use sqlite in
a Visual Basic project.  The archives of this list have a lot of
questions where people are introduced to open, prep sql, (bind), step,
fetch, finalize, close. It is often a good idea to specify which book
you are working through for a question relating to a published
tutorial, as some future person may be reading the same book and could
find the thread helpful.  Some people on the list likely have a copy
of the same book on their shelf.  Someone on  this list might even be
the author.

Adam




On Thu, Apr 23, 2015 at 3:47 PM, Jay Smith  wrote:
> Thank you Adam for responding to my post. I have the windows binaries
> downloaded.
>
> At this point I am just following the instructions in the book. And I
> really am not sure what I need the dll for.
>
> Here's the scenario. I have created a program in vb2012. The program stores
> less than 20 fields of data. I am currently saving the data in a html
> format. I just recently discovered SQLite. I am now in the process of
> changing over to a database to store data. I studied SQL and Oracle 10
> years ago. I have almost completed the database for the project.  My
> problem is how to integrate the SQL db into my VB program.
>
> On Wed, Apr 22, 2015 at 10:16 AM, Adam Devita  wrote:
>
>> Good day,
>>
>>
>> Why are you compiling a dll instead of using the pre-compiled windows
>> binaries at http://www.sqlite.org/download.html?
>>
>> Are you adding some sort of extra wrapper?
>>
>> Why are you not adding the amalgamated c source in your project (turn
>> off use pre-compiled headers for that file) ?
>>
>> If you insist on creating your own dll, try the vs wizard to create a
>> dll project, then add code to it.
>>
>> regards,
>> Adam DeVita
>>
>>
>> On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik 
>> wrote:
>> > On 4/21/2015 11:01 AM, Jay Smith wrote:
>> >>
>> >> Before I sent the last message I had signed up to become a user.
>> >> My previous message was bounced.  WHY
>> >
>> >
>> > I, for one, have received both your original and this new message.
>> > --
>> > Igor Tandetnik
>> >
>> >
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users at mailinglists.sqlite.org
>> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>>
>> --
>> --
>> VerifEye Technologies Inc.
>> 151 Whitehall Dr. Unit 2
>> Markham, ON
>> L3R 9T1
>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



-- 
--
VerifEye Technologies Inc.
151 Whitehall Dr. Unit 2
Markham, ON
L3R 9T1

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Thanks Igor
the only response I got to the first message was "it has been bounced"


On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik  wrote:

> On 4/21/2015 11:01 AM, Jay Smith wrote:
>
>> Before I sent the last message I had signed up to become a user.
>> My previous message was bounced.  WHY
>>
>
> I, for one, have received both your original and this new message.
> --
> Igor Tandetnik
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Thank you Adam for responding to my post. I have the windows binaries
downloaded.

At this point I am just following the instructions in the book. And I
really am not sure what I need the dll for.

Here's the scenario. I have created a program in vb2012. The program stores
less than 20 fields of data. I am currently saving the data in a html
format. I just recently discovered SQLite. I am now in the process of
changing over to a database to store data. I studied SQL and Oracle 10
years ago. I have almost completed the database for the project.  My
problem is how to integrate the SQL db into my VB program.

On Wed, Apr 22, 2015 at 10:16 AM, Adam Devita  wrote:

> Good day,
>
>
> Why are you compiling a dll instead of using the pre-compiled windows
> binaries at http://www.sqlite.org/download.html?
>
> Are you adding some sort of extra wrapper?
>
> Why are you not adding the amalgamated c source in your project (turn
> off use pre-compiled headers for that file) ?
>
> If you insist on creating your own dll, try the vs wizard to create a
> dll project, then add code to it.
>
> regards,
> Adam DeVita
>
>
> On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik 
> wrote:
> > On 4/21/2015 11:01 AM, Jay Smith wrote:
> >>
> >> Before I sent the last message I had signed up to become a user.
> >> My previous message was bounced.  WHY
> >
> >
> > I, for one, have received both your original and this new message.
> > --
> > Igor Tandetnik
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> --
> --
> VerifEye Technologies Inc.
> 151 Whitehall Dr. Unit 2
> Markham, ON
> L3R 9T1
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] building SQLite DLL with Visual C++

[Adam Devita]

Good day,


Why are you compiling a dll instead of using the pre-compiled windows
binaries at http://www.sqlite.org/download.html?

Are you adding some sort of extra wrapper?

Why are you not adding the amalgamated c source in your project (turn
off use pre-compiled headers for that file) ?

If you insist on creating your own dll, try the vs wizard to create a
dll project, then add code to it.

regards,
Adam DeVita


On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik  wrote:
> On 4/21/2015 11:01 AM, Jay Smith wrote:
>>
>> Before I sent the last message I had signed up to become a user.
>> My previous message was bounced.  WHY
>
>
> I, for one, have received both your original and this new message.
> --
> Igor Tandetnik
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



-- 
--
VerifEye Technologies Inc.
151 Whitehall Dr. Unit 2
Markham, ON
L3R 9T1

[sqlite] building SQLite DLL with Visual C++

[Igor Tandetnik]

On 4/21/2015 11:01 AM, Jay Smith wrote:
> Before I sent the last message I had signed up to become a user.
> My previous message was bounced.  WHY

I, for one, have received both your original and this new message.
-- 
Igor Tandetnik

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Dear sir
Before I sent the last message I had signed up to become a user.
My previous message was bounced.  WHY
copy of previous message:

I am new to SQLite. I have a book I am learning from and I am a novice.

I have a fairly good handle on SQL

I want to include SQLite in my VS2012 program.

I am attempting to run " LIB  /DEF:sqlite3.def "

I get error This error "LIB is not recognized as an internal or external
command."

What am I doing wrong?

On Mon, Apr 20, 2015 at 10:21 AM, Jay Smith  wrote:

> I am new to SQLite. I have a book I am learning from and I am a novice.
>
> I have a fairly good handle on SQL
>
> I want to include SQLite in my VS2012 program.
>
> I am attempting to run " LIB  /DEF:sqlite3.def "
>
> I get error This error "LIB is not recognized as an internal or external
> command."
>
> What am I doing wrong?
>
> Jay
>

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

I am new to SQLite. I have a book I am learning from and I am a novice.

I have a fairly good handle on SQL

I want to include SQLite in my VS2012 program.

I am attempting to run " LIB  /DEF:sqlite3.def "

I get error This error "LIB is not recognized as an internal or external
command."

What am I doing wrong?

Jay

[sqlite] Building SQLite 3.7.14.1 for OpenVMS

[Maxim Zinal]

Hello and have a good time of day!

Some time ago I've posted a patch which allowed to compile and use SQLite
3.7.9 under OpenVMS operating system:

http://sqlite.1065341.n5.nabble.com/Port-of-SQLite-3-7-9-to-OpenVMS-td55734.html

http://sqlite.1065341.n5.nabble.com/Port-of-SQLite-3-7-9-to-OpenVMS-patch-td55735.html

Now I have a somewhat improved version of that patch, which can be used
with 3.7.14.1 SQLite amalgamation. I used some tricks from
http://www.vmspython.org/ version of SQLite, and invented some new.

Database locking still doesn't work (use "unix-none" driver argument of
sqlite3_open_v2(), or you will get a "Database is locked" message). I just
cannot figure out why does SQLite POSIX advisory locking code fail to work
under OpenVMS, and I plan to write a specific question to some VMS
programming user group.

To compile a patched sqlite3.c, use the following DCL script (mostly taken
from http://www.vmspython.org/):

 BEGIN sqlite3vms.com
$ vmsver = f$getsyi("VERSION")
$ if vmsver .ges. "V8.2"
$ then
$   cc/opt/define=(NO_GETTOD,RTLD_GLOBAL=0,_USE_STD_STAT=1,-
_LARGEFILE,_POSIX_EXIT=1) -
/float=ieee/ieee=denorm -
sqlite3.c
$ else
$   cc/opt/define=(NO_GETTOD,RTLD_GLOBAL=0, _LARGEFILE,-
__USE_INO64=1,_POSIX_EXIT=1) -
/float=ieee/ieee=denorm -
sqlite3.c
$ endif
 END sqlite3vms.com

Best regards,
  Maxim Zinal

P.S. And this is a patch itself:

 BEGIN sqlite-3.7.14.1-vms.patch
diff -urb sqlite-3.7.14.1/sqlite3.c sqlite-3.7.14.1-vms/sqlite3.c
--- sqlite-3.7.14.1/sqlite3.c 2012-10-04 23:49:28.0 +0400
+++ sqlite-3.7.14.1-vms/sqlite3.c 2012-10-31 22:48:37.391310431 +0400
@@ -71,6 +71,15 @@
 #endif

 /*
+** Under VMS, dirsync must be disabled
+ */
+#ifdef __VMS
+# ifndef SQLITE_DISABLE_DIRSYNC
+#  define SQLITE_DISABLE_DIRSYNC 1
+# endif
+#endif
+
+/*
 ** Include the configuration header output by 'configure' if we're using
the
 ** autoconf-based build
 */
@@ -316,6 +325,10 @@
 #include 
 #endif

+#ifdef __VMS
+#include 
+#endif
+
 /*
 ** The following macros are used to cast pointers to integers and
 ** integers to pointers.  The way you do this varies from one compiler
@@ -14888,8 +14901,15 @@
   DO_OS_MALLOC_TEST(id);
   return id->pMethods->xSync(id, flags);
 }
+#ifdef __VMS
+SQLITE_PRIVATE int _vms_fsync(sqlite3_file *);
+#endif
 SQLITE_PRIVATE int sqlite3OsFileSize(sqlite3_file *id, i64 *pSize){
   DO_OS_MALLOC_TEST(id);
+#ifdef __VMS
+  int rc = _vms_fsync(id);
+  if ( rc!=0 ) return rc;
+#endif
   return id->pMethods->xFileSize(id, pSize);
 }
 SQLITE_PRIVATE int sqlite3OsLock(sqlite3_file *id, int lockType){
@@ -23060,6 +23080,12 @@
 #define threadid 0
 #endif

+#ifdef __VMS
+static char *posixGetcwd(char *buf, size_t size) {
+  return getcwd(buf, size, 0);
+}
+#endif
+
 /*
 ** Different Unix systems declare open() in different ways.  Same use
 ** open(const char*,int,mode_t).  Others use open(const char*,int,...).
@@ -23069,7 +23095,20 @@
 ** which always has the same well-defined interface.
 */
 static int posixOpen(const char *zFile, int flags, int mode){
+#ifdef __VMS
+  if ( (flags & O_NDELAY) == 0 ) {
+/* Normal file */
+return open(zFile, flags, mode,
+ "shr = del, get, put, upd", "ctx = stm", "ctx = bin");
+  } else {
+/* Temporary file - delete on close */
+flags &= ~O_NDELAY;
+return open(zFile, flags, mode, "fop = dlt, tmp",
+ "shr = del, get, put, upd", "ctx = stm", "ctx = bin");
+  }
+#else
   return open(zFile, flags, mode);
+#endif
 }

 /*
@@ -23104,7 +23143,11 @@
   { "access",   (sqlite3_syscall_ptr)access, 0  },
 #define osAccess((int(*)(const char*,int))aSyscall[2].pCurrent)

+#ifdef __VMS
+  { "getcwd",   (sqlite3_syscall_ptr)posixGetcwd,0  },
+#else
   { "getcwd",   (sqlite3_syscall_ptr)getcwd, 0  },
+#endif
 #define osGetcwd((char*(*)(char*,size_t))aSyscall[3].pCurrent)

   { "stat", (sqlite3_syscall_ptr)stat,   0  },
@@ -23390,7 +23433,7 @@
 zOpName = "SETLK";
   }else{
 s = osFcntl(fd, op, p);
-sqlite3DebugPrintf("fcntl unknown %d %d %d\n", fd, op, s);
+sqlite3DebugPrintf("fcntl unknown FD=%d OP=%d S=%d\n", fd, op, s);
 return s;
   }
   if( p->l_type==F_RDLCK ){
@@ -23405,9 +23448,9 @@
   assert( p->l_whence==SEEK_SET );
   s = osFcntl(fd, op, p);
   savedErrno = errno;
-  sqlite3DebugPrintf("fcntl %d %d %s %s %d %d %d %d\n",
+  sqlite3DebugPrintf("fcntl T=%d FD=%d %s %s LS=%d LL=%d PID=%d S=%d
ERR=%d\n",
  threadid, fd, zOpName, zType, (int)p->l_start, (int)p->l_len,
- (int)p->l_pid, s);
+ (int)p->l_pid, s, savedErrno);
   if( s==(-1) && op==F_SETLK && (p->l_type==F_RDLCK || p->l_type==F_WRLCK)
){
 struct flock l2;
 l2 = *p;
@@ -23421,7 +23464,7 @@
 }else{
   assert( 0 );
 }
-sqlite3DebugPrintf("fcntl-failure-reason: %s %d %d %d\n",
+sqlite3DebugPrintf("fcntl-failure-reason: %s LS=%d LL=%d PID=%d\n",
zType, (int)l2.l_start, (int)l2.l_len, (int)l2.l_pid);
   }
   errno = savedErrno;

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Simon Slavin]

On 15 Oct 2012, at 10:41pm, "Caleb A. Austin"  wrote:

> There is one odd part to all this
> 
> FILE *fp;
>  fp = fopen("/release/sql/MYFILE.txt", "a");
>  fprintf(fp, "%s\n ", "Hello World, Where there is will, there is a
> way.");
>  fclose(fp) ;
> 
> This works... but SQLite does not running the program multiple
> times, adds lines to the txt file. So the full path in SQLite does not
> work as I would expect

My guess is that you have amend privileges over the existing database file, but 
not enough privileges to create the journal file.  I'm glad to see that you 
have solved the problem.

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Got IT!  The release directory is not a valid location to place the
file... this works:

/Storage_Card/sql/count.db works as I would expect.

Thanks guys!

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Monday, October 15, 2012 2:33 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


On 15 Oct 2012, at 9:50pm, "Caleb A. Austin"  wrote:

> Hmm, I will try  a few other locations.  It seems that CE does not 
> have a local directory that windows does. So the 
> sqlite3_open(("count.db"), &db); even when run from /release/sql/ it 
> thinks the root is the local directory.

Okay, I thought you knew this.  Sorry for not posting earlier.  Windows
CE does not have anything like a local directory, a current directory or
a default directory.  Every create and open command must specify a full
path.  If you do not specify a full path random things may happen,
including different things on different platforms and in different
versions.  You must learn how your device organises data files for each
application, and specify a path that your application is allowed to keep
its files in.

This is described in detail in several programming sources for WinCE,
but you can find confirmation here:

<http://msdn.microsoft.com/en-us/library/ms900336.aspx>

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Simon, 

There is one odd part to all this

FILE *fp;
  fp = fopen("/release/sql/MYFILE.txt", "a");
  fprintf(fp, "%s\n ", "Hello World, Where there is will, there is a
way.");
  fclose(fp) ;

This works... but SQLite does not running the program multiple
times, adds lines to the txt file. So the full path in SQLite does not
work as I would expect

Caleb Austin

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Monday, October 15, 2012 2:33 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


On 15 Oct 2012, at 9:50pm, "Caleb A. Austin"  wrote:

> Hmm, I will try  a few other locations.  It seems that CE does not 
> have a local directory that windows does. So the 
> sqlite3_open(("count.db"), &db); even when run from /release/sql/ it 
> thinks the root is the local directory.

Okay, I thought you knew this.  Sorry for not posting earlier.  Windows
CE does not have anything like a local directory, a current directory or
a default directory.  Every create and open command must specify a full
path.  If you do not specify a full path random things may happen,
including different things on different platforms and in different
versions.  You must learn how your device organises data files for each
application, and specify a path that your application is allowed to keep
its files in.

This is described in detail in several programming sources for WinCE,
but you can find confirmation here:

<http://msdn.microsoft.com/en-us/library/ms900336.aspx>

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Simon, 

Thanks, no, I have not learned much about CE... it's a starting from the
ground up:(  I have been moving into a project that was going to be
handled by another engineer... So I am digging pretty deep to learn a
lot of stuff quickly.

Thanks for you link... that will likely answer the problem...

Caleb Austin

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Monday, October 15, 2012 2:33 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


On 15 Oct 2012, at 9:50pm, "Caleb A. Austin"  wrote:

> Hmm, I will try  a few other locations.  It seems that CE does not 
> have a local directory that windows does. So the 
> sqlite3_open(("count.db"), &db); even when run from /release/sql/ it 
> thinks the root is the local directory.

Okay, I thought you knew this.  Sorry for not posting earlier.  Windows
CE does not have anything like a local directory, a current directory or
a default directory.  Every create and open command must specify a full
path.  If you do not specify a full path random things may happen,
including different things on different platforms and in different
versions.  You must learn how your device organises data files for each
application, and specify a path that your application is allowed to keep
its files in.

This is described in detail in several programming sources for WinCE,
but you can find confirmation here:

<http://msdn.microsoft.com/en-us/library/ms900336.aspx>

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Simon Slavin]

On 15 Oct 2012, at 9:50pm, "Caleb A. Austin"  wrote:

> Hmm, I will try  a few other locations.  It seems that CE does not have
> a local directory that windows does. So the sqlite3_open(("count.db"),
> &db); even when run from /release/sql/ it thinks the root is the local
> directory.

Okay, I thought you knew this.  Sorry for not posting earlier.  Windows CE does 
not have anything like a local directory, a current directory or a default 
directory.  Every create and open command must specify a full path.  If you do 
not specify a full path random things may happen, including different things on 
different platforms and in different versions.  You must learn how your device 
organises data files for each application, and specify a path that your 
application is allowed to keep its files in.

This is described in detail in several programming sources for WinCE, but you 
can find confirmation here:



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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Hmm, I will try  a few other locations.  It seems that CE does not have
a local directory that windows does. So the sqlite3_open(("count.db"),
&db); even when run from /release/sql/ it thinks the root is the local
directory.

Thanks for you help... it has helped me to see what to do at times.
SQLite is a fairly complex set of code to learn about and build into a
working database, yet it has been possible to get it functional(still
have to work on the CE file path) database project in a fairly short
time. 

Thanks!

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Monday, October 15, 2012 10:55 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


Caleb A. Austin wrote:
> 
> What is odd, is that if I use the root folder then I don't get any 
> errors. Meaning if I use sqlite3_open(("count.db"), &db); I get a 
> created db file with content.
> 

Perhaps the other directory is actually a mount point to another file
system with different capabilities (e.g. a storage card)?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
> 
> What is odd, is that if I use the root folder then I don't get any
> errors. Meaning if I use sqlite3_open(("count.db"), &db); I get a
> created db file with content. 
> 

Perhaps the other directory is actually a mount point to another file
system with different capabilities (e.g. a storage card)?

--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

We are using a Windows CE based on TI's AM3517 SDK. 

What is odd, is that if I use the root folder then I don't get any
errors. Meaning if I use sqlite3_open(("count.db"), &db); I get a
created db file with content. 

I will  ask the people who are working on the SDK about the
FlushFileBuffers() and Win32 API details.

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Monday, October 15, 2012 10:08 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


Caleb A. Austin wrote:
>
> sqlite3_open(("/release/sql/count.db"), &db);
> 
> 1034: os_win.c: 32125: (50) winSync(/release/sql/count.db-journal)
> -osError 0x32
> (50)  ...
>
> ... create table fails... disk IO error

That error code is ERROR_NOT_SUPPORTED, coming from winSync(), which
probably means that the FlushFileBuffers() Win32 API is not implemented
for the operating system version you are using.

Is this a custom version of Windows CE?  If so, do you have any control
over the customizations?
 
--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
>
> sqlite3_open(("/release/sql/count.db"), &db);
> 
> 1034: os_win.c: 32125: (50) winSync(/release/sql/count.db-journal)
> -osError 0x32
> (50)  ...
>
> ... create table fails... disk IO error

That error code is ERROR_NOT_SUPPORTED, coming from winSync(), which
probably means that the FlushFileBuffers() Win32 API is not implemented
for the operating system version you are using.

Is this a custom version of Windows CE?  If so, do you have any control
over the customizations?
 
--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

sqlite3_open(("/release/sql/count.db"), &db);

1034: os_win.c: 32125: (50) winSync(/release/sql/count.db-journal)
-osError 0x32
(50)  ...

 ... create table fails... disk IO error




Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Friday, October 12, 2012 9:41 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


Caleb A. Austin wrote:
> 
> The top file operation works, but the sqlite3_open does not... 
> 
> Wondering if I need to compile an option for SQLite to be using the 
> correct file io for WEC7
> 

What return code is coming back from sqlite3_open()?  Can you enable
logging via the SQLITE_CONFIG_LOG configuration option before calling
any other SQLite APIs?

http://www.sqlite.org/c3ref/c_config_getmalloc.html#sqliteconfiglog

Example:

void logging_callback(void *notUsed, int iCode, const char *zErrmsg){
  /* handle output here... */
  fprintf(stdout, "%d: %s\n", iCode, zErrmsg); }

sqlite3_config(SQLITE_CONFIG_LOG, logging_callback, 0);

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
> 
> The top file operation works, but the sqlite3_open does not... 
> 
> Wondering if I need to compile an option for SQLite to be using the
> correct file io for WEC7
> 

What return code is coming back from sqlite3_open()?  Can you enable
logging via the SQLITE_CONFIG_LOG configuration option before calling
any other SQLite APIs?

http://www.sqlite.org/c3ref/c_config_getmalloc.html#sqliteconfiglog

Example:

void logging_callback(void *notUsed, int iCode, const char *zErrmsg){
  /* handle output here... */
  fprintf(stdout, "%d: %s\n", iCode, zErrmsg);
}

sqlite3_config(SQLITE_CONFIG_LOG, logging_callback, 0);

--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Here is what I  have come up with:

  FILE *fp;
  fp = fopen("\\release\\sql\\MYFILE.txt", "a");
  fprintf(fp, "%s\n ", "Hello World, Where there is will, there is a
way.");
  fclose(fp) ;

  sqlite3_open(("\\release\\sql\\count.db"), &db);

The top file operation works, but the sqlite3_open does not... 

Wondering if I need to compile an option for SQLite to be using the
correct file io for WEC7


Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Friday, October 12, 2012 10:39 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


Caleb A. Austin wrote:
>
> Any ideas on why the database is being placed in root and  not in
local?
>

My understanding is that Windows CE does not support the concept of a
current directory.  Therefore, in order for a file to be created in a
particular directory, the full path to the file must be specified (i.e.
in the call to sqlite3_open()).

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
> 
> I have tried:
> 
> sqlite3_open("/release/sql/countries.db", &db);
> 

I'm not sure if it will make a difference; however, I think Windows CE
may need backslashes, not forward slashes.

--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Thanks Joe, 

I have tried:

sqlite3_open("/release/sql/countries.db", &db);

but I get a 0 bytes countries.db in the "/release/sql/" folder  and then
a long list of SQL errors about no access to the database.  I think this
is a Windows CE issue... but asking here if someone has used SQLite on
Windows CE to help fix the problem.

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Friday, October 12, 2012 10:39 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


Caleb A. Austin wrote:
>
> Any ideas on why the database is being placed in root and  not in
local?
>

My understanding is that Windows CE does not support the concept of a
current directory.  Therefore, in order for a file to be created in a
particular directory, the full path to the file must be specified (i.e.
in the call to sqlite3_open()).

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
>
> Any ideas on why the database is being placed in root and  not in local?
>

My understanding is that Windows CE does not support the concept of a
current directory.  Therefore, in order for a file to be created in a
particular directory, the full path to the file must be specified (i.e.
in the call to sqlite3_open()).

--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Thanks Joe,

Yes, I will look at keeping the source code clean of any edits. This was
just a way to prove that it worked.

I have been able to run SQLite on the WEC7 board and  create tables/
inserts/ etc. So it looks like things are working correctly. I do have a
few questions though.

In short: The database is created in the root directory, not in the
local directory. And as such it does not find the database after being
closed.

I have the following setup:

My working directory:
/release/sql/
I run the following code in a program running from my working directory:
Sqlite_test.exe

..
  sqlite3_open("main.db", &db);
..

but the data base shows up in the root directory.

Root:
/main.db

Any ideas on why the database is being placed in root and  not in local?

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Thursday, October 11, 2012 12:35 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


Caleb A. Austin wrote:
> 
> Added near line 14092:
> #define HAVE_LOCALTIME_S 0 
> 

Since the SDK you are using does not appear to provide the localtime_s
function, even though it uses MSVC and its associated CRT, this makes
sense.  This could be defined in the Makefile and/or project properties
to avoid having to modify the source code.

> 
> Added near 14109:
> struct tm *__cdecl localtime(const time_t *t);
> 

Since  is included, this should not be required.  I'm not sure
exactly which SDK you are using; however, it appears that it may not be
fully ANSI compliant?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
> 
> Added near line 14092:
> #define HAVE_LOCALTIME_S 0 
> 

Since the SDK you are using does not appear to provide the localtime_s
function, even though it uses MSVC and its associated CRT, this makes
sense.  This could be defined in the Makefile and/or project properties
to avoid having to modify the source code.

> 
> Added near 14109:
> struct tm *__cdecl localtime(const time_t *t);
> 

Since  is included, this should not be required.  I'm not sure
exactly which SDK you are using; however, it appears that it may not be
fully ANSI compliant?

--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
> 
> Is there a known Windows CE build that could be used as a reference to
> set my project settings up with?
> 

This WinCE project file is used with the System.Data.SQLite project:

http://system.data.sqlite.org/index.html/artifact?ci=trunk&filename=SQLite.I
nterop/SQLite.Interop.CE.2008.vcproj

--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

I may have found the fix to my first issue with compiling SQLite for
Windows CE. The following items are what I changed:

In the SQLite3.c file

Added near line 14092:
#define HAVE_LOCALTIME_S 0

Just above:

#if !defined(HAVE_LOCALTIME_R) && !defined(HAVE_LOCALTIME_S) && \
 defined(_MSC_VER) && defined(_CRT_INSECURE_DEPRECATE)
#define HAVE_LOCALTIME_S 1
#endif

#ifndef SQLITE_OMIT_LOCALTIME
/*
** The following routine implements the rough equivalent of
localtime_r()
** using whatever operating-system specific localtime facility that
** is available.  This routine returns 0 on success and
** non-zero on any kind of error.
**
** If the sqlite3GlobalConfig.bLocaltimeFault variable is true then this
** routine will always fail.
*/



Added near 14109:
struct tm *__cdecl localtime(const time_t *t);

just above:

static int osLocaltime(time_t *t, struct tm *pTm){


The project now compiles... but I have not tested on a Window CE device
yet.

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Wednesday, October 10, 2012 8:52 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


On 10 Oct 2012, at 4:44pm, Caleb A. Austin  wrote:

> Then I add the SQLite3.c and SQLite3.h to the project and include 
> SQLite3.h into the Hello World project. This is where I get the 
> errors.

Please make sure your compiler is set to compile '.c' files as C code,
and not anything else like C++.  This is a common source of compilation
problems.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

To confirm if I have a good set of source code, I did a WIN32 build with
the shell.c. This works, I can build and run SQLite.

Is there a known Windows CE build that could be used as a reference to
set my project settings up with?

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Wednesday, October 10, 2012 8:52 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


On 10 Oct 2012, at 4:44pm, Caleb A. Austin  wrote:

> Then I add the SQLite3.c and SQLite3.h to the project and include 
> SQLite3.h into the Hello World project. This is where I get the 
> errors.

Please make sure your compiler is set to compile '.c' files as C code,
and not anything else like C++.  This is a common source of compilation
problems.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

It looks to be building it as a C file, this is from the build log:

BUILD: [00:000111:PROGC ] C++0 0
0
BUILD: [00:000112:PROGC ] C1 5
0


Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Wednesday, October 10, 2012 8:52 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


On 10 Oct 2012, at 4:44pm, Caleb A. Austin  wrote:

> Then I add the SQLite3.c and SQLite3.h to the project and include 
> SQLite3.h into the Hello World project. This is where I get the 
> errors.

Please make sure your compiler is set to compile '.c' files as C code,
and not anything else like C++.  This is a common source of compilation
problems.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Simon Slavin]

On 10 Oct 2012, at 4:44pm, Caleb A. Austin  wrote:

> Then I add the SQLite3.c and SQLite3.h to the project and
> include SQLite3.h into the Hello World project. This is where I get the
> errors.

Please make sure your compiler is set to compile '.c' files as C code, and not 
anything else like C++.  This is a common source of compilation problems.

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

I have a VS2008 WEC7 project, that I then add a sub project to that is a
basic Hello World type program. Put another way, I have the WEC7 OS with
a WEC7 program that put's hello world on the WEC7 console. This works
correctly. Then I add the SQLite3.c and SQLite3.h to the project and
include SQLite3.h into the Hello World project. This is where I get the
errors.

I am using the "sqlite-amalgamation-3071400" and working with the files
directly. I have not modified the contents of the .c file other than the
"#define SQLITE_OS_WINCE 1" to force WINCE as the OS.

I have also unseccefully added a few other lines of code that I have
found on the web, but these are from a number of years ago, and the
following link 
http://www.sqlite.org/cvstrac/tktview?tn=2945

I don't see a make file in the zip file with the amalgamation. 

The SDK that is being used with WEC7 is the TI SDK for our processor,
AM3517.

Thanks!

Caleb Austin


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Tuesday, October 09, 2012 10:53 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact
7(WEC7)


Caleb A. Austin wrote:
> 
> I am using SQLITE_OS_WINCE as defined:
> 
> #if defined(_WIN32_WCE)
> # define SQLITE_OS_WINCE 1
> #else
> # define SQLITE_OS_WINCE 0
> #endif
> 

Is a special SDK being used for Windows Embedded Compact 7?

What other defines are you using?  Are you using the Makefile.msc in the
source tree to build or some other mechanism?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
> 
> I am using SQLITE_OS_WINCE as defined:
> 
> #if defined(_WIN32_WCE)
> # define SQLITE_OS_WINCE 1
> #else
> # define SQLITE_OS_WINCE 0
> #endif
> 

Is a special SDK being used for Windows Embedded Compact 7?

What other defines are you using?  Are you using the Makefile.msc in the
source
tree to build or some other mechanism?

--
Joe Mistachkin

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

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

I am using SQLITE_OS_WINCE as defined:

 #if defined(_WIN32_WCE)
# define SQLITE_OS_WINCE 1
#else
# define SQLITE_OS_WINCE 0
#endif

I have also forced #define SQLITE_OS_WINCE 1 at the top of the .c file. 

Would there be a basic set of define's that would build a Windows CE
SQLite?

I hope this is going back to the right place... As I have not replied to
a list like this before.

Caleb Austin
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

I am using SQLITE_OS_WINCE as defined:

 #if defined(_WIN32_WCE)
# define SQLITE_OS_WINCE 1
#else
# define SQLITE_OS_WINCE 0
#endif

I have also forced #define SQLITE_OS_WINCE 1 at the top of the .c file. 

Would there be a basic set of define's that would build a Windows CE
SQLite?

I hope this is going back to the right place... As I have not replied to
a list like this before.

Caleb Austin
##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Joe Mistachkin]

Caleb A. Austin wrote:
> 
> Warning   2  warning C4013: 'localtime_s'
> undefined; assuming extern returning int
> 

What defines are you using to compile the sqlite3.c file?

Are you using the defines SQLITE_OS_WIN and SQLITE_OS_WINCE?

--
Joe Mistachkin

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

[sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

[Caleb A. Austin]

Hi All,

 

I am working on  building SQLite and I am using(from header file): 

 

#define SQLITE_VERSION"3.7.14"

#define SQLITE_VERSION_NUMBER 3007014

#define SQLITE_SOURCE_ID  "2012-09-03 15:42:36
c0d89d4a9752922f9e367362366efde4f1b06f2a"

I am getting the following warning and then link error:

 

Warning   2  warning C4013: 'localtime_s'
undefined; assuming extern returning int
{log="C:\WINCE700\OSDesigns\Climet_test1\Climet_test1\sqlite_test\bldsys
log(32)"}
c:\wince700\osdesigns\climet_test1\climet_test1\sqlite_test\sqlite3.c
14129

 

Error  4  sqlite3.obj : error LNK2019: unresolved
external symbol localtime_s referenced in function osLocaltime
C:\WINCE700\OSDesigns\Climet_test1\Climet_test1\sqlite_test\bldsys.log
48

 

I have looked over Google and found a few examples of how this was
handled by others, but found this:

 

http://www.sqlite.org/cvstrac/tktview?tn=2945

 

This implies that the error regarding "localtime_s" is fixed in the main
trunk of SQLite and should compile... but I don't have something right. 

 

I am using  VS2008 and have a working CE build and hello world program
working.  When I add SQLite into the project I get the above
error/warning.

 

I would like some advice on how to build SQLite for WEC7. 

 

 

Caleb Austin

 


##
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Building sqlite for windows in a proper way

[jeff archer]

>On Mon, Apr 18, 2011 at 8:42 AM, Kuba Nowak  wrote:
>
>Does anyone one know how to build sqlite to get the same binary as on
>download page ?
>

What do you use to compare the speed between the builds of SQLite?

Are using debug build from VS2010?  My experience is that VS debug builds run 
most code significantly slower than the release builds.

Jeff Archer
Nanotronics Imaging
jsarc...@nanotronicsimaging.com
<330>819.4615 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building sqlite for windows in a proper way

[Pavel Ivanov]

> Does anyone one know how to build sqlite to get the same binary as on
> download page ?

Did you try to remove all those defines that you add at build time and
leave only default values set inside sqlite3.c file?


Pavel


On Mon, Apr 18, 2011 at 8:42 AM, Kuba Nowak  wrote:
> Hello
>
> My problem is no matter how i build sqlite - my binary is much slower than
> the precompiled one on sqlite download page (about 3 - 6 times depending on
> the query).
>
> I am using sqlite3.h and sqlite3.c from the amalgamation source:
>
> http://www.sqlite.org/sqlite-amalgamation-3070602.zip
>
> I have added the following flags when compiling sqlite:
>
> gcc
> -s -O4 -I. -fomit-frame-pointer
> -DNDEBUG
> -DSQLITE_OS_WIN=1
> -DSQLITE_HAVE_READLINE=0
> -DSQLITE_THREADSAFE=1
> -DSQLITE_TEMP_STORE=2
> -DSQLITE_ENABLE_RTREE
> -DSQLITE_ENABLE_FTS3
> -DSQLITE_OMIT_COMPILEOPTION_DIAGS
> -DSQLITE_ENABLE_COLUMN_METADATA
> -DNO_TCL
>
> I built it both with MINGW and with MSVS 2010.
>
> Does anyone one know how to build sqlite to get the same binary as on
> download page ?
>
> Any help would be appreciated.
>
> Thanks.
>
> Jakub
> ___
> 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] Building sqlite for windows in a proper way

[Kuba Nowak]

Hello

My problem is no matter how i build sqlite - my binary is much slower than
the precompiled one on sqlite download page (about 3 - 6 times depending on
the query).

I am using sqlite3.h and sqlite3.c from the amalgamation source:

http://www.sqlite.org/sqlite-amalgamation-3070602.zip

I have added the following flags when compiling sqlite:

gcc
-s -O4 -I. -fomit-frame-pointer
-DNDEBUG
-DSQLITE_OS_WIN=1
-DSQLITE_HAVE_READLINE=0
-DSQLITE_THREADSAFE=1
-DSQLITE_TEMP_STORE=2
-DSQLITE_ENABLE_RTREE
-DSQLITE_ENABLE_FTS3
-DSQLITE_OMIT_COMPILEOPTION_DIAGS
-DSQLITE_ENABLE_COLUMN_METADATA
-DNO_TCL

I built it both with MINGW and with MSVS 2010.

Does anyone one know how to build sqlite to get the same binary as on
download page ?

Any help would be appreciated.

Thanks.

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

Re: [sqlite] Building SQLIte Commands or Sanitzing User Input

[Jeffrey Walton]

Thanks for the quick response Simon.

Happy holidays.

On Fri, Dec 31, 2010 at 8:25 PM, Simon Slavin  wrote:
>
> On 1 Jan 2011, at 12:35am, Jeffrey Walton wrote:
>
>> I'm using SQLite on embedded devices (iPhone and, SmartPhone, and
>> PocketPC). Ichecked OWASP, and they don't have anything for SQLite or
>> C/C++. http://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet.
>>
>> Does the SQLite API offer the ability to create a 'command object'. Or
>> a call to sanitize user input (which would probably include escaping
>> special characters)?
>
> Yep.  sqlite3_prepare() creates a compiled SQL statement, which is more or 
> less what you mean by 'command object'.  It's not possible to inject if 
> you're using sqlite3_prepare(): it will execute only a single instruction and 
> syntax characters in parameters are interpreted as if they're part of the 
> parameter, not part of the command.
>
> If you're using sqlite3_exec() then you have bigger problems.  You can, of 
> course, screen your input string for semi-colons.  You can check that INSERT, 
> UPDATE and DELETE are followed only by your desired table names.  You can 
> screen the first two words of each SQL command.  Further precautions vary 
> depending on what you know is a legitimate use in your particular application.
>
> So I recommend that if you're nervous about injection, you use the prepare 
> sequence:
>
> 
>
> In the case of the iPhone you other special security measures acting in your 
> favour.  For instance, it's impossible to use one application to get at the 
> data belonging to other applications.  Other operating systems have their own 
> measures.
>
> Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLIte Commands or Sanitzing User Input

[Simon Slavin]

On 1 Jan 2011, at 12:35am, Jeffrey Walton wrote:

> I'm using SQLite on embedded devices (iPhone and, SmartPhone, and
> PocketPC). Ichecked OWASP, and they don't have anything for SQLite or
> C/C++. http://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet.
> 
> Does the SQLite API offer the ability to create a 'command object'. Or
> a call to sanitize user input (which would probably include escaping
> special characters)?

Yep.  sqlite3_prepare() creates a compiled SQL statement, which is more or less 
what you mean by 'command object'.  It's not possible to inject if you're using 
sqlite3_prepare(): it will execute only a single instruction and syntax 
characters in parameters are interpreted as if they're part of the parameter, 
not part of the command.

If you're using sqlite3_exec() then you have bigger problems.  You can, of 
course, screen your input string for semi-colons.  You can check that INSERT, 
UPDATE and DELETE are followed only by your desired table names.  You can 
screen the first two words of each SQL command.  Further precautions vary 
depending on what you know is a legitimate use in your particular application.

So I recommend that if you're nervous about injection, you use the prepare 
sequence:



In the case of the iPhone you other special security measures acting in your 
favour.  For instance, it's impossible to use one application to get at the 
data belonging to other applications.  Other operating systems have their own 
measures.

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

[sqlite] Building SQLIte Commands or Sanitzing User Input

[Jeffrey Walton]

Hi All,

I'm using SQLite on embedded devices (iPhone and, SmartPhone, and
PocketPC). Ichecked OWASP, and they don't have anything for SQLite or
C/C++. http://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet.

Does the SQLite API offer the ability to create a 'command object'. Or
a call to sanitize user input (which would probably include escaping
special characters)?

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

[sqlite] Building sqlite 3.7.3 with Tcl binding

[Paweł Salawa]

Hi,

How do I compile sqlite 3.7.3 with Tcl bindings? I don't see any tcl-related 
options in configure script (the amalgamation distribution) and default 
compilation doesn't probide Tcl bindings.

Thanks for help!
Regards,
-- 
Paweł Salawa
pawelsal...@gmail.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building sqlite

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Doug wrote:
> You may need SQLITE_THREADSAFE depending on how you're using the library

SQLITE_THREADSAFE defaults to 1 (meaning that SQLite is fully threadsafe
no matter what you do).  See

  http://www.sqlite.org/compile.html

IF for some reason you want the library to not bother with mutexes and
being threadsafe then you can use sqlite3_config with an appropriate
config option:

  http://sqlite.org/c3ref/config.html
  http://sqlite.org/c3ref/c_config_getmalloc.html

ie as long you use the defaults for compilation you will be fine and can
change them at runtime anyway.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkpJL4UACgkQmOOfHg372QRlegCgknctHB61XIeFVFS7CK0uiLzM
VAYAniskhUHMJe0LwpTxPC2JBpf+yC06
=SmvA
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building sqlite

[Doug]

You may need SQLITE_THREADSAFE depending on how you're using the library

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Robert Dailey
> Sent: Monday, June 29, 2009 1:51 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Building sqlite
> 
> On Mon, Jun 29, 2009 at 12:58 PM, Eric Minbiole
> wrote:
> 
> > > I'm currently on Windows and I've set up a python script to
> download the
> > > sqlite3 amalgamation. However, the ZIP file contains no build
> system for
> > > sqlite. I had to create a custom CMake script to build sqlite3 into
> a
> > > library. I do not wish to compile the C file with my source, it
> needs to
> > be
> > > a static library.
> > >
> > > Do you guys have a package that contains a build system for sqlite3
> for
> > > Windows?
> >
> > Can you use a dynamic library instead of static?  If so, there is a
> > precompiled Windows dll for download on the SQLite site.  Otherwise,
> you
> > will probably need to build manually, as you have done.
> >
> > (Another option might be to use one of the myriad of Dll -> Static
> lib
> > converters available, though this seems like more work than it's
> worth.)
> 
> 
> Thanks for the response. I actually have no need to use a shared
> library,
> since it isn't going to be shared. A static library is what I need and
> what
> I'm currently building. As long as there are no preprocessor
> definitions or
> other compilation flags that I need to be aware of for sqlite3, then
> what I
> have now will work just fine and it can be automated. It's a very
> simple
> CMake script and I'd be willing to contribute it to the project if you
> would
> like. You can package this up with the ZIP file and the tarball
> amalgamations so that people have the option of building a static
> library.
> 
> Let me know. Thanks again for the help.
> ___
> 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] Building sqlite

[Robert Dailey]

On Mon, Jun 29, 2009 at 12:58 PM, Eric Minbiole
wrote:

> > I'm currently on Windows and I've set up a python script to download the
> > sqlite3 amalgamation. However, the ZIP file contains no build system for
> > sqlite. I had to create a custom CMake script to build sqlite3 into a
> > library. I do not wish to compile the C file with my source, it needs to
> be
> > a static library.
> >
> > Do you guys have a package that contains a build system for sqlite3 for
> > Windows?
>
> Can you use a dynamic library instead of static?  If so, there is a
> precompiled Windows dll for download on the SQLite site.  Otherwise, you
> will probably need to build manually, as you have done.
>
> (Another option might be to use one of the myriad of Dll -> Static lib
> converters available, though this seems like more work than it's worth.)


Thanks for the response. I actually have no need to use a shared library,
since it isn't going to be shared. A static library is what I need and what
I'm currently building. As long as there are no preprocessor definitions or
other compilation flags that I need to be aware of for sqlite3, then what I
have now will work just fine and it can be automated. It's a very simple
CMake script and I'd be willing to contribute it to the project if you would
like. You can package this up with the ZIP file and the tarball
amalgamations so that people have the option of building a static library.

Let me know. Thanks again for the help.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building sqlite

[Eric Minbiole]

> I'm currently on Windows and I've set up a python script to download the
> sqlite3 amalgamation. However, the ZIP file contains no build system for
> sqlite. I had to create a custom CMake script to build sqlite3 into a
> library. I do not wish to compile the C file with my source, it needs to be
> a static library.
> 
> Do you guys have a package that contains a build system for sqlite3 for
> Windows?

Can you use a dynamic library instead of static?  If so, there is a 
precompiled Windows dll for download on the SQLite site.  Otherwise, you 
will probably need to build manually, as you have done.

(Another option might be to use one of the myriad of Dll -> Static lib 
converters available, though this seems like more work than it's worth.)

~Eric

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

[sqlite] Building sqlite

[Robert Dailey]

I'm currently on Windows and I've set up a python script to download the
sqlite3 amalgamation. However, the ZIP file contains no build system for
sqlite. I had to create a custom CMake script to build sqlite3 into a
library. I do not wish to compile the C file with my source, it needs to be
a static library.

Do you guys have a package that contains a build system for sqlite3 for
Windows?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite ... configure/make deprecated?

[P Kishor]

On Mon, May 4, 2009 at 2:59 PM, Rob Sciuk  wrote:
>
> I note with interest the source download now (recently?) deprecates the
> configure/make build of SQLite 3.6.x sources.  What gives??  I've been
> configure/make(ing) SQLite since, forever, and the only problems I ever
> encountered were omitting options that I needed, and quickly sorted out!
>
> How does one actually obtain the "amalgamation", if not by using the
> configure/make scripts, complete with lemon and friends??
>
> from the web site:
>
>        "A tarball of the complete source tree for SQLite version 3.6.13
>        as extracted from the version control system. The Makefile and 
> configure
>        script in this tarball are not supported. Their use is not recommended.
>        The SQLite developers do not use them. You should not use them either. 
> If
>        you want a configure script and an automated build, use either the
>        amalgamation tarball or TEA tarball instead of this one. To build from
>        this tarball, hand-edit one of the template Makefiles in the root
>        directory of the tarball and build using your own customized
>        Makefile."
>
> Perhaps this is just me, but it seems a retrograde approach from a
> Unix/Linux developer perspective ...

Not necessarily. I think it is more like a gentle nudge from the
developers to make us use the amalgamation instead of the separate
bits and bobs. The amalgamation has always been available standalone
with its associated Makefile.

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



-- 
Puneet Kishor http://www.punkish.org/
Carbon Model http://carbonmodel.org/
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/
Science Commons Fellow, Geospatial Data http://sciencecommons.org
Nelson Institute, UW-Madison http://www.nelson.wisc.edu/
---
collaborate, communicate, compete
===
Sent from Madison, WI, United States
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building SQLite ... configure/make deprecated?

[Eugene Wee]

On Tue, May 5, 2009 at 3:59 AM, Rob Sciuk  wrote:
> How does one actually obtain the "amalgamation", if not by using the
> configure/make scripts, complete with lemon and friends??

One way is by direct download of say,
sqlite-amalgamation-3.6.13.tar.gz, from
http://www.sqlite.org/download.html

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

[sqlite] Building SQLite ... configure/make deprecated?

[Rob Sciuk]

I note with interest the source download now (recently?) deprecates the 
configure/make build of SQLite 3.6.x sources.  What gives??  I've been 
configure/make(ing) SQLite since, forever, and the only problems I ever 
encountered were omitting options that I needed, and quickly sorted out!

How does one actually obtain the "amalgamation", if not by using the 
configure/make scripts, complete with lemon and friends??

from the web site:

"A tarball of the complete source tree for SQLite version 3.6.13
as extracted from the version control system. The Makefile and configure
script in this tarball are not supported. Their use is not recommended.
The SQLite developers do not use them. You should not use them either. 
If
you want a configure script and an automated build, use either the
amalgamation tarball or TEA tarball instead of this one. To build from
this tarball, hand-edit one of the template Makefiles in the root
directory of the tarball and build using your own customized
Makefile."

Perhaps this is just me, but it seems a retrograde approach from a 
Unix/Linux developer perspective ...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] building SQLite 3.5.4 with SQLITE_OMIT_LOAD_EXTENSION

[Dimitri]

Hi,

We're building the amalgamated source file with SQLITE_OMIT_LOAD_EXTENSION 
defined.


This had been working just fine until the release of SQLite 3.5.2.

It stopped working after the release of SQLite 3.5.3 because sqlite3.c contains:
  #ifndef SQLITE_OMIT_LOAD_EXTENSION
  #define SQLITE_CORE 1  /* Disable the API redefinition in sqlite3ext.h */
and then:
  #ifndef SQLITE_CORE
#include "sqlite3ext.h"
SQLITE_EXTENSION_INIT1
  #endif

Changing from:
  #ifndef SQLITE_OMIT_LOAD_EXTENSION
  #define SQLITE_CORE 1  /* Disable the API redefinition in sqlite3ext.h */
to :
  #define SQLITE_CORE 1  /* Disable the API redefinition in sqlite3ext.h */
  #ifndef SQLITE_OMIT_LOAD_EXTENSION
"works" for me - functions such as qlite3OsDlOpen() are defined but not used 
but at least SQLite builds.


Any clue?

Regards,
--
Dimitri

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] building sqlite on windows in Unicode

[Joe Wilson]

Many large open source projects have committers for specific platforms, 
or particular sections of the code. I would think that Windows support
and autoconfigury would be good candidates for delegation.
One guy can't do it all.

--- Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > Your contributions are greatly appreciated.  Please do not let
> > anything I say or do discourage you from contributing again to
> > either SQLite or other open source projects.  User contributions
> > are very important to open source projects like SQLite and I want
> > to encourage them.  But you also need to understand that there is
> > no guarantee that a patch will be accepted.  With SQLite in
> > particular, with me in the drivers seat, it is very very difficult
> > to get a patch accepted into the core.  It has been done, but it
> > does not happen very often.  Usually, if I implement a suggested
> > feature at all, I merely use the patch as a guideline to implement 
> > my own changes.  Do not let this discourage you.  Your patch has
> > been recorded in the bug tracking system, and I have studied it
> > closely.  It will be likely used as a reference someday.  Just 
> > not today.
> 
> Having these comments added to the bug system would be useful to start
> with. You have your reasons for ignoring the bug, but with no movement
> at all it is frustrating to have to continually patch the source just to
> get it to build on Windows. Especially when it is so simple to get it to
> work.


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] building sqlite on windows in Unicode

[Brodie Thiesfield]

Robert Simpson wrote:

I wrote the original patch to loadext.c with the intent of making it as
minimally obtrusive as possible to the existing code structure.  I know
firsthand how much DRH hates changing his codebase :)

[snip]
> FWIW, that patch I wrote is currently in production code in the 
ADO.NET 2.0

> provider and in use by Windows CE users since October.

I don't doubt that your patch fixes your specific problem, however it 
has 2 main problems for me:
1) it doesn't address the larger problem of building the library in 
UNICODE mode in general (of which Windows CE is just one client)
2) you've assumed that the char* strings are in CP_ACP whereas I 
understand that all char* are UTF-8.


That said I can easily write a patch that doesn't touch the OS 
abstraction code, it just seems crazy to hack missing OS abstraction 
functions into files all around the codebase just in order to avoid 
adding them to the existing OS abstraction layer.


Regards,
Brodie


-Original Message-
From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 17, 2006 10:10 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] building sqlite on windows in Unicode

[EMAIL PROTECTED] wrote:

Brodie Thiesfield <[EMAIL PROTECTED]> wrote:

Done. Is there anything else that is necessary to contribute code

and

patches to sqlite?

For ticket #2023, the first patch seems unlikely to work right
since it changes the character encoding for LoadLibrary() but
leaves it unchanged for FreeLibrary().  That seems wrong to me,
but not having any access to WinCE (and having zero desire to
ever get access) I have no way of testing it.

I didn't write the first patch. It should just be ignored as my patch
is
more comprehensive.

The only function that has a different version for UNICODE vs MBCS is
LoadLibrary (i.e. both LoadLibraryA and LoadLibraryW). This can be seen
from the documentation. The T in LPCTSTR in the LoadLibrary definition
signifies that there is both A and W versions. GetProcAddress takes
only
a LPCSTR which is always char*. FreeLibrary takes only the handle to
the
library that LoadLibrary created.

These functions are pretty much the same as dlopen/dlsym/dlclose, with
the exception that LoadLibrary needs to be specially handled.

MSDN documentation:
LoadLibrary http://snipurl.com/loadlibrary
GetProcAddress http://snipurl.com/getprocaddress
FreeLibrary http://snipurl.com/freelibrary


The second patch extends the OS interface in ways that will break
legacy implementations.  A significant part of my income derives
from people and companies who pay me to not do that.

If those implementations are not be broken by the current
implementation
of loadext.c then surely these changes won't break them either. The
whole idea of have the OS interface is that it abstracts the OS away in
a single location. Hacking OS abstraction into other parts of the
codebase (e.g. the current loadext.c) is not the correct thing to do.
In
any case, since all of those people/companies are either supported by
the current method of dlopen/sym/close as is currently used in
loadext.c, or they aren't using 3.3.7+


I could perhaps fix up either patch to do the right thing, but
then I would have no way of testing the results, since I do not
have access to WinCE.

You do not need access to WinCE. It also breaks the build on Windows
when defining _UNICODE. I'm sure that you an set the _UNICODE define
(removing _MBCS) on your cross-compiler (if that is what you are
using).
If you can you elaborate more on the requirements for changes to the OS
layer then I can adapt my patch to fit your requirements.


The above are some of the reasons that there has been so little
movement on ticket #2023.

Your contributions are greatly appreciated.  Please do not let
anything I say or do discourage you from contributing again to
either SQLite or other open source projects.  User contributions
are very important to open source projects like SQLite and I want
to encourage them.  But you also need to understand that there is
no guarantee that a patch will be accepted.  With SQLite in
particular, with me in the drivers seat, it is very very difficult
to get a patch accepted into the core.  It has been done, but it
does not happen very often.  Usually, if I implement a suggested
feature at all, I merely use the patch as a guideline to implement
my own changes.  Do not let this discourage you.  Your patch has
been recorded in the bug tracking system, and I have studied it
closely.  It will be likely used as a reference someday.  Just
not today.

Having these comments added to the bug system would be useful to start
with. You have your reasons for ignoring the bug, but with no movement
at all it is frustrating to have to continually patch the source just
to
get it to build on Windows. Especially when it is so simple to get it
to
work.

Regards,
Brodie

RE: [sqlite] building sqlite on windows in Unicode

[Robert Simpson]

I wrote the original patch to loadext.c with the intent of making it as
minimally obtrusive as possible to the existing code structure.  I know
firsthand how much DRH hates changing his codebase :)

As Brodie stated, FreeLibrary() takes a type HANDLE, which is returned from
a call to LoadLibrary() -- so the only time the string needs referencing is
at the original LoadLibrary() call.

FWIW, that patch I wrote is currently in production code in the ADO.NET 2.0
provider and in use by Windows CE users since October.

Robert


> -Original Message-
> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> Sent: Sunday, December 17, 2006 10:10 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] building sqlite on windows in Unicode
> 
> [EMAIL PROTECTED] wrote:
> > Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
> >> Done. Is there anything else that is necessary to contribute code
> and
> >> patches to sqlite?
> >
> > For ticket #2023, the first patch seems unlikely to work right
> > since it changes the character encoding for LoadLibrary() but
> > leaves it unchanged for FreeLibrary().  That seems wrong to me,
> > but not having any access to WinCE (and having zero desire to
> > ever get access) I have no way of testing it.
> 
> I didn't write the first patch. It should just be ignored as my patch
> is
> more comprehensive.
> 
> The only function that has a different version for UNICODE vs MBCS is
> LoadLibrary (i.e. both LoadLibraryA and LoadLibraryW). This can be seen
> from the documentation. The T in LPCTSTR in the LoadLibrary definition
> signifies that there is both A and W versions. GetProcAddress takes
> only
> a LPCSTR which is always char*. FreeLibrary takes only the handle to
> the
> library that LoadLibrary created.
> 
> These functions are pretty much the same as dlopen/dlsym/dlclose, with
> the exception that LoadLibrary needs to be specially handled.
> 
> MSDN documentation:
> LoadLibrary http://snipurl.com/loadlibrary
> GetProcAddress http://snipurl.com/getprocaddress
> FreeLibrary http://snipurl.com/freelibrary
> 
> > The second patch extends the OS interface in ways that will break
> > legacy implementations.  A significant part of my income derives
> > from people and companies who pay me to not do that.
> 
> If those implementations are not be broken by the current
> implementation
> of loadext.c then surely these changes won't break them either. The
> whole idea of have the OS interface is that it abstracts the OS away in
> a single location. Hacking OS abstraction into other parts of the
> codebase (e.g. the current loadext.c) is not the correct thing to do.
> In
> any case, since all of those people/companies are either supported by
> the current method of dlopen/sym/close as is currently used in
> loadext.c, or they aren't using 3.3.7+
> 
> > I could perhaps fix up either patch to do the right thing, but
> > then I would have no way of testing the results, since I do not
> > have access to WinCE.
> 
> You do not need access to WinCE. It also breaks the build on Windows
> when defining _UNICODE. I'm sure that you an set the _UNICODE define
> (removing _MBCS) on your cross-compiler (if that is what you are
> using).
> If you can you elaborate more on the requirements for changes to the OS
> layer then I can adapt my patch to fit your requirements.
> 
> > The above are some of the reasons that there has been so little
> > movement on ticket #2023.
> >
> > Your contributions are greatly appreciated.  Please do not let
> > anything I say or do discourage you from contributing again to
> > either SQLite or other open source projects.  User contributions
> > are very important to open source projects like SQLite and I want
> > to encourage them.  But you also need to understand that there is
> > no guarantee that a patch will be accepted.  With SQLite in
> > particular, with me in the drivers seat, it is very very difficult
> > to get a patch accepted into the core.  It has been done, but it
> > does not happen very often.  Usually, if I implement a suggested
> > feature at all, I merely use the patch as a guideline to implement
> > my own changes.  Do not let this discourage you.  Your patch has
> > been recorded in the bug tracking system, and I have studied it
> > closely.  It will be likely used as a reference someday.  Just
> > not today.
> 
> Having these comments added to the bug system would be useful to start
> with. You have your reasons for ignoring the bug, but with no movement
> at all it is frustrating to have to continually patch the source just
> to
> get it to build on Windows. Especi

Re: [sqlite] building sqlite on windows in Unicode

[Brodie Thiesfield]

[EMAIL PROTECTED] wrote:
> Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
>> Done. Is there anything else that is necessary to contribute code and 
>> patches to sqlite? 
> 
> For ticket #2023, the first patch seems unlikely to work right
> since it changes the character encoding for LoadLibrary() but
> leaves it unchanged for FreeLibrary().  That seems wrong to me,
> but not having any access to WinCE (and having zero desire to
> ever get access) I have no way of testing it.

I didn't write the first patch. It should just be ignored as my patch is
more comprehensive.

The only function that has a different version for UNICODE vs MBCS is
LoadLibrary (i.e. both LoadLibraryA and LoadLibraryW). This can be seen
from the documentation. The T in LPCTSTR in the LoadLibrary definition
signifies that there is both A and W versions. GetProcAddress takes only
a LPCSTR which is always char*. FreeLibrary takes only the handle to the
library that LoadLibrary created.

These functions are pretty much the same as dlopen/dlsym/dlclose, with
the exception that LoadLibrary needs to be specially handled.

MSDN documentation:
LoadLibrary http://snipurl.com/loadlibrary
GetProcAddress http://snipurl.com/getprocaddress
FreeLibrary http://snipurl.com/freelibrary

> The second patch extends the OS interface in ways that will break
> legacy implementations.  A significant part of my income derives
> from people and companies who pay me to not do that.

If those implementations are not be broken by the current implementation
of loadext.c then surely these changes won't break them either. The
whole idea of have the OS interface is that it abstracts the OS away in
a single location. Hacking OS abstraction into other parts of the
codebase (e.g. the current loadext.c) is not the correct thing to do. In
any case, since all of those people/companies are either supported by
the current method of dlopen/sym/close as is currently used in
loadext.c, or they aren't using 3.3.7+

> I could perhaps fix up either patch to do the right thing, but
> then I would have no way of testing the results, since I do not
> have access to WinCE.

You do not need access to WinCE. It also breaks the build on Windows
when defining _UNICODE. I'm sure that you an set the _UNICODE define
(removing _MBCS) on your cross-compiler (if that is what you are using).
If you can you elaborate more on the requirements for changes to the OS
layer then I can adapt my patch to fit your requirements.

> The above are some of the reasons that there has been so little 
> movement on ticket #2023.
> 
> Your contributions are greatly appreciated.  Please do not let
> anything I say or do discourage you from contributing again to
> either SQLite or other open source projects.  User contributions
> are very important to open source projects like SQLite and I want
> to encourage them.  But you also need to understand that there is
> no guarantee that a patch will be accepted.  With SQLite in
> particular, with me in the drivers seat, it is very very difficult
> to get a patch accepted into the core.  It has been done, but it
> does not happen very often.  Usually, if I implement a suggested
> feature at all, I merely use the patch as a guideline to implement 
> my own changes.  Do not let this discourage you.  Your patch has
> been recorded in the bug tracking system, and I have studied it
> closely.  It will be likely used as a reference someday.  Just 
> not today.

Having these comments added to the bug system would be useful to start
with. You have your reasons for ignoring the bug, but with no movement
at all it is frustrating to have to continually patch the source just to
get it to build on Windows. Especially when it is so simple to get it to
work.

Regards,
Brodie

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] building sqlite on windows in Unicode

[drh]

Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
> Done. Is there anything else that is necessary to contribute code and 
> patches to sqlite? 

For ticket #2023, the first patch seems unlikely to work right
since it changes the character encoding for LoadLibrary() but
leaves it unchanged for FreeLibrary().  That seems wrong to me,
but not having any access to WinCE (and having zero desire to
ever get access) I have no way of testing it.

The second patch extends the OS interface in ways that will break
legacy implementations.  A significant part of my income derives
from people and companies who pay me to not do that.

I could perhaps fix up either patch to do the right thing, but
then I would have no way of testing the results, since I do not
have access to WinCE.

The above are some of the reasons that there has been so little 
movement on ticket #2023.

Your contributions are greatly appreciated.  Please do not let
anything I say or do discourage you from contributing again to
either SQLite or other open source projects.  User contributions
are very important to open source projects like SQLite and I want
to encourage them.  But you also need to understand that there is
no guarantee that a patch will be accepted.  With SQLite in
particular, with me in the drivers seat, it is very very difficult
to get a patch accepted into the core.  It has been done, but it
does not happen very often.  Usually, if I implement a suggested
feature at all, I merely use the patch as a guideline to implement 
my own changes.  Do not let this discourage you.  Your patch has
been recorded in the bug tracking system, and I have studied it
closely.  It will be likely used as a reference someday.  Just 
not today.

--
D. Richard Hipp  <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] building sqlite on windows in Unicode

[Brodie Thiesfield]

Done. Is there anything else that is necessary to contribute code and 
patches to sqlite? The bug database seems to lack feedback (many bugs 
seem to just lie stale, there is no way to create an account to login, 
etc). I can't find documentation on the website on contributions.


Regards,
Brodie


Christian Smith wrote:

Check the requirements in:
http://www.sqlite.org/copyright.html

for patches and other submissions to SQLite. This could be what is 
holding up inclusion of the patch.


Christian

Brodie Thiesfield uttered:


Hi,

Building sqlite on windows in Unicode mode broke with the addition of
the loadable extensions. I found a bug matching this problem and
attached a patch to it to fix it a while ago, however I haven't seen any
other comments or movement in the bug. I'm not sure what else needs to
be done to have a patch accepted, so I'm posting here in the hope to
prod it along for review or acceptance.

The problem is that the dlopen/LoadLibrary code looks like it was hacked
in instead of being added to the platform abstraction API and it doesn't
support windows unicode builds out of the box. The patch fixes that
problem and silences a warning generated by the new index format.

bug...
http://www.sqlite.org/cvstrac/tktview?tn=2023

patch...
http://www.sqlite.org/cvstrac/attach_get/309/sqlite3.patch

Regards,
Brodie

- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 





--
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
 X   - AGAINST MS ATTACHMENTS
/ \

- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] building sqlite on windows in Unicode

[Christian Smith]

Check the requirements in:
http://www.sqlite.org/copyright.html

for patches and other submissions to SQLite. This could be what is holding 
up inclusion of the patch.


Christian

Brodie Thiesfield uttered:


Hi,

Building sqlite on windows in Unicode mode broke with the addition of
the loadable extensions. I found a bug matching this problem and
attached a patch to it to fix it a while ago, however I haven't seen any
other comments or movement in the bug. I'm not sure what else needs to
be done to have a patch accepted, so I'm posting here in the hope to
prod it along for review or acceptance.

The problem is that the dlopen/LoadLibrary code looks like it was hacked
in instead of being added to the platform abstraction API and it doesn't
support windows unicode builds out of the box. The patch fixes that
problem and silences a warning generated by the new index format.

bug...
http://www.sqlite.org/cvstrac/tktview?tn=2023

patch...
http://www.sqlite.org/cvstrac/attach_get/309/sqlite3.patch

Regards,
Brodie

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



--
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
 X   - AGAINST MS ATTACHMENTS
/ \

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] building sqlite on windows in Unicode

[Brodie Thiesfield]

Hi,

Building sqlite on windows in Unicode mode broke with the addition of
the loadable extensions. I found a bug matching this problem and
attached a patch to it to fix it a while ago, however I haven't seen any
other comments or movement in the bug. I'm not sure what else needs to
be done to have a patch accepted, so I'm posting here in the hope to
prod it along for review or acceptance.

The problem is that the dlopen/LoadLibrary code looks like it was hacked
in instead of being added to the platform abstraction API and it doesn't
support windows unicode builds out of the box. The patch fixes that
problem and silences a warning generated by the new index format.

bug...
http://www.sqlite.org/cvstrac/tktview?tn=2023

patch...
http://www.sqlite.org/cvstrac/attach_get/309/sqlite3.patch

Regards,
Brodie

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

[Lloyd Thomas]

The precompiled version did work. I was just trying to compile it myself to 
get experience building a linux box.


Lloyd

- Original Message - 
From: <[EMAIL PROTECTED]>

To: 
Sent: Tuesday, January 03, 2006 1:29 PM
Subject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)


"Lloyd Thomas" <[EMAIL PROTECTED]> wrote:

Thanks Kimball
Your right about having a little experience. I am
just running into error after error installing apps, but I'm learnoing
slowly. Anyway, I was trying to install the sqlite support for another
application I want to use and as a side issue it seems to have installed
sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at
the prompt and it would just start.



Did the precompiled binary on the website not work for you?
http://www.sqlite.org/download.html

--
D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

[drh]

"Lloyd Thomas" <[EMAIL PROTECTED]> wrote:
> Thanks Kimball
> Your right about having a little experience. I am 
> just running into error after error installing apps, but I'm learnoing 
> slowly. Anyway, I was trying to install the sqlite support for another 
> application I want to use and as a side issue it seems to have installed 
> sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at 
> the prompt and it would just start.
> 

Did the precompiled binary on the website not work for you?
http://www.sqlite.org/download.html

--
D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

[Arjen Markus]

Lloyd Thomas wrote:
> 
> Thanks Kimball
> Your right about having a little experience. I am
> just running into error after error installing apps, but I'm learnoing
> slowly. Anyway, I was trying to install the sqlite support for another
> application I want to use and as a side issue it seems to have installed
> sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at
> the prompt and it would just start.
> 

Hello Lloyd,

you mean the sqlite3 command-line utility? Well, if all else fails,
try it with a small script that you can put in a directory within
your path:

---
# Run command-line utility sqlite3
#
export LD_LIBRARY_PATH=/your/install/dir/lib:$LD_LIBRARY_PATH
export PATH=/your/install/dir/bin:$PATH

sqlite3
---

(Store this in a convenient file like "mysqlite" and use:

chmod +x mysqlite

to make it executable)

The environment variables LD_LIBRARY_PATH and PATH are 
changed locally. So as soon as you leave the utility 
and thus the script, you go back to the original environment.

Regards,

Arjen

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

[Lloyd Thomas]

Thanks Kimball
   Your right about having a little experience. I am 
just running into error after error installing apps, but I'm learnoing 
slowly. Anyway, I was trying to install the sqlite support for another 
application I want to use and as a side issue it seems to have installed 
sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at 
the prompt and it would just start.


Lloyd


- Original Message - 
From: "Arjen Markus" <[EMAIL PROTECTED]>

To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 03, 2006 7:51 AM
Subject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)



Lloyd Thomas wrote:


There does not seem to be a library file in /usr/lib/  called
libsqlite3.so.0. would that be the problem. Please bear with me I am a 
linux

newbie.



Hello Lloyd,

my reply may be a bit too detailed, but I assume you have very little
experience with Linux/UNIX. So bare with me if the explanations are
too basic.

What about /usr/local/lib? That is the usual place for
packages/libraries that
are not part of the operating system.

You can print the current setting of LD_LIBRARY_PATH by typing:

echo $LD_LIBRARY_PATH

on the prompt.

It is a list of directories that the loader/linker will look at in
search
of shared objects. The sqlite3 library must be contained in any of
these.

If you find it in a different directory not listed there, you need to
set LD_LIBRARY_PATH:

export LD_LIBRARY_PATH=/your/new/directory:$LD_LIBRARY_PATH

or:

setenv LD_LIBRARY_PATH /your/new/directory:$LD_LIBRARY_PATH

(Presumably the first, the second form is specific to the C-shell, and
you probably have "bash".)

What directory (the prefix option) did you use for installing
SQLite? That is the directory where the library will live in (or in
the subdirectory "lib" of that directory).

Hope this helps.

Regards,

Arjen

Re: [sqlite] Building sqlite 3.2.8 on redhat 9

[Lloyd Thomas]

There does not seem to be a library file in /usr/lib/  called 
libsqlite3.so.0. would that be the problem. Please bear with me I am a linux 
newbie.


Lloyd
- Original Message - 
From: "Arjen Markus" <[EMAIL PROTECTED]>

To: 
Sent: Monday, January 02, 2006 12:13 PM
Subject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9



Lloyd Thomas wrote:


I have compilted tcl, but had a problem with tk. having compiled sqlite3 
I

get a new error trying to run sqlite3 =
'sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot 
open

shared object file: No such file or diretory'



That seems a common problem with shared objects/libraries ... they have
to
be in the path of the dynamic linker/loader. Have you set
LD_LIBRARY_PATH
properly?

Regards,

Arjen

Re: [sqlite] Building sqlite 3.2.8 on redhat 9

[Arjen Markus]

Lloyd Thomas wrote:
> 
> I have compilted tcl, but had a problem with tk. having compiled sqlite3 I
> get a new error trying to run sqlite3 =
> 'sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open
> shared object file: No such file or diretory'
> 

That seems a common problem with shared objects/libraries ... they have
to 
be in the path of the dynamic linker/loader. Have you set
LD_LIBRARY_PATH
properly?

Regards,

Arjen

Re: [sqlite] Building sqlite 3.2.8 on redhat 9

[Lloyd Thomas]

I have compilted tcl, but had a problem with tk. having compiled sqlite3 I 
get a new error trying to run sqlite3 =
'sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open 
shared object file: No such file or diretory'


Any Ideas?

Lloyd

- Original Message - 
From: "Dan Kennedy" <[EMAIL PROTECTED]>

To: 
Sent: Monday, January 02, 2006 5:37 AM
Subject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9



If possible, the easiest way around this is to install Active-tcl.
Or compile the tcl library yourself. For a long time the stock tcl
install in redhat was problematic.

http://www.activestate.com/Products/ActiveTcl/




--- Lloyd Thomas <[EMAIL PROTECTED]> wrote:

I am having a problem building sqlite on my redhat 9 box. There seems to 
be
a problem with TCL. I am no linux guru, so it some one can poinjt me in 
the

right direction that would be great.

here is as far as I get


[EMAIL PROTECTED] sqlite-3.2.8]# make
./libtool --mode=compile

cc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG  -DTHREADSAFE=0
-DSQLITE_OMIT_CURSOR -c ./src/tclsqlite.c
 gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0
-DSQLITE_OMIT_CURSOR -c ./src/tclsqlite.c  -fPIC -DPIC -o 
.libs/tclsqlite.o

src/tclsqlite.c: In function `tclSqlFunc':
src/tclsqlite.c:372: warning: passing arg 1 of `Tcl_NewByteArrayObj'
discards qualifiers from pointer target type
src/tclsqlite.c:380: warning: assignment makes pointer from integer 
without

a cast
src/tclsqlite.c:438: `Tcl_WideInt' undeclared (first use in this 
function)

src/tclsqlite.c:438: (Each undeclared identifier is reported only once
src/tclsqlite.c:438: for each function it appears in.)
src/tclsqlite.c:438: parse error before "v"
src/tclsqlite.c:439: `v' undeclared (first use in this function)
src/tclsqlite.c: In function `DbObjCmd':
src/tclsqlite.c:636: warning: passing arg 3 of `Tcl_GetIndexFromObj' from
incompatible pointer type
src/tclsqlite.c:1252: warning: passing arg 2 of `Tcl_GetVar2Ex' discards
qualifiers from pointer target type
src/tclsqlite.c:1274: `Tcl_WideInt' undeclared (first use in this 
function)

src/tclsqlite.c:1274: parse error before "v"
src/tclsqlite.c:1275: `v' undeclared (first use in this function)
src/tclsqlite.c:1325: warning: passing arg 1 of `Tcl_NewByteArrayObj'
discards qualifiers from pointer target type
src/tclsqlite.c:1333: warning: assignment makes pointer from integer 
without

a cast
src/tclsqlite.c:1773: warning: passing arg 3 of `Tcl_GetIndexFromObj' 
from

incompatible pointer type
src/tclsqlite.c: In function `DbMain':
src/tclsqlite.c:1918: warning: passing arg 2 of `Tcl_CreateObjCommand'
discards qualifiers from pointer target type
make: *** [tclsqlite.lo] Error 1
--








__
Yahoo! for Good - Make a difference this year.
http://brand.yahoo.com/cybergivingweek2005/ 

Re: [sqlite] Building sqlite 3.2.8 on redhat 9

[Dan Kennedy]

If possible, the easiest way around this is to install Active-tcl. 
Or compile the tcl library yourself. For a long time the stock tcl 
install in redhat was problematic. 

http://www.activestate.com/Products/ActiveTcl/




--- Lloyd Thomas <[EMAIL PROTECTED]> wrote:

> I am having a problem building sqlite on my redhat 9 box. There seems to be 
> a problem with TCL. I am no linux guru, so it some one can poinjt me in the 
> right direction that would be great.
> 
> here is as far as I get
> 
> 
> [EMAIL PROTECTED] sqlite-3.2.8]# make
> ./libtool --mode=compile 
> gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG  -DTHREADSAFE=0  
> -DSQLITE_OMIT_CURSOR -c ./src/tclsqlite.c
>  gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0  
> -DSQLITE_OMIT_CURSOR -c ./src/tclsqlite.c  -fPIC -DPIC -o .libs/tclsqlite.o
> src/tclsqlite.c: In function `tclSqlFunc':
> src/tclsqlite.c:372: warning: passing arg 1 of `Tcl_NewByteArrayObj' 
> discards qualifiers from pointer target type
> src/tclsqlite.c:380: warning: assignment makes pointer from integer without 
> a cast
> src/tclsqlite.c:438: `Tcl_WideInt' undeclared (first use in this function)
> src/tclsqlite.c:438: (Each undeclared identifier is reported only once
> src/tclsqlite.c:438: for each function it appears in.)
> src/tclsqlite.c:438: parse error before "v"
> src/tclsqlite.c:439: `v' undeclared (first use in this function)
> src/tclsqlite.c: In function `DbObjCmd':
> src/tclsqlite.c:636: warning: passing arg 3 of `Tcl_GetIndexFromObj' from 
> incompatible pointer type
> src/tclsqlite.c:1252: warning: passing arg 2 of `Tcl_GetVar2Ex' discards 
> qualifiers from pointer target type
> src/tclsqlite.c:1274: `Tcl_WideInt' undeclared (first use in this function)
> src/tclsqlite.c:1274: parse error before "v"
> src/tclsqlite.c:1275: `v' undeclared (first use in this function)
> src/tclsqlite.c:1325: warning: passing arg 1 of `Tcl_NewByteArrayObj' 
> discards qualifiers from pointer target type
> src/tclsqlite.c:1333: warning: assignment makes pointer from integer without 
> a cast
> src/tclsqlite.c:1773: warning: passing arg 3 of `Tcl_GetIndexFromObj' from 
> incompatible pointer type
> src/tclsqlite.c: In function `DbMain':
> src/tclsqlite.c:1918: warning: passing arg 2 of `Tcl_CreateObjCommand' 
> discards qualifiers from pointer target type
> make: *** [tclsqlite.lo] Error 1
> --
> 
> 





__ 
Yahoo! for Good - Make a difference this year. 
http://brand.yahoo.com/cybergivingweek2005/

[sqlite] Building sqlite 3.2.8 on redhat 9

[Lloyd Thomas]

I am having a problem building sqlite on my redhat 9 box. There seems to be 
a problem with TCL. I am no linux guru, so it some one can poinjt me in the 
right direction that would be great.


here is as far as I get


[EMAIL PROTECTED] sqlite-3.2.8]# make
./libtool --mode=compile 
gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG  -DTHREADSAFE=0  
-DSQLITE_OMIT_CURSOR -c ./src/tclsqlite.c
gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG -DTHREADSAFE=0  
-DSQLITE_OMIT_CURSOR -c ./src/tclsqlite.c  -fPIC -DPIC -o .libs/tclsqlite.o

src/tclsqlite.c: In function `tclSqlFunc':
src/tclsqlite.c:372: warning: passing arg 1 of `Tcl_NewByteArrayObj' 
discards qualifiers from pointer target type
src/tclsqlite.c:380: warning: assignment makes pointer from integer without 
a cast

src/tclsqlite.c:438: `Tcl_WideInt' undeclared (first use in this function)
src/tclsqlite.c:438: (Each undeclared identifier is reported only once
src/tclsqlite.c:438: for each function it appears in.)
src/tclsqlite.c:438: parse error before "v"
src/tclsqlite.c:439: `v' undeclared (first use in this function)
src/tclsqlite.c: In function `DbObjCmd':
src/tclsqlite.c:636: warning: passing arg 3 of `Tcl_GetIndexFromObj' from 
incompatible pointer type
src/tclsqlite.c:1252: warning: passing arg 2 of `Tcl_GetVar2Ex' discards 
qualifiers from pointer target type

src/tclsqlite.c:1274: `Tcl_WideInt' undeclared (first use in this function)
src/tclsqlite.c:1274: parse error before "v"
src/tclsqlite.c:1275: `v' undeclared (first use in this function)
src/tclsqlite.c:1325: warning: passing arg 1 of `Tcl_NewByteArrayObj' 
discards qualifiers from pointer target type
src/tclsqlite.c:1333: warning: assignment makes pointer from integer without 
a cast
src/tclsqlite.c:1773: warning: passing arg 3 of `Tcl_GetIndexFromObj' from 
incompatible pointer type

src/tclsqlite.c: In function `DbMain':
src/tclsqlite.c:1918: warning: passing arg 2 of `Tcl_CreateObjCommand' 
discards qualifiers from pointer target type

make: *** [tclsqlite.lo] Error 1
--

[sqlite] Building SQLite in MSVC 6

[Guy Hachlili]

Hello.
First I'd like to compliment you on a very nice product; I've been adding 
database support to an open source project and SQLite is of immense help to us.

I've been building SQLite as a library and as a DLL for Windows using 
Visual C++ 6 from sources of version 3.0.8. I'd be happy to publish or 
provide you with a .dsp (project file) for both types of compilation, as I 
couldn't seem to find them anywhere on the site.

I've gotten quite a few warnings while compiling; one of the warnings is 
severe IMHO - the function access() used in shell.c has no prototype (an 
#include  is needed there somewhere). There are lots of other 
warnings that can probably be removed.
I was wandering if you would be fixing those warnings, or if you'd like me 
to try and fix them myself and send you the results.

Guy