Re: [sqlite] Sqlite 2

download url like this http://www.sqlite.org/sqlite-2_x_xx.zip exam:http://www.sqlite.org/sqlite-2_8_17.zip -- View this message in context: http://www.nabble.com/Sqlite-2-tp22944102p25199847.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] Viable alternatives to SQL?

On 28 Aug 2009, at 9:56pm, Beau Wilkinson wrote: >> I want a query language that non-techies can use easily, but also >> supports arbitrarily complex queries. Does such a language exist? > > I remember reading once, in an old book about RDBMS, that SQL was > intended to be something that

Re: [sqlite] Viable alternatives to SQL?

> I want a query language that non-techies can use easily, but also > supports arbitrarily complex queries. Does such a language exist? I remember reading once, in an old book about RDBMS, that SQL was intended to be something that non-technical decision-maker types could learn in a few hours.

Re: [sqlite] Problem invoking php functions from a trigger

Thank's Swithun but I still have trouble. Ok, I find out how to register functions with PDO_Sqlite extensions. Just in case someone is in the same situation, the way to do it is this: $dbh = new PDO('sqlite:/whatever.sqlite'); $dbh->sqliteCreateFunction('Test','Test'); But I still have a

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

Yes, you are right (as always). Time with SQLITE_THREADSAFE=0 is about 4.33 seconds now. Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 28, 2009, at 5:23 PM, D. Richard Hipp wrote: > > On Aug 28, 2009, at 11:17 AM, Mike Eggleston wrote: > >>

Re: [sqlite] Explanation

On Aug 28, 2009, at 11:17 AM, Mike Eggleston wrote: > On Fri, 28 Aug 2009, Marco Bambini might have said: >> >> Version 3.4.2 takes about 5.06 seconds (average value) while version >> 3.6.17 takes about 7.28 seconds (average value). >> Could be a slowdown in the library for the complexity added

Re: [sqlite] Explanation

Library is statically linked into the final app and the db is newly created... -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 28, 2009, at 5:17 PM, Mike Eggleston wrote: > On Fri, 28 Aug 2009, Marco Bambini might have said: > >> Hello, >> >> today I made

Re: [sqlite] Explanation

On Fri, 28 Aug 2009, Marco Bambini might have said: > Hello, > > today I made some test on a project I wrote some years ago. > I upgraded sqlite library from version 3.4.2 to version 3.6.17. > What I am really unable to understand is the time difference required > to perform the same query

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

Hi all 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 ? Best regards, Anders ___ sqlite-users mailing list

Re: [sqlite] Regarding Memory Database

Can I ask you why do you need to allocate memsys5 memory pool in the first place? Why don't you use standard mallocs? Or even your own allocator? I just have a feeling that you're pursuing some goals very specific to your application and this kind of functionality is not necessary to anybody else.

[sqlite] Explanation

Hello, today I made some test on a project I wrote some years ago. I upgraded sqlite library from version 3.4.2 to version 3.6.17. What I am really unable to understand is the time difference required to perform the same query using the exact same algorithm by the two libraries. SELECT *

Re: [sqlite] Problem invoking php functions from a trigger

Hello AR if I run this php script AR AR *$dbh = new PDO('sqlite:/var/www/test.sqlite'); AR $sql="INSERT INTO Test ( Nombre , IP , MAC , Descripcion_Modulo ) VALUES ( AR '2221' , '2121' , '1212' , '1212' ) "; AR $modulo=$dbh->query($sql); AR print_r($dbh->errorInfo()); * AR AR from outside

Re: [sqlite] Conditional triggers

Use old.TypeID==1 if you want the trigger to be fired when TypeID WAS 1 before the update, or new.TypeID==1 if you want the trigger to be fired when TypeID is updated to 1. Hope this help... 2009/8/28 Dennis Volodomanov > Hello all, > > Is it possible to create such an

[sqlite] Problem invoking php functions from a trigger

Hi everybody, I'm having a problem when I invoke a function developed in php from a trigger. I've been using SQLIteManager to develop and test my functions and everything work's perfect. I've created this function: *INSERT INTO user_function ( funct_name , funct_type , funct_code ,

[sqlite] Knowing required columns for Virtual Tables

Does any one know of a way to know which columns are to be used in a virtual table implementation for a particular query? At the xFilter() point the engine essentially knows what it is going to do and what columns it will use, but that information does not seem to be exposed anywhere. Certainly

[sqlite] Conditional triggers

Hello all, Is it possible to create such an AFTER INSERT trigger that updates certain fields in a table based on the actual data being inserted? Let's say: CREATE TABLE abc(TypeID INTEGER) CREATE TABLE abcCount(TypeCountA, TypeCountB) CREATE TRIGGER CountTypeA AFTER INSERT ON abc /* when

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] Conditional triggers

> create trigger CountType after insert on abc > begin > update abcCount set > TypeCountA = TypeCountA + (new.TypeID = 1), > TypeCountB = TypeCountB + (new.TypeID = 2); > end; Thank you - that looks great! Dennis ___