Software-update: SQLite 3.25.3

SQLite is een in C ontwikkeld databasesysteem dat als database voor onder meer websites en embedded applicaties is te gebruiken. Volgens de ontwikkelaars heeft SQLite geen installatie en administratie nodig, ondersteunt het databases tot een omvang van twee terabyte en wordt een volledige database in één bestand opgeslagen. Verder ondersteunt het bijna de volledige SQL92-specificatie en is het eenvoudig via onder andere Tcl/Tk aan te sturen. De ontwikkelaar heeft versie 3.25.3 met de volgende lijst aanpassingen de deur uit gedaan:

SQLite Release 3.25.3

• Disallow the use of window functions in the recursive part of a CTE.
• Fix the behavior of typeof() and length() on virtual tables.
• Strengthen defenses against deliberately corrupted database files.
• Fix a problem in the query planner that results when a row-value expression is used with a PRIMARY KEY with redundant columns.
• Fix the query planner so that it works correctly for IS NOT NULL operators in the ON clause of a LEFT JOIN with the SQLITE_ENABLE_STAT4 compile-time option.

Version 3.25.2:

• Add the PRAGMA legacy_alter_table=ON command that causes the "ALTER TABLE RENAME" command to behave as it did in SQLite versions 3.24.0 and earlier: references to the renamed table inside the bodies of triggers and views are not updated. This new pragma provides a compatibility work around for older programs that expected the older, wonky behavior of ALTER TABLE RENAME.
• Fix a problem with the new window functions implementation that caused a malfunction when complicated expressions involving window functions were used inside of a view.
• Fixes for various other compiler warnings and minor problems associated with obscure configurations.

Version 3.25.1:

• Extra sanity checking added to ALTER TABLE in the 3.25.0 release sometimes raises a false-positive when the table being modified has a trigger that updates a virtual table. The false-positive caused the ALTER TABLE to rollback, thus leaving the schema unchanged.
• The fix in the 3.25.0 release for the endless-loop in the byte-code associated with the ORDER BY LIMIT optimization did not work for some queries involving window functions. An additional correction is required.

Version 3.25.0:

• Add support for window functions
• Enhancements the ALTER TABLE command:
  • Add support for renaming columns within a table using ALTER TABLE table RENAME COLUMN oldname TO newname.
  • Fix table rename feature so that it also updates references to the renamed table in triggers and views.
• Query optimizer improvements:
  • Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause.
  • The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, check to make sure there exist rows that match the columns to the right before continuing with the next IN value.
  • Use the transitive property to try to propagate constant values within the WHERE clause. For example, convert "a=99 AND b=a" into "a=99 AND b=99".
• Use a separate mutex on every inode in the unix VFS, rather than a single mutex shared among them all, for slightly better concurrency in multi-threaded environments.
• Enhance the PRAGMA integrity_check command for improved detection of problems on the page freelist.
• Output infinity as 1e999 in the ".dump" command of the command-line shell.
• Added the SQLITE_FCNTL_DATA_VERSION file-control.
• Added the Geopoly module

Bug fixes:

• The ORDER BY LIMIT optimization might have caused an infinite loop in the byte code of the prepared statement under very obscure circumstances, due to a confluence of minor defects in the query optimizer.
• On an UPSERT when the order of constraint checks is rearranged, ensure that the affinity transformations on the inserted content occur before any of the constraint checks.
• Avoid using a prepared statement for ".stats on" command of the CLI after it has been closed by the ".eqp full" logicc.
• The LIKE optimization was generating incorrect byte-code and hence getting the wrong answer if the left-hand operand has numeric affinity and the right-hand-side pattern is '/%' or if the pattern begins with the ESCAPE character.

Versienummer	3.25.3
Releasestatus	Final
Besturingssystemen	Windows 7, Android, Linux, BSD, macOS, Solaris, UNIX, Windows Server 2008, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016
Website	SQLite 3.25.3
Download	https://www.sqlite.org/download.html
Licentietype	GPL

Reacties (3)

Nooit verder bij stilgestaan dat dit best eens interessant zou kunnen zijn en altijd standaard MySQL gebruikt voor mijn interactieve websites.
Dan iemand mij in zeer korte tekst aangeven of SQLite interessant is voor kleine websites met gemiddeld te bewaren data?
Thanks...

Ik heb er zelf geen ervaring met SQLite (behalve dat mijn browser, Firefox, het gebruikt voor het opslaan van history, bookmarks etc.) maar ik weet dat het Bolt CMS het als de default optie heeft zodat mensen voor een dynamische site niet direct een DB server hoeven te draaien.

Je zou bij Bolt eens kunnen kijken tot welk niveau zij SQLite aanraden.

Sqlite is eigenlijk prima bruikbaar op websites, in tegenstellling tot wat mensen soms denken. Dit is een goede samenvatting:
https://www.sqlite.org/whentouse.html