Re: [sqlite] Accessing SQLite from PHP5?

I think this is not really sqlite related, i am using fastcgi with nginx server and when security became in issue i had similar problems quick solution - do 'chmod -R 777 /srv/www' and you will see if problem is related to rights or if its something else also i think you should use absolute

Re: [sqlite] values containing dash - not evaluated

i had similar problems and it was caused by microsoft office it didn't used ordinary dash but some strange character with different ascii code - so search based on it always failed i had to convert these strange dashes to ordinary ones to make it work try, maybe this is also your case

Re: [sqlite] Problem with between clause and dates

On 17. 3. 2010 11:49, Mike Martin wrote: > sample time= 2010-03-16 23:06:00 > sample start= 2010-03-16-22:00:00 > sample end= 2010-03-16 23:05:00 > select tsid from recordings where '2010-03-16 23:05:00' between start and end' > > This query should return nothing, so can anyone explain why it is

Re: [sqlite] how to load custom function from QT

i somehow skipped one message in thread and as result i posted you what you already knew and wrote, sorry no more ideas from me On 25. 1. 2010 12:27, greensparker wrote: > > Thnks michel for ur reply. > yes thats the way. i also tried using the HANDLE. but the query failed in > int b =

Re: [sqlite] how to load custom function from QT

i did it, and solution is not nice in general, qt doesn't export any of sqlitefunctions in its sqlite driver. so you have to add sqlite to your project. you can find version of sqlite used in qt in its sources (qt/src/3rdparty/sqlite) or if its set to use dynamically sqlite installed in system you

Re: [sqlite] Problems with SQLite under Cygwin

just an idea - make sure you are crosscompiling and libsqlite3.a is for arm-linux and not for cygwin j.hermanussen wrote: > Hi to all, I'm new on this list. > > I'm working on an application that runs on a small ARM-LINUX device, too > small to contain GCC. So I've installed Cygwin on my Win XP

Re: [sqlite] Will Bitwise Operations Use an Index?

itwise operators cannot be changed so easily to inequalities. > i didn't said this condition should be *replaced* , i said that inequality should be *added*. then index could limit resultset, but bitwise operator will still be used, only on hopefully smaller set of data > > Pavel > &

Re: [sqlite] Will Bitwise Operations Use an Index?

Daniel Wickes wrote: > I'm trying to optimise some of my queries, and I would like to know if > bitwise operators in terms will still use an index, or if I should be > thinking about moving the more important values to separate columns that > could be checked for equality. > > At the moment, I

Re: [sqlite] STL and SQLite

Atul_Vaidya wrote: > Hi, > How to store a multimap in SQlite database ? > My requirement is that i want to store a multimap in a column of > the SQlite table > Regards, > Atul i don't use stl but i also work with more complex structures. the best approach to save them in database is

Re: [sqlite] Performance issue on records retrieval :: 100, 000 records

MADHAVAN VINOD wrote: > > 5) No INDEX created. > > The retrieval logic is such that to retrieve the oldest 10 records along > with some additional constraints (say a, b and c are columns and the > constraints are like a=1 AND b < c). > > > > So my WHERE clause is like "CurrTime <=

Re: [sqlite] Do people think of SQLite as a file or as a database

for me sqlite is database engine. and its files i call databases CadMapper wrote: > This is not a technical question about SQLite. I want to you how people in > general think about SQLite. Is that a file or a database? When you talk > about it, do you refer to it as file or database? > >

Re: [sqlite] what is most effective way to temporarily disable triggers?

hi attached is patch which will make temporary disable of triggers possible. i tried it in my application with current data (many inserts in to various table with many triggers on them, which are not meant to be run while importing data). it works and it changed running time from 62 seconds to 4,

Re: [sqlite] what is most effective way to temporarily disable triggers?

hi attached is patch which will make temporary disable of triggers possible. i tried it in my application with current data (many inserts in to various table with many triggers on them, which are not meant to be run while importing data). it works and it changed running time from 62 seconds to 4,

Re: [sqlite] migrating a pipeline to using sqlite

Robert Citek wrote: > create table foo ( > col_1, col_2, col_3, col_4, col_5, col_6, col_7, col_8, col_9, > col_10, col_11, col_12, col_13, col_14, col_15, col_16, col_17, > col_18, col_19, col_20, col_21, col_22 ) ; > .mode tab > .imp "foo.tsv" "foo" > select col_9, col_22, count(*) as

Re: [sqlite] what is most effective way to temporarily disable triggers?

D. Richard Hipp wrote: > On Jun 24, 2009, at 10:35 AM, Michal Seliga wrote: >>> Instead of >>> >>> WHEN not exists(SELECT * FROM ) >>> >>> create an application-defined function (perhaps called >>> "enable_triggers()&quo

Re: [sqlite] what is most effective way to temporarily disable triggers?

D. Richard Hipp wrote: > On Jun 24, 2009, at 9:17 AM, Michal Seliga wrote: > >> hi >> >> in my application i sometimes must insert huge amount of pre- >> prepared data so i >> don't want triggers to do any action while i am inserting them >> >>

[sqlite] what is most effective way to temporarily disable triggers?

hi in my application i sometimes must insert huge amount of pre-prepared data so i don't want triggers to do any action while i am inserting them for this reason i created one small table which is normally empty, however if it contains record set to 1 triggers shoudl not do any action. to make