Re: [sqlite] Most wanted features of SQLite ?

2009-09-21 Thread Itamar Syn-Hershko
You mean like http://www.sqlite.org/contrib ? I agree though there's much to improve in that area... Itamar. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Grzegorz Wierzchowski Sent: Monday, September 21, 2009 1:34 PM To:

Re: [sqlite] Most wanted features of SQLite ?

2009-09-20 Thread Itamar Syn-Hershko
Having to support a dedicated language for stored-preocedures sounds to me like an overkill, PL/SQL or not. IMHO having the ability to store complex queries in the standard TSQL syntax already supported today for queries, plus basic extra stuff only like loops, and have their compiled version

Re: [sqlite] Most wanted features of SQLite ?

2009-09-20 Thread Itamar Syn-Hershko
As Igor mentioned in a previous post, Hebrew has no capital and lower case versions of a letter. It has only what's called Mantzpach, which are 5 letters which look different if in the end of a word; IIRC this is never an issue since they are ordered right after the original letter, and have their

Re: [sqlite] Two feature requests

2009-09-17 Thread Itamar Syn-Hershko
Tim, In this context, you might find clucene useful. It's an IR lib written completely in cross-platform C++. It could be used just for what you're after using Queries and Filters. The git master HEAD is stable but still work in progress, or you could download the latest official release (quite

[sqlite] Best approach for storing not-so-small BLOBs per record

2009-09-16 Thread Itamar Syn-Hershko
Hi all, I'm in the design phase of an application with SQLite backend. The SQLite file will hold a table of about 20K records initially, and a few several other small tables. About 75% of the records in the large table will have binary data associated with it. My main question is which one of