On 12.11.2013 10:45, Sylvain Pointeau wrote:
The merge statement is really missing in sqlite...
Definitely it is missing ... for maybe 0.05% of the (advanced) SQLite
users :-). Much large group missing UPDATE and DELETE statements over
joins at first place.
Is there any plan to integrate this SQL 2003 syntax in sqlite?
Your question is already 36+ hours old. Because the SQLite[*] core team
(consisting of *3 developers* including the leading architect) is
usually very responsive when the subject is considered important (we
often have seen bugfixes and improvements done literally over the
night), the answer is obviously "No" - at least from the core team side.
But ... SQLite is very simple and smart architecture. Almost every part
is plugable and the interfaces between the moving parts are rigorously
documented.
http://www.sqlite.org/arch.html
For the MERGE RFE implementation you need just an extension of the SQL
frontend (first tier of the architecture) which translates SQL to the
simple and well evolved bytecode.
http://www.sqlite.org/opcode.html
sqlite3 :memory: 'explain select name from sqlite_master'
Actually SQLite is close to MERGE support in the sense that hypothetical
MERGE VDBE bytecode is relatively simple function of the bytecodes of
the three "elementary" statements which MERGE combines (insert, update,
delete).
Naturally, SQLite already generates MERGE "sub" statements bytecode for
every version of the engine. I.e. you have valid input to the bytecode
morphing transformation at hand.
So, if you are really like MERGE, and you are hacker with few dozens of
free hours - give it a go, many people here will (at least) follow with
interest your experiment.
If you are not - help the listening hackers (they are many here, but
believe me - 2 .. 5 max of them are regular MERGE users :-) ) to
understand the benefits of your RFE.
Cheers,
Alek
[*] The most used DB in the world
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
