Re: [sqlite] Google Chrome and SQLite3

Rich Rattanni wrote: > So after playing around in my application data directory for google > chrome, I noticed file called something-journal. Of course, I knew > what that was. So I began opening all kinds of SQLite databases in > use by Chrome (had to close chrome due to locks on a few of

Re: [sqlite] Google Chrome and SQLite3

On Mon, Sep 8, 2008 at 1:30 PM, Rich Rattanni <[EMAIL PROTECTED]> wrote: > So after playing around in my application data directory for google > chrome, I noticed file called something-journal. Of course, I knew > what that was. So I began opening all kinds of SQLite databases in > use by

Re: [sqlite] Google Chrome and SQLite3

Chrome is built heavily on Gears... all SQLite all the way. On another note, one of the reasons why Chrome may not yet be available on Macs, in spite of using WebKit as its rendering engine, is that Gears is not yet available on Macs via Safari (Gears can be used on Macs via FF). So, this implies

[sqlite] Google Chrome and SQLite3

So after playing around in my application data directory for google chrome, I noticed file called something-journal. Of course, I knew what that was. So I began opening all kinds of SQLite databases in use by Chrome (had to close chrome due to locks on a few of them). Interesting the things

Re: [sqlite] SQLite vs. quad-cores

I would suggest you force your software to use only one processor on both dual- and quad-core machines and check the timings again. If the timings are in the range of expectancy (due to hardware speed/processor frequency) then your software has a bug related to NUMA. The non-uniform memory

Re: [sqlite] SQLite vs. quad-cores

This might be a wild goose chase, and I'm not convinced it's directly related, but AMD multi-core CPUs are known to have timing issues. Google for "AMD negative ping" and you'll see it affects the results from the ping utility for example. They've released a "Dual-Core Optimizer" patch to

Re: [sqlite] 500 sqlites on one server machine?

Hello! В сообщении от Monday 08 September 2008 17:51:35 Daniel van Ham Colchete написал(а): > You might want to take a look at GlusterFS (www.glusterfs.org), it's a > clustered filesystem that works well with fcntl() (the locking system). > If you need a smaller latency, it will also work with

[sqlite] SQLite vs. quad-cores

Hi everyone, I'm a BioConductor developer and we use SQLite (via RSQLite package) to handle annotation of high-density oligonucleotide microarrays. Our solution, implemented in the pdInfoBuilder package, worked great until we got machines with quad-core processors. One particular setup is a

Re: [sqlite] fts search, quoting and sippet generation

On Sep 7, 2008, at 1:46 AM, Peter Hoffmann wrote: > 1) The first one is to strip out all tags before inserting new text > into the virtual table. I don't want to do this, because I have a pure > text interface too, where the tags in results won't hurt. Went down that road (i.e. stripping tags

Re: [sqlite] fts search, quoting and sippet generation

When putting together fts, we never quite could come up with a really solid way to handle snippets. A big factor was that fts is embedded w/in SQLite, not directly w/in your program, so it's sometimes challenging to provide a really wide API. This is why there is both a snippet() function and an

Re: [sqlite] Get declared Datatype of SQLite Virtual Table

paul schindler wrote: > Thanks for your answer! > But I expected that when 'amount' has the declared datatype INTEGER then > sum(amount) is also INTEGER... > Not if one of the entries in the column is 1.7 Gerry ___ sqlite-users mailing list

Re: [sqlite] SQLite test suite - where is it?

On Sep 8, 2008, at 11:05 PM, Ribeiro, Glauber wrote: > Sorry for the newbie question, but how is the regression testing > invoked? > > I tried "make check" with the 3.6.2 "amalgamation" distribution in > Unix, > but that seemed to do nothing. You only get the test suite if you download the

[sqlite] SQLite test suite - where is it?

Sorry for the newbie question, but how is the regression testing invoked? I tried "make check" with the 3.6.2 "amalgamation" distribution in Unix, but that seemed to do nothing. Thanks, glauber ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite 3.6.2 tests on Mac OS X

On Sep 8, 2008, at 9:46 PM, Jens Miltner wrote: > Hi, > > I just merged our code base with the sqlite 3.6.2 distribution and > decided to run the tests on Mac OS X (10.5.4). I had two issues: > > (1) make tests would not properly link the testfixture - it complains > about missing Tcl symbols -

[sqlite] sqlite 3.6.2 tests on Mac OS X

Hi, I just merged our code base with the sqlite 3.6.2 distribution and decided to run the tests on Mac OS X (10.5.4). I had two issues: (1) make tests would not properly link the testfixture - it complains about missing Tcl symbols - I guess the libtool link phase does not know about the

Re: [sqlite] 500 sqlites on one server machine?

Hi, Daniel Colchete: Thank you very much, very useful information for me! regards ye On Mon, Sep 8, 2008 at 3:51 PM, Daniel van Ham Colchete <[EMAIL PROTECTED]>wrote: > ye, > > at the fifth question of the SQLite FAQ, at > http://www.sqlite.org/faq.html, it is explained why using a sqlite file

Re: [sqlite] Error A0A

Are you using the native api or one of the wrappers? On Mon, Sep 8, 2008 at 9:58 AM, Dan <[EMAIL PROTECTED]> wrote: > > On Sep 8, 2008, at 1:47 PM, [EMAIL PROTECTED] wrote: > >> >> I'm using multiple connections to sqlite database from more threads >> in my application. Few customers reports

Re: [sqlite] Error A0A

On Sep 8, 2008, at 1:47 PM, [EMAIL PROTECTED] wrote: > > I'm using multiple connections to sqlite database from more threads > in my application. Few customers reports sqlite error in windows > vista which I cannot get in my system. > Error code is 0xA0A (I haven't turned on extended error

Re: [sqlite] 500 sqlites on one server machine?

ye, at the fifth question of the SQLite FAQ, at http://www.sqlite.org/faq.html, it is explained why using a sqlite file by multiple nodes over a network with a NFS filesystem is not a good idea. I would avoid it although the FAQ does not say 'it does not work', it only says 'it might not

Re: [sqlite] 500 sqlites on one server machine?

Hi, Igor: Thanks for reply! Yes, I just noticed the sqlite data file is nothing but a empty file. Thanks! About the remote visit, if the sqlite data file is created on a NFS, will the remote visiting process be considered as a equal local process? regards ye On Mon, Sep 8, 2008 at 1:48 PM, Igor

Re: [sqlite] 500 sqlites on one server machine?

"ye" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 1. Is it possible to create 500 sqlite databases on one server > machine, on which the simulation is running. Each sqlite is supposed > to be managed/used by one java thread. Yes. SQLite database is just a file. You can have as

[sqlite] 500 sqlites on one server machine?

Hi, Dear all: I am working on creating a cluster simulation with 500 nodes. Each node is supposed to have its's own database. I am curiously about following questions: 1. Is it possible to create 500 sqlite databases on one server machine, on which the simulation is running. Each sqlite is

Re: [sqlite] Get declared Datatype of SQLite Virtual Table

Igor Tandetnik wrote: > > "paul schindler" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> sqlite3_column_decltype("select amount from myvirtualtable", 0) >> returns "INTEGER" -> good! >> >> BUT: >> >> sqlite3_column_decltype("select sum(amount) from myvirtualtable", 0) >>

Re: [sqlite] Get declared Datatype of SQLite Virtual Table

D. Richard Hipp wrote: > > > On Sep 5, 2008, at 9:03 AM, paul schindler wrote: > >> >> Hello, >> >> I have a virtual table and some (by me) declared datatypes are >> "TEXT10" or >> "INTEGER" or "DATE"... >> >> When I am using the function sqlite3_column_decltype() then I get >> those >>