Re: [sqlite] sqlite-users Digest, Vol 67, Issue 18

> "The sqlite3_reset() function is called to reset a prepared statement object > back to its initial state, ready to be re-executed. Any SQL statement > variables > that had values bound to them using the > sqlite3_bind_*() API retain their values. Use sqlite3_clear_bindings() to > reset > the

Re: [sqlite] FTS4 search for terms inside a word

On Jul 22, 2013, at 3:29 PM, Marco Bambini wrote: > I have a virtual FTS4 table and I would like to search for some terms inside > a word, is that possible? Not with the default tokenizers, but perhaps you could write your own, say an ngram tokenizer or such.

Re: [sqlite] FTS4 search for terms inside a word

Marco Bambini wrote: > I have a virtual FTS4 table and I would like to search for some terms inside > a word, is that possible? No. > For example if a column contains "mysuperword mytestword" I would like to > find it using the subword: "super". > > While with the MATCH operator it does not

Re: [sqlite] FTS4 search for terms inside a word

Unfortunately FTS is only able to do prefix search, not sufix. -- View this message in context: http://sqlite.1065341.n5.nabble.com/FTS4-search-for-terms-inside-a-word-tp70196p70218.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] SQLite patch contribution

You could include us as another group who would like to see this functionality added to virtual tables. -- E On Jul 22, 2013, at 8:46 AM, Richard Hipp wrote: > On Mon, Jul 22, 2013 at 10:27 AM, Dušan Paulovič wrote: > >> So, in other words, there is no

Re: [sqlite] Multiple return values from aggregate function

That's great info and thanks for the advice. I'll give it a shot. On Mon, Jul 22, 2013 at 12:05 AM, Hick Gunter wrote: > Having written a lot of virtual tables I am quite sure you could write a > virtual table module "analytics" with > > real columns context, order and value

Re: [sqlite] SQLite patch contribution

I think it is not important only for me, but for all who want to use xBestIndex and xFilter functions and correctly solve all possible scenarios. Is there a way I can determine in xBestIndex/xFilter a collation sequence used in constraints? - perhaps not. All I found is that if I do not solve

Re: [sqlite] Using in-memory DBs of the form: of 20) 2 of 20) "file:memdb1?mode=memory=shared" (via Perl, DBD::SQLite & DBI)

On Sat, 20 Jul 2013 18:03:43 +0100, Simon Slavin - slav...@bigfraud.org wrote: On 20 Jul 2013, at 3:11pm, sqlite.20.browse...@xoxy.net wrote: this in-memory database actually persists. Ie. Beyond the life of the program that

Re: [sqlite] attaching databases programmatically

Marc L. Allen wrote on Monday, July 22, 2013 10:55 AM > > I see. Sorry about that! > > I guess the real problem is the in-memory ones. The other ones must > have a database file associated with them, right? > Probably, but that doesn't mean that the file is accessible through a filename

Re: [sqlite] SQLite patch contribution

On Mon, Jul 22, 2013 at 4:18 PM, Richard Hipp wrote: > From what I understand, no. In the EU you can not give away, disavow, or > otherwise dispose of your moral rights. You can enter into an agreement to > not enforce your moral rights, but you can never do away with them. >

Re: [sqlite] attaching databases programmatically

On Mon, Jul 22, 2013 at 10:47 AM, Marc L. Allen wrote: > Perhaps I misunderstood the question. It sounds like he has the sqlite* > objects for the databases, but wants to be able to determine the > database/filename associated with them so he can construct an

Re: [sqlite] SQLite patch contribution

On Mon, Jul 22, 2013 at 9:42 AM, Adam DeVita wrote: > Is it possible for one in a nation that doesn't permit dedication to > public domain to simply gift the work (and intellectual rights) to > someone personally, who can and will the reassign it to the public > domain

Re: [sqlite] attaching databases programmatically

Richard Hipp wrote on Monday, July 22, 2013 10:28 AM > > On Mon, Jul 22, 2013 at 10:19 AM, Nelson, Erik wrote: > > > I've got an application that allows the user to create an arbitrary > > number of databases, either in memory or not. In my C++ program, I > > have the handles and I'd like to

Re: [sqlite] attaching databases programmatically

Perhaps I misunderstood the question. It sounds like he has the sqlite* objects for the databases, but wants to be able to determine the database/filename associated with them so he can construct an ATTACH statement in another query. So.. the question is.. given an sqlite*, can you determine

[sqlite] attaching databases programmatically

I've got an application that allows the user to create an arbitrary number of databases, either in memory or not. In my C++ program, I have the handles and I'd like to attach them all together so the user can execute queries against them. However, the only way that I've found to do that is to

Re: [sqlite] attaching databases programmatically

I see. Sorry about that! I guess the real problem is the in-memory ones. The other ones must have a database file associated with them, right? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nelson, Erik - 2 Sent: Monday,

Re: [sqlite] SQLite patch contribution

On Mon, Jul 22, 2013 at 10:27 AM, Dušan Paulovič wrote: > 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? > Actually implementing such a patch is

Re: [sqlite] attaching databases programmatically

On Mon, Jul 22, 2013 at 10:19 AM, Nelson, Erik - 2 < erik.l.nel...@bankofamerica.com> wrote: > I've got an application that allows the user to create an arbitrary number > of databases, either in memory or not. In my C++ program, I have the > handles and I'd like to attach them all together so

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] attaching databases programmatically

Marc L. Allen wrote on Monday, July 22, 2013 10:47 AM > Nelson, Erik wrote: > > I've got an application that allows the user to create an arbitrary > > number of databases, either in memory or not. In my C++ program, I > > have the handles and I'd like to attach them all together so the user > >

Re: [sqlite] SQLITE_BUSY on rare occasions, single thread, single connection

On 22 Jul 2013, at 7:28am, Jesper Baekdahl wrote: > there should not be anything holding a > lock. Please check the return values of all the sqlite3_ API calls before the one which is getting SQLITE_BUSY, even those which are apparently working. For instance, do not do

Re: [sqlite] syste.data.sqllite exection on .net vs 2010 w7

Hi, Had the same problem. You will have to use the "appropriate" assembly for (x86 or x64). The final step is to identify the target processor architecture on both the development and customer machines. Generally, x86 binaries will work on an x64 machine running Windows (using WoW64).

Re: [sqlite] SQLite patch contribution

Is it possible for one in a nation that doesn't permit dedication to public domain to simply gift the work (and intellectual rights) to someone personally, who can and will the reassign it to the public domain (such as a member of the sqlite dev team)? On Mon, Jul 22, 2013 at 9:30 AM, Dušan

Re: [sqlite] SQLITE_BUSY on rare occasions, single thread, single connection

On Mon, Jul 22, 2013 at 3:48 PM, Simon Slavin wrote: > assert(sqlite3_finalize(S) == SQLITE_OK) > Nononono - in non-debug builds assert() is compiled out, so the above disappears. (Been there, done that!) -- - stephan beal

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 > On Mon, Jul 22, 2013 at 8:10 AM, Dušan Paulovič > wrote: > > > Hello,

[sqlite] FTS4 search for terms inside a word

I have a virtual FTS4 table and I would like to search for some terms inside a word, is that possible? For example if a column contains "mysuperword mytestword" I would like to find it using the subword: "super". So with LIKE it worked but it is really slow: SELECT * FROM myTable WHERE

Re: [sqlite] SQLite patch contribution

On Mon, Jul 22, 2013 at 8:10 AM, Dušan Paulovič wrote: > 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

[sqlite] syste.data.sqllite exection on .net vs 2010 w7

Hi All, I have been using the dll system.data.sqllite for vs2010 windows xp project and it worked fine. Now, I want to develop it in windows 7. I build the same project and I did not have any problem. when I run it, I got the following error.: BadImageFormatexception: Could not load file or

[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] Access Permission on Table

http://www.sqlite.org/c3ref/set_authorizer.html -Ursprüngliche Nachricht- Von: techi eth [mailto:techi...@gmail.com] Gesendet: Montag, 22. Juli 2013 11:03 An: General Discussion of SQLite Database Betreff: [sqlite] Access Permission on Table Is their any statement I can build using

Re: [sqlite] Access Permission on Table

On 22 July 2013 10:02, techi eth wrote: > Is their any statement I can build using SQLite3, which will provide me > access permission over table. > > Let us say I have 3 tables (table 1, table 2, table 3). Here I am looking > Read permission for one->many but Write can be done

[sqlite] Access Permission on Table

Is their any statement I can build using SQLite3, which will provide me access permission over table. Let us say I have 3 tables (table 1, table 2, table 3). Here I am looking Read permission for one->many but Write can be done by creator of table only. If other will try to access then they

Re: [sqlite] Trigger Logic!!!

Thanks for quick answer. Yes,I understand i may no be able do inter process communication but calling process can be register for call back (function register to sqlite3_create_function()) on trigger & do whatever required . Cheers- On Mon, Jul 22, 2013 at 12:09 PM, RSmith

Re: [sqlite] SQLITE_BUSY on rare occasions, single thread, single connection

Hi Jesper, the code you posted is not the offending code, it's just the symptom of a problem happening somewhere else. We will need to see the other operations also done by the DB code to know what goes on with it, but from some experiences on the list the following is likely: - You have

Re: [sqlite] Multiple return values from aggregate function

Having written a lot of virtual tables I am quite sure you could write a virtual table module "analytics" with real columns context, order and value and virtual columns ema, ... for your functions You would then - INSERT INTO analytics VALUES (context, order, value) ... And retrieve functions

Re: [sqlite] Trigger Logic!!!

There is no way to contact an unknown thread that may or may not be running. This means that any thread you wish to speak to needs to be registered somehow in some list and have a means of "listening" to you, which in turn means SQLite (or indeed any other RDBMS) cannot simply notify one or more

[sqlite] SQLITE_BUSY on rare occasions, single thread, single connection

Hey everybody. I'm getting SQLITE_BUSY on sqlite_step on insert statement, that is part of an explicit transaction of multiple statements. There is only 1 thread and 1 connection, so there should not be anything holding a lock. It does not happen very often, so I'm having a hard time debugging