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

t 9:56 PM, Dušan Paulovič <paulo...@gisoft.cz> > wrote: > > > Thanks for suggestion, but: > > 1.) one object is not linked to one connection > > > > If you have your own memory management, it's not a problem since the scheme > I described is basically ju

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

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&

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

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

Re: [sqlite] sqlite-amalgamation32k

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...@g

Re: [sqlite] sqlite-amalgamation32k

org> > > On 24 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 li

[sqlite] sqlite-amalgamation32k

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 patch contribution

does 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

Re: [sqlite] attaching databases programmatically

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 > I've got an application that allows the user to create an arbitrary number > of databases, either in memory or

Re: [sqlite] SQLite patch contribution

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 > On Mon, Jul 22, 2013 at 9:42 AM, Adam DeVita wrote: > >

Re: [sqlite] SQLite patch contribution

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

[sqlite] SQLite patch contribution

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] Passing collation to xBestIndex

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 ta

Re: [sqlite] Passing collation to xBestIndex

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] Sqlite locking issue with ATTACH'ed databases

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 > Hi everyone, > > I have an interesting locking problem that I'm wondering

Re: [sqlite] Passing collation to xBestIndex

* 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

Re: [sqlite] Passing collation to xBestIndex

Wed, Jul 17, 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 featur

Re: [sqlite] Passing collation to xBestIndex

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 co

[sqlite] Passing collation to xBestIndex

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] sqlite3_auto_extension - unloaded DLL issue

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

[sqlite] sqlite3_auto_extension - unloaded DLL issue

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