[sqlite] SQLite - IIS, PHP and java

Hi there, I am at the research stage of a project i have been asked to undertake. At the moment the O/S will be windows server 2003 and the web server IIS. These are set and i cannot change them. I will be using PHP to deliver the web content to users and also a Java application will be used

Re: [sqlite] SQLite - IIS, PHP and java

Hi, the important question is: What about updates to the database? Will there be concurrent updates, or will the db be read only? Will some processes read an others write? What amount of traffic do you expect on the site? See http://www.sqlite.org/faq.html#q5 Martin alexis_ wrote: Hi

Re: [sqlite] SQLite - IIS, PHP and java

Hi Martin The Java Application will do all the write. PHP will only read. (Just out of curiosity what would the implication be if both PHP and Java did write. Wouldn’t SQLite insure sequential write?) As for Traffic: Java could do 1 or 2 write's once a day. PHP will be doing 2000 - 4000 reads

[sqlite] ANN: SQLite Code Factory 10.2 released

Hi! SQL Maestro Group announces the release of SQLite Code Factory 10.2, a powerful Windows GUI solution aimed at the SQL queries and scripts development. The new version is immediately available for download at http://www.sqlmaestro.com/products/sqlite/codefactory/download/ Please note that

Re: [sqlite] SQLite - IIS, PHP and java

Hi Alexis, you will be ok. However, make sure to handle the SQLITE_BUSY returncode in your apps correctly, and keep the write-transactions short and commit or rollbackt them all. Based on your data, a SQLITE_BUSY will be very unlikely, but you have to take it into account. See also

Re: [sqlite] SQLite - IIS, PHP and java

Thanks Martin, alexis Martin Engelschalk wrote: Hi Alexis, you will be ok. However, make sure to handle the SQLITE_BUSY returncode in your apps correctly, and keep the write-transactions short and commit or rollbackt them all. Based on your data, a SQLITE_BUSY will be very

[sqlite] String Vs Integer Index

Howdy SQLite users, I know I can benchmark myself this question, but I am sure somebody did that already. Supose a table with a key that is a string (say, words from 1 to 10 characters) or a table with a key of integers. How different is the efficiency on fetching one record on these tables?

Re: [sqlite] String Vs Integer Index

On 10 Feb 2010, at 5:19pm, Alberto Simões wrote: I know I can benchmark myself this question, but I am sure somebody did that already. Supose a table with a key that is a string (say, words from 1 to 10 characters) or a table with a key of integers. How different is the efficiency on

[sqlite] Cloning a database to memory

Is there an easy way of opening a SQLite database and cloning it to an in-memory database? Cloning a database in a file is easy, you just copy the file. It would be nice if I could just copy a file into memory just as easily. Phil Hibbs. -- Don't you just hate self-referential sigs?

Re: [sqlite] String Vs Integer Index

I think you should be asking 'How fast is SQLite locating a key in a integer column index vs a string index'... Generally, integer keys are faster in key lookups than string keys, because comparing a integer value is a single CMP CPU instruction versus a more-complicated string comparison (that

Re: [sqlite] String Vs Integer Index

On Wed, Feb 10, 2010 at 5:42 PM, Virgilio Fornazin virgilioforna...@gmail.com wrote: I think you should be asking 'How fast is SQLite locating a key in a integer column index vs a string index'... Generally, integer keys are faster in key lookups than string keys, because comparing a integer

Re: [sqlite] Cloning a database to memory

Phil Hibbs sna...@gmail.com wrote: Is there an easy way of opening a SQLite database and cloning it to an in-memory database? http://www.sqlite.org/backup.html Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Doc bug in 'Datatypes' page

Minor typo: section 2.0 Type Affinity of http://www.sqlite.org/datatype3.html says, in the third paragraph after the bullet list, Hence, the string '3.0e+5' is stored in a column with NUMERIC affinity as the integer 3, not as the floating point value 30.0. I think this

Re: [sqlite] String Vs Integer Index

Sure (com certeza!), because it depends on the hardware and software of your target platform. 2010/2/10 Alberto Simões hashas...@gmail.com On Wed, Feb 10, 2010 at 5:42 PM, Virgilio Fornazin virgilioforna...@gmail.com wrote: I think you should be asking 'How fast is SQLite locating a key in a

Re: [sqlite] Cloning a database to memory

http://www.sqlite.org/backup.html Awesome, that means an application could use SQLite both for its save file storage mechanism, and for manipulating its data in memory while it is running, dumping it back out to disk when it's finished. Thanks. Phil Hibbs. -- Don't you just hate

Re: [sqlite] String Vs Integer Index

Am 10.02.2010 18:19, schrieb Alberto Simões: Supose a table with a key that is a string (say, words from 1 to 10 characters) or a table with a key of integers. How different is the efficiency on fetching one record on these tables? If you look into the documentation for create table

Re: [sqlite] Usage of vacuum and auto vacuum

On Wed, 10 Feb 2010 10:05:34 +0530, ramesh.kotab...@wipro.com wrote: Hi All, I am Ramesh, facing come issue regarding DB malformed, find trace below. sqlite pragma integrity_check; *** in database main *** Main freelist: 4 of 4 pages missing from overflow list starting at 0 Page 1515 is

Re: [sqlite] String Vs Integer Index

On 10 Feb 2010, at 7:51pm, Ibrahim A wrote: An INTEGER PRIMARY KEY is at least twice as fast as another type of PRIMARY KEY, the reason is based on the implementation of the engine. An integer primary key substitutes the rowid column of a table. But that's true only if you're running a

Re: [sqlite] String Vs Integer Index

On Wed, Feb 10, 2010 at 10:17:28PM +, Simon Slavin scratched on the wall: On 10 Feb 2010, at 7:51pm, Ibrahim A wrote: An INTEGER PRIMARY KEY is at least twice as fast as another type of PRIMARY KEY, the reason is based on the implementation of the engine. An integer primary key

Re: [sqlite] String Vs Integer Index

Am 10.02.2010 23:17, schrieb Simon Slavin: But that's true only if you're running a SELECT which actually uses that column and only that column to do the searching. Which is why I asked that question earlier on in this thread. Simon. The implementation of sqlite uses a B+Tree for the

[sqlite] very simple update query failure...

I'm new to SQLITE. I'm trying to update a series of text entries for book titles that were entered with underscores. I want to convert them to spaces. I can run the query: select replace(title, '_', ' ') from books; and see the output I'm looking for, but if I try to do an update query

Re: [sqlite] very simple update query failure...

On Wed, Feb 10, 2010 at 11:08 PM, jflaming jay.flam...@gmail.com wrote: I'm new to SQLITE. I'm trying to update a series of text entries for book titles that were entered with underscores.  I want to convert them to spaces. I can run the query: select replace(title, '_', ' ') from books;

Re: [sqlite] very simple update query failure...

Of course... apologies. I have tried this on command line sqlite 3 (3.6.22), sqlite 2.817, and also in the sqliteman gui and sqlite database browser, all on an Ubuntu linux box. P Kishor-3 wrote: On Wed, Feb 10, 2010 at 11:08 PM, jflaming jay.flam...@gmail.com wrote: I'm new to SQLITE.