Re: [sqlite] How to create connection life-time object?

2013-07-27 Thread Dušan Paulovič
What I need is 'install and don't care' because I use many C++ classes as lifetime objects. I think that my solution does work now well, but if there would be a way to avoid use of SQL parser, it would be better. 2013/7/27 Max Vlasov max.vla...@gmail.com On Fri, Jul 26, 2013 at 9:56 PM, Dušan

Re: [sqlite] How to create connection life-time object?

2013-07-26 Thread Dušan Paulovič
Thanks for suggestion, but: 1.) one object is not linked to one connection 2.) object is not destroyed together with connection Dusan 2013/7/26 Max Vlasov max.vla...@gmail.com Hi, Dušan On Thu, Jul 25, 2013 at 2:39 PM, Dušan Paulovič paulo...@gisoft.cz wrote: Hello, is there a way

[sqlite] How to create connection life-time object?

2013-07-25 Thread Dušan Paulovič
Hello, is there a way to somehow set a connection life-time object? I mean something like: Let's imagine you are working with some sqlite3 connection and want so share same data with extensions, but must be guaranteed, that object gets destroyed when connection is closed. For now, I use creating

[sqlite] sqlite-amalgamation32k

2013-07-24 Thread Dušan Paulovič
On download page, there is available an amalgamation, where the code is split into a small number of source files, such that no single source file is longer than 32767 lines of code. This is good, because Visual Studio does not support more than 65535 lines of code for debugging in single file,

Re: [sqlite] sqlite-amalgamation32k

2013-07-24 Thread Dušan Paulovič
Jul 2013, at 7:56am, Dušan Paulovič paulo...@gisoft.cz wrote: On download page, there is available an amalgamation, where the code is split into a small number of source files, such that no single source file is longer than 32767 lines of code. This is good, because Visual Studio does

Re: [sqlite] sqlite-amalgamation32k

2013-07-24 Thread Dušan Paulovič
more about problem: http://social.msdn.microsoft.com/Forums/vstudio/en-US/7d991493-06f7-45f6-8f34-165b988e266c/how-can-i-debug-code-with-more-than-65535-lines 2013/7/24 Simon Slavin slav...@bigfraud.org On 24 Jul 2013, at 7:56am, Dušan Paulovič paulo...@gisoft.cz wrote: On download page

[sqlite] SQLite patch contribution

2013-07-22 Thread Dušan Paulovič
Hello, I like to make a patch for SQLite so that function xBestIndex gets a collation sequences as a part of sqlite3_index_info structure. Patch will be binary compatible with previous versions, so all existing virtual table implementations will work with new version. I understand, that I must

Re: [sqlite] SQLite patch contribution

2013-07-22 Thread Dušan Paulovič
1. I am not citizen of Czech Republic (but citizen of Slovak Republic with similar law) 2. If I do not want apply my copyrights, I can public my code without it. 2013/7/22 Richard Hipp d...@sqlite.org On Mon, Jul 22, 2013 at 8:10 AM, Dušan Paulovič paulo...@gisoft.cz wrote: Hello, I like

Re: [sqlite] attaching databases programmatically

2013-07-22 Thread Dušan Paulovič
Perhaps you can create new connection with multiple virtual tables reading from all connections. But it is hard work... 2013/7/22 Nelson, Erik - 2 erik.l.nel...@bankofamerica.com I've got an application that allows the user to create an arbitrary number of databases, either in memory or not.

Re: [sqlite] SQLite patch contribution

2013-07-22 Thread Dušan Paulovič
So, in other words, there is no way for programmers from EU to contribute on SQLite? Is there any other option? Is there a plan to solve xBestIndex collation issue? Thanks 2013/7/22 Richard Hipp d...@sqlite.org On Mon, Jul 22, 2013 at 9:42 AM, Adam DeVita adev...@verifeye.com wrote: Is it

Re: [sqlite] SQLite patch contribution

2013-07-22 Thread Dušan Paulovič
not work, but WHERE column LIKE 'ABCabc' does. 2013/7/22 Richard Hipp d...@sqlite.org On Mon, Jul 22, 2013 at 10:27 AM, Dušan Paulovič paulo...@gisoft.cz wrote: So, in other words, there is no way for programmers from EU to contribute on SQLite? Is there any other option

[sqlite] Passing collation to xBestIndex

2013-07-17 Thread Dušan Paulovič
Hello, in virtual table mechanism is missing a way to correctly handle following queries: SELECT * FROM vtab WHERE field = 'abc' COLLATE NOCASE; SELECT * FROM vtab WHERE field = 'abc' COLLATE USER_COLLATE; To xBestIndex function is passed only constraint field = 'abc', but there is no way to

Re: [sqlite] Passing collation to xBestIndex

2013-07-17 Thread Dušan Paulovič
What do you mean? I use it for a while on Windows and all works. Binary not compatible with what? Dusan 2013/7/17 Dan Kennedy danielk1...@gmail.com On 07/17/2013 03:46 PM, Dušan Paulovič wrote: Hello, in virtual table mechanism is missing a way to correctly handle following queries

Re: [sqlite] Passing collation to xBestIndex

2013-07-17 Thread Dušan Paulovič
, 2013 at 12:24 PM, Dušan Paulovič paulo...@gisoft.cz wrote: What do you mean? I use it for a while on Windows and all works. Binary not compatible with what? What Dan means is that libraries built with and without this feature might not be binary compatible. i compile against an sqlite3

Re: [sqlite] Passing collation to xBestIndex

2013-07-17 Thread Dušan Paulovič
* sqlite3_vtab_constraint_coll_seq(const sqlite3_index_constraint* pConstraint); sqlite3_index_constraint contains iTermOffset, so to find a collation sequence for it should not be so big problem. How about it? 2013/7/17 Dušan Paulovič paulo...@gisoft.cz But it is the same as with new functions

Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

2013-07-17 Thread Dušan Paulovič
If you remove a busy check, does it output any statements? Do you have any custom functions/operations running so they could block sqlite in creating new statement? 2013/7/17 Loren Keagle loren.kea...@braemarllc.com Hi everyone, I have an interesting locking problem that I'm wondering if

Re: [sqlite] Passing collation to xBestIndex

2013-07-17 Thread Dušan Paulovič
Yes, xRename was a part of the v1 module interface, but v1 module interface is not the first verson of it. Old sqlite extensions does not even contain xRename in their VT implementations and xFindFunction was the last one considered. I understand what you mean by binary incompatibility, but it is

Re: [sqlite] Passing collation to xBestIndex

2013-07-17 Thread Dušan Paulovič
sequences (same size as aConstraints) */ } *extras; }; this would be binary compatible and also extendable for needs in future. How about this? 2013/7/17 Dan Kennedy danielk1...@gmail.com On 07/17/2013 03:46 PM, Dušan Paulovič wrote: Hello, in virtual table mechanism is missing a way

Re: [sqlite] sqlite3_auto_extension - unloaded DLL issue

2013-07-15 Thread Dušan Paulovič
Thank you MR. Hipp... Dušan 2013/7/15 Richard Hipp d...@sqlite.org On Sat, Jul 13, 2013 at 5:14 AM, Dušan Paulovič paulo...@gisoft.cz wrote: Hello, we are currently facing problem with Access violation exception caused by function sqlite3_open_v2 trying to load extensions from

[sqlite] sqlite3_auto_extension - unloaded DLL issue

2013-07-13 Thread Dušan Paulovič
Hello, we are currently facing problem with Access violation exception caused by function sqlite3_open_v2 trying to load extensions from unloaded DLLs. How it happens: - There are 2 (or more) plugin DLLs in main application which are linked to SQLite. - These plugins can be loaded and uloaded by