Re: [sqlite] 回复： stack-overflow issue in fts4 module

林性伟(林以) wrote: Hi, Sorry to make you inconvenient. poc, test.sql: CREATE VIRTUAL TABLE t0 USING fts4(content=t0,0); SELECT count() FROM t0(0); Maybe I'm completely wrong, but using t0 both as the name of the virtual table and the source for its content seems to me like the perfect condition

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

Richard Hipp wrote: On 9/6/16, Chris Locke wrote: Additionally, on the menu, the 'Download' option is not visible at all. By design. There is nothing on the Download page that is useful to a mobile device. So links to that page are omitted on mobile, to save

[sqlite] Good way for CEIL, or is there a better way

E.Pasma wrote: > 09-05-2016, OBones: >> Isn't Ceil(Value) simply Round(Value + 0.5) ? > But Round(0.5) = 1 > May be Round(Value+0.4) is good enough? Well, yes, there's an issue at 0, but for anything else positive, it should be good enough.

[sqlite] Good way for CEIL, or is there a better way

Cecil Westerhof wrote: > I need to have a CEIL function in SQLite. This is the way I implemented it: > WITH percentage AS ( > SELECT date > , 100.0 * rank / outOf AS percentage > , CAST(100.0 * rank / outOf AS int) AS castedPercentage > FROM ranking > ) >

[sqlite] sqlite3_errmsg and wide char

Dominique Devienne wrote: > On Fri, Nov 27, 2015 at 2:16 PM, Dan Kennedy wrote: > >> On 11/27/2015 12:13 PM, Igor Korot wrote: >> >>> Hi, >>> Is there any way to have "sqlite3_errmsg" function return a wide char >>> string? >>> Or do a conversion in a portable way? >>> >> Will sqlite3_errmsg16()

[sqlite] Random performance issues with SQLite

Brice Andr? wrote: > So, my question is the following : does someone has already experienced > performance issues on database with an HDD device starting to fail (without > any corruption problem) ? And if yes, is it possible that those performance > issues come with no notification in the windows

Re: [sqlite] sqlite3.dll no longer operative

Actually, the 32 bits version should go to c:\windows\syswow64 as c:\windows\system32 is for 64 bits DLLs on a 64bits Windows. Stephen Chrzanowski wrote: This "smells" like a program that is either installed by you, or, from your CD when you reloaded, is looking for the sqlite3.dll but can't

Re: [sqlite] Virtual tables are driving me insane!

Hello, have a look at what's here: http://code.google.com/p/sv-utils/wiki/Intro There is a complete and unit tested encapsulation for SQlite and its virtual tables. Regards ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Virtual Tables: retrieving the ppArg given in xFindFunction

Hello, Is there a place where I should enter such a documentation request? Regards Olivier OBones wrote: Hello all, As I'm moving forward in my usage of virtual tables, I'm using the xFindFunction method to overload some functions with my own implementation. That works just fine, but I

Re: [sqlite] Virtual Tables: xSync without xBegin

Hello again. Does anyone have any suggestion here? Regards Olivier OBones wrote: Hello all, I'm pushing my experiment with virtual tables a bit further by trying out the transaction functions. As a result, I gave values for the xBegin, xSync, xCommit and xRollback members of my

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

If you've got the database in a stream, why can't you save it to a disk file and then use this file with sqlite? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Virtual Tables: idxStr parameter for xBestIndex and xFilter

Jay A. Kreibich wrote: On Tue, Jun 26, 2012 at 03:56:33PM +0200, OBones scratched on the wall: Hello all, As I'm experimenting with Virtual Tables, I have had to implement xBestIndex and xFilter. The documentation says that idxNum and idxStr are of no importance to the SQLite core

Re: [sqlite] Virtual tables: rename, disconnect and reconnect

Jay A. Kreibich wrote: On Tue, Jun 26, 2012 at 03:47:07PM +0200, OBones scratched on the wall: I would have thought that since the disconnect was given a valid pVTab, this one could have been given back to xConnect when reconnecting the database after its rename. Except SQLite doesn't store

[sqlite] Virtual Tables: xSync without xBegin

Hello all, I'm pushing my experiment with virtual tables a bit further by trying out the transaction functions. As a result, I gave values for the xBegin, xSync, xCommit and xRollback members of my sqlite3_module structure. Then after having registered the module, I sent those two statements:

[sqlite] Virtual Tables: retrieving the ppArg given in xFindFunction

Hello all, As I'm moving forward in my usage of virtual tables, I'm using the xFindFunction method to overload some functions with my own implementation. That works just fine, but I stumbled upon a hurdle that was not obvious to solve at first glance. Inside the xFindFunction, you can give a

[sqlite] Virtual Tables: idxStr parameter for xBestIndex and xFilter

Hello all, As I'm experimenting with Virtual Tables, I have had to implement xBestIndex and xFilter. The documentation says that idxNum and idxStr are of no importance to the SQLite core and that it's our responsibility to make sure xFilter and xBestIndex agree on the meaning. This is fine by

[sqlite] Virtual tables: rename, disconnect and reconnect

Hello all, I'm experimenting with virtual tables and I must say that it's a very nice feature to have, it saves me from inserting millions of records in a database when I can simply map the source file in memory and read it directly. However, I have a small issue when renaming a database.