Re: [sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nicolas Williams wrote: On Tue, Sep 29, 2009 at 11:21:30AM -0700, Roger Binns wrote: Nicolas Williams wrote: If you move the cast to the left the warning should go away: ((sqlite3_int64)(1L63)) And this is why making warnings go away leads

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

the SQLite shell. That kind of test is easy for anyone else to download and reproduce. You then need to ensure the test suite itself gets the same numbers as the shell. Transactions and disk syncing have been covered by other comments. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU

Re: [sqlite] C code spanish character insert problem

mean hundreds of megabytes and possibly gigabytes.) The defaults it picks are very sensible (ie match the api family you use.) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] feature request - field exclusion list in select list

this sort of thing (eg functions to filter out columns). Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkrAYGoACgkQmOOfHg372QSfrQCcDmSWj8c7edneWaGEI1DJwyeD TmgAn08Ygk3phS/XzMdtFZv8TmXx8M7S =WWXW -END

Re: [sqlite] building permanently loaded extensions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 P Kishor wrote: So, here it is again -- how can I convert a loadable extension to a permanently loaded extension? A tutorial, por favor. Look at how RTree, FTS3 and ICU are done with the amalgamation. Roger -BEGIN PGP SIGNATURE- Version

Re: [sqlite] inserting a number as a string and keeping it that way

test BEGIN TRANSACTION; CREATE TABLE test(t blobmeansnotypeaffinity); INSERT INTO test VALUES(123); INSERT INTO test VALUES('0123'); COMMIT; Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq

Re: [sqlite] inserting a number as a string and keeping it that way

to SQLite? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq/pUgACgkQmOOfHg372QSPzQCdGc2woGg1cAnLOXX8uQXQcP5y EUwAnjWManvuLxwtAQTSTfMfZas4wZiG =fs3t -END PGP SIGNATURE

Re: [sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

overflow detected: op http://www.sqlite.org/faq.html#q17 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq/4PUACgkQmOOfHg372QRTqwCgtfRSypFXYICYKwBeeMGJjiWp +kEAoLoJ6cc/uR+AYveWEPQu+/VBCDWr =Ee6q

Re: [sqlite] feature request - field exclusion list in select list

world source code using this kind of functionality, or some equivalent that has the same effect? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkrAMYUACgkQmOOfHg372QTkoQCfVwf9FQu+tXRkhXjmoGtvCeP6

Re: [sqlite] SQLite Suitability for Shopping Cart

database servers, as they require marshalling of queries and responses between processes and possibly over the network - something which will be way slower than SQLite's quick transactions. (SQLite was originally started because of database servers being flaky and needing administration.) Roger

Re: [sqlite] Problem if IF NOT EXISTS

them. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq6cf4ACgkQmOOfHg372QQtxACgqzJyyDjhpr0+3LnhNt03yREm soMAn2Q+qo/L5Ktf9R2Q3ilfUs/M6NTL =R5Uh -END PGP SIGNATURE

Re: [sqlite] List of active savepoints names

a capable debugger like gdb could use. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq4j7QACgkQmOOfHg372QSR6QCfa2GwUyYzYh5npjqhOmNF5gE3 4Q8An2pZDrDNPrnortRAfzOagIl3JWez =rdE9 -END PGP SIGNATURE

Re: [sqlite] Inserting into an empty table

/~sgtatham/bugs.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq5cjIACgkQmOOfHg372QQZnwCgglwWogTchQNWOUu40Fne9Dk2 IsIAn3QlR5lWocZ8rSW2EXIgE2cA5nzy =25gH -END PGP SIGNATURE

Re: [sqlite] Sqlite testing

likely TH3 is used. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq5opYACgkQmOOfHg372QS4rQCg0thYdw8ktn25yl/lodhgW5kk 8+wAn1kMfNq2SVeYwkA43MeIltlTr1VU =4JOd -END PGP SIGNATURE

Re: [sqlite] Most wanted features of SQLite ?

are also very cheap and liberally licensed. No matter how you look at it, SQLite is a bargain. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq3LOsACgkQmOOfHg372QRrWgCgrgqcqMEIMs6GgQpWv8WUzcCb

Re: [sqlite] List of active savepoints names

in addition to the future maintenance costs. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq3uvIACgkQmOOfHg372QQI/QCcDDg5dthEmqBJj+FZL5NhatN2 JusAoMSHlyXRJsLHMhCF+S3vQgKFUX7E =+RxM -END PGP SIGNATURE

Re: [sqlite] Running test after misc7-6.1.2

directly included the amalgamation and not defined any of the HAVE's like HAVE_USLEEP, sleep is used. (If configure is used then it will define HAVE_USLEEP.) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] List of active savepoints names

duplicate names. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqzkggACgkQmOOfHg372QQfuACgpNEzkhdLLDnRw5HNGEpAH6Am tIUAnjnlBEaD6V72b91QALN4L4oRwjfv =O3HE -END PGP SIGNATURE

Re: [sqlite] Most wanted features of SQLite ?

but are not prepared to use the ICU extension which provides about the most correct implementation of those. ie they want something less accurate and smaller/quicker. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] Most wanted features of SQLite ?

then most of the language bindings provide a way of doing something substantially similar. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq0CmAACgkQmOOfHg372QSIzACgywwsjWKAaxFISkyxFioNSVom LFgAoN

Re: [sqlite] Most wanted features of SQLite ?

you. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq0P0QACgkQmOOfHg372QSz9ACggmw5kaLKwL90nggbr0GaTxkZ SNMAn17gWLmy3SdbzZVMI6fSoUtTVmYS =jOGK -END PGP SIGNATURE

Re: [sqlite] Most wanted features of SQLite ?

information etc. Your own code doesn't even have to be touched or modified in any way: http://apsw.googlecode.com/svn/publish/execution.html#apsw-trace Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] Two feature requests

that author more receptive to your requests. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqxVW4ACgkQmOOfHg372QSEFwCeLbJ9de0gOszqUgivMgWWdBRY g04An2mY7/YDMjVa9KKbnh7uvFx4NYQo =Ecf8 -END PGP

Re: [sqlite] Practicality of using pragma integrity_check at runtime

to measure this (CPU vs I/O tradeoff) but you may instead want to use the SQLite backup API to make a copy of the database and then run the integrity check on that copy. At that point you won't care about how long the integrity check takes, and as a bonus you have a backup of the database. Roger

Re: [sqlite] SQLite version 3.6.18 scheduled for Monday

to use Fossil instead of the other DVCS systems. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqodxAACgkQmOOfHg372QTBegCg0f8kZj4aky9m/QRKWhoRI+Hx 8eUAnAznE8xE+wYngZnGwi4VoBE18PAz =/bZL -END PGP

Re: [sqlite] load extension -- unload hook?

environment then you have total control over what is going on. In a normal environment, allocated memory that isn't being used will end up swapped out. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] got a loop call of mallopt() when run sqlite_open()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 chean xu wrote: i got a loop call of mallopt() when run sqlite_open(), anybody can help me? Start here: http://www.catb.org/~esr/faqs/smart-questions.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using

Re: [sqlite] Will referential constraints be supported in the future ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Anders Moe wrote: I think Sqlite is great, but I'm surprised referential integrity contraints have not been implemented a long time ago. Does anyone know if this is anywhere on the roadmap ? Lookup the genfkey command in the shell. Roger

Re: [sqlite] loadable extension doesn't load

a loadable extension in C, but you are using C++. /home/sk/utils/sqlite/sqlite-3.6.17/half.so: undefined symbol: sqlite3_extension_init You need to declare sqlite3_extension_init as extern C. If you do not then the name gets mangled according to normal C++ symbol mangling rules. Roger -BEGIN

Re: [sqlite] can sqlite result be sorted by using prepare-step API

binding values as appropriate. A restriction is that you can't alter the database schema since that would need the byte code to be updated. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] Copying an open db file

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Angus March wrote: I want to copy a db file while it is still open, Have you considered the API specifically designed for this? http://www.sqlite.org/c3ref/backup_finish.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux

[sqlite] SUGGESTION: sqlite3 and TMP environment variable

is set to. 2) The sqlite3.OperationalError message should tell you the path to the file it is unable to open. Thank you, Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table Exists Query

Maybe something like select db1.* from database1.lists db1 union select db2.* from database2.lists db2; and select db1.* from database1.list_2 db1 union all select db2.* from database2.list_2 db2; /Roger -Ursprungligt meddelande- Från: sqlite-users-boun...@sqlite.org [mailto:sqlite

Re: [sqlite] Question about turn off the synchronous flag

although SSD writing speeds are variable or use a controller and drive that are battery backed so they can lie about data actually being on the platters. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] SQLite locking problem with mozStorage

is happening also using a 1kb reporting unit. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqF2+oACgkQmOOfHg372QQvCgCgr+WTz3tC4eOViSIfPwmHUV7Z QXAAn2PeO5nLy+fXKeIowsbd+/jgc78m =njqI -END PGP SIGNATURE

Re: [sqlite] SQLite locking problem with mozStorage

as whatever is using it, omitting network round trips. In general the way servers win is by dedicating gigabytes of memory to caching but SQLite can also a lot if you increase various defaults. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla

Re: [sqlite] SQLJet - pure Java implementation of SQLite

of the NestedVM approach all seem to require a lot of work just to keep up with SQLite native C source. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqDK9IACgkQmOOfHg372QS29wCgjqjMuswg2o8oQxvAMo2ZEpVK

Re: [sqlite] SQLJet - pure Java implementation of SQLite

and test code easier, and the search for issues or optimisations easier. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqCCWgACgkQmOOfHg372QQXqwCeJ4pqKa89vcCAxTQOelMyoPU6

Re: [sqlite] UPDATE 11 times slower than SELECT?

cause a lot of variance. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqCOIAACgkQmOOfHg372QSWYgCfVRDkPdWcjJooIrUjsIM2iLLw bWQAnjC2SDgdtE87DcMbjXQjRN2F38fU =lLYM -END PGP SIGNATURE

Re: [sqlite] SQLJet - pure Java implementation of SQLite

) is that keeping up with SQLite progress is easy. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqCTmwACgkQmOOfHg372QSCUwCeKD+V+e7yjYgbcF9e+lXhAbbE U9cAoIzXPblugsswnhbgnmTNYSrkdMj7 =VYQ3 -END PGP

Re: [sqlite] SQLite version 3.6.17

you give some idea of how this will be fixed which will determine if I need to make my build process fix it or just download a fixed version? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

Re: [sqlite] FTS and postfix search

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lukas Haase wrote: additionally I would also accept the index being bigger. You could have a second FTS table where you store the keywords in reverse order :-) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using

Re: [sqlite] Disk I/O error on AIX

? This has come up before and you may recognise the poster: http://thread.gmane.org/gmane.comp.db.sqlite.general/39682/ Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Looking for a w_char alternative to the sqlite3_mprintf famili of functions

of formatted string. Whatever you bind is what goes directly into the database - there is no interpretation, tidying, escaping or anything else. Heck you can even include embedded nulls if you want! Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG

Re: [sqlite] Foreign Key constraint checking

until the SQLite optimiser figures out what is happening. Something like: UPDATE table SET column=column Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkpzUQQACgkQmOOfHg372QRoWgCcD6jHw9VNNoRRiJHs

Re: [sqlite] Looking for a w_char alternative to the sqlite3_mprintf famili of functions

to do what you are doing above, less efficient and has the potential for SQL injection attacks (unless you remembered %q everywhere!) These are the functions you need: http://www.sqlite.org/c3ref/bind_blob.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using

Re: [sqlite] How secure is encrypted sqlite database

guy would charge to break it. If they had local access to the machine then it would be a few hundred dollars. If not then a few hundred plus whatever it takes to gain local access (dependent on operating system, configuration, who can be bribed if necessary, exposure to networks etc). Roger

Re: [sqlite] insert gdkpixbuf to sqlite database

incremental blob i/o assuming gda has implemented that. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkpv4QQACgkQmOOfHg372QQs9ACePuJsBboYxlqlecldb0jGuDYC 2agAn1USBGQ6g3IURvr5N784UaqmT+D5 =bwwn -END PGP

Re: [sqlite] Port to C#; Progress report

a simple regular instruction set.) They then translate the MIPS binary into Java: http://nestedvm.ibex.org/ Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkpr

Re: [sqlite] .lib file?

so you don't have to rely on a hand maintained def file. It also has dlltool which can take that def file and generate a lib but I don't know if it is a generic lib file or in MinGW format. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux

Re: [sqlite] How do bitwise operators work? Prototype done

the [] with () which will drastically cut down on memory usage. If performance is at all an issue then you'd get the best bang for the buck by coding the functions in C which won't require round trips through Python data types or iteration over them. Roger -BEGIN PGP SIGNATURE- Version: GnuPG

Re: [sqlite] Run genfkey on temp db from app

callable from C I have been toying with doing an automated extraction of the code from the shell. Unfortunately the various private functions aren't prefixed with sqlite3 like other SQLite private functions so I have to be very careful about namespace clashes. Roger -BEGIN PGP SIGNATURE

Re: [sqlite] Run genfkey on temp db from app

(their name has a predictable prefix) and generate a new set. Unfortunately because it is part of the shell, that is the only way to access it. For many it is sufficient as you can load your database with the shell, run genfkey and then quit. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU

Re: [sqlite] Strange index creation/insertion performance between Windows and Linux 64-bit

doubling of I/O) plus the cache available for other information will be reduced. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkphf90ACgkQmOOfHg372QRHWACbBJjTvvCDk2Xqqufu7r7HvO3n lw0Anjh0UxhczDmgfaGalIwuCOiO++kP =FlEd -END PGP SIGNATURE

Re: [sqlite] Number truncation problem in SQLite 3

/archive/2005/01/31/363790.aspx Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpaZl0ACgkQmOOfHg372QR3OQCeJN8iq1kfjjM5Lel8qGToQ06j /ocAoLdOsq3gVaf5mNAiWanqfQN6dxSe =9JUC -END PGP SIGNATURE- ___ sqlite-users

Re: [sqlite] SQLITE is not working in pthread

the trailing newline if they are executed until some other printf that does have a newline is printf'ed. (The whole stdio/printf thing is actually pretty hairy behind the scenes. Some fun functions you may not have known about are fflush, setbuf/setvbuf, freopen, fdopen and in glibc fopencookie!) Roger

Re: [sqlite] SQLITE is not working in pthread

is to use http://www.pastebin.com and then send the link here. That way we can see exactly what the code is, it is nicely syntax coloured and we can download exactly what you have. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux

Re: [sqlite] Fetch whole result set to memory

the incremental blob I/O api to get the blob contents. This approach is useful if you don't need them all at once (eg you have a user interface with a scroll bar) and that they are non-trivial in size (ie at least several database pages). Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU

Re: [sqlite] sqlite3StrICmp and sqlite3StrNICmp

every time some are missed in new releases :-) See the derived tickets list at the bottom of that page. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpX1FkACgkQmOOfHg372QRPJwCgrItHAZOYegKjvBxhtKRtu8U1 qJIAn3brJaY/9gVYp4pgu+g9PPS00c0k =5MwS -END PGP

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

use it that way - you are not the first. http://www.sqlite.org/threadsafe.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpX1ikACgkQmOOfHg372QQUyACgugrjN65qDEwEnn1c3Rkpd926 kHgAnjrXLUd620KE6FbIPPiuKR7WpJFH =wcje -END PGP SIGNATURE

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pavel Ivanov wrote: Roger, note that OP is talking about re-entrance, not thread-safety. He wants to know which functions can be called from signal handlers which can be called in the middle of some other SQLite call in the same thread. I doubt

Re: [sqlite] Pros and cons of various online code sharing sites

mercurial, and there is a dedicated mercurial based hoster at http://www.bitbucket.org http://hgbook.red-bean.com/ Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpWKQIACgkQmOOfHg372QRgMQCbBGWsCD0t2GwotjeWaPJOzcTA LykAniJas2Yy/iemeVyuma6kxRwrfui2 =kExD -END

Re: [sqlite] blob c/c++ sample code

zeroblobs to efficiently allocate the space for blobs. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpWi+YACgkQmOOfHg372QRm4wCg2R6DNGpcwLiBVA2e/PNKXfRA /n4AoJy8+G8jkij5ComIzZ0g+6m5KWmZ =Chnh -END PGP SIGNATURE

Re: [sqlite] sqlite or python error

.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpTwwYACgkQmOOfHg372QS5CwCfXA/cQuaq1rOt5daZxxyBjRd8 DMkAoN6RnEES29/5z+v2JwaRp6GgPl/b =vklI -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users

Re: [sqlite] getting offending constraint

? sqlite3_errmsg is just telling me constraint failed...which is of limited usefulness. http://www.sqlite.org/cvstrac/tktview?tn=1648 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpLub0ACgkQmOOfHg372QTM5wCeO38HYFTMGi77aHcgtl1Y1xyK H3EAoJav+Q

Re: [sqlite] Python sqlite binding: commit inside select loop

expecting. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpKZKgACgkQmOOfHg372QSMJwCgkIoZ8VGqUcpn8rMtZPF7kpoF vqIAnj5qIaSCy7VTp5mJsAQ4mBVCk+GD =SGGD -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Python sqlite binding: commit inside select loop

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim Wilcoxson wrote: I guess I am a bit confused. Igor says it's not possible, but Roger says my example works. For the exact code you were running the error message came from pysqlite and not from SQLite. Other posters are not aware

Re: [sqlite] SQLite and MinGWSys

and include the amalgamation as part of your project using whatever compiler you use for the rest of your project. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpKj9AACgkQmOOfHg372QRQTwCgyODpuPrsb83BqyFPBmwVtWex XoEAniGntZcAhXfgIfn7CMQi7JbS62U5 =+Gvq -END

Re: [sqlite] Python sqlite binding: commit inside select loop

APSW): http://apsw.googlecode.com/svn/publish/pysqlite.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpK1ygACgkQmOOfHg372QRg9wCgvDDrA6lduq+4CilO5NCiuGlR nAwAoMziOD7TnsrR0xTNiPlX8GK1NsJ0 =OJfe -END PGP SIGNATURE

Re: [sqlite] database exception question

are best spent not having a corrupt database in the first place :-) BTW if you do want to corrupt a database, here are some methods: http://www.sqlite.org/lockingv3.html (section 6) http://www.sqlite.org/pragma.html#modify (eg journal=memory, synchronous=off) Roger -BEGIN PGP SIGNATURE

Re: [sqlite] Building sqlite

change them at runtime anyway. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpJL4UACgkQmOOfHg372QRlegCgknctHB61XIeFVFS7CK0uiLzM VAYAniskhUHMJe0LwpTxPC2JBpf+yC06 =SmvA -END PGP SIGNATURE- ___ sqlite-users mailing

Re: [sqlite] unable to write the string 1.0 into a database table

if a simple update didn't work :-) You should look over the programming documentation on the web site including sample programs again. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpF0O4ACgkQmOOfHg372QQlrQCffy0JJqpxSaDR8pg9B903eofi DYYAnR

Re: [sqlite] help with a utf-8 error

is valid UTF8. Consequently the data can be stored in the database and returned as is, which will then cause non-SQLite code trying to convert it from what is believed to be UTF8 to fail. You can use CAST as a workaround: http://apsw.googlecode.com/svn/publish/tips.html#unicode Roger -BEGIN

Re: [sqlite] Interrupting sqlite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 João Eiras wrote: My doubt is the following: if from the progress callback (set with sqlite3_progress_handler) Why don't you call the main message loop from within the progress handler callback? Roger -BEGIN PGP SIGNATURE- Version: GnuPG

Re: [sqlite] Duplicating an sqlite3_stmt

and instances of sqlite3_stmt that you use. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAko6rJ0ACgkQmOOfHg372QQizwCeKmjSjTzoG3ODNuSkVSBKSlfF VkcAoNiJWQtsVrBOdKyWSxIty75sDIYU =UBPh -END PGP SIGNATURE- ___ sqlite

Re: [sqlite] Question about searches

/lib/Text/Unidecode/ Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAko4c4wACgkQmOOfHg372QQwUwCglqxQzZSGjHHoL13/L8Kw6NrX 46wAn3q12ugcrBryawTwpV8bjs/nYlZe =XPU9 -END PGP SIGNATURE- ___ sqlite-users mailing list

Re: [sqlite] Parsing line output (Was: How does SQLite handle newlines in values?)

/news/software/developer/6803-libferris-and-sqlite-a-powerful-combination-part-1 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAko18TsACgkQmOOfHg372QR4UgCcCC9OQTEPZcLaHdsc01lxHSNW CMEAnR5ra3dAzrVQrWNbPp8oWGBG83so =7KCT -END PGP SIGNATURE

Re: [sqlite] Parsing line output (Was: How does SQLite handle newlines in values?)

that SQLite stores Unicode strings and successfully works with all Unicode codepoints. That means code point 0 works as do those greater than 16 bits (0x/65535). Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAko0D1IACgkQmOOfHg372QTuMwCfSKJd

Re: [sqlite] repeating events?

. If we used some sort of metric time there might have been some hope. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoyDWYACgkQmOOfHg372QSeXQCgjCnHrqaV2GCx0SzKRDKGy2iY gV0AoJ85pJ7444hYKheRX1T0ZabjYSLD =fmLA -END PGP SIGNATURE

Re: [sqlite] Shortest time interval? [Was: Re: repeating events?]

SQL and compare the results as your test framework. (Strictly speaking you are already doing this but the programming language is your brain :-) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoywAAACgkQmOOfHg372QQtRgCgwXukh19LMNZmgW/PlNWtIykM rVYAnA

Re: [sqlite] Shortest time interval? [Was: Re: repeating events?]

done that work for you :-) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoy79oACgkQmOOfHg372QTmMgCdGky6/ipTjNN/T4kmDdvQj+2o ksEAn1aHs/gy4F7j2qoBXhhgFZrQ6sMq =hE/G -END PGP SIGNATURE- ___ sqlite-users mailing

Re: [sqlite] Advice on which to use (SQLite or SQL Server) for the following app.

requests you specify. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkowsQoACgkQmOOfHg372QQsRQCeIHiikyM8k/h/oTeitLCPzHpA IaYAoM9dEjvqD2GZWIkiWZCnni2H28GH =LzSr -END PGP SIGNATURE

Re: [sqlite] repeating events?

) calculations. You could do a space vs time tradeoff by having a table with the calculations already done for each day although you'll have to be very careful to ensure it stays in sync. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkox7mkACgkQmOOfHg372QT

Re: [sqlite] Advice on which to use (SQLite or SQL Server) for the following app.

as a server so there isn't a straight forward comparison. I suggest reading http://www.sqlite.org/whentouse.html which gives good advice. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkowlowACgkQmOOfHg372QQ0NQCbBwYmOVAQOAvhRwM70+cpioZz 94MAoI62fP0VKlFN

Re: [sqlite] Direct row insert from C (without SQL) / Database speed

caches, how the operating system prioritizes memory for caching vs applications, what filesystem you using, how things behave if the disk starts getting full etc. With so many variables only your own test code will give you reasonably accurate answers. Roger -BEGIN PGP SIGNATURE- Version

Re: [sqlite] Problem with sqlite3_interrupt on Windows

to you what to do. You can prepare new queries to execute, call sqlite3_reset to run the query again, or finalize the statements and call sqlite3_close on the connection. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkouwS8ACgkQmOOfHg372QTu8wCfa2

Re: [sqlite] Perticular Field encription in sqlite3 database

your plans. Bruce Schneier has written many good books about security if you want to improve your knowledge. http://www.schneier.com/ Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkomElEACgkQmOOfHg372QT5ZgCggeaZ10VEpo69fsX2BmP7Im4t Q3gAoJ8s9dJO2YeYD

Re: [sqlite] Difference between sqlite3_bind_zeroblob sqlite3_bind_blob( , , , 0, )

. Close the file and the blob. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkokEWsACgkQmOOfHg372QTxcQCfeHajHeJfSnD81vzk1/tdmNz3 Pt8An2PJiXrv941swNJLH3DaUH1CPlHt =+uoU -END PGP SIGNATURE- ___ sqlite-users

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

with your data on the platforms you use? Please read this: http://catb.org/esr/faqs/smart-questions.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkokVFEACgkQmOOfHg372QTcbQCbB3MJbcS

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

platform, test methodology, you found a bug etc. So please please please read the smart questions page even if you think you don't need to. Even following a small portion of its advice will result in you getting better answers and the rest of learning from them. Roger -BEGIN PGP SIGNATURE

Re: [sqlite] Types for strings, non-expert question

feel embarrassed that the only issues I report seem rather petty! Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkokowUACgkQmOOfHg372QQUXACgsD/PcII9sRSajy120KQjOmvE kmcAn24ACFTy9Unq66UXnF6/L1uPLaVj =Zdwm -END PGP SIGNATURE

Re: [sqlite] memory occupied by columns with NULL value

byte. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkoSdHkACgkQmOOfHg372QSIwwCeMrmB6qfYKPVntB2H8UnUpCkZ t4gAn2mjJHchwKxoRlFKQ+LC7TqJRkry =FtGs -END PGP SIGNATURE

Re: [sqlite] Transaction isolation

) on each iteration of the for loop. The simplest solution is to read them all in first. Add .fetchall() after the execute. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoRJ9kACgkQmOOfHg372QT/JgCfRImM5e85JCgn3bmp45zGm6j6 uQMAn11x9OfWdBUMwq/6zZdvSCSuGGGS =ABo

Re: [sqlite] Transaction isolation

complies with some (IMHO pointless) part of the Python DBAPI spec. Fortunately it can be turned off which is what the isolation level stuff in the docs are all about. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoRnrIACgkQmOOfHg372QRhMwCeI52EqZ2/MR8AZK

Re: [sqlite] Transaction isolation

this article: http://www.joelonsoftware.com/articles/Unicode.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoRoFUACgkQmOOfHg372QSIagCg5nllDS/Q5hsgfc+WzjS94Ubk 5jAAoONyqlKsczc1f+q01JqR6/Ysih2q =TODs -END PGP SIGNATURE

Re: [sqlite] Transaction isolation

) is an excellent way of doing that. The wrappers already do this because it is good practise. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoR10IACgkQmOOfHg372QQyjwCfXTwHMBsdAznHfDZ8CeaQIGNH T64Anj5qvy6MjjL/K08xi5CPY7pxueEi =Zet9 -END PGP SIGNATURE

Re: [sqlite] How make atomic? Was: Sqlite as a FIFO buffer?

, or to contribute your SQLite based implementation back. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoR2iwACgkQmOOfHg372QTBFgCfdGWCRMpCqZwQnCRPeKU4Vmjj xgcAn0YW2IRXyyPwkoFFadEn8fW+mLjE =HduX -END PGP SIGNATURE

Re: [sqlite] how do I use more than one column as a combined key?

and login as a combined key. The general process of doing this is called normalization. Wikipedia has an article to start you off: http://en.wikipedia.org/wiki/Database_normalization Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux

Re: [sqlite] Retrieve database modification stamp

modification time. Other approaches include using triggers to automatically update a table with modification information that other processes can read. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkn

Re: [sqlite] The details of the behavior of the sqlite3_step() interface

on the page you quoted as well as a bolded parapgraph at the bottom. http://www.catb.org/~esr/faqs/smart-questions.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkn+bssACgkQmOOfHg372QRsHQCeIB7h2MLl1yk/gBgqBWS6WhTk zzgAoKDwQwOwvd5YFUhYUfZCeXM/GQD6 =Gz7F

<    5   6   7   8   9   10   11   12   13   14   >