From: Keith Christian <keith1christian@gmail.com>
To: cygwin@cygwin.com
Subject: Compiling the Sqlite3 v 3.20.1 libsqlite3.x.y.dll on Cygwin
Date: Sun, 10 Sep 2017 21:10:00 -0000 [thread overview]
Message-ID: <CAFWoy7FZt30FaFEog7S9aTMo2u1Kh_YHY-8gyUqjXRDa8R6HwQ@mail.gmail.com> (raw)
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
next reply other threads:[~2017-09-10 21:10 UTC|newest]
Thread overview: 2+ messages / expand[flat|nested] mbox.gz Atom feed top
2017-09-10 21:10 Keith Christian [this message]
2017-09-10 21:44 ` Keith Christian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=CAFWoy7FZt30FaFEog7S9aTMo2u1Kh_YHY-8gyUqjXRDa8R6HwQ@mail.gmail.com \
--to=keith1christian@gmail.com \
--cc=cygwin@cygwin.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).