Re: [sqlite] Version 3.3.9
Good work Dr. R. Hipp! I agree with Jason Hawryluk that the temp-file location should be change-able with an option, e.g. compile-time define. Regards, Klemens Friedl - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Version 3.3.9
SQLite version 3.3.9 is now available from the SQLite website http://www.sqlite.org/ http://www.sqlite.org/download.html The more important change is a fix for an obscure bug that can lead to database corruption on multi-processor systems. Other important changes include the addition of the sqlite3_prepare_v2() API which new users should always use in place of the legacy sqlite3_prepare() API. A summary of the changes can be found at http://www.sqlite.org/changes.html A detailed listing of all changes can be found by consulting the CVSTrac timeline at http://www.sqlite.org/cvstrac/timeline There are a number of important changes to winCE and win95 support. I have no ability to test these changes. I think they work. If not, I suppose I will be hearing about it very soon now. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Version 3.3.9
Looks it has got faster in my particular situation. Thanks for that. RBS SQLite version 3.3.9 is now available from the SQLite website http://www.sqlite.org/ http://www.sqlite.org/download.html The more important change is a fix for an obscure bug that can lead to database corruption on multi-processor systems. Other important changes include the addition of the sqlite3_prepare_v2() API which new users should always use in place of the legacy sqlite3_prepare() API. A summary of the changes can be found at http://www.sqlite.org/changes.html A detailed listing of all changes can be found by consulting the CVSTrac timeline at http://www.sqlite.org/cvstrac/timeline There are a number of important changes to winCE and win95 support. I have no ability to test these changes. I think they work. If not, I suppose I will be hearing about it very soon now. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Version 3.3.9
Congratulations D. Richard Hipp. Thank for give us SQLite On 04/01/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Looks it has got faster in my particular situation. Thanks for that. RBS SQLite version 3.3.9 is now available from the SQLite website http://www.sqlite.org/ http://www.sqlite.org/download.html The more important change is a fix for an obscure bug that can lead to database corruption on multi-processor systems. Other important changes include the addition of the sqlite3_prepare_v2() API which new users should always use in place of the legacy sqlite3_prepare() API. A summary of the changes can be found at http://www.sqlite.org/changes.html A detailed listing of all changes can be found by consulting the CVSTrac timeline at http://www.sqlite.org/cvstrac/timeline There are a number of important changes to winCE and win95 support. I have no ability to test these changes. I think they work. If not, I suppose I will be hearing about it very soon now. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.phpclasses.org/grank (A PHP implementation of PageRank)
Re: [sqlite] Version 3.3.9
[EMAIL PROTECTED] wrote: Looks it has got faster in my particular situation. There were a few minor enhancements to the optimizer, but nothing major. Perhaps one of those enhancements fell right where you needed it. I'm curious to know what your situation is. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Version 3.3.9
I'm curious to know what your situation is. I am doing commercial software that provides an Excel frontend (.xla with some VB6 ActiveX dll's) for a medical Interbase database. I am in the process of doing a major re-write, moving away from array manipulations and text file SQL to doing all the data manipulation in SQLite. On the whole this re-write will probably make my software slightly slower (difficult to beat the array work), but the benefit is in simplicity and therefor increased maintainability. The other great benefit is that it is much easier to see what is going on as all can be seen in the SQL, which is easy to log. So, I am doing some large datadumps from Interbase to SQLite and then lots of manipulations in SQLite to get the output in the right shape to finally dump to Excel. If you are interested then I can send you the SQL output of a typical report/search. RBS [EMAIL PROTECTED] wrote: Looks it has got faster in my particular situation. There were a few minor enhancements to the optimizer, but nothing major. Perhaps one of those enhancements fell right where you needed it. I'm curious to know what your situation is. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Version 3.3.9
Good work Dr. Hipp and thanks for Sqlite. One question comes to mind when looking at the changes implemented. In particular.. (VACUUM uses a temporary file in the official TEMP folder, not in the same directory as the original database) Would doing this not pose a problem when the process does not have proper access to the system/temp folder? For example a web site implementation, or a company that is very tight on security. IMHO this probably could have been implemented as an option. Keep in mind security is not my forte. Any thoughts, and are these correct assumptions? Thanks again for a wonderful product. Jason -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoyé : jeudi 4 janvier 2007 18:12 À : sqlite-users@sqlite.org Objet : [sqlite] Version 3.3.9 SQLite version 3.3.9 is now available from the SQLite website http://www.sqlite.org/ http://www.sqlite.org/download.html The more important change is a fix for an obscure bug that can lead to database corruption on multi-processor systems. Other important changes include the addition of the sqlite3_prepare_v2() API which new users should always use in place of the legacy sqlite3_prepare() API. A summary of the changes can be found at http://www.sqlite.org/changes.html A detailed listing of all changes can be found by consulting the CVSTrac timeline at http://www.sqlite.org/cvstrac/timeline There are a number of important changes to winCE and win95 support. I have no ability to test these changes. I think they work. If not, I suppose I will be hearing about it very soon now. -- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
