DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:from:date:message-id:subject:to
	:content-type; q=dns; s=default; b=UOK9o5+FTBRSxdWjQPdSdiI7zHmur
	mrcquVjclb7xESiAMdXH2M97BKyVC9MPaMH7hM+HVh1vRaTTTXfy7h4yNxaHXGh4
	KEZm/7EuJ9C/gLiwmax++e5ibtDsJ6vJntYJRRFpW2KZuR5mx6hwCtGFmapRgYNa
	KqW+bUvzjXngao=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
MIME-Version: 1.0
From: Keith Christian <keith1christian AT gmail DOT com>
Date: Sun, 10 Sep 2017 15:09:59 -0600
Message-ID: <CAFWoy7FZt30FaFEog7S9aTMo2u1Kh_YHY-8gyUqjXRDa8R6HwQ@mail.gmail.com>
Subject: Compiling the Sqlite3 v 3.20.1 libsqlite3.x.y.dll on Cygwin
To: cygwin AT cygwin DOT com
Content-Type: text/plain; charset="UTF-8"

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