After the SQLite community, last month, released draft of what users can expect in the SQLite’s next release, the community finally announced the release of SQLite 3.25.0 yesterday.
The primary update, however, is that they have added a support for windows functions and have provided improvements in the query optimizer.
Let’s have a closer look at what the new features in this version are.
The August draft release had showcased fixes for two tickets. However, the final release has four ticket fixes including,
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.
For more details, visit SQLite 3.25.0 release log.
How to use SQLite with Ionic to store data?
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed…
Key takeaways The transformer architecture has proved to be revolutionary in outperforming the classical RNN…
Once we learn how to deploy an Ubuntu server, how to manage users, and how…
Key-takeaways: Clean code isn’t just a nice thing to have or a luxury in software projects; it's a necessity. If we…
While developing a web application, or setting dynamic pages and meta tags we need to deal with…
Software architecture is one of the most discussed topics in the software industry today, and…