[sqlite] shared cache and journal files

Hello list I have been using a modified version of threadtest1.c from the SQLite test code to test the robustness of multi-threaded read/write connections (SQLite 3.6.10) on an embedded platform (with my own VFS implementation). The test code spawns 10 threads, each of which creates, populates

Re: [sqlite] Transaction behavior with large numbers of inserts

So thinking about this, what would be the impediment (apart from current implementation, of course,) to implementing a disk-based temp file page cache, that could grow arbitrarily large? Operations against the page cache in memory are already lost if your process dies before commission. Are

Re: [sqlite] database encrypted

Hi Joannek, On Wed, 28 Jan 2009 13:07:47 -0800 (PST), Joanne Pham wrote in General Discussion of SQLite Database : >Hi all, >One of our database had problem to run the "schema". The error message below: >The question is how the database getting

Re: [sqlite] database encrypted

On 29/01/2009 8:07 AM, Joanne Pham wrote: > Hi all, > One of our database had problem to run the "schema". The error message below: > The question is how the database getting to this stats " Error: file is > encrypted or is not a database" > Thanks, > JP > > Below is the error message > >

Re: [sqlite] database encrypted

On 1/28/09, Joanne Pham wrote: > Hi all, > One of our database had problem to run the "schema". The error message below: > The question is how the database getting to this stats " Error: file is > encrypted or is not a database" > Thanks, > JP > > Below is the error

Re: [sqlite] Sqlite2 vs Sqlite3 issues

One other note of interest is if I go at the database with sqlite3 from command line not only can I get in I can run queries jut fine. On Wed, Jan 28, 2009 at 12:59 PM, Tony Bibbs wrote: > I have a PHP/SQLite issue. I'm on Kubuntu with PHP 5.2.8. PHPInfo() > gives: > >

[sqlite] database encrypted

Hi all, One of our database had problem to run the "schema". The error message below: The question is how the database getting to this stats " Error: file is encrypted or is not a database" Thanks, JP Below is the error message Enter ".help" for instructions sqlite> .schema Error: file is

Re: [sqlite] SQLite utilty to import XML

Cool Thanks Joaquim -Original Message- I think the firefox SQLite Manager plugin can do XML. http://code.google.com/p/sqlite-manager/ Alex ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Do all db's in a connection need same level of lock?

I have read http://sqlite.org/atomiccommit.html which seems to imply that all db files in a transaction are locked at the same level as the transaction progresses (i.e. all Reserved, then all Exclusive, ...). This makes sense when all the files are being changed, but I have a use case where I am

Re: [sqlite] SQLite utilty to import XML

Salles, Joaquim Campos wrote: > Hello, > > I'm looking for an SQLite utility (Windows / Linux) to import XML files > into an SQLite Database (free/open source), so I can use it in a shell > script to periodicly search a directory and import the XML files. > > I tried to find one in: > >

[sqlite] Sqlite2 vs Sqlite3 issues

I have a PHP/SQLite issue. I'm on Kubuntu with PHP 5.2.8. PHPInfo() gives: PDO->PDO drivers: sqlite, mysql, sqlite2 pdo_sqlite->SQLite Library: 3.4.2 Running a very simple query I get an error with the following (via print_r): Array ( [0] => HY000 [1] => 26 [2] => file is encrypted or is not

Re: [sqlite] Multi-threading problem!

Create a connection for each thread. --- On Wed, 1/28/09, Anatoly Stepanov wrote: > From: Anatoly Stepanov > Subject: [sqlite] Multi-threading problem! > To: "sqlite-users@sqlite.org" > Date: Wednesday,

Re: [sqlite] Transaction behavior with large numbers of inserts

Hi, Does your reader threads access to the same table as your writer ? Maybe (I'm not 100% sure it works) you could try : on a single file database, with the PRAGMA read_uncommited=1 on the readers connections (this is not a good idea if the tables are the same between readers and writers, it

Re: [sqlite] help : sqlite database restore

Thanks a lot Donald, These links really helps me a lot... On 1/27/09, Griggs, Donald wrote: > > > > On 1/27/09, Griggs, Donald wrote: > > > > Venkat, > > > > If you have a ".db" file it almost certainly *is* an sqlite database. > > A

Re: [sqlite] Transaction behavior with large numbers of inserts

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Griggs, Donald wrote: > The INSERT into main.table (with its associated SELECT) would still be > an implicit transaction and of course would require writing to the > database of the million records. > > During the rather long period of time for the

Re: [sqlite] Transaction behavior with large numbers of inserts

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns Sent: Wednesday, January 28, 2009 1:12 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Transaction behavior with large numbers of inserts

[sqlite] Multi-threading problem!

Hello! I use the latest (3.6.10) version of SQLite library. I was trying to perform query "select" from one table inside single database connection from different threads(up to 8 threads). In summary I had 50% CPU Usage( 2 core CPU)-this is a problem! I tried to find the reason in Debug mode and

[sqlite] Multiuser Readonly Database

I have a user application written in Abobe AIR that utilizes SQLite - its a modular application in that users can download sets of files and each set has its own SQLite db as an index for performing searches etc Originally this was designed to be standalone client application but the

Re: [sqlite] SQLite - Explain

"Rogério Costa" wrote in message news:3dd03f9d93e74caebaace23a9c3cc...@rochico > Does any one know what means each of the values that are presented as > a result of a EXPLAIN command? http://sqlite.org/opcode.html http://sqlite.org/vdbe.html Igor Tandetnik

Re: [sqlite] SQLite - Explain

Hi, Rogério. Depending on exactly what info you want, you might be looking for the EXPLAIN QUERY PLAN statement, as in: EXPLAIN QUERY PLAN SELECT * FROM a; or, if you want to understand what the VDBE commands you're seeing there mean, you will have to look at the source, namely vdbe.c.

Re: [sqlite] Checking versions where functions first appeared

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Maurí­cio wrote: > I'm writing a wrapper for sqlite3 for a different > language (Haskell). I would like to support different > versions of sqlite, i.e., user would be able to link > against a slightly outdated version without having > link problems

[sqlite] Checking versions where functions first appeared

Hi, I'm writing a wrapper for sqlite3 for a different language (Haskell). I would like to support different versions of sqlite, i.e., user would be able to link against a slightly outdated version without having link problems due to a recently introduced function. How can I check at which

[sqlite] SQLite - Explain

Hi, Does any one know what means each of the values that are presented as a result of a EXPLAIN command? Is there anything like an "query execution cost"? Thanks 0|Trace|0|0|0|explain select * from a;|00| 1|Goto|0|10|0||00| 2|SetNumColumns|0|1|0||00| 3|OpenRead|0|2|0||00|

[sqlite] testing sqlite on target

Hi All, I am running Linux 2.6 on PPC based target. Also have application using SQLite 3.6.10 How can i run the tests comming with SQLite package? There is Tcl 8.5.6 on my target also. Thanks for the help. ___ sqlite-users mailing list

Re: [sqlite] Adding Custom Column Data Types

Thanks, Everyone. I think I understand this enough to at least attempt to test it, unfortunately, it will probably be a couple of days before them. I will let you know the results... Mike On Wed, Jan 28, 2009 at 2:24 AM, MikeW wrote: > Mike McGonagle writes:

Re: [sqlite] SELECT issue with SQLite 3.6.10

You got it right Igor ! So I have my table GENERAL with a field ID. I create a view VIEW_GENERAL like this : CREATE VIEW VIEW_GENERAL AS SELECT GENERAL.ID FROM GENERAL Note that this is just an example, in my real case, I needed to select GENERAL.ID instead of ID only because I also do some

Re: [sqlite] ODBC drivers are faster than NAtive C API why?

> I tried to execute some SQL queries using drivers(sqliteodbc) and Native c > API but i found that ODBC drivers are working twice faster than c API. > Why this behavior is coming as c APIs are supposed to be faster than > drivers? May be the old issue: You've been using transactions with your

[sqlite] ODBC drivers are faster than NAtive C API why?

Hi all, I tried to execute some SQL queries using drivers(sqliteodbc) and Native c API but i found that ODBC drivers are working twice faster than c API. Why this behavior is coming as c APIs are supposed to be faster than drivers? Any thought on this would be appreciated. Regards

Re: [sqlite] Very slow query execution with SQLite Database

Hi, I tried with concatenated index (by dropping an index which was already present on timestamp_id) It took 12 seconds for completion, so there was no improvement in speed. > If we might assume your table is 1.5 GB in size and you do that query you > have to do a full table scan for it. (unless

Re: [sqlite] Adding Custom Column Data Types

Mike McGonagle writes: > > Hello all, > > I am in the process of integrating SQLite into a multimedia > environment/programming language. One thing that I would like to be > able to do is support all the various datatypes in this language, and > one in particular is a list of other