Re: [sqlite] Compile Virtualtext extension

Hi Alexey thanks for the prompt answer. I saw your extension and tried it in the Spatialite GUI. The trial worked well in the GUI and it is useful for messaging environments. However I am still not sure what the recommended way of compiling it is. - Should it be compiled when compiling SQLite

Re: [sqlite] Local data structures vs sqlite

>>I wouldn't use SQLite for most in memory data that never needs to be >>stored on disk > >Even this depends entirely on your context. Of course if only a simple >lookup in a table is more or less all you ever need, there is little >point in SQLite. But if or when your requirements get more

Re: [sqlite] Canceling a integrity check in progress (feature request)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave Wright wrote: > sqlite3_interrupt does not appear to cancel an integrity check (pragma > integrity_check or quick_check) in progress. http://www.sqlite.org/src/info/33fdaab1a0 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9

[sqlite] test harness?

I am encountering significant differences in the way the data libraries for SQLite produced by a "major player" are handling joins, unions, and inline views, in combination, compared to several other GUI front ends for SQLite which have been well-received and which jibe with each other. Is

Re: [sqlite] Local data structures vs sqlite

>Nice Freudian slip! Again rotfl, when you know that slip is French word for men underwear... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Local data structures vs sqlite

>I think "worth" should be more accurate. Yes, rotfl! I realize this while hitting Send and didn't dare one more post. You know, I'm a victim of rogue cosmic rays and badly need one of those stock ECC brains. Sorry for my French accent btw! ___

Re: [sqlite] SQLite on PocketBook

On Nov 5, 2009, at 5:15 PM, Beau Wilkinson wrote: > I really think this warrants further discussion. Perhaps the correct > answer (that ARMs implement a non-standard FP type which is > incompatible with Sqlite) is already out there, but I think the > issues I raised with that answer should

Re: [sqlite] Local data structures vs sqlite

I think "worth" should be more accurate. - Original Message - From: "Jean-Christophe Deschamps" To: "General Discussion of SQLite Database" Sent: Friday, November 06, 2009 9:47 AM Subject: Re: [sqlite] Local data structures vs sqlite > You

Re: [sqlite] Local data structures vs sqlite

On Nov 5, 2009, at 5:44 PM, Jean-Christophe Deschamps wrote: > Hi John, > >> I wouldn't use SQLite for most in memory data that never needs to be >> stored on disk > > Even this depends entirely on your context. Of course if only a > simple > lookup in a table is more or less all you ever

Re: [sqlite] Local data structures vs sqlite

You read 'worse' instead of 'worst', of course! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Local data structures vs sqlite

Hi John, >I wouldn't use SQLite for most in memory data that never needs to be >stored on disk Even this depends entirely on your context. Of course if only a simple lookup in a table is more or less all you ever need, there is little point in SQLite. But if or when your requirements get

Re: [sqlite] Local data structures vs sqlite

SQLite will have some overhead, no questions asked. If you aren't using indexes, a raw loop and raw data is going to be faster. A raw file will also always be smaller. That said, Dr. Hipp is right. If you are STORING the data, you should strongly consider using SQLite rather than proprietary file

Re: [sqlite] SQLite on PocketBook

On 5 Nov 2009, at 10:45pm, D. Richard Hipp wrote: > I'm sorry that you are having difficulty and that SQLite is not > working to your satisfaction. But the fact remains that it works > great on every platform that I have access to. If you are able to > find a bug in SQLite we will be happy to

Re: [sqlite] Local data structures vs sqlite

Ok, sqlite group, please accept my apologies. It was thoughtless of me. On 11/5/09 4:54 PM, "P Kishor" wrote: > First, you shouldn't hijack a thread. If you have a new subject, start > a new email thread instead of using an existing one. > > > On Thu, Nov 5, 2009 at 4:43

Re: [sqlite] Local data structures vs sqlite

On Nov 5, 2009, at 5:43 PM, Kavita Raghunathan wrote: > > I saw a presentation on sqlite by Dr Hipp that mentioned that > anytime I'm > storing data in structures or tables, I should be thinking about using > sqlite instead. > > Would it be more efficient to use the sqlite database to store a

Re: [sqlite] Local data structures vs sqlite

First, you shouldn't hijack a thread. If you have a new subject, start a new email thread instead of using an existing one. On Thu, Nov 5, 2009 at 4:43 PM, Kavita Raghunathan wrote: > > I saw a presentation on sqlite by Dr Hipp that mentioned that anytime I'm >

Re: [sqlite] SQLite on PocketBook

On Nov 5, 2009, at 5:15 PM, Beau Wilkinson wrote: > > Assuming (and perhaps this is the rub...) that Sqlite is built > around C++ "float" and "double," then I fail to see how any FP > system that is even plausibly useful could give the results cited by > Mr Drozd. If I put (for example)

[sqlite] Local data structures vs sqlite

I saw a presentation on sqlite by Dr Hipp that mentioned that anytime I'm storing data in structures or tables, I should be thinking about using sqlite instead. Would it be more efficient to use the sqlite database to store a table that Looks like this: where lets say I'm looking for the word

Re: [sqlite] SQLite on PocketBook

I really think this warrants further discussion. Perhaps the correct answer (that ARMs implement a non-standard FP type which is incompatible with Sqlite) is already out there, but I think the issues I raised with that answer should at least be addressed. Assuming (and perhaps this is the

Re: [sqlite] Compile Virtualtext extension

Hello! On Thursday 05 November 2009 14:47:03 Gary_Gabriel wrote: > I want to use the Virtualtext extension in an application and I > downloaded it from VirtualText extension > . Oh, I'm sorry, is needed the

Re: [sqlite] Problems with the UPDATE command

Hi Igor, Thanks for your reply. I have a database with a table in it called local_episodes, it has about 8000 entries in it. Each record in the table holds a reference to the location of a file on my computer. Currently the files are stored on 3 different drives (D:, F:, H:). I

Re: [sqlite] in-memory database concept

On Wed, Nov 4, 2009 at 4:57 AM, Serdar Genc wrote: > Yes I am aware of that but I need to access an in-memory database from two > processes which were written in Java and C++. > I am just looking for a way to do so.. Hey Serdar, do you have any update on this ? I found

Re: [sqlite] Problems with the UPDATE command

On Thu, Nov 5, 2009 at 1:28 PM, Rodney Cocker wrote: > > I ran the following SQL command > > UPDATE local_episodes > SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename, > 3,LENGTH(EpisodeFilename)) > WHERE SUBSTR(EpisodeFilename,1,3)='F:\' > > Which worked perfectly,

Re: [sqlite] Problems with the UPDATE command

Rodney Cocker wrote: > I ran the following SQL command > > UPDATE local_episodes > SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename, > 3,LENGTH(EpisodeFilename)) > WHERE SUBSTR(EpisodeFilename,1,3)='F:\' > > Which worked perfectly, but when I went to run it the

[sqlite] Problems with the UPDATE command

I ran the following SQL command UPDATE local_episodes SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename, 3,LENGTH(EpisodeFilename)) WHERE SUBSTR(EpisodeFilename,1,3)='F:\' Which worked perfectly, but when I went to run it the next time to change any files stored on my H: drive it didn't

[sqlite] Canceling a integrity check in progress (feature request)

sqlite3_interrupt does not appear to cancel an integrity check (pragma integrity_check or quick_check) in progress. Given how long these checks can take on big DBs, it's nice to be able to abort them (if your app is asked to exit for example). I've hacked in my own support for doing this, but