[sqlite] Full-text indexing for SQLite

"Their interfaces and designs, where available, will likely be useful in planning Cinnamon." http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex&t=1146015756 Is 'Cinnamon' the codename for SQLite 4? Just kidding. Anyway, full text search would be very cool.

Re: [sqlite] Most appropriate Web based database? (Newbie)

If you want to easy portability of your database use SQLite... but if you are a great site, doing every time insert and update use another like postgresql or mysql. and it depends of the language your are writing your web site, if you PHP you could use what ever between mysql,postgresql, sqlite or

[sqlite] Libraries supplied via the starKit

Hi I am running 3.3.5 on OSX10.4 from the starKit available on www.sqlite.org. I have written a wrapper and I am now unit testing each of the C functions. I am getting fails on sqlite3_table_column_metadata sqlite3_release_memory sqlite3_soft_heap_limit Could these be due to the library

Re: [sqlite] SQLite on limited Memory

"Tony Fenleish" <[EMAIL PROTECTED]> wrote: > You meantion avoid using sqlite3_get_table. I've been using sqlite 2.8.15 > and have postponed upgrading just because "it's been working". Are there > better memory handling and speed improvements for embedded devices in sqlite > 3, or are most of t

Re: [sqlite] SQLite on limited Memory

You meantion avoid using sqlite3_get_table. I've been using sqlite 2.8.15 and have postponed upgrading just because "it's been working". Are there better memory handling and speed improvements for embedded devices in sqlite 3, or are most of the improvements for machines with lots of ram and l

Re: [sqlite] Using sqlite3_complete

Aidan Reel wrote: Hi If I give sqlite3_complete the string 'select from Person;' should I expect it to return zero or one? Since it is not a valid Select statement I am expecting a zero, instead I get a one. If I remove the semicolon from the end of the string I receive a zero. Regards Aid

[sqlite] Using sqlite3_complete

Hi If I give sqlite3_complete the string 'select from Person;' should I expect it to return zero or one? Since it is not a valid Select statement I am expecting a zero, instead I get a one. If I remove the semicolon from the end of the string I receive a zero. Regards Aidan

Re: [sqlite] SQLite on limited Memory

On Mon, 24 Apr 2006, Tony Fenleish wrote: >I've been developing an app on a linux embedded device with 128 M of RAM, >although the available RAM for queries is less than that. Now that the >databases are getting a little larger (120 MB), I'm having problems with >some queries that have large resu

[sqlite] Would temp table faster than normal table doing insert/delete?

Hello, Our application does a lot insert and delete, it is strange that in one rather low-end machine, the performance by using temp table is around 7 times faster than using normal table. but in one high-end machine, the performance of those both are about equal. how is the "temp table" impleme

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Windows (NT, 2000, XP etc..) unicode strings are in UCS-2 (!= UTF-16) You should be calling SHGetSpecialFolderPathW (note the W at the end) with a 'wide' buffer for the "My Documents" directory, before converting this to UTF-8 and passing it to sqlite_open(). HTH. On 24/04/06, COS <[EMAIL PROTECTE

Re: [sqlite] Sqlite inside MySQL as one of the pluggable "storage mechanisms" ?

Jim C. Nasby wrote: On Sun, Apr 23, 2006 at 07:30:21AM +1000, John Stanton wrote: I have actually done that and it works well for a particular class of applications, ones with a relatively small number of simultaneous users. For large numbers we switch to PostgreSQL The basic architecture of