Re: [sqlite] ANN: C#-SQLite 3.6.16

Kosenko Max wrote: > > > Noah Hart wrote: >> C#-SQLite is now ready for review. The project is located at >> http://code.google.com/p/csharp-sqlite > I think this name much better than sql-sharp. > I've posted a question on SQLite ADO.NET forum >

Re: [sqlite] translating CSV file into sqlite3 database for iPhone?

On 7/08/2009 1:21 PM, aerende wrote: > I'm trying to take a CSV file and create a sqlite3 database for the iPhone. > The CSV file has 33K entries and is 2 MB. The problem I am having is that > only about 1/10 of the database file gets written into the sqlite3 database. > > I first translated

[sqlite] translating CSV file into sqlite3 database for iPhone?

I'm trying to take a CSV file and create a sqlite3 database for the iPhone. The CSV file has 33K entries and is 2 MB. The problem I am having is that only about 1/10 of the database file gets written into the sqlite3 database. I first translated the CSV file into SQL commands using the

Re: [sqlite] sqlite database "signature" ?

On 7/08/2009 2:36 AM, luc.moulinier wrote: > I'd like to know what is the best way to know if a file > is a sqlite DB or not (without launching sqlite of course) ? > For example, is the first line of the file unambiguously > a signature of sqlite ? If so, what is its structure ?

Re: [sqlite] FTS and postfix search

"Hugh Sasse" schrieb im Newsbeitrag news:alpine.lfd.2.00.0908061712390.30...@trueman.cs.cse.dmu.ac.uk... > I wonder if the idea of suffix arrays would belp. > http://www.cs.dartmouth.edu/~doug/sarray/ I was about suggesting basically the same thing... In case of Lukas'

Re: [sqlite] sqlite database "signature" ?

Yeah, in my project I just check if the file content starts with this string to see if it's a Sqlite3 file. I don't think of a way that could guarantee the "unambiguously". 2009/8/7 P Kishor > On Thu, Aug 6, 2009 at 11:36 AM, luc.moulinier >

Re: [sqlite] sqlite database "signature" ?

On Thu, 6 Aug 2009, luc.moulinier wrote: > I'd like to know what is the best way to know if a file is a sqlite DB or > not (without launching sqlite of course) ? For example, is the first line > of the file unambiguously a signature of sqlite ? If so, what is its > structure ? Many thanks in

[sqlite] sqlite database "signature" ?

Hello ! I'd like to know what is the best way to know if a file is a sqlite DB or not (without launching sqlite of course) ? For example, is the first line of the file unambiguously a signature of sqlite ? If so, what is its structure ? Many thanks in advance ! Luc Créez votre adresse

Re: [sqlite] FTS and postfix search

You can lazy-init the table of substrings and substring matches when you save words, so you only use space for substrings that appear in words that have been saved in your database. That avoids entering substrings that never occur in English, and substrings that occur in English but not in any

Re: [sqlite] FTS and postfix search

I hadn't thought about it until now, but there's no reason you can't treat the table of substrings as substrings appearing anywhere in a word, and join each substring of a word to the substrings table. For 26 letters, you have > 17k three-letter substrings and almost 500k four-letter

Re: [sqlite] FTS and postfix search

Hi Jim, and thank you for the great idea. But I thought it would be possible to search '*word*' - but this is not possible with this method either. Is there any chance for searching '*word*' quickly? Regards, Luke Jim Showalter schrieb: > You could store the words reversed (in addition to

Re: [sqlite] FTS and postfix search

Roger Binns schrieb: > [...] > > Lukas Haase wrote: >> additionally I would also accept the index being bigger. > > You could have a second FTS table where you store the keywords in reverse > order :-) Hi, DAMN!! Damn, damn. Thank you for the great idea. But unfortunately I thought I could

Re: [sqlite] SQLite Memory Pool overflow probelm

Thanks Simon for response. I got the problem. I need to use the the macro * SQLITE_DEFAULT_CACHE_SIZE= *The documentation can be found at *http://www.sqlite.org/compile.html * The default configuration is 2000 pages which is not fitting into 256 KB of memory pool. I have

Re: [sqlite] ANN: C#-SQLite 3.6.16

Noah Hart wrote: > C#-SQLite is now ready for review. The project is located at > http://code.google.com/p/csharp-sqlite I think this name much better than sql-sharp. I've posted a question on SQLite ADO.NET forum http://sqlite.phxsoftware.com/forums/p/1879/7971.aspx about supporting your

Re: [sqlite] SQLite Memory Pool overflow probelm

On 6 Aug 2009, at 9:43am, shankar m wrote: > I am able to reproduce the problem in normal PC also. > > I am using sqlite3_exec statement > * > rc = sqlite3_exec(db, "INSERT INTO city (name, state) VALUES('ggg', > 'abcdef')", callback, 0, );* > > After your suggestion i used transcation

Re: [sqlite] Data synchronization between two offices

Rstat wrote: > > Hi everyone, > > After building a database for our growing company, we have a problem with > our data and its synchronization. Our company has a rather small, but > growing, book warehouse and sells books online. We have been able to deal > with orders and stock because

Re: [sqlite] SQLite Memory Pool overflow probelm

I am able to reproduce the problem in normal PC also. I am using sqlite3_exec statement * rc = sqlite3_exec(db, "INSERT INTO city (name, state) VALUES('ggg', 'abcdef')", callback, 0, );* After your suggestion i used transcation statements. For every 1000 insertions i am doing a commit. But then