[sqlite] How to detect SQLITE_ENABLE_FTS3_PARENTHESIS support?
Suppose that I'm using an SQLite database via a non-C interface (such as Perl, Python, PHP, etc.) which is running a version of SQLite that I have no control over and I would like to determine whether or not SQLITE_ENABLE_FTS3_PARENTHESIS support is enabled. How can I do this? (It's easy enough to check for SQLITE_ENABLE_FTS3 support with something like: create virtual table check_for_fts3 using fts3(); And then you need drop table check_for_fts3; if it succeeds as there doesn't seem to be a way to create a virtual table in temporary storage or else just make sure you're doing the testing on the :memory: database.) Since SQLITE_ENABLE_FTS3_PARENTHESIS is recommended for new applications (see http://www.sqlite.org/fts3.html#section_2 ) I would like to verify it's available before trying to use the enhanced syntax. Is there a recommended way to check for SQLITE_ENABLE_FTS3_PARENTHESIS support? Thanks, Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Is there size limit for tables?
Okay. I've got a table. I insert data in it via an INSERT INTO query. I can insert as many rows as I want. But it seems that if my table gets past a certain size, when trying to INSERT data in it, I'll just get a completely blank page. No error message. I absolutely hate silent failing. So please help me! I'm searching but cannot find any result. Thank you in advance. Luigi__ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is there size limit for tables?
On Sat, Jan 23, 2010 at 10:39 AM, Luigi__ luigi...@gmail.com wrote: Okay. I've got a table. I insert data in it via an INSERT INTO query. I can insert as many rows as I want. But it seems that if my table gets past a certain size, when trying to INSERT data in it, I'll just get a completely blank page. No error message. Are you sure you are using the sqlite library directly (that is, via either the command line shell or via a programmatic interface) or are you using a program that has sqlite embedded in it. What do you mean by I'll just get a completely blank page? Sqlite by itself doesn't show any page, blank or otherwise. I absolutely hate silent failing. So please help me! I'm searching but cannot find any result. Thank you in advance. Luigi__ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu --- Assertions are politics; backing up assertions with evidence is science === ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] famous constraint failed error
What else do you need to know? BTW... is there any way how to detect which constraint has failed? Jan Pavel Ivanov wrote: But why it only happens when any concurrent select query is in progress? Probably you don't tell us all necessary information about your set up (or maybe you don't know it yourself) because concurrent select cannot cause this kind of error in any way. It can cause only SQLITE_BUSY error. Are you sure you don't mess with your data from some other process? Pavel On Fri, Jan 22, 2010 at 2:28 PM, Jan Bilek bil...@gmail.com wrote: But why it only happens when any concurrent select query is in progress? Thanks for any response. Jan Pavel Ivanov wrote: Does any sqlite MVP know what could be beyond this strange error message. Exactly what message says: you tried to insert data that is not allowed by constraints in the table. Read/write threads construct doesn't have anything to do with that - everything can be reproduced in one write thread. Pavel On Fri, Jan 22, 2010 at 11:45 AM, Jan Bilek bil...@gmail.com wrote: Hello, I've got a setup, where one process/thread writes data (multiple inserts in one transaction ) to db and other which reads data (one select) from db. These two threads use their own db connections. When write thread and read thread access the database at the same time, then processing of write transaction fails with strange constraint failed error (no. 19). I've tried to search the web for any solution, but i haven't found anything. Does any sqlite MVP know what could be beyond this strange error message. Thanks for any help. Sincerely, Jan ___ 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 ___ 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] famous constraint failed error
Jan Bilek wrote: ... is there any way how to detect which constraint has failed? http://www.sqlite.org/src/tktview?name=23b2128201 Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] error with authorizer, onecolumn and TCL
The following sequence gives an incorrect result value: (ramsan) package require sqlite3 3.6.22 (ramsan) 2 % sqlite3 db :memory: (ramsan) 3 % db authorizer myauth (ramsan) 4 % proc myauth { cmd args } { return SQLITE_OK } (ramsan) 6 % db eval { create table t(a,b) } (ramsan) 7 % db onecolumn { select a from t } SQLITE_OK The error is probably due to the fact that the onecolumn TCL code, in some cases (if there are no results), does not store a void string as result. Then, a previous not valid TCL result (SQLITE_OK) is returned as result of the onecolumn method. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite on opensolaris with bogofilter
I am using sqlite 3.6.21 with bogofilter 1.2.1 on opensolaris 5.11 snv_111b When I run bogoutil -r sqllite.db it returns -NaN Any ideas? Is it a sqlite problem or bogofilter problem? Thanks for any tips. I tried compiling sqlite with -DSQLITE_HAVE_ISNAN ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] how to load custom function from QT
hi, im using DEBIAN,QT4.5.2 I have custom functions in sqlite,like ascii,ceil,floor etc. lib name is myfunciton.so. i have tested manually in sqlite3 command line by using, select load_extension('myfunction.so') . Its working well. my question is ,how can i automate this with QT. i want to use CEIL function from QT. like, QSqlquery q=(select ceil(5.2)); pls guide me Bala -- View this message in context: http://old.nabble.com/how-to-load-custom-function-from-QT-tp27292725p27292725.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users