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

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

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

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

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

he 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 <htt

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

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 <http://core.tcl.tk/akupries/> Developer @ SUS

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

> 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 <http://core.tcl.tk/akupries/> Developer @ Hewlett Packard Enterprise Tcl'2016, Nov 14-18, Houston, TX, USA. http:/

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

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.

[sqlite] AUTOINC vs. UUIDs

> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cg

[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 a

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

, op=72, >> pLeft=0xa9eeb8, pRight=0xa9edb8, pToken=0x0) >> at sqlite3.c:81167 >> #5 0x00752a7c in spanBinaryExpr (pLeft=, >> pLeft=, pRight=, >> pRight=, op=, pParse=> out>, pOut=) at sqlite3.c:120313 >> #6 yy_reduce (yyruleno=,

Re: [sqlite] fixing time-warp

#x27;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/cg

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

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 l

[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 Confe

Re: [sqlite] Division accuracy

divs might be exhausted quick. >> >> The question is - how can I accurately establish how many >> total-then-divide-by-2's a set of co-values in 64-bit FP guise can >> withstand before the difference is too small to make sense to the sorter in >> SQLite? &

Re: [sqlite] SQLite wrapper for Swift

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

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

eral 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

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

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 Ku

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

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 So

Re: [sqlite] Is there a way to load a blob from the shell?

On Mon, Apr 7, 2014 at 4:58 PM, Petite Abeille wrote: > > On Apr 8, 2014, at 1:46 AM, Andreas Kupries wrote: > >> Most generally, a website to show off any kind of contribution to >> sqlite, be it custom function, virtual table, virtual filesystem, >> schemata, othe

Re: [sqlite] Is there a way to load a blob from the shell?

agrams of various kinds, ER diagrams, ...) Similarly, a website to show off/demo virtual tables of kinds ? Most generally, a website to show off any kind of contribution to sqlite, be it custom function, virtual table, virtual filesystem, schemata, other extensions, ... ? -- Andreas Kupries Senio

Re: [sqlite] which of these is faster?

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.

[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)

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

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

edule.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/Fa

Re: [sqlite] Serialize an in-memory database

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

Re: [sqlite] Serialize an in-memory database

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

[sqlite] 3rd 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

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

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

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

ounce 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 Ger

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

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 Cyn

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

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 Bria

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

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

[sqlite] 3rd 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

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

e 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 Softwar

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

e 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

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

e 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 Sen

[sqlite] 3rd Call For Papers, 18th Annual Tcl/Tk Conference 2011

l/ 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 M

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

ounce 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

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

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

ommittee 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

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

nsights 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 Lil

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

neral 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 Markus

Re: [sqlite] Loading Sqlite3 DB into memory

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 O

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

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

Re: [sqlite] SQLite version 3.6.23

d it for me, on both machines (Tiger, Leopard). -- Sincerely, Andreas Kupries 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 Developer @<http://www.activestate.com/> ___ sqlite-users mailing list sqlite-users@sqlite.org http:/

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?

te 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

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

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

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

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

l 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