[sqlite] .Net provider performance

I've been comparing three .Net providers along with the JET OLEDB provider. I have the same data in an MDB and also an Sqlite db. The providers I've used so far, all on Windows, are: - The Mono Sqlite client http://www.go-mono.com - The AGS Sqlite provider http://www.ag-software.com/sqlite.aspx

Re: [sqlite] a few questions about indexes

> ok. As I am sure you realize it would be very useful to be able to > create case-insensitive indexes with: > > create index idx_my_index on my_table(lower(my_column)); How can you be sure which index sqlite will use when there are more indices on a field? > > culley > > On Friday,

Re: [sqlite] Using Mono client in Microsoft.Net

> Not sure if this has been posted before, but it took me a while to work > out so might help someone. Thanks for posting this. Had the same issue with my own .net wrapper and at least now I know why! -- Richard Heyes - To

[sqlite] cannot declare member function `static int

Hi, at the moment I try to write a few wrappers for the sqlite api. Here we are: ## #include #include using namespace std; namespace F { class FSqLite : public FApplication { public: FSqLite() {} ~FSqLite() {} static int callback(void

[sqlite] SQLite in OpenOffice?

Hi all, wouldn't sqlite fit into the openoffice package as access fits into Microsoft Office? / Jonas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] How to update a whole column

What you propose will work, but you haven't given enough info for anyone to tell you whether it's the best solution. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] AGS_SQLite_Wrapper VB

Hi all, does someone could tell me how to implement the record (rows) navigation like "MoveNext", "MovePrevious", "EOF" etc... using the AGS_SQLite wrapper and VB6? Thank you a lot in advance, Giuliano Isacchi - To

Re: [sqlite] cannot declare member function `static int

My Implementation: ## namespace F { static int FSqLite :: callback(void *NotUsed, int argc, char **argv, char **azColName) { return 0; // only for testing } > [ ... ] use int FSqLite :: callback(void *NotUsed, int argc, char **argv, char

Re: [sqlite] Triggers

Try create trigger itemDelTrg after delete on Items for each row begin delete from Stats where Stats.ID = old.ID; end; Also consider create trigger statInsTrg before insert on Stats for each row when (select count(ID) from Items where ID = new.ID) = 0 begin select

Re: [sqlite] Many bugs with threads (errors and corruption)

Guillaume Fougnies wrote: 2) Disk image corruption (with indexes): After a time of running, i get this error in return: "database disk image is malformed". I have tracked this problem down to what appears to be a bug in Linux threads. For details see

RE: [sqlite] AGS_SQLite_Wrapper VB

Hi, The returned result is a variant array. You move through a array as you normally do, by increasing a index counter. You can write a class around any array to emulate an ADO recordset if you want. Regards Greg -Original Message- From: ISA Programmi [mailto:[EMAIL PROTECTED] Sent:

[sqlite] #ifdef in parse.y?

G'day all, In my quest to get regex support running I have modified parse.y to accept ~ as regex or bitnot depending on context. I have put #ifdefs around all the regex code and setup an autoconf test for it so it can be compiled out, or is not compiled in if the OS does not support regex. I