Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

Patches are still welcome, I guess. I haven't seen anybody claiming that this would be done in any way. On 6 June 2017 at 15:17, PICCORO McKAY Lenz wrote: > how its the status of this work? > > a limited implementation will be good! > > Lenz McKAY Gerardo (PICCORO) > http://qgqlochekone.blogspot.

Re: [sqlite] RIGHT JOIN! still not supported?

Seeing how SQLite was created in 2000, it seems like nobody really needed this feature for the last 17 years enough in order to actually implement it. Last I heard, patches are welcome on this mailing list. Don't keep us waiting. Kind regards, Daniel On 20 March 2017 at 21:09, PICCORO McKAY Lenz

Re: [sqlite] tclsqlite3 db function exports not visible on other connections. Why not?

You can use sqlite3_auto_extension for this. On 19 March 2017 at 11:35, R Smith wrote: > > On 2017/03/19 11:05 AM, petern wrote: >> >> Taking DRH's remarks about learning tclsqlite for the efficient coding to >> heart, I discovered a big problem. >> >> Here is the simplest example from the docs a

Re: [sqlite] IS NULL and IS NOT NULL constraints not passed into virtual table's xBestIndex

Thanks a ton for the replies. This pretty much confirms what I've been suspecting. On 3 February 2017 at 11:24, Clemens Ladisch wrote: > The FTS and R-tree virtual tables do not contain NULL values, so > I guess it was never seen as necessary. Does this make it an accidental omission, then? Woul

[sqlite] IS NULL and IS NOT NULL constraints not passed into virtual table's xBestIndex

Hi. I'd like to ask why using a IS NULL or IS NOT NULL constraint in a query made to a virtual table does not result in these constraints being present in the sqlite3_index_info structure passed to the virtual table's xBestIndex. Currently, using one of these constraints results in no constraints a

[sqlite] using @_ characters in LIKE syntax

I have problem with filtering database with LIKE statement. In query i'm doing this: ... WHERE [EMAIL PROTECTED] AND (ze_nazwa LIKE @ze_nazwa ESCAPE '\' OR ze_typ_el LIKE @ze_nazwa ESCAPE '\') and in program for @ze_nazwa i'm inserting this string: string elementFiltr = "%" + (new Regex(@"([\\%_

[sqlite] Preallocating fixed disk space for database ...

such database ? How large should it be ? If yes, then is there a better way to create large files than massive insterts/deletes ? Thanks in advance, Kamil - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Performance of two queries, why such big difference ?

- Original Message - From: "Brandon, Nicholas (UK)" <[EMAIL PROTECTED]> To: Sent: Monday, July 03, 2006 1:59 PM Subject: RE: [sqlite] Performance of two queries, why such big difference ? It takes <1ms to return 16 rows using the first query, but over 200ms when using the second

[sqlite] Performance of two queries, why such big difference ?

r 200ms when using the second one. What is wrong ? Is there a way to speed up the second query ? Thanks in advance, Kamil

[sqlite] How to check whether sqlite_open created the new database ?

I have to create a database schema in such case. Thanks in advance, Kamil