Re: [sqlite] JSON_EXTRACT does not work with non-BMP characters

rticle. 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'

Re: [sqlite] SIMD based JSON parsing for speeding up JSON extension

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

Re: [sqlite] Infinite loop when updating indexed with case and where clause

. 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>

Re: [sqlite] 3.11.0: Tcl sqlite3 extension can't do variable interpolation _and_ json_extract

cit 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

Re: [sqlite] 3rd Call For Papers - 23rd Annual Tcl/Tk Conference (Tcl'2016)

ndreas'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,

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, Hous

[sqlite] Numerics bigger than 32-bit and sqlite as 64-bit TCL extension

483649 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/communi

[sqlite] Is readline ubiquitous on 32-bit x86 Linux?

_ > 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 active

Re: [sqlite] a couple of crashing bugs from a fuzzer

8, 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=, yypPars

Re: [sqlite] fixing time-warp

s.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 >> sqlit

[sqlite] 21th Tcl Conference - Registration & Hotel Reminder

, 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

[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

Re: [sqlite] Division accuracy

tablish >> 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.or

Re: [sqlite] SQLite wrapper for Swift

te.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

[sqlite] 2nd Call For Papers, 21th Annual Tcl/Tk Conference 2014

, 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 Univer

[sqlite] Fwd: [fossil-users] DRH's PGCon 2014 Keynote (with Fossil sighting!)

/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.eu

[sqlite] 1st Call For Papers, 21th Annual Tcl/Tk Conference 2014

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

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

Re: [sqlite] which of these is faster?

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 P

[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

[sqlite] Hotel Room Rate Reminder - 20th Annual Tcl/Tk Conference (Tcl'2013)

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

[sqlite] Registration Open for 19th Annual Tcl/Tk Conference (Tcl'2012)

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 C

Re: [sqlite] Serialize an in-memory database

ckup > 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

Re: [sqlite] Serialize an in-memory database

kup.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.actives

[sqlite] 3rd Call For Papers, 20th Annual Tcl/Tk Conference 2013

://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

Re: [sqlite] A sqlite database changing the contents when I change the database name or user rights

e 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: Smart

[sqlite] 2nd Call For Papers, 20th Annual Tcl/Tk Conference 2013

. 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

[sqlite] 1st Call For Papers, 19th Annual Tcl/Tk Conference 2012

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

[sqlite] Hotel Room Rate Reminder - 19th Annual Tcl/Tk Conference (Tcl'2012)

General 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] Registration Open for 19th Annual Tcl/Tk Conference (Tcl'2012)

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/Facili

[sqlite] 3rd Call For Papers, 19th Annual Tcl/Tk Conference 2012

. 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 C

[sqlite] 2nd Call For Papers, 19th Annual Tcl/Tk Conference 2012

-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

[sqlite] 1st Call For Papers, 19th Annual Tcl/Tk Conference 2012

-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, Chi

Re: [sqlite] Bug in GCC - suggestions sought for a backup tool chain

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 De

[sqlite] 2nd Call For Papers, 18th Annual Tcl/Tk Conference 2011

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

[sqlite] 1st Call For Papers, 18th Annual Tcl/Tk Conference 2011

, 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

Re: [sqlite] Question about database design

n.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] Register For The 17th Annual Tcl/Tk Conference 2010

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/FRI

[sqlite] 3rd Call For Papers, 17th Annual Tcl/Tk Conference 2010

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

[sqlite] 2 Call For Papers, 17th Annual Tcl/Tk Conference 2010

r, 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

Re: [sqlite] Loading Sqlite3 DB into memory

lsym, 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 Ope

[sqlite] 1st Call For Papers, 17th Annual Tcl/Tk Conference 2010

General 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

Re: [sqlite] SQLite version 3.6.23

d 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?

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 lis

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 >>> sqlite

[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[] =

Re: [sqlite] "database is locked" on clean install, empty database?

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]>

RE: [sqlite] Suggests for improving the SQLite website

as 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

RE: [sqlite] Trouble compiling with MSVC++ 6.0

d 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. --

RE: Re[2]: [sqlite] Trouble compiling with MSVC++ 6.0

-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 P

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

RE: [sqlite] Trouble compiling with MSVC++ 6.0

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

/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

RE: [sqlite] Version 3.4.0

ine. 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