This is the mail archive of the
cygwin
mailing list for the Cygwin project.
Compiling the Sqlite3 v 3.20.1 libsqlite3.x.y.dll on Cygwin
- From: Keith Christian <keith1christian at gmail dot com>
- To: cygwin at cygwin dot com
- Date: Sun, 10 Sep 2017 15:09:59 -0600
- Subject: Compiling the Sqlite3 v 3.20.1 libsqlite3.x.y.dll on Cygwin
- Authentication-results: sourceware.org; auth=none
What .dll should be compiled or loaded to execute a TCL program
including the SQLite library as shown in this fragment, which used to
work a few years ago?
#!/usr/bin/tclsh
load libsqlite3.8.3.dll "SQLite3"
sqlite3 db1 ./tcl_interface.db
puts ""
puts "Dropping table t1"
puts ""
db1 eval {DROP TABLE IF EXISTS t1}
db1 eval {CREATE TABLE IF NOT EXISTS t1(a int, b text)}
db1 eval {INSERT INTO t1 VALUES('1','hello')}
db1 eval {INSERT INTO t1 VALUES('2','goodbye')}
db1 eval {INSERT INTO t1 VALUES('3','howdy!')}
close db1
I downloaded and extracted the the amalgamation as done previously:
2069637 Sep 10 14:36 sqlite-amalgamation-3200100.zip
Then ran this gcc command provided by Dr. Hipp a few years ago:
gcc -o sqlite3.exe -I. sqlite3.c shell.c
No libsqlite3.x.y.z.dll in the current directory as before. These
DLL's were created in a subdirectory, howver:
find . -type f -name 'libsqlite3*' -exec ls -dl {} +
-rw-rw-rw-+ 1 KChris0000 Domain Users 5414520 Sep 10 14:46
./.libs/libsqlite3.a
-rw-rw-rw-+ 1 KChris0000 Domain Users 159728 Sep 10 14:46
./.libs/libsqlite3.dll.a
-rw-rw-rw-+ 1 KChris0000 Domain Users 912 Sep 10 14:46
./.libs/libsqlite3.lai
-rw-rw-rw-+ 1 KChris0000 Domain Users 904 Sep 10 14:46
./libsqlite3.la
>From here, with Sqlite3 v3.20.1, how to create a .dll as before? Or
is the method of loading libsqlite3 different now?
#!/usr/bin/tclsh
load libsqlite3.8.3.dll "SQLite3"
sqlite3 db1 ./tcl_interface.db
Thanks,
Keith
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple