Re: [sqlite] Custom Collation comparing only firt character?

On Sat, Aug 27, 2011 at 12:04 AM, Jean-Christophe Deschamps < j...@antichoc.net> wrote: > If you also need to search names with uncertain spelling, you can also > use my typos() function to perform a fuzzy search. Here's a sample of > its use on a decently populated ZipCodes table (848207 rows):

Re: [sqlite] Custom Collation comparing only firt character?

Roberto, >Though I cannot use DLLs since it is an iPhone iOS (MacOSX) >operational system. I made it DLL by default at build time since it fits my needs. You can still compile the extension (or part of it) as a standard .o obj and statically link it into your application. >I was hoping for

Re: [sqlite] "Possible" doc bug in os_unix.c

On Fri, Aug 26, 2011 at 4:50 PM, Stephan Beal wrote: > Hi, gurus, > > i just randomly stumbled upon a _possible_ internal documentation bug: > > http://www.sqlite.org/src/ci/05c9832e5f > > The commit message says: > > "Enable the SQLITE_FCNTL_SIZE_HINT on unix even if

[sqlite] "Possible" doc bug in os_unix.c

Hi, gurus, i just randomly stumbled upon a _possible_ internal documentation bug: http://www.sqlite.org/src/ci/05c9832e5f The commit message says: "Enable the SQLITE_FCNTL_SIZE_HINT on unix even if SQLITE_FCNTL_CHUNK_SIZE has not been set." but there are some docs in the top part of that diff

[sqlite] speeding up an fts query

I have the following schema (slightly simplified for this post) CREATE TABLE projects ( project_id INTEGER PRIMARY KEY, project_start DATETIME ); CREATE TABLE feeds ( feed_id INTEGER PRIMARY KEY, feed_uri TEXT, project_id INTEGER ); CREATE TABLE feed_history (

Re: [sqlite] WAL mode and Network filesystems

On Fri, Aug 26, 2011 at 4:43 PM, wrote: > Well, my system configuration is such that the RFS is mounted via NFS > server. All the processes that access the DB will be on the same CPU. Just FYI: in my very limited experience, using fcntl()-style locking on NFS can bring

Re: [sqlite] WAL mode and Network filesystems

On 26 Aug 2011, at 3:43pm, sreekumar...@gmail.com wrote: > Well, my system configuration is such that the RFS is mounted via NFS server. > All the processes that access the DB will be on the same CPU. > > > --Original Message-- > From: Pavel Ivanov > To: Sreekumar TP > To: General

Re: [sqlite] fsync and ext3 ordered mode, data integrity.

On Tue, Aug 23, 2011 at 09:28:35AM +0200, Sébastien Escudier wrote: > Hi, > > I am currently using sqlite on an ext3 file system with ordered mode. > But we have serious performance issues when sqlite calls fsync, > especially on RAID devices. > > We noticed that disabling fsync in sqlite OR

Re: [sqlite] WAL mode and Network filesystems

Well, my system configuration is such that the RFS is mounted via NFS server. All the processes that access the DB will be on the same CPU. --Original Message-- From: Pavel Ivanov To: Sreekumar TP To: General Discussion of SQLite Database Subject: Re: [sqlite] WAL mode and Network

Re: [sqlite] WAL mode and Network filesystems

http://www.sqlite.org/wal.html Disadvantage #2: All processes using a database must be on the same host computer; WAL does not work over a network filesystem. So as long as all users of your database are on the same host it seems that WAL will work even if file is on NFS. But then what's the

[sqlite] WAL mode and Network filesystems

I understand that WAL mode of sqlite is not supported over network file systems. Does this mean that if my DB is in a filesystem mounted on a NFS server will also not work in WAL mode? If so what is the bottleneck? Sent from BlackBerry® on Airtel ___

Re: [sqlite] Autoincrement failure

What happens if you make it an in-memory database? If that works that will help narrow the problem to the MMC. And can you run it on your development machine too and see what happens? And I think we asked before but can you make a small sample program that causes this for you? Michael

Re: [sqlite] Custom Collation comparing only firt character?

Roberto Colnaghi wrote: > Thank you for your detailed reply. > Though I cannot use DLLs since it is an iPhone iOS (MacOSX) operational > system.I was hoping for a collation callback that is > called for all characters, not only the first. It is. What do you think str1Length

Re: [sqlite] SQL ROWNUM option is failed - Want to Read records in chunks from table

On Fri, Aug 26, 2011 at 12:50:36PM +0530, Tarun scratched on the wall: > Hi, > > I am calling sqlite3_get_table() to execute query to read all records > from table but issue is records can be many lacs so result set in char > **result may not be able to contain that large number of records. So i

Re: [sqlite] Custom Collation comparing only firt character?

Thank you for your detailed reply. Though I cannot use DLLs since it is an iPhone iOS (MacOSX) operational system.I was hoping for a collation callback that is called for all characters, not only the first. For my subset of data, it fits just perfect. All comparing fields are UTF8 VARCHAR.

Re: [sqlite] SQL ROWNUM option is failed - Want to Read records in chunks from table

> Tarun writes: […] > I planned to execute query that works on SQL ROWNUM option > "select * from employee2 where rownum > 1 and rownum < 2" Perhaps: SELECT * FROM employee2 ORDER BY oid LIMIT 1 OFFSET 1 > but i m getting error from sqlite3 that "no such

[sqlite] SQL ROWNUM option is failed - Want to Read records in chunks from table

Hi, I am calling sqlite3_get_table() to execute query to read all records from table but issue is records can be many lacs so result set in char **result may not be able to contain that large number of records. So i wanted to read records in chunks like first 1 records then next 1 records