SQLite updated to most recent 3-38 version

Back to General discussions forum

Rodion (admin)     2022-03-11 22:49:41
User avatar

Hi Friends!

Dropping this note as separate topic since it was asked on several occasions. We previously had quite outdated version of SQLite (for sql problems) on server-side, like 3.16 (from five years ago or so) - since it was the version available on the hosting.

At last I managed to compile latest stable version 3.38 (allowing update ... from for example) and store it at some 3rd party server (since hosting won't allow running compiled code).

It surprisingly seems to work less or more well :)

Please feel free to examine it and tell if you find anything wrong. It may behave bit differently and be broken at some of tasks (but hopefully I updated everything properly).

(also please be so kind to suggest sql-related problems if you remember some or encounter at interview, your work etc)

Sorry for it take so long, thanks for your patience!

gardengnome     2022-03-11 23:57:08
User avatar

UPDATE ... FROM now works nicely (it's similar to Oracle's MERGE INTO), and the code looks cleaner this way. Many thanks for this!

Please login and solve 5 problems to be able to post at forum