Re: [sqlite] SQLite version 3.6.4
Sorry, I should have stated that I am not defining SQLITE_MUTEX_NOOP explicitly. SQLITE_MUTEX_NOOP is defined implicitly if you let SQLITE_THREADSAFE default to 1 and define SQLITE_OS_OTHER=1 (i.e. do not use SQLITE_OS_UNIX, SQLITE_OS_WIN or SQLITE_OS_OS2). I know this won't affect many people, but it's an issue if you're building for an embedded platform. Cheers, Dave. -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: 15 October 2008 10:52 To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite version 3.6.4 On Oct 15, 2008, at 1:31 PM, Dave Toll wrote: > I found a small compile error when SQLITE_MUTEX_NOOP is defined with > the > amalgamation source: > SQLITE_MUTEX_NOOP is an internal symbol that gets set if and only if you define SQLITE_THREADSAFE=0. You should not set SQLITE_MUTEX_NOOP yourself. Instead set SQLITE_THREADSAFE=0 and let SQLITE_MUTEX_NOOP be set automatically. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4
I found a small compile error when SQLITE_MUTEX_NOOP is defined with the amalgamation source: sh4gcc -ansi -fsigned-char -mruntime=os21 -ml -c -O0 -DSQLITE_OS_OTHER=1 -DSQLITE_32BIT_ROWID=1 -DSQLITE_INT64_TYPE=long -DSQLITE_OMIT_AUTHORIZATION -DSQLITE_OMIT_AUTOINCREMENT -DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM -DSQLITE_OMIT_CAST -DSQLITE_OMIT_CHECK -DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_COMPOUND_SELECT -DSQLITE_OMIT_CONFLICT_CLAUSE -DSQLITE_OMIT_DECLTYPE -DSQLITE_OMIT_FLAG_PRAGMAS -DSQLITE_OMIT_FOREIGN_KEY -DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_INCRBLOB -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_PROGRESS_CALLBACK -DSQLITE_OMIT_SCHEMA_VERSION_PRAGMAS -DSQLITE_OMIT_TCL_VARIABLE -DSQLITE_OMIT_XFER_OPT -DUSE_RAWPPP_DL -DUSE_PSW_DL -DEVENTBRK_TEST -DINCLUDE_TEST_POPUP -DOPENTV_FUSION -DFNS_REAL_SKEPTIC -DDHCP -DNO_PACKED_STRU -DNO_STASS -DRAWPPP_MODEM_TEST -DHTTP -DSECURITY_PRESENT -DFUSION_CALLS_REDEFINE -DUSE_RAWSTK_MODEM_ERRORS -DRAWPPP -DFUSION_CALLS_REDEFINE -DUSE_THE_XSOCKET -DDVB_SI -DUSE_THE_HDMI -DUSE_THE_SQLDB -DUSE_THE_SQLITE -D__st40__ -Dinline=__inline -D__LITTLE_ENDIAN__ -D__LONG_INT__ -D__LONG_ALIGN__ -D__FLAT__ -D_ANSI_C_SOURCE -DKERNEL_HAS_ANSI -DUSE_THE_FONT16EXT -DUSE_THE_EITS -DUSE_THE_HTTP -DUSE_THE_PPPLINK -DUSE_THE_XSOCKET -DUSE_THE_ETHERNET -DUSE_THE_EVENTBRK -DUSE_THE_SVSCALE -DUSE_THE_IMAGE -DUSE_THE_XYMAN -DUSE_THE_FEP -DUSE_THE_FEMGR -DUSE_THE_FONT16_GLUE -DUSE_THE_NATAPP -DUSE_THE_MODEMSVC -DUSE_THE_USERPROF -DUSE_THE_ATTRIBUTE -DUSE_THE_DEBTRACE -DUSE_THE_VOD -DUSE_THE_PVR -DUSE_PVR_MPEG_MEDIUM -DUSE_CORE_2_DRIVERS -DUSE_THE_SSLEXT -DUSE_THE_OPENTV_SI -DUSE_THE_VKBENH -DUSE_THE_SCARTSW -DUSE_THE_APPSTOR -DUSE_THE_EEFILSYS -DUSE_THE_FMFILE -DUSE_THE_RAMFSYS -DUSE_THE_BC_SOURCE -DUSE_THE_RSB_LIB -DUSE_THE_RAWSTK -DUSE_THE_SCHED -DUSE_THE_RESMAN -DUSE_THE_DSM -DUSE_THE_SLM -DUSE_THE_USB -DUSE_THE_USB_COMM -DUSE_THE_USB_MSD -DUSE_THE_HDMI -DUSE_THE_OTHREAD -DUSE_THE_GRAPHICS_JPEG_SUPPORT -DUSE_THE_GRAPHICS_PNG_SUPPORT -DUSE_THE_SQLITE -DUSE_THE_SQLDB -I/projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/include -I../src/include -I. -g -DUSE_NO_ROMED_APPLICATIONS -osqlite3.o /projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/sqlite/sq lite3.c /projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/sqlite/sq lite3.c: In function `sqlite3DefaultMutex': /projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/sqlite/sq lite3.c:14997: error: `noopMutexLeave' undeclared (first use in this function) /projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/sqlite/sq lite3.c:14997: error: (Each undeclared identifier is reported only once /projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/sqlite/sq lite3.c:14997: error: for each function it appears in.) /projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/sqlite/sq lite3.c:14997: error: initializer element is not constant /projects/OTV_OS/Core2/DEVELOP/mdal_db/opentv/external/opensrc/sqlite/sq lite3.c:14997: error: (near initialization for `sMutex.xMutexLeave') Renaming debugMutexLeave() to noopMutexLeave() at line 14987 seems to fix it. Cheers, Dave. -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: 15 October 2008 05:12 To: [EMAIL PROTECTED]; General Discussion of SQLite Database Subject: [sqlite] SQLite version 3.6.4 SQLite version 3.6.4 is now available for download on the SQLite website: http://www..sqlite.org/download.html SQLite version 3.6.4 is considered a stable release. Upgrading from version 3.6.3 is optional. For a summary of changes and enhancements that have occurred in version 3.6.4 visit http://www.sqlite.org/3_6_4.html D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4
On Oct 15, 2008, at 1:31 PM, Dave Toll wrote: > I found a small compile error when SQLITE_MUTEX_NOOP is defined with > the > amalgamation source: > SQLITE_MUTEX_NOOP is an internal symbol that gets set if and only if you define SQLITE_THREADSAFE=0. You should not set SQLITE_MUTEX_NOOP yourself. Instead set SQLITE_THREADSAFE=0 and let SQLITE_MUTEX_NOOP be set automatically. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4
Try http://sqlite.org/releaselog/3_6_4.html On Wed, Oct 15, 2008 at 8:17 AM, Alexey Pechnikov <[EMAIL PROTECTED]>wrote: > Hello! > > В сообщении от Wednesday 15 October 2008 16:11:47 D. Richard Hipp > написал(а): > > For a summary of changes and enhancements > > that have occurred in version 3.6.4 visit > > > > http://www.sqlite.org/3_6_4.html > > Document Not Found > The document /3_6_4.html is not avaivable on this server > > Best regards, Alexey. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4
On Oct 15, 2008, at 8:11 AM, D. Richard Hipp wrote: > SQLite version 3.6.4 is now available for download on the SQLite > website: > > http://www..sqlite.org/download.html > > SQLite version 3.6.4 is considered a stable release. Upgrading from > version 3.6.3 is optional. For a summary of changes and > enhancements that have occurred in version 3.6.4 visit > >http://www.sqlite.org/3_6_4.html Corrected URL: http://www.sqlite.org/releaselog/3_6_4.html D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4
Hello! В сообщении от Wednesday 15 October 2008 16:11:47 D. Richard Hipp написал(а): > For a summary of changes and enhancements > that have occurred in version 3.6.4 visit > > http://www.sqlite.org/3_6_4.html Document Not Found The document /3_6_4.html is not avaivable on this server Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite version 3.6.4
SQLite version 3.6.4 is now available for download on the SQLite website: http://www..sqlite.org/download.html SQLite version 3.6.4 is considered a stable release. Upgrading from version 3.6.3 is optional. For a summary of changes and enhancements that have occurred in version 3.6.4 visit http://www.sqlite.org/3_6_4.html D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15
D. Richard Hipp wrote: > On Oct 9, 2008, at 9:11 PM, dcharno wrote: > >>> If you have issues or concerns with any aspect of the upcoming >>> release, now would be a good time to raise them. >> Is there any way to have both the BNF and syntax diagrams in the SQL >> Syntax? > > > Not really. Explain to me again why you want BNF instead of syntax > diagrams? Most people find the syntax diagrams to be much easier to > understand. I could imagine its a lot of effort to create those syntax diagrams. They didn't seem any easier to follow, at least to me. Maybe they grow on you ... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15
On Fri, Oct 10, 2008 at 10:45:11AM +0300, Cariotoglou Mike wrote: > well, since you asked, BNF is indeed more difficult to read, BUT it is > machine-readable, which means validation tools and parsers can be built. If that's what you want then there's already the grammar that Lemon uses to generate the pasrser for SQLite3. Someone suggested that the BNF stuff is text, and therefore more easily accessible to blind users. That need not mean that BNF is the way to go. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15
D. Richard Hipp schrieb: > I suppose that announcements of this kind should really only be posted > on the sqlite-dev mailing list, not on sqlite-users. So I will likely > reframe from making subsequent pre-release announcements on sqlite- > users and use only sqlite-dev for such purposes. If you think this > revised policy is out of line with the usual practice on other > projects, please let me know. I think its nice to see this on sqlite-users also. If i mostly use/embed SQLite into some project i probably don't really need the extra details added by sqlite-dev, but its nice to get heads up notice about upcoming releases so i can schedule or reschedule needed work (e.g. no reason to do an upgrade to 3.6.3 when knowing 3.6.4 will come just days later.) But if the plans are still rather vague and could change quite easily your probably right that sqlite-dev is the right place. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [EMAIL PROTECTED] Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15
well, since you asked, BNF is indeed more difficult to read, BUT it is machine-readable, which means validation tools and parsers can be built. so, if you did have the BNF grammar *available* (as opposed to part of the web documentation), I personally would be happier. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15
On Oct 9, 2008, at 9:11 PM, dcharno wrote: >> If you have issues or concerns with any aspect of the upcoming >> release, now would be a good time to raise them. > > Is there any way to have both the BNF and syntax diagrams in the SQL > Syntax? Not really. Explain to me again why you want BNF instead of syntax diagrams? Most people find the syntax diagrams to be much easier to understand. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.4 planned for 2008-10-15
> If you have issues or concerns with any aspect of the upcoming > release, now would be a good time to raise them. Is there any way to have both the BNF and syntax diagrams in the SQL Syntax? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite version 3.6.4 planned for 2008-10-15
We are planning to release SQLite version 3.6.4 at approximately 2008-10-15 12:00:00 UTC. Additional information can be found on the draft website: http://www.sqlite.org/draft/index.html If you have issues or concerns with any aspect of the upcoming release, now would be a good time to raise them. Note that the future of the INDEXED BY clause is uncertain and it might be pulled from the release. I suppose that announcements of this kind should really only be posted on the sqlite-dev mailing list, not on sqlite-users. So I will likely reframe from making subsequent pre-release announcements on sqlite- users and use only sqlite-dev for such purposes. If you think this revised policy is out of line with the usual practice on other projects, please let me know. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users