Re: [sqlite] Can't load sqlite 3.75 under tcl 8.4.4.0
于 2011-4-10 12:43, thoselai...@shaw.ca 写道: > % package require sqlite > couldn't load library "C:/Tcl/lib/sqlite3/sqlite3/.dll": this library or a > dependent library could not be found in library path > > What is sqlite3/.dll ? > Where did that "/" come from? > > The pkgindex file contains - > > package ifneeded sqlite 3.7.5 [list load [file join $dir \ > sqlite3[info sharedlibextension]] sqlite3] > > (I'm using 8.4 because I want to continue using BLT - so don't ask me to > upgrade to 8.5) > > Any help gratefully received > > Richard Laing > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users hi Richard it seems your sqlite.dll do not export the Sqlite_Init function, you can check it's exported functions use Depends.Exe if you are in windows. good luck ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Can't load sqlite 3.75 under tcl 8.4.4.0
As you suggested I tried the load command with the following results: % load C:/Tcl/lib/sqlite3/sqlite3.dll couldn't find procedure Sqlite_Init And then I examined the pkgindex file - and you were right - there is a space. Correcting that, and then doing the package require command again, I get: % package require sqlite couldn't find procedure Sqlite3_Init or alternatively: % package require sqlite 3.7.5 couldn't find procedure Sqlite3_Init Under "load" - Sqlite_Init is missing Under "package require" (either version) - Sqlite3_Init is missing Why the difference? Any suggestions on how to proceed next? I appreciate your responses. On Apr 10, 10:30 pm, Dan Kennedy wrote: > On 04/10/2011 11:43 AM, thoselai...@shaw.ca wrote: > > > % package require sqlite > > couldn't load library "C:/Tcl/lib/sqlite3/sqlite3/.dll": this library or a > > dependent library could not be found in library path > > > What is sqlite3/.dll ? > > Where did that "/" come from? > > > The pkgindex file contains - > > > package ifneeded sqlite 3.7.5 [list load [file join $dir \ > > sqlite3[info sharedlibextension]] sqlite3] > > Maybe there is a space or tab or something between "sqlite3" and > "[info". > > Does the command "load C:/Tcl/lib/sqlite3/sqlite3.dll" work if > you enter it directly? > ___ > sqlite-users mailing list > sqlite-us...@sqlite.orghttp://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] Weird CHECK behavior
On 4/7/11 4:37 PM, "Jay A. Kreibich" wrote: >On Thu, Apr 07, 2011 at 03:45:18PM -0700, Duquette, William H (318K) >scratched on the wall: > >> Hmmm. I tried this; but this constraint fails for ANY value I give it. > >> I tried this: >> >> CHECK (0.0 <= CAST (value AS real)) >> >> But this just casts the string 'NONESUCH' to 0.0, which is no help. > > > What about CHECK( value == CAST( value AS real ) ) ? It took me a while to get back to this--but, YES, that does the trick. Thanks very much! Will > > > Otherwise, I'm not a Tcl guy, so someone else will need to jump in. > > -j > >-- >Jay A. Kreibich < J A Y @ K R E I B I.C H > > >"Intelligence is like underwear: it is important that you have it, > but showing it to the wrong people has the tendency to make them > feel uncomfortable." -- Angela Johnson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 1st Call For Papers, 18th Annual Tcl/Tk Conference 2011
18th Annual Tcl/Tk Conference (Tcl'2011) http://www.tcl.tk/community/tcl2011/ October 24 - 28, 2011 Comfort Suites Manassas Manassas, Virgina, USA Important Dates: Abstracts and proposals due August26, 2011 Notification to authors September 12, 2011 WIP and BOF reservations open August 1, 2011 Author materials due October9, 2011 Tutorials Start October 24, 2011 Conference starts October 26, 2011 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2011 will be held in Manassas, Virgina, USA from October 24 - 28, 2011. The program committee is asking for papers and presentation proposals from anyone using or developing with Tcl/Tk (and extensions). Past conferences have seen submissions covering a wide variety of topics including: * Scientific and engineering applications * Industrial controls * Distributed applications and Network Managment * Object oriented extensions to Tcl/Tk * New widgets for Tk * Simulation and application steering with Tcl/Tk * Tcl/Tk-centric operating environments * Tcl/Tk on small and embedded devices * Medical applications and visualization * Use of different programming paradigms in Tcl/Tk and proposals for new directions. * New areas of exploration for the Tcl/Tk language This year is the fourth year that the Tcl community is participating in the Google Summer of Code. The conference program committee would like to encourage submissions that report on the Tcl projects selected for Google SoC 2011. Submissions should consist of an abstract of about 100 words and a summary of not more than two pages, and should be sent as plain text to no later than August 30, 2011. Authors of accepted abstracts will have until October 14, 2011 to submit their final paper for the inclusion in the conference proceedings. The proceedings will be made available on digital media, so extra materials such as presentation slides, code examples, code for extensions etc. are encouraged. Printed proceedings will be produced as an on-demand book at lulu.com The authors will have 25 minutes to present their paper at the conference. The program committee will review and evaluate papers according to the following criteria: * Quantity and quality of novel content * Relevance and interest to the Tcl/Tk community * Suitability of content for presentation at the conference Proposals may report on commercial or non-commercial systems, but those with only blatant marketing content will not be accepted. Application and experience papers need to strike a balance between background on the application domain and the relevance of Tcl/Tk to the application. Application and experience papers should clearly explain how the application or experience illustrates a novel use of Tcl/Tk, and what lessons the Tcl/Tk community can derive from the application or experience to apply to their own development efforts. Papers accompanied by non-disclosure agreements will be returned to the author(s) unread. All submissions are held in the highest confidentiality prior to publication in the Proceedings, both as a matter of policy and in accord with the U. S. Copyright Act of 1976. The primary author for each accepted paper will receive registration to the Technical Sessions portion of the conference at a reduced rate. Other Forms of Participation The program committee also welcomes proposals for panel discussions of up to 90 minutes. Proposals should include a list of confirmed panelists, a title and format, and a panel description with position statements from each panelist. Panels should have no more than four speakers, including the panel moderator, and should allow time for substantial interaction with attendees. Panels are not presentations of related research papers. Slots for Works-in-Progress (WIP) presentations and Birds-of-a-Feather sessions (BOFs) are available on a first-come, first-served basis starting in August 1, 2011. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 2011. Some WIP and BOF time slots will be held open for on-site reservation. All attendees with an interesting work in progress should consider reserving a WIP slot. Registration Information More information on the conference is available the conference Web site (http://www.tcl.tk/community/tcl2011/) and will be published on various Tcl/Tk-related information channels. To keep in touch with news regarding the conference and Tcl events in general, subscribe to the tcl-announce list. See: http://aspn.activestate.com/ASPN/Mail/ to subscribe to the tcl-announce mailing list. Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Cyndy Lilagan Iomas Research, LLC Brian Griffin Mentor Graphics Ron Fox NSCL/F
Re: [sqlite] Effect of using WAL on technical support
Thanks for confirming this. I did some more testing and turned off connection pooling in SQLite.NET and then the connections got closed correctly. I'll plan on rewriting my own connection pool implementation and not using the one provided by the wrapper. Sam On Sun, Apr 10, 2011 at 10:08 PM, Simon Slavin wrote: > > On 11 Apr 2011, at 2:48am, Richard Hipp wrote: > > > On Sun, Apr 10, 2011 at 9:36 PM, Samuel Neff > wrote: > > > >> I'm sorry, my statement was misleading. I'm referring to immediately > after > >> our application is closed. > >> > >> We're seeing that even if the application is gracefully shut down, the > -wal > >> and -shm files are still there. In order to clear them I need to open > the > >> database files with sqlite3.exe and issue a "pragma wal_checkpoint". > > > > The -wal and -shm are deleted when the last connection to the database > > closes. If you are having -wal and -shm files left over, that implies > that > > you are not closing all your database connections before you exit. > > Yes ! If your application has exited and you still have a journal file, > something is wrong. Are you closing your connection correctly, however > ASP.NET wants you to do it ? > > Simon. > ___ > 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] User function calculates for every row before applying any where condition
On 04/11/2011 05:32 PM, Enrico Thierbach wrote: > > On 11.04.2011, at 10:18, Maxim V. Shiyanovsky wrote: > >> Does SQlite (3.6.23.1 to be precise) perform any optimization when user >> function appears in the statement? >> >> I defined custom function MY_FUNC(a TEXT, b TEXT) and bound it with >> sqlite3_create_function. >> >> Suppose, we have 2 tables: >> Tbl1(id1 INTEGER, id2 INTEGER, str TEXT) with 2 records >> Tbl2(id INTEGER, Tbl1_id INTEGER, str TEXT) with 5000 records >> >> Using query: >> SELECT Tbl2.id, MY_FUNC(Tbl1.str, Tbl2.str) FROM Tbl2 JOIN Tbl1 ON >> Tbl1.id1=Tbl2.Tbl1_id WHERE Tbl2.id>1000 AND Tbl1.id2=1 LIMIT 50 >> I hope MY_FUNC would be evaluated 50 times at most, but it appeared 1. >> >> Using subquery does not do anything with the problem. > > SELECT sq.id, MY_FUNC(sq.str1, sq.str2) FROM >(SELECT Tbl2.id, Tbl1.str AS str1, Tbl2.str AS str2 FROM Tbl2 JOIN Tbl1 ON > Tbl1.id1=Tbl2.Tbl1_id WHERE Tbl2.id>1000 AND Tbl1.id2=1 LIMIT 50) sq > > really doesn't help? This doesn't seem right. What is the whole database schema? Is this the exact query in use or a modified version? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] User function calculates for every row before applying any where condition
On 11.04.2011, at 10:18, Maxim V. Shiyanovsky wrote: > Does SQlite (3.6.23.1 to be precise) perform any optimization when user > function appears in the statement? > > I defined custom function MY_FUNC(a TEXT, b TEXT) and bound it with > sqlite3_create_function. > > Suppose, we have 2 tables: > Tbl1(id1 INTEGER, id2 INTEGER, str TEXT) with 2 records > Tbl2(id INTEGER, Tbl1_id INTEGER, str TEXT) with 5000 records > > Using query: > SELECT Tbl2.id, MY_FUNC(Tbl1.str, Tbl2.str) FROM Tbl2 JOIN Tbl1 ON > Tbl1.id1=Tbl2.Tbl1_id WHERE Tbl2.id>1000 AND Tbl1.id2=1 LIMIT 50 > I hope MY_FUNC would be evaluated 50 times at most, but it appeared 1. > > Using subquery does not do anything with the problem. SELECT sq.id, MY_FUNC(sq.str1, sq.str2) FROM (SELECT Tbl2.id, Tbl1.str AS str1, Tbl2.str AS str2 FROM Tbl2 JOIN Tbl1 ON Tbl1.id1=Tbl2.Tbl1_id WHERE Tbl2.id>1000 AND Tbl1.id2=1 LIMIT 50) sq really doesn't help? /eno ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] User function calculates for every row before applying any where condition
Does SQlite (3.6.23.1 to be precise) perform any optimization when user function appears in the statement? I defined custom function MY_FUNC(a TEXT, b TEXT) and bound it with sqlite3_create_function. Suppose, we have 2 tables: Tbl1(id1 INTEGER, id2 INTEGER, str TEXT) with 2 records Tbl2(id INTEGER, Tbl1_id INTEGER, str TEXT) with 5000 records Using query: SELECT Tbl2.id, MY_FUNC(Tbl1.str, Tbl2.str) FROM Tbl2 JOIN Tbl1 ON Tbl1.id1=Tbl2.Tbl1_id WHERE Tbl2.id>1000 AND Tbl1.id2=1 LIMIT 50 I hope MY_FUNC would be evaluated 50 times at most, but it appeared 1. Using subquery does not do anything with the problem. Any suggestion on how to avoid 1 evaluation of time-consuming function? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users