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 wrote: >> >> I'm new to

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

On Wed, Feb 10, 2010 at 11:08 PM, jflaming 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

[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] 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

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 > >

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

Re: [sqlite] Usage of vacuum and auto vacuum

On Wed, 10 Feb 2010 10:05:34 +0530, 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

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

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

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

[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

Re: [sqlite] Cloning a database to memory

Phil Hibbs 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

Re: [sqlite] String Vs Integer Index

On Wed, Feb 10, 2010 at 5:42 PM, Virgilio Fornazin 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

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

[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

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

[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] 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 >

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

[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 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

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

[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