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 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 >> and >> actually perform the change: >> >> update books set title = replace(title, '_', ' '); >> >> it fails with this error: >> Query Error: no such function: title_sort Unable to execute statement >> >> I'm sure I'm missing something simple here, but it's driving me crazy... >> any >> ideas? >> > > > One important thing you are missing is that you are not telling us how > you are selecting and updating. Are you using the command line, > another program, a programming language... and, which version of > sqlite on which platform? Works for me... this is what I get on my > Macbook > > SQLite version 3.6.19 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE books (title TEXT); > sqlite> INSERT INTO books VALUES ('a_book'); > sqlite> INSERT INTO books VALUES ('another_book'); > sqlite> SELECT * FROM books; > title > -- > a_book > another_bo > sqlite> SELECT Replace(title, '_', ' ') FROM books; > Replace(title, '_', ' ') > > a book > another book > sqlite> UPDATE books SET title = Replace(title, '_', ' '); > sqlite> SELECT * FROM books; > title > -- > a book > another bo > sqlite> > > > > -- > Puneet Kishor http://www.punkish.org > Carbon Model http://carbonmodel.org > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > --- > Assertions are politics; backing up assertions with evidence is science > === > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/very-simple-update-query-failure...-tp27542440p27542690.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 books; > > and see the output I'm looking for, but if I try to do an update query and > actually perform the change: > > update books set title = replace(title, '_', ' '); > > it fails with this error: > Query Error: no such function: title_sort Unable to execute statement > > I'm sure I'm missing something simple here, but it's driving me crazy... any > ideas? > One important thing you are missing is that you are not telling us how you are selecting and updating. Are you using the command line, another program, a programming language... and, which version of sqlite on which platform? Works for me... this is what I get on my Macbook SQLite version 3.6.19 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE books (title TEXT); sqlite> INSERT INTO books VALUES ('a_book'); sqlite> INSERT INTO books VALUES ('another_book'); sqlite> SELECT * FROM books; title -- a_book another_bo sqlite> SELECT Replace(title, '_', ' ') FROM books; Replace(title, '_', ' ') a book another book sqlite> UPDATE books SET title = Replace(title, '_', ' '); sqlite> SELECT * FROM books; title -- a book another bo sqlite> -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu --- Assertions are politics; backing up assertions with evidence is science === ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 and actually perform the change: update books set title = replace(title, '_', ' '); it fails with this error: Query Error: no such function: title_sort Unable to execute statement I'm sure I'm missing something simple here, but it's driving me crazy... any ideas? Jay -- View this message in context: http://old.nabble.com/very-simple-update-query-failure...-tp27542440p27542440.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 stored data and a BTree for primary keys, indexes etc. If you create a table with a "INTEGER PRIMARY KEY" as "CREATE TABLE" states you will end up wit only one table where the "INTEGER PRIMARY KEY" is the reference for your B+Tree where your Data resists. If you search for more columns than the primary key value you'll get a faster query because the engine won't need to look up references from your defined primary key to the rowid in a second Btree table but use the primary key directly as a reference to the B+Tree. The performance gain is not restricted only for select but also for update, delete, insert. You can measure this easily with a table where you define a primary key with "int primary key" (results in at least one b+tree and one btree) and the same table with "integer primary key" (results in one b+tree). The op asked for a performance difference using integer keys and string keys and for sqlite a "integer primary key" is the recommended solution due to implementation and documentation. It's clear that you'll loose this performance gain when you don't use the primary key to access your data but that's not what the op asked for as far as i understood his question. Ibrahim. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 substitutes the rowid column of a table. > > But that's true only if you're running a SELECT which actually uses > that column and only that column to do the searching. It is actually much, much more complex. It depends on what you're searching on, what you're searching for, what other columns you want, how the index is built, and about seven other things. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 1515 is never used > Page 1519 is never used > Page 1528 is never used > Page 1529 is never used > sqlite> > >The above DB can be recover by using VACUUM command. > > sqlite> vacuum; > sqlite> pragma integrity_check; > ok > sqlite> > >Presently PRAGMA auto_vacuum is disabled, and we are using as it is, > >Please give me you suggestions to over come this issue, > >will enabling PRAGMA auto_vacuum will solve the issue, Probably not. >OR any othet way...? In which version of SQLite does this happen? SELECT sqlite_version(); Check the timeline, there have been similar issues in the past. Perhaps you use an old version. http://www.sqlite.org/src/timeline Make sure you use one of the latest. >Thanks in advance. > >Regards, >Ramesh -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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" you'll find the right answer : 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. While another type of primary key always results in a second reference table (key ==> rowid) the integer primary key doesn't need a second index table. This results in a performance gain because the engine hasn't to look up the rowid in the index table to find the correct rowsets assigned to a primary key but looks directly in the data table. If you can't won't use a integer primary key as described in the documentation the performance difference between strings and numbers won't be a big deal not as long as your strings have a lenght between 1 and 10 characters cause the greatest part of the time needed to look up a key ==> rowid pair is spent with io operations to read the fileblocks. When your strings get longer you'll find, that string keys will get slower because the number of key ==> rowid pairs fitting in a btree decreases with the length of the entries. This will only matter if you get more levels of pages counted from the root page. As long as you result in the same height of btrees you won't measure a big performance loss due to the use of strings as primary keys when you don't use the "integer primary key" feature. The argument with Timing of assembler instructions would only matter if you use memory databases but even then you'll end up with "virtual memory paging" or "caching". If there are no reasons to avoid "INTEGER PRIMARY KEY" you'll have a real performance gain by using this feature !!! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 self-referential sigs? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 > > can be virtually unlimited in size). > > Yes, I know it should be faster.. I just would like to have an idea of > how fast to know how relevant is an indirection table (from string to > integer). > > But probably the best is to try and compare :P > > > > > On Wed, Feb 10, 2010 at 15:38, Simon Slavin > wrote: > > > >> > >> 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 fetching one record on these > tables? > >> > >> How are you fetching the record ? Do you have a SELECT command that > looks > >> up the record using a WHERE clause matching a key value ? Is there an > index > >> on the key column ? > >> > >> Simon. > >> ___ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Alberto Simões > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 should read Hence, the string '3.0e+5' is stored in a column with NUMERIC affinity as the integer 30, not as the floating point value 30.0. (the integer '3' should be '30'). ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 integer value is a > single CMP CPU instruction versus a more-complicated string comparison (that > can be virtually unlimited in size). Yes, I know it should be faster.. I just would like to have an idea of how fast to know how relevant is an indirection table (from string to integer). But probably the best is to try and compare :P > > On Wed, Feb 10, 2010 at 15:38, Simon Slavin wrote: > >> >> 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 fetching one record on these tables? >> >> How are you fetching the record ? Do you have a SELECT command that looks >> up the record using a WHERE clause matching a key value ? Is there an index >> on the key column ? >> >> Simon. >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Alberto Simões ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 can be virtually unlimited in size). On Wed, Feb 10, 2010 at 15:38, Simon Slavin wrote: > > 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 fetching one record on these tables? > > How are you fetching the record ? Do you have a SELECT command that looks > up the record using a WHERE clause matching a key value ? Is there an index > on the key column ? > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 fetching one record on these tables? How are you fetching the record ? Do you have a SELECT command that looks up the record using a WHERE clause matching a key value ? Is there an index on the key column ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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? Thanks -- Alberto Simões ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 > unlikely, but you have to take it into account. > > See also http://www.sqlite.org/c3ref/busy_timeout.html > > To answer your question: Yes, sqlite will insure sequestial write by > using its locking nechanism. If there are many write operations however, > the database will be locked often and other applications will be forced > to wait for longer and longer times, which can become unaccepable to the > people using you web application. > > Martin > > alexis_ wrote: >> 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 a day. Mostly in the morning around >> 08:30 and afternoon 17:00 >> >> Cheers >> Alexis >> >> >> Martin Engelschalk wrote: >> >>> 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 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 to integrate to third party product. Both PHP and Java will be accessing a SQLite db concurrently. SQLite, Java App and php will all be on one box. So my questing is should this setup work OK? Is there anything i should be aware off. Thank you for any help, pointers Alexis >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >>> > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/SQLite---IIS%2C-PHP-and-java-tp27530283p27531096.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 http://www.sqlite.org/c3ref/busy_timeout.html To answer your question: Yes, sqlite will insure sequestial write by using its locking nechanism. If there are many write operations however, the database will be locked often and other applications will be forced to wait for longer and longer times, which can become unaccepable to the people using you web application. Martin alexis_ wrote: > 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 a day. Mostly in the morning around > 08:30 and afternoon 17:00 > > Cheers > Alexis > > > Martin Engelschalk wrote: > >> 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 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 to integrate to third party product. >>> >>> Both PHP and Java will be accessing a SQLite db concurrently. SQLite, >>> Java >>> App and php will all be on one box. So my questing is should this setup >>> work >>> OK? Is there anything i should be aware off. >>> >>> Thank you for any help, pointers >>> >>> Alexis >>> >>> >>> >>> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 before February 14 you can purchase SQLite Code Factory as well as all other our products and bundles with a 20% discount. Happy Valentine's Day! New features = 1. Visual Query Builder has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs. 2. Data Export wizard has been significantly improved. Now you can export data to Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats and select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, Mac). Also the wizard has been completely redesigned to increase the usability. 3. Data Import wizard has been updated too. Now you can import data from Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats, import CSV and Text data files stored in different encodings, empty the target table as well as execute custom SQL scripts before and after import. This wizard also has been completely rewritten; moreover, the speed of the import process has been significantly increased. 4. Starting with this version it is possible to reorder servers in the Explorer Tree as well as reorder databases from the same server. You can also sort servers and databases in an alphabetical order. 5. Data grid: starting with this version it is possible to allow displaying row numbers in grids. Also we have added support for fixed columns. 6. Get SQL Dump: from now on you can specify output file encoding. 7. An Italian localization is now included into the installation package. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release is available at: http://www.sqlmaestro.com/news/company/code_factory_product_family_updated_to_version_10_2/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 a day. Mostly in the morning around 08:30 and afternoon 17:00 Cheers Alexis Martin Engelschalk wrote: > > 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 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 to integrate to third party product. >> >> Both PHP and Java will be accessing a SQLite db concurrently. SQLite, >> Java >> App and php will all be on one box. So my questing is should this setup >> work >> OK? Is there anything i should be aware off. >> >> Thank you for any help, pointers >> >> Alexis >> >> >> > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/SQLite---IIS%2C-PHP-and-java-tp27530283p27530753.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 to integrate to third party product. > > Both PHP and Java will be accessing a SQLite db concurrently. SQLite, Java > App and php will all be on one box. So my questing is should this setup work > OK? Is there anything i should be aware off. > > Thank you for any help, pointers > > Alexis > > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 to integrate to third party product. Both PHP and Java will be accessing a SQLite db concurrently. SQLite, Java App and php will all be on one box. So my questing is should this setup work OK? Is there anything i should be aware off. Thank you for any help, pointers Alexis -- View this message in context: http://old.nabble.com/SQLite---IIS%2C-PHP-and-java-tp27530283p27530283.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users