Back to General discussions forum
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!
UPDATE ... FROM
now works nicely (it's similar to Oracle's MERGE INTO
), and the code looks cleaner this way.
Many thanks for this!