Re: [sqlite] JSON_EXTRACT does not work with non-BMP characters
> On 11/10/19, Richard Hipp wrote: > > It seems there are also problems in generating valid JSON for large > > unicode characters. For example: > > > > SELECT json_quote(char(1114111)); > > > > I'm working on the problem > I take that back. It seems that the spec allow arbitrary UTF-8 > characters in a JSON string, without the need to escape them using > the backslash notation, except for ", \, and control characters, and > so the current behavior is correct after all, as far as I can tell. > Please let me know if you see any cases that I have mised that do > not work. It seems that it is time to remind everybody about https://github.com/nst/JSONTestSuite and the adjunct article http://seriot.ch/parsing_json.php Actually, the github repository is considered to be an appendix to the article. Might be interesting to submit the sqlite json parser to this testsuite for comparison. -- See you, Andreas Kupries <https://core.tcl-lang.org/akupries/> Developer @ SUSE Software Canada ULC Tcl'2019, Nov 5-8, Houston, TX, USA. http://www.tcl.tk/community/tcl2019/ --- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SIMD based JSON parsing for speeding up JSON extension
> It's only a fair comparison if the simdjson code runs on the same system. > It might reach 10GB/s or 200MB/s⦠> > Another possible concern is whether the SQLite JSON code is 100% compliant AFAIK no known json parser is 100% compliant. > (I don't know if this is the case). There are some hairy edge cases in JSON > (Unicode handling) that might slow down processing if they need to be > handled according to spec. Then the question becomes if that is important. http://seriot.ch/parsing_json.php is a very in-depth analysis of the json spec, its edge cases, and of many json parsers with respect to these. The associated torture test suite used by and written for that article can be found at https://github.com/nst/JSONTestSuite > Just playing devil's advocate, those reasons given look very solid. > > Wout. -- See you, Andreas Kupries <http://core.tcl.tk/akupries/> Developer @ SUSE (MicroFocus Canada LLC) EuroTcl 2019, Jun 29-30, Nuernberg/DE, http://eurotcl.eu/ --- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Infinite loop when updating indexed with case and where clause
> On 1/16/18, Don V Nielsen <donvniel...@gmail.com> wrote: > > Off topic question regarding fix: "0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)" > > > > Is there a performance bonus or compiler optimization if one compares a > > target constant to a source condition versus comparing a target condition > > to a source constant, as in "(wctrlFlags & WHERE_ONEPASS_MULTIROW)!=0"? > > Without actually checking, I'm guessing that both forms generating > identical machine code. The difference is purely a stylistic thing. The difference is when the operator is == and you make a typo, i.e. == vs =. 0 = foofrom 0 == foo vs foo = 0from foo == 0 The first becomes a quickly fixed syntax error, the second an assignment, a not so easily seen bug. -- See you, Andreas Kupries <akupr...@shaw.ca> <http://core.tcl.tk/akupries/> Developer @ SUSE (MicroFocus Canada LLC) <andreas.kupr...@suse.com> --- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] 3.11.0: Tcl sqlite3 extension can't do variable interpolation _and_ json_extract
> On 6/9/17, Zach C. <fxc...@gmail.com> wrote:
> > I was partially unclear with using a constant table name here; what I
> > actually need as well is the table name as effectively a const that I
> > control as well. So more like
> >
> > mydb eval {$SELECT json FROM $table WHERE json_extract(json, '$.hash') =
> > $someId}
>
> Like this then:
>
>mydb eval "SELECT json FROM $table WHERE
> json_extract(json,'\$.hash')=\$someId"
>
> Put a backslash \ before every $ that you want passed down into
> SQLite. And not that you definitely want the $ on $someId passed down
> into SQLite. You do *not* want TCL to expand $someId for you.
How about using the :-form of variable references ?
mydb eval "SELECT json FROM $table WHERE
json_extract(json,':.hash')=:someId"
Tcl will ignore that form, and Sqlite will expand them.
A bit less of quoting hell.
Another alternative:
set map [list < $table]
mydb eval [string map $map {
SELECT json
FROM <>
WHERE json_extract(json,'$.hash')=$someId
}]
I.e. explicit interpolation of a chosen placeholder, here <>,
via [string map], and putting the statement again into {} to prevent
Tcl from doing variable expansion.
--
See you,
Andreas Kupries <akupr...@shaw.ca>
<http://core.tcl.tk/akupries/>
Developer @ SUSE (MicroFocus Canada LLC)
<andreas.kupr...@suse.com>
Tcl'2017, Oct 16-20, Houston, TX, USA. http://www.tcl.tk/community/tcl2017/
EuroTcl 2017, Jul 8-9, Berlin/DE, http://www.eurotcl.tcl3d.org/
---
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] 3rd Call For Papers - 23rd Annual Tcl/Tk Conference (Tcl'2016)
> On 9/5/16, akupr...@shaw.ca <akupr...@shaw.ca> wrote: > > > > Hello SQLite Users, fyi ... > > > > 23rd Annual Tcl/Tk Conference (Tcl'2016) > > http://www.tcl.tk/community/tcl2016/ > > > To clarification the relevancy and appropriateness of Andreas's post > above: SQLite is a TCL extension that has "escaped" into the wide - > perhaps the most famous of all TCL extensions. And SQLite still > heavily depends on TCL for building from canonical sources and for > testing. Thank you for the clarification. -- So long, Andreas Kupries <akupr...@shaw.ca> <http://core.tcl.tk/akupries/> Developer @ Hewlett Packard Enterprise Tcl'2016, Nov 14-18, Houston, TX, USA. http://www.tcl.tk/community/tcl2016/ --- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Article & HN discussion - The beets blog: we’re pretty happy with SQLite & not urgently interested in a fancier DBMS
https://news.ycombinator.com/item?id=11934826 http://beets.io/blog/sqlite-performance.html -- So long, Andreas Kupries <akupr...@shaw.ca> <http://core.tcl.tk/akupries/> Developer @ Hewlett Packard Enterprise Tcl'2016, Nov 14-18, Houston, TX, USA. http://www.tcl.tk/community/tcl2016/ --- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Numerics bigger than 32-bit and sqlite as 64-bit TCL extension
On Tue, Aug 4, 2015 at 12:34 PM, Jan Nijtmans wrote:
> 2015-07-28 11:52 GMT-05:00 Richard Hipp :
>> On 7/28/15, Rafa? Ponikwia wrote:
>>> Hi,
>>> I'm using sqlite3 TCL extension from Teapot (version 64-bit). When I try
>>> to insert number bigger than signed 32-bit it inserts wrong number to
>>> database.
>>> % sqlite3 db C:/tmp/test.sqlite
>>> % db eval {
> CREATE TABLE test (num NUMERIC);
> INSERT INTO test (num) VALUES ($l1), ($l2), ($l3);
> SELECT * FROM test;
> }
>>> 2147483647 2147483649 -2147483647
>>>
>>
>> I get the correct answer (2147483647 2147483649 2147483649) when I try
>> this on 64-bit Ubuntu.
>
> Tried this on both cygwin64 and mingw-w64 (64-bit), getting the same
> correct answer in both environments. e.g.:
> >tclsh86
> % set tcl_platform(pointerSize)
> 8
> % package require sqlite3
> 3.8.11.1
> % info loaded
> {C:/cygwin64/lib/sqlite3.8.11.1/sqlite38111.dll Sqlite3}
> % set l1 [expr {2 ** 31 - 1}]
> 2147483647
> % set l2 2147483649
> 2147483649
> % set l3 [expr {$l1 + 2}]
> 2147483649
> % sqlite3 db test.sqlite
> % db eval {
> CREATE TABLE test (num NUMERIC);
> INSERT INTO test (num) VALUES ($l1), ($l2), ($l3);
> SELECT * FROM test;
> }
> 2147483647 2147483649 2147483649
> %
>
> @Andreas: could this be a compiler issue?
Maybe !?
For the record, we (AS) are using the MS Platform SDK cl.exe for the
64bit build of ActiveTcl, sqlite, etc.
>
> Regards,
> Jan Nijtmans
--
% Tcl'2015 Oct 19-23 = http://www.tcl.tk/community/tcl2015/cfp.html
% EuroTcl'15 June 20-21 = http://www.eurotcl.tcl3d.org/
Andreas Kupries
Senior Tcl Developer
Code to Cloud: Smarter, Safer, Faster?
F: 778.786.1133
andreask at activestate.com, http://www.activestate.com
Learn about Stackato for Private PaaS: http://www.activestate.com/stackato
[sqlite] Is readline ubiquitous on 32-bit x86 Linux?
A possible (and small alternative) to readline would be Antirez "linenoise". Steve Bennet's fork adds windows portability and some other things. https://github.com/antirez/linenoise https://github.com/msteveb/linenoise That is small enough to be directly built as part of the shell, I believe. On Tue, Feb 24, 2015 at 10:01 AM, Dan Kennedy wrote: > > > The pre-built sqlite3 shell tool for x86 Linux available for download here: > > http://www.sqlite.org/download.html > > does not include readline support. Which makes it painful to use. > > Does anyone think that many systems would be affected if it dynamically > linked against the system readline? This means that the binary would not > work on systems without libreadline.so installed. Or is readline considered > ubiquitous by now? > > Dan. > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster? F: 778.786.1133 andreask at activestate.com, http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato
Re: [sqlite] a couple of crashing bugs from a fuzzer
e=pValue@entry=0x7fffc9a4) at sqlite3.c:16463 >> #1 0x004f3aed in sqlite3ExprIsInteger (pValue=0x7fffc9a4, >> p=0xa9edb8) at sqlite3.c:81085 >> #2 exprAlwaysFalse (p=0xa9edb8) at sqlite3.c:15665 >> #3 sqlite3ExprAnd (db=0xa8d598, pLeft=0xa9eeb8, pRight=0xa9edb8) at >> sqlite3.c:15682 >> #4 0x00687b86 in sqlite3PExpr (pParse=0xa9f0c8, op=72, >> pLeft=0xa9eeb8, pRight=0xa9edb8, pToken=0x0) >> at sqlite3.c:81167 >> #5 0x000000752a7c in spanBinaryExpr (pLeft=, >> pLeft=, pRight=, >> pRight=, op=, pParse=> out>, pOut=) at sqlite3.c:120313 >> #6 yy_reduce (yyruleno=, yypParser=) at >> sqlite3.c:57482 >> #7 sqlite3Parser (yyp=0xa9f368, yymajor=-13916, yyminor=..., >> pParse=0x3d5, pParse@entry=0xa9f0c8) at sqlite3.c:58144 >> >> /mz >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > -- > D. Richard Hipp > d...@sqlite.org > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com, http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] fixing time-warp
How about looking into fossil test-shortest-path and see how it follows the path of revisions. ? On Wed, Nov 5, 2014 at 9:04 AM, E. Timothy Uy <t...@loqu8.com> wrote: > Thank you, that is helpful information. > > On Tue, Nov 4, 2014 at 11:52 PM, Stephan Beal <sgb...@googlemail.com> wrote: > >> On Wed, Nov 5, 2014 at 7:07 AM, E. Timothy Uy <t...@loqu8.com> wrote: >> >> > The problem is ultimately not time-warps. DRH can confirm - the problem >> is >> > actually inside fossil and sqlite.fossil. Very early on in sqlite.fossil >> > there are entries in the plink table where the parent id (pid) is greater >> > than the commit id (cid). There are over a thousand of these. >> >> >> Those IDs are _transient_, not part of the historical record. The "child ID >> comes before parent ID" behaviour also appears on completely benign repos >> (i've seen it before in my own while testing libfossil). >> >> >> >> > If I had more brain cells, I could perhaps invent a way to efficiently >> use >> > the plink table to generate the proper export list where parents always >> > come before children regardless of mtime. >> > >> >> i've also attempted something similar in libfossil, but haven't been >> successful. The RIDs cannot be used to figure it out, and neither can >> mtime. The only 100% reliable way i know of traversing the history is to >> read each manifest, as the P-cards give us that piece of context we need to >> know the ordering. >> >> -- >> - stephan beal >> http://wanderinghorse.net/home/stephan/ >> http://gplus.to/sgbeal >> "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of >> those who insist on a perfect world, freedom will have to do." -- Bigby >> Wolf >> ___ >> 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 -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com, http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato 21'st Tcl/Tk Conference: Nov 10-14, Portland, OR, USA -- http://www.tcl.tk/community/tcl2014/ Send mail to tclconfere...@googlegroups.com, by Sep 8 Registration is open. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 21th Tcl Conference - Registration & Hotel Reminder
21'th Annual Tcl/Tk Conference (Tcl'2014) http://www.tcl.tk/community/tcl2014/ This is a reminder that Registration for the Conference is open and can be done at http://www.tcl.tk/community/tcl2014/reg.html Note that the holding period for hotel rooms has passed. To register for a room, call 1-503-796-3851, speak to Mary Kirchner and mention the Tcl Conference to receive the reduced rate. See you in Portland, Andreas Kupries Tcl 2014 Program Chair ActiveState Software Inc. Vancouver, BC, Canada ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] HN has noticed "SQLite 3.8.7 is 50% faster than 3.7.17 "
https://news.ycombinator.com/item?id=8420274 -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com, http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato 21'st Tcl/Tk Conference: Nov 10-14, Portland, OR, USA -- http://www.tcl.tk/community/tcl2014/ Send mail to tclconfere...@googlegroups.com, by Sep 8 Registration is open. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Division accuracy
and reassign >> SortOrders simply in Integer steps: 1, 2, 3 etc., but I want to establish >> how often this should be done, as little as possible preferred, but not so >> little as to allow the order to break or div0 errors or such. >> >> >> >> ___ >> 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 -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com, http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato 21'st Tcl/Tk Conference: Nov 10-14, Portland, OR, USA -- http://www.tcl.tk/community/tcl2014/ Send mail to tclconfere...@googlegroups.com, by Sep 8 Registration is open. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite wrapper for Swift
See also https://news.ycombinator.com/item?id=8226962 for discussion. On Tue, Aug 26, 2014 at 9:09 AM, Simon Slavin <slav...@bigfraud.org> wrote: > A thin SQLite wrapper for Swift: > > <https://github.com/ryanfowler/SwiftData> > > Uses Swift variable types. You have to explicitly say what type you want > your value as. > Implements variable binding for security purposes. > Implements a date class. I have not checked out how well it does this. > > Implements its own transaction structure but you can ignore that and execute > BEGIN/END. You can't mix and match them, though: stick to one or the other. > > Would welcome comments from experienced Swift programmers, if such a thing > can be said to exist. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com, http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato 21'st Tcl/Tk Conference: Nov 10-14, Portland, OR, USA -- http://www.tcl.tk/community/tcl2014/ Send mail to tclconfere...@googlegroups.com, by Sep 8 Registration is open. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 2nd Call For Papers, 21th Annual Tcl/Tk Conference 2014
21'th Annual Tcl/Tk Conference (Tcl'2014) http://www.tcl.tk/community/tcl2014/ [ It is 4 weeks to the deadline for Abstracts and proposals ... ] November 10 - 14, 2014 Embassy Suites Downtown Portland, Oregon, USA Important Dates: Abstracts and proposals due Sep 8, 2014 Notification to authors Sep 22, 2014 Author materials dueOct 20, 2014 Tutorials start Nov 10, 2014 Conference starts Nov 12, 2014 [[ Registration is open. ]] Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2014 will be held in Portland, Oregon, USA from November 10 - 14, 2014. 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 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 5, 2014. Authors of accepted abstracts will have until September 2, 2014 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. WIP slots can be reserved like any paper proposal. BOF slots will be managed on-site. 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/tcl2014/) and will be published on various Tcl/Tk-related information channels. Registration is open. To keep in touch with news regarding the conference and Tcl events in general, subscribe to the tcl-announce list. See: http://code.activestate.com/lists/tcl-announce to subscribe to the tcl-announce mailing list. Conference Committee Clif Flynt Noumena Corp General Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Brian Griffin Mentor GraphicsSite/Facilities Chair Arjen MarkusDeltares Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Donal Fellows University of Manchester Gerald Lester KnG Consulting, LLC Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center Larry Virden Mike Doyle Nati
[sqlite] Fwd: [fossil-users] DRH's PGCon 2014 Keynote (with Fossil sighting!)
-- Forwarded message -- From: Joel Bruick <j...@joelface.com> Date: Sun, Jun 1, 2014 at 4:20 PM Subject: [fossil-users] DRH's PGCon 2014 Keynote (with Fossil sighting!) To: Fossil SCM user's discussion <fossil-us...@lists.fossil-scm.org> I just wanted to share Richard's PGCon 2014 keynote for anyone here that wasn't aware of it: https://www.youtube.com/watch?v=ZvmMzI0X7fE It's a great talk about the historical relationship between SQLite and PostgreSQL as well as a celebration of the usefulness of SQL. Richard goes through several specific examples of how SQLite is currently or could potentially be used as a superior application file format to a "pile of files." He also throws in a dig at NoSQL databases that anyone who appreciates both SQL and the general concept of truth will find highly amusing. Near the end of the speech (around the 32:30 mark), a certain unnamed SQL-based SCM makes a special appearance (spoiler alert: it's Fossil). Thanks, Richard, and everyone else, enjoy! ___ fossil-users mailing list fossil-us...@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato EuroTcl'2014, July 12-13, Munich, GER -- http://www.eurotcl.tcl3d.org/ 21'st Tcl/Tk Conference: Nov 10-14, Portland, OR, USA -- http://www.tcl.tk/community/tcl2014/ Send mail to tclconfere...@googlegroups.com, by Sep 8 Registration is open. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 1st Call For Papers, 21th Annual Tcl/Tk Conference 2014
21'th Annual Tcl/Tk Conference (Tcl'2014) http://www.tcl.tk/community/tcl2014/ November 10 - 14, 2014 Embassy Suites Downtown Portland, Oregon, USA Important Dates: Abstracts and proposals due Sep 8, 2014 Notification to authors Sep 22, 2014 Author materials dueOct 20, 2014 Tutorials start Nov 10, 2014 Conference starts Nov 12, 2014 [[ Registration is open. ]] Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2014 will be held in Portland, Oregon, USA from November 10 - 14, 2014. 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 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 5, 2014. Authors of accepted abstracts will have until September 2, 2014 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. WIP slots can be reserved like any paper proposal. BOF slots will be managed on-site. 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/tcl2014/) and will be published on various Tcl/Tk-related information channels. Registration is open. To keep in touch with news regarding the conference and Tcl events in general, subscribe to the tcl-announce list. See: http://code.activestate.com/lists/tcl-announce to subscribe to the tcl-announce mailing list. Conference Committee Clif Flynt Noumena Corp General Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Brian Griffin Mentor GraphicsSite/Facilities Chair Arjen MarkusDeltares Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Donal Fellows University of Manchester Gerald Lester KnG Consulting, LLC Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center Larry Virden Mike Doyle National Museum of Health & Medicine, Chicago Ron Fox
Re: [sqlite] Is there a way to load a blob from the shell?
On Mon, Apr 7, 2014 at 4:58 PM, Petite Abeille <petite.abei...@gmail.com> wrote: > > On Apr 8, 2014, at 1:46 AM, Andreas Kupries <andre...@activestate.com> wrote: > >> Most generally, a website to show off any kind of contribution to >> sqlite, be it custom function, virtual table, virtual filesystem, >> schemata, other extensions, ... ? Thanks. > > A bit obsolete, but: > > http://www.sqlite.org/contrib > > Perhaps github could be of interest as well: > > https://github.com/search?q=sqlite=cmdform > > For example: > > https://github.com/sqlcipher/sqlcipher -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster(tm) F: 778.786.1133 andre...@activestate.com http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato EuroTcl'2014, July 12-13, Munich, GER -- http://www.eurotcl.tcl3d.org/ 21'st Tcl/Tk Conference: Nov 10-14, Portland, OR, USA -- http://www.tcl.tk/community/tcl2014/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] which of these is faster?
On Thu, Mar 13, 2014 at 11:37 AM, Stephan Beal <sgb...@googlemail.com> wrote: > Hi, all, > > i know this is probably splitting hairs, and i ask only out of curiosity, > not because i'm looking to optimize at this level... > > Given a Fossil repository db (namely the event.mtime value, a Julian Day), > which of the following is faster for finding the min/max value of that > field: > > SELECT MIN(mtime) FROM event; > > or: > > SELECT mtime FROM event ORDER BY mtime LIMIT 1; WIBNI regardless of which form is faster, the engine would detect and rewrite the slower into the other ? Note: Which is faster might depend on if we have an index on the mtime field or not. -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster(tm) F: 778.786.1133 andre...@activestate.com http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato EuroTcl'2014, July 12-13, Munich, GER ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] John Ousterhout Featured Speaker at Tcl New & Proven User Conference in New Orleans (Tcl'2013)
Founder of Tool Command Language to talk about Tcl Past, Present & Future Ann Arbor, MI -- August 16, 2013 -- The Tcl/Tk User Association, which is celebrating over 20 years of innovation using the Tool Command Language (Tcl), confirmed today that John Ousterhout will be a Featured Speaker at the conference in New Orleans, LA from Sept 23-27, 2013. Ousterhout is the original developer of the Tcl and Tk programming language, a combination of the Tool Command Language and the Tk graphical user interface tookit (Tk). His presentation will focus on the evolution of Tcl/Tk from its original language format created at the University of California Berkeley to the most robust and easy-to-learn dynamic programming language that seamlessly powers today's applications. He is also the author of Tcl and the Tk ToolKit (2nd Edition). "John started a revolution born out of frustration," says Clif Flynt, President, Tcl Community Association and author of Tcl/Tk: A Developer's Guide. "Before Tcl, programmers devised their own languages that were intended to be embedded into applications. By creating Tcl/Tk, John created a language for rapid prototyping that works immediately." The Tcl New and Proven user conference will feature several Tcl experts including Jeff Hobbs, Chief Technical Officer at ActiveState, Gerald Lester, creator of Tcl Web Services and a keynote speech by Karl Lehenbauer of FlightAware.com. Programmers attending the conference will learn the best practices for using Tcl's new object-oriented commands and widgets as well as seeing new applications and techniques in the fields ranging from business applications to health, aerospace and beyond. "The Tcl New & Proven User Conference will be focusing on innovation throughout the years," says Flynt. "We are very pleased to have two of the people who helped create the Tcl we know today at our 20th conference." Interested in attending the Tcl conference? Go to http://www.tcl.tk/community/tcl2013/ to register. Learn more about Tcl/Tk by visiting the Tcl Developer Xchange http://www.tcl.tk/ where you can download Tcl 8.6 and a free trial of TDK 5 (Tcl Dev Kit). ### About Tcl/Tk (http://www.tcl.tk/) Celebrating over 20 years of providing rapid prototyping, Tool Command Language (Tcl) is an open source, robust, powerful and easy-to-learn dynamic programming language ideal for today's web and desktop applications, networking, administration, and testing. Tk is a graphical user interface toolkit that enables the development of native-looking GUIs on multiple platforms such as Windows, Mac OS X and Linux. The combination of Tcl and the Tk GUI toolkit is referred to as Tcl/Tk.. The vibrant Tcl user community comes together on the Tcl Developer Xchange website hosted by ActiveState (http://www.tcl.tk/), which provides a variety of resources for programmers working with Tcl/Tk to increase their productivity and share ideas. Worldwide Tcl conferences, Tcl/Tk downloads and access to the Tcler's Wiki are all available online at the Tcl Developer Xchange. The latest books, tutorials and demos are also accessible from this site along with the Tcl core development team that steers the ongoing evolution of the language. Contact: Amy Hesser Hesser Communications Group a...@hessercommunications.com 312-933-8324 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Hotel Room Rate Reminder - 20th Annual Tcl/Tk Conference (Tcl'2013)
20'th Annual Tcl/Tk Conference (Tcl'2013) http://www.tcl.tk/community/tcl2013/ September 23 - 27, 2013 Bourbon Orleans Hotel New Orleans, Louisiana, USA http://www.bourbonorleans.com/ Hello all. This is a general reminder that the offer of reduced rates for rooms at the conference hotel expires on August 19, i.e. in a week. Book Now! (if you haven't already). Of course registration for the Conference is still open at http://www.tcl.tk/community/tcl2013/reg.html To book a room at the conference hotel at reduced rates please follow the instructions on that page. Our schedule can be found at http://www.tcl.tk/community/tcl2013/schedule.html Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Gerald Lester KnG Consulting, LLC Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Donal Fellows University of Manchester Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center Larry Virden Mike Doyle National Museum of Health & Medicine, Chicago Ron Fox NSCL/FRIB Michigan State University Steve Landers Digital Smarties Contact Information tclconfere...@googlegroups.com Tcl'2013 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Registration Open for 19th Annual Tcl/Tk Conference (Tcl'2012)
20'th Annual Tcl/Tk Conference (Tcl'2013) http://www.tcl.tk/community/tcl2013/ September 23 - 27, 2013 Bourbon Orleans Hotel New Orleans, Louisiana, USA http://www.bourbonorleans.com/ I am pleased to announce that registration for the Conference is now open at http://www.tcl.tk/community/tcl2013/reg.html To book a room at the conference hotel at reduced rates please follow the instructions on that page. Note that the offer of reduced rates expires on August 19 (In 2 weeks). Book NOW. Our schedule can be found at http://www.tcl.tk/community/tcl2013/schedule.html Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Donal Fellows University of Manchester Gerald Lester KnG Consulting, LLC Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center Larry Virden Mike Doyle National Museum of Health & Medicine, Chicago Ron Fox NSCL/FRIB Michigan State University Steve Landers Digital Smarties Contact Information tclconfere...@googlegroups.com Tcl'2012 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Serialize an in-memory database
On Wed, Jun 5, 2013 at 12:25 PM, Philip Bennefall <phi...@blastbay.com> wrote: > - Original Message - From: "Petite Abeille" > On Jun 5, 2013, at 9:10 PM, Philip Bennefall <phi...@blastbay.com> wrote: >> Yes, I have seen the backup API. But I would like to avoid the disk file >> entirely and just serialize to and from memory. > Lateral thinking… write your db to tmpfs… > > Doesn't that still create a file, just a temporary one? Yes. It is a RAM disk fs however AFAIK, i.e. in memory, thus matching the constraints given so far. > I need the > serialized content in a char* or similar so I can memcpy it etc, and then Ok, that is not something even tmpfs provides. > feed it back to SqLite at a later time. I guess I could make a toy vfs that > uses a malloc:ed chunk that pretends to be the disk drive, and backup > to/from that to a regular in-memory database. Thoughts? That might be workable. Take me with a heap of salt here, as I have not done anything with sqlite's vfs API whatsoever so far. -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato Tcl'2013, Sep 23-27, New Orleans, LA, USA @ http://www.tcl.tk/community/tcl2013/ EuroTcl'2013, July 6-7, Munich, GER ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Serialize an in-memory database
On Wed, Jun 5, 2013 at 11:55 AM, Philip Bennefall <phi...@blastbay.com> wrote: > Hello all, > > This may be a somewhat strange question, but I can't find an answer to it on > the website so I figured I would give it a shot. > > Is it possible to put the full contents of an SqLite in-memory database into > a string/blob in memory? If you can work with a file instead of string the backup/restore APIs should be able to do what you want, i.e. backup of a live database to a file, and back, and the live database can be in-memory, of course. http://www.sqlite.org/backup.html See example 1. http://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupinit -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato Tcl'2013, Sep 23-27, New Orleans, LA, USA @ http://www.tcl.tk/community/tcl2013/ EuroTcl'2013, July 6-7, Munich, GER ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 3rd Call For Papers, 20th Annual Tcl/Tk Conference 2013
[[ Notes: Abstracts and proposals are now due July 6, 2013 [+ 2 weeks] ]] 20'th Annual Tcl/Tk Conference (Tcl'2013) http://www.tcl.tk/community/tcl2013/ September 23 - 27, 2013 Bourbon Orleans Hotel New Orleans, Louisiana, USA http://www.bourbonorleans.com/ Important Dates: Abstracts and proposals due July 6, 2013 [+ 2 weeks] Notification to authors July 22, 2013 [- 2 weeks] Author materials due September 2, 2013 Tutorials Start September 23, 2013 Conference starts September 25, 2013 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2013 will be held in New Orleans, Louisiana, USA from September 23 - 27, 2013. 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 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 5, 2013. Authors of accepted abstracts will have until September 2, 2013 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 5, 2013. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 3, 2013. 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/tcl2013/) 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://code.activestate.com/lists/tcl-announce to subscribe to the tcl-announce mailing list. Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Gerald Lester KnG Consulting, LLC Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Donal Fel
Re: [sqlite] A sqlite database changing the contents when I change the database name or user rights
Are you possibly running into http://en.wikipedia.org/wiki/Shadow_Copy http://windows.microsoft.com/en-ca/windows-vista/previous-versions-of-files-frequently-asked-questions ? (I guess that when you say 'administrator' you are talking about Windows Admin. On Mon, Apr 8, 2013 at 6:16 AM, Bernardino Flores/Jeanologia <bflo...@jeanologia-laser.com> wrote: > Hi, > > I have found a problem with a sqlite database which I cannot find any > reasonable explanation for it. > I use both "sqliteadmin" and "sqlitebrowser_200_b1_win" editors to check the > contents, and with both I observe the same problem. The problem is that > sometimes I see 7 tables in the database and sometimes 11 tables. After some > hours of looking for the problem I have realized that, if I open the database > with the editor started as administrator I see 11 tables, if not only 7 (and > those 7 tables have not the same contents as the 11 tables db, it seems a > different database, an old one). It happens when I rename the database, too. > Have any found a problem like this? Could it be a windows 7 operative system > error, when indexing files? > > Regards, > > Berna > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Faster™ F: 778.786.1133 andre...@activestate.com http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato Tcl'2013, Sep 23-27, New Orleans, LA, USA @ http://www.tcl.tk/community/tcl2013/ EuroTcl'2013, July 6-7, Munich, GER ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 2nd Call For Papers, 20th Annual Tcl/Tk Conference 2013
[[ Notes: Karl Lehenbauer of FlightAware is confirmed as our Keynote speaker. http://www.flightaware.com ]] 20'th Annual Tcl/Tk Conference (Tcl'2013) http://www.tcl.tk/community/tcl2013/ September 23 - 27, 2013 Bourbon Orleans Hotel New Orleans, Louisiana, USA http://www.bourbonorleans.com/ Important Dates: Abstracts and proposals due June 22, 2013 Notification to authors August 5, 2013 Author materials due September 2, 2013 Tutorials Start September 23, 2013 Conference starts September 25, 2013 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2013 will be held in New Orleans, Louisiana, USA from September 23 - 27, 2013. 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 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 5, 2013. Authors of accepted abstracts will have until September 2, 2013 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 5, 2013. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 3, 2013. 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/tcl2013/) 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://code.activestate.com/lists/tcl-announce to subscribe to the tcl-announce mailing list. Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Gerald Lester KnG Consulting, LLC Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago D
[sqlite] 1st Call For Papers, 19th Annual Tcl/Tk Conference 2012
20'th Annual Tcl/Tk Conference (Tcl'2013) http://www.tcl.tk/community/tcl2013/ September 23 - 27, 2013 Bourbon Orleans Hotel New Orleans, Louisiana, USA Important Dates: Abstracts and proposals due June 22, 2013 Notification to authors August 5, 2013 Author materials due September 2, 2013 Tutorials Start September 23, 2013 Conference starts September 25, 2013 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2013 will be held in New Orleans, Louisiana, USA from September 23 - 27, 2013. 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 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 5, 2013. Authors of accepted abstracts will have until September 2, 2013 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 5, 2013. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 3, 2013. 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/tcl2013/) 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://code.activestate.com/lists/tcl-announce to subscribe to the tcl-announce mailing list. Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Gerald Lester KnG Consulting, LLC Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Donal Fellows University of Manchester Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center L
[sqlite] Hotel Room Rate Reminder - 19th Annual Tcl/Tk Conference (Tcl'2012)
19th Annual Tcl/Tk Conference (Tcl'2012) http://www.tcl.tk/community/tcl2012/ November 12 - 16, 2012 Sessions: National Museum of Health and Medicine Chicago 175 W. Washington Chicago, IL 60602 Rooms: Holiday Inn Chicago Mart Plaza 350 West Mart Center Drive Chicago, Illinois, USA Map/Transport: https://maps.google.com/maps/ms?msid=204739899073144451536.0004c144222a9036c99f6=0=41.885266,-87.633734=0.008443,0.018818 http://wiki.tcl.tk/28843#pagetoca7e55932 Hello all. This is a reminder that the offer of reduced rates for rooms at the conference hotel expires on October 20, i.e. at the end of this week. Book Now! (if you haven't already). And talk to us should you run into trouble with the Hotel claiming to be sold out already before the deadline. Of course registration for the Conference is still open at http://www.tcl.tk/community/tcl2012/reg.html To book a room at the conference hotel at reduced rates please follow the instructions on that page. Our schedule can be found at http://www.tcl.tk/community/tcl2012/schedule.html Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Donal Fellows University of Manchester Gerald Lester KnG Consulting, LLC Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center Larry Virden Mike Doyle National Museum of Health & Medicine, Chicago Ron Fox NSCL/FRIB Michigan State University Steve Landers Digital Smarties Contact Information tclconfere...@googlegroups.com Tcl'2012 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Registration Open for 19th Annual Tcl/Tk Conference (Tcl'2012)
19th Annual Tcl/Tk Conference (Tcl'2012) http://www.tcl.tk/community/tcl2012/ November 12 - 16, 2012 Sessions: National Museum of Health and Medicine Chicago 175 W. Washington Chicago, IL 60602 Rooms: Holiday Inn Chicago Mart Plaza 350 West Mart Center Drive Chicago, Illinois, USA Map/Transport: https://maps.google.com/maps/ms?msid=204739899073144451536.0004c144222a9036c99f6=0=41.885266,-87.633734=0.008443,0.018818 http://wiki.tcl.tk/28843#pagetoca7e55932 I am pleased to announce that registration for the Conference is now open at http://www.tcl.tk/community/tcl2012/reg.html To book a room at the conference hotel at reduced rates please follow the instructions on that page. Note that the offer of reduced rates expires on October 20. Book early. Our schedule can be found at http://www.tcl.tk/community/tcl2012/schedule.html Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Cyndy Lilagan Nat. Museum of Health & Medicine, Chicago Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Donal Fellows University of Manchester Gerald Lester KnG Consulting, LLC Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center Larry Virden Mike Doyle National Museum of Health & Medicine, Chicago Ron Fox NSCL/FRIB Michigan State University Steve Landers Digital Smarties Contact Information tclconfere...@googlegroups.com Tcl'2012 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 3rd Call For Papers, 19th Annual Tcl/Tk Conference 2012
: http://code.activestate.com/lists/tcl-announce 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 Nat. Museum of Health & Medicine, Chicago Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics Donal Fellows University of Manchester Gerald Lester KnG Consulting, LLC Jeffrey Hobbs ActiveState Software Inc. Kevin Kenny GE Global Research Center Larry Virden Mike Doyle National Museum of Health & Medicine, Chicago Ron Fox NSCL/FRIB Michigan State University Steve Landers Digital Smarties Contact Information tclconfere...@googlegroups.com Tcl'2012 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 2nd Call For Papers, 19th Annual Tcl/Tk Conference 2012
[[ Notes: Colin Walker of F5 is confirmed as our Keynote speaker. http://www.f5.com ]] 19th Annual Tcl/Tk Conference (Tcl'2012) http://www.tcl.tk/community/tcl2012/ November 12 - 16, 2012 Holiday Inn Chicago Mart Plaza 350 West Mart Center Drive Chicago, Illinois, USA Important Dates: Abstracts and proposals due August27, 2012 Notification to authors September 10, 2012 WIP and BOF reservations open August 6, 2012 Author materials due October 29, 2012 Tutorials Start November 12, 2012 Conference starts November 14, 2012 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2012 will be held in Chicago, Illinois, USA from November 12 - 16, 2012. 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 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 27, 2012. Authors of accepted abstracts will have until October 29, 2012 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 6, 2012. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 2012. 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/tcl2012/) 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://code.activestate.com/lists/tcl-announce 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 Nat. Museum of Health & Medicine, Chicago Site/Facilities Chair Arjen MarkusDeltares Brian Griffin Mentor Graphics D
[sqlite] 1st Call For Papers, 19th Annual Tcl/Tk Conference 2012
19th Annual Tcl/Tk Conference (Tcl'2012) http://www.tcl.tk/community/tcl2012/ November 12 - 16, 2012 Holiday Inn Chicago Mart Plaza 350 West Mart Center Drive Chicago, Illinois, USA Important Dates: Abstracts and proposals due August27, 2012 Notification to authors September 10, 2012 WIP and BOF reservations open August 6, 2012 Author materials due October 29, 2012 Tutorials Start November 12, 2012 Conference starts November 14, 2012 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2012 will be held in Chicago, Illinois, USA from November 12 - 16, 2012. 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 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 27, 2012. Authors of accepted abstracts will have until October 29, 2012 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 6, 2012. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 2012. 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/tcl2012/) 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://code.activestate.com/lists/tcl-announce 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 Nat. Museum of Health & Medicine, Chicago Site/Facilities Chair Brian Griffin Mentor Graphics Ron Fox NSCL/FRIB Michigan State University Arjen MarkusDeltares Mike Doyle National Mu
Re: [sqlite] Bug in GCC - suggestions sought for a backup tool chain
On 8/22/2011 5:22 PM, Richard Hipp wrote: > Consider this line of code in the "build.c" source file of SQLite: > As it happens, the GCC bug is harmless in this case. SQLite never invokes > the sqlite3SrcListShiftJoinType() function with a non-NULL SrcList pointer > that has a NULL p->a value. So the p->a!=NULL test really is always true. > (Note that the GCC optimizer has no way of knowing that because the function > has external linkage.) And so it didn't matter that the test was omitted. > I didn't notice the problem until this morning, when I upgraded my desktop > to the latest Ubuntu containing GCC 4.5.2, and reran the full branch > coverage tests. GCC 4.5.2 was showing that the p->a!=NULL branch was always > true. Further investigation shows that it has always been always true but > that the GCC 4.1.0 bug simply masked the error up until now. > > I see two take-aways from this episode: > > (1) Compilers sometimes make mistakes. http://blog.regehr.org/ will agree with you, heartily. He is researching on the topic of compiler certification, testing, etc. > So it is important that you test > your object code - not just your source code. That means running your test > cases using exactly the same *.o files that you use for delivery. "Fly what > you test and test what you fly." > (2) I need to come up with a second, independent method of verifying branch > test coverage in SQLite. I have been using GCC+GCOV and it does a great job > and I fully intend to continue using it as the primary tool chain for > development and testing. But in this case, because GCC was omitting a test, > it missed the fact that there was no test coverage for the omitted test. So > it would be nice to have an independently developed tool chain that can be > used to confirm the results we get from GCOV. Anybody have any suggestions? While I do not know of additional tools you could use, maybe Mr Regehr above will. -- Andreas Kupries Senior Tcl Developer ActiveState, The Dynamic Language Experts P: 778.786.1122 F: 778.786.1133 andre...@activestate.com http://www.activestate.com Get insights on Open Source and Dynamic Languages at www.activestate.com/blog ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 2nd Call For Papers, 18th Annual Tcl/Tk Conference 2011
p 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/FRIB Michigan State University Arjen MarkusDeltares Mike Doyle Iomas Research, LLC Gerald Lester KnG Consulting, LLC Donal Fellows University of Manchester Jeffrey Hobbs ActiveState Software Inc. Steve Landers Digital Smarties Kevin Kenny GE Global Research Center Larry VirdenTcl FAQ Maintainer Steve Redler IV SR Technology Contact Information tclconfere...@googlegroups.com Tcl'2011 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ 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
Re: [sqlite] Question about database design
On 2/2/2011 11:48 AM, Bert Nelsen wrote: > Hello! > > I have over 100 columns in a table. Most of the columns will stay empty. > Just an example: [example elided] > This is kind of an xml design, but it works and it takes up less space. > I "decompile" this weird expression at runtime to get the separate values > again. > > Can I get an opinion on it? > I have not found any good information on the number of columns and > relationship between their count and speed and diskspace used. It seems to me that you are looking for http://en.wikipedia.org/wiki/Database_normalization -- Andreas Kupries Senior Tcl Developer ActiveState, The Dynamic Language Experts P: 778.786.1122 F: 778.786.1133 andre...@activestate.com http://www.activestate.com Get insights on Open Source and Dynamic Languages at www.activestate.com/blog ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Register For The 17th Annual Tcl/Tk Conference 2010
17th Annual Tcl/Tk Conference (Tcl'2010) http://www.tcl.tk/community/tcl2010/ October 11 - 15, 2010 Hilton Suites/Conference Center Chicago/Oakbrook Terrace, Illinois, USA Registration for the Conference is open at http://www.tcl.tk/community/tcl2010/reg.html To book a room at the conference hotel at reduced rates follow the link on that page. Note that this offer expires on September 26. Book early. Our schedule can be found at http://www.tcl.tk/community/tcl2010/schedule.html We have special social activites October 15, 2010 - Friday afternoon -- Tour of Fermilab Fermi National Accelerator Laboratory, http://www.fnal.gov/ Tour signup is at the conference, Wednesday, Oct 13. A tour lasts about two hours and begins in Wilson Hall. Visitors view the Laboratory from the 15th floor windows and visit various displays located there. The tour moves to the Linear Accelerator building where visitors see the Cockcroft-Walton, the components in the linear accelerator gallery and the Main Control Room. There is a docent for every 20 people. Registration required since tours must be arranged in advance. October 15, 2010 - Friday evening Dinner-theater at the award winning Drury Lane theater located next to our hotel. Special package price for dinner and theater at $44.00 per person. Regularly $64 per person. Please make reservation and payment at time of registration, or by Wednesday Oct 13 latest (at the conference). "Seven Brides for Seven Brothers" http://www.drurylaneoakbrook.com/ Bill Jenkins is one of the newest and most exciting new directors on the Chicago scene. As Chairman of the Department of Theatre and Dance at Ball State University, he heads one of the nation's largest theatre programs. After admiring his work with other Chicago area theatres, we are very pleased for this opportunity to showcase his talent at Drury Lane. Once Bill shared some of the fresh ideas and insights he had for ÂSeven Brides for Seven BrothersÂ, we knew we would have a great show for the holidays. Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Cyndy Lilagan Iomas Research, LLC Facilities Coordination Brian Griffin Mentor Graphics Ron Fox NSCL/FRIB Michigan State University Arjen MarkusDeltares Mike Doyle Iomas Research, LLC Gerald Lester KnG Consulting, LLC Donal Fellows University of Manchester Jeffrey Hobbs ActiveState Software Inc. Steve Landers Digital Smarties Kevin Kenny GE Global Research Center Larry VirdenTcl FAQ Maintainer Steve Redler IV SR Technology Contact Information tclconfere...@googlegroups.com Tcl'2010 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 3rd Call For Papers, 17th Annual Tcl/Tk Conference 2010
mailing list. Special Social Activites October 15, 2010 - Friday afternoon -- Tour of Fermilab Fermi National Accelerator Laboratory, http://www.fnal.gov/ A tour lasts about two hours and begins in Wilson Hall. Visitors view the Laboratory from the 15th floor windows and visit various displays located there. The tour moves to the Linear Accelerator building where visitors see the Cockcroft-Walton, the components in the linear accelerator gallery and the Main Control Room. There is a docent for every 20 people. Registration required since tours must be arranged in advance. October 15, 2010 - Friday evening Dinner-theater at the award winning Drury Lane theater located next to our hotel. . Special package price for dinner and theater at $44.00 per person. Regularly $64 per person. "Seven Brides for Seven Brothers" http://www.drurylaneoakbrook.com/ Bill Jenkins is one of the newest and most exciting new directors on the Chicago scene. As Chairman of the Department of Theatre and Dance at Ball State University, he heads one of the nation's largest theatre programs. After admiring his work with other Chicago area theatres, we are very pleased for this opportunity to showcase his talent at Drury Lane. Once Bill shared some of the fresh ideas and insights he had for ÂSeven Brides for Seven BrothersÂ, we knew we would have a great show for the holidays. Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Cyndy Lilagan Iomas Research, LLC Facilities Coordination Brian Griffin Mentor Graphics Ron Fox NSCL/FRIB Michigan State University Arjen MarkusDeltares Mike Doyle Iomas Research, LLC Gerald Lester KnG Consulting, LLC Donal Fellows University of Manchester Jeffrey Hobbs ActiveState Software Inc. Steve Landers Digital Smarties Kevin Kenny GE Global Research Center Larry VirdenTcl FAQ Maintainer Steve Redler IV SR Technology Contact Information tclconfere...@googlegroups.com Tcl'2010 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 2 Call For Papers, 17th Annual Tcl/Tk Conference 2010
, subscribe to the tcl-announce list. See: http://aspn.activestate.com/ASPN/Mail/ to subscribe to the tcl-announce mailing list. Special Social Activites October 15, 2010 - Friday afternoon -- Tour of Fermilab Fermi National Accelerator Laboratory, http://www.fnal.gov/ A tour lasts about two hours and begins in Wilson Hall. Visitors view the Laboratory from the 15th floor windows and visit various displays located there. The tour moves to the Linear Accelerator building where visitors see the Cockcroft-Walton, the components in the linear accelerator gallery and the Main Control Room. There is a docent for every 20 people. Registration required since tours must be arranged in advance. October 15, 2010 - Friday evening Dinner-theater at the award winning Drury Lane theater located next to our hotel. . Special package price for dinner and theater at $44.00 per person. Regularly $64 per person. "Seven Brides for Seven Brothers" http://www.drurylaneoakbrook.com/ Bill Jenkins is one of the newest and most exciting new directors on the Chicago scene. As Chairman of the Department of Theatre and Dance at Ball State University, he heads one of the nation's largest theatre programs. After admiring his work with other Chicago area theatres, we are very pleased for this opportunity to showcase his talent at Drury Lane. Once Bill shared some of the fresh ideas and insights he had for ÂSeven Brides for Seven BrothersÂ, we knew we would have a great show for the holidays. Conference Committee Clif Flynt Noumena CorpGeneral Chair, Website Admin Andreas Kupries ActiveState Software Inc. Program Chair Cyndy Lilagan Iomas Research, LLC Facilities Coordination Brian Griffin Mentor Graphics Ron Fox NSCL/FRIB Michigan State University Arjen MarkusDeltares Mike Doyle Iomas Research, LLC Gerald Lester KnG Consulting, LLC Donal Fellows University of Manchester Jeffrey Hobbs ActiveState Software Inc. Steve Landers Digital Smarties Kevin Kenny GE Global Research Center Larry VirdenTcl FAQ Maintainer Steve Redler IV SR Technology Contact Information tclconfere...@googlegroups.com Tcl'2010 would like to thank those who are sponsoring the conference: ActiveState Software Inc. Buonacorsi Foundation Mentor Graphics Noumena Corp. SR Technology Tcl Community Association ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Loading Sqlite3 DB into memory
Max Cat wrote: > Thanks. In writing the VFS, I see several function pointers that don't appear > to have explanations. Can anyone help shed some light on what the following > are supposed to do (and what their parameters are)? > > From http://sqlite.org/c3ref/vfs.html > > void *(*xDlOpen)(sqlite3_vfs*, const char *zFilename); > void (*xDlError)(sqlite3_vfs*, int nByte, char *zErrMsg); > void (*(*xDlSym)(sqlite3_vfs*,void*, const char *zSymbol))(void); > void (*xDlClose)(sqlite3_vfs*, void*); These seem to be abstractions of dlopen, dlsym, etc., i.e. the functions for dynamically loading shared libraries into a process, accessing its symbols, etc. -- Andreas Kupries Senior Tcl Developer ActiveState, The Dynamic Language Experts P: 778.786.1122 F: 778.786.1133 andre...@activestate.com http://www.activestate.com Get insights on Open Source and Dynamic Languages at www.activestate.com/blog ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 1st Call For Papers, 17th Annual Tcl/Tk Conference 2010
17th Annual Tcl/Tk Conference (Tcl'2010) http://www.tcl.tk/community/tcl2010/ October 11 - 15, 2010 Hilton Suites/Conference Center Chicago/Oakbrook Terrace, Illinois, USA Important Dates: Abstracts and proposals due August 1, 2010 Notification to authors August 15, 2010 WIP and BOF reservations open August 1, 2010 Author materials due October 1, 2010 Tutorials Start October 11, 2010 Conference starts October 13, 2010 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2010 will be held in Chicago/Oakbrook Terrace, Illinois USA from October 11 - 15, 2010. 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 third 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 2010. 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 15, 2010. Authors of accepted abstracts will have until October 1, 2010 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, 2010. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 2010. 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/tcl2010/) 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 Facilities Coordination Brian
Re: [sqlite] SQLite version 3.6.23
D. Richard Hipp wrote: > On Mar 10, 2010, at 12:54 AM, Melton Low wrote: > >> I just tried to build 3.6.23 on a PPC Mac running OS X 10.4. > > Please try adding SQLITE_ENABLE_LOCKING_STYLE=0 to the compiler options. >>> I got an undefined symbol error and the make aborted. >> /bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1 >> -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -o libsqlite3.la >> -rpath I got the same undefined symbol in our OS X builds. Adding the -DSQLITE_ENABLE_LOCKING_STYLE=0 fixed it for me, on both machines (Tiger, Leopard). -- Sincerely, Andreas Kupries <andr...@activestate.com> Developer @<http://www.activestate.com/> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Multi-master replication through UPDATE and INSERT logging?
Simon Slavin wrote:
> On 17 Sep 2009, at 5:29pm, Simon Slavin wrote:
>> [stuff]
> Sorry, I forgot to add: you are asking questions about a subject which
> is frequently raised here: synchronising multiple copies of a
> database. This stuff is hard.
Note also
http://www.sqliteconcepts.org
and especially
http://www.sqliteconcepts.org/DCS_index.html
--
Sincerely,
Andreas Kupries <andr...@activestate.com>
Developer @<http://www.activestate.com/>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] tea tarball ditto affected - Re: SQLite version 3.6.17
D. Richard Hipp wrote: > On Aug 10, 2009, at 5:11 PM, Andreas Kupries wrote: >>> The amalgamation has been rebuilt and a new (corrected) version is on >>> the website. >>> >>> The underlying problem is that a new SQLITE_API is added to the >>> sqlite3.h file every time you do "make sqlite3.c". So if you do that >>> multiple times without doing "make clean" in between, you get >>> multiple >>> copies of SQLITE_API. We'll fix the makefile later. The present fix >>> is to do "make clean; make sqlite3.c" before rebuilding the >>> amalgamation tarball. >> The TEA tarball is apparently affected in the same way, and doesn't >> seem to >> have been updated. > > > Does it need to be? Does anybody every define SQLITE_API to anything > other than nothing on a TEA build? Hm. Let me check ... Ok, according to the grep I have lots of uses, and only one definition, to empty (if undefined, the default). Nothing in configure, nor configure.in ... Ok, you are correct, it should not matter to TEA and me. Apologies for the quick-shot mail without checking before. Andreas. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] tea tarball ditto affected - Re: SQLite version 3.6.17
D. Richard Hipp wrote: > On Aug 10, 2009, at 3:30 PM, Roger Binns wrote: >> There is a problem in the amalgamation (.tar.gz but not .zip) where >> SQLITE_API is repeated multiple times making the code invalid if >> defined to >> anything. Example: >> >>> SQLITE_API const char sqlite3_version[] = SQLITE_VERSION; >>> SQLITE_API SQLITE_API SQLITE_API SQLITE_API const char >>> *sqlite3_libversion(void); >>> SQLITE_API SQLITE_API SQLITE_API SQLITE_API int >>> sqlite3_libversion_number(void); > > > The amalgamation has been rebuilt and a new (corrected) version is on > the website. > > The underlying problem is that a new SQLITE_API is added to the > sqlite3.h file every time you do "make sqlite3.c". So if you do that > multiple times without doing "make clean" in between, you get multiple > copies of SQLITE_API. We'll fix the makefile later. The present fix > is to do "make clean; make sqlite3.c" before rebuilding the > amalgamation tarball. The TEA tarball is apparently affected in the same way, and doesn't seem to have been updated. Andreas. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] "database is locked" on clean install, empty database?
> > I must be missing something: > > $ sudo apt-get install sqlite3 > ... > Selecting previously deselected package sqlite3. > ... > Setting up sqlite3 (3.3.8-1.1) ... > $ ls -l test.db > ls: test.db: No such file or directory > $ sqlite3 test.db > SQLite version 3.3.8 > Enter ".help" for instructions > sqlite> create table foo (node_id, timestamp, tput); > SQL error: database is locked > What am I doing wrong? Is the database file by chance in a NFS mounted directory ? -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] Suggests for improving the SQLite website
> I don't think the extra bandwidth is an issue. Dan points out that > if you put the CSS in a separate file, then sometimes a browser > will render the page without CSS, then when the CSS arrives a > fraction of a second later, everything shifts. I'd rather avoid > that. > > I am now also told that web pages need to be designed for > three separate browsers: IE6, IE7, and all others. This is > madness. Richard, talk to SteveL. IIRC he did the CSS for the Tcler's Wiki recently, or at least knows who did ... Might have been Jos DeCoster too. And that CSS has IIRC a lot of the tricks for nice display on a variety of browsers. +1 on the madness. -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122 - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Trouble compiling with MSVC++ 6.0
> > The problem is actually linked to the optimizations in the release code. > If you compile it without optimizations (for example, in Debug mode), it > compiles successfully. Testing ... Without -O2 it compiles ok, -O1, -O2 fails, -O3 is ok. > I made some tests, and you can compile all the rest of the files (if you > don't use the amalgamation file) I am using the TEA tarball, which is based on the amalgamation. >with release flags; and you can even > compile btree.c if you do the following: > - Select btree.c > - Right-click the file in the FileView and select 'Settings' from the menu > - Select the 'C/C++' tab on the right > - Select 'Customize' in the Optimizations box > - Mark all the check boxes in the list, EXCEPT for: > Assume Aliasing Across Function Calls* > Favor Small Code > - Select the Online _inline option in the inline functions box > - Click OK > > Now it should compile (my VC6 with SP6 compiler reads Version 12.00.8804). My cl (with SP6 installed) gives me the same version, i.e. 12.00.8804. so we are on the same page there. > As this is just an optimization that fails, the code should work. > > * The actual problem is with this option. It can probably be turned of > specifically for this file using a VC6 macro Ok... Will see if I can find pragmas to set the opt level for parts of a single file ... And find out what O1/2/3 mean, too. Thanks for that information. -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122 - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: Re[2]: [sqlite] Trouble compiling with MSVC++ 6.0
I dod not believe that I am using pre-compiled headers at all. The compile command is, nicely broken across lines cl -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" \ -DPACKAGE_VERSION=\"3.4.0\" -DPACKAGE_STRING=\"sqlite\ 3.4.0\" \ -DPACKAGE_BUGREPORT=\"\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 \ -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 \ -DHAVE_MEMORY_H=1 -DBUILD_sqlite=1 -DTCL_THREADS=1 \ -DTHREADSAFE=1 -DUSE_TCL_STUBS=1 -Dfdatasync=fsync \ -DSQLITE_ENABLE_FTS2=1 \ -I"../generic" \ -I"/e/Home/dbn/lba/night/builds/win32-ix86/tcl/generic" \ -nologo -O2 -W2 -MD \ -c `cygpath -w ../generic/tclsqlite3.c` -o tclsqlite3.obj Per google I should have a -XY there to activate PCH -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122 > -Original Message- > From: Teg [mailto:[EMAIL PROTECTED] > Sent: Monday, June 25, 2007 3:38 PM > To: Andreas Kupries > Subject: Re[2]: [sqlite] Trouble compiling with MSVC++ 6.0 > > > Hello Andreas, > > Try turning off pre-compiled headers for that module. > > C > > Monday, June 25, 2007, 6:29:40 PM, you wrote: > > >> > Ticket #2457 reports difficulty building SQLite version 3.4.0 > >> > using MSVC++ 6.0. This appears to be a bug in MSVC++. See the > >> > comments on the ticket for details: > >> > > >> >http://www.sqlite.org/cvstrac/tktview?tn=2457 > >> > > >> > I do not own MSVC++ (and have no intention of acquiring a copy) > >> > so I am unable to reproduce. On the other hand, Version 3.4.0 > >> > has been out for a week and there have been no other reports > >> > of problems, so I am somewhat suspicious that this problem is > >> > specific to the specific installation. > >> > > >> > Can anybody shed any light on ticket #2457? Can anybody else > >> > reproduce the problem or suggest a work-around? > >> > >> Error in MSVC 6.0 -- the user who wrote the ticket hasn't installed the > >> latest service pack of VC6. > >> > >> http://support.microsoft.com/kb/890892 > > AK> The article sounds like a very likely match (large macros). > > AK> Just retrieved and installed VC6 SP6, rebooted the machine > ... The compiler > AK> now reports a different build number, higher than before, so > I guess really > AK> did not have that ServicePack before ... > > AK> Compiling the original sources (not the ones I messed with) > ... I however > AK> still run into the same internal compiler error, in the same > line of code. > > AK> :( > > AK> -- > AK> Andreas Kupries <[EMAIL PROTECTED]> > AK> Developer @ http://www.ActiveState.com > AK> Tel: +1 778-786-1122 > > > > AK> > -- > --- > AK> To unsubscribe, send email to [EMAIL PROTECTED] > AK> > -- > --- > > > > > -- > Best regards, > Tegmailto:[EMAIL PROTECTED] > > > -- > --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- > --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Trouble compiling with MSVC++ 6.0
> I know VC++ 8.0 (2005) works like a charm!
I do not believe that I will have the option to upgrade.
--
Andreas Kupries <[EMAIL PROTECTED]>
Developer @ http://www.ActiveState.com
Tel: +1 778-786-1122
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
RE: [sqlite] Trouble compiling with MSVC++ 6.0
> > Ticket #2457 reports difficulty building SQLite version 3.4.0 > > using MSVC++ 6.0. This appears to be a bug in MSVC++. See the > > comments on the ticket for details: > > > >http://www.sqlite.org/cvstrac/tktview?tn=2457 > > > > I do not own MSVC++ (and have no intention of acquiring a copy) > > so I am unable to reproduce. On the other hand, Version 3.4.0 > > has been out for a week and there have been no other reports > > of problems, so I am somewhat suspicious that this problem is > > specific to the specific installation. > > > > Can anybody shed any light on ticket #2457? Can anybody else > > reproduce the problem or suggest a work-around? > > Error in MSVC 6.0 -- the user who wrote the ticket hasn't installed the > latest service pack of VC6. > > http://support.microsoft.com/kb/890892 The article sounds like a very likely match (large macros). Just retrieved and installed VC6 SP6, rebooted the machine ... The compiler now reports a different build number, higher than before, so I guess really did not have that ServicePack before ... Compiling the original sources (not the ones I messed with) ... I however still run into the same internal compiler error, in the same line of code. :( -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122 - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Version 3.4.0
> > Is the incremental blob I/O available at the level of the Tcl binding ? > > From the online information this seems to be currently available only at the > > C level. > > Yes. There is a new (undocumented!) "incrblob" method on the > database object that opens a channel to BLOB. The syntax is > like this: > > db incrblob ?-readonly? ?DBNAME? TABLENAME COLUMN ROWID > > I neglected to update the documentation to describe how this > works. Please open a ticket for me so that I do not forget > again... Done. http://www.sqlite.org/cvstrac/tktview?tn=2424 Oh. Oh. Will/does this work with fts1/2/... etc as well ? Adding question to the ticket. -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122 - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Version 3.4.0
> SQLite version 3.4.0 is now available for download from the SQLite > website and from the back-up site: > > Version 3.4.0 also includes support for new features such as: > >* Incremental BLOB I/O > > Additional information about these new features is available online. Is the incremental blob I/O available at the level of the Tcl binding ? >From the online information this seems to be currently available only at the C level. -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122 - To unsubscribe, send email to [EMAIL PROTECTED] -
