Hello "CTE in SQLite" fans,
To get CTE in SQLite, I guess we must answer by the example the fears
expressed by Simon and Rsmith.
I propose the following method :
- unproven-demand :
==> publish on this mailing list external "CTE for SQLite"
implementations,
==> if there is demand :
. they should become popular and improve quickly,
. the number of implementations should grow.
- code size + performance increase fear :
==> from the external implementations :
. develop knowledge of the algorithm to implement in SQLite,
. implement it in a true SQLite 'fossil' branch, with those two
goals in mind.
Here is my first implementation in Python (very rough and unclean, please
apologize) :
http://nbviewer.ipython.org/github/stonebig/baresql/blob/master/examples/baresql_with_cte_code_included.ipynb
I encourage other "CTE in SQlite" fans to :
- create and publish theirs, from this first example,
- provide links to other existing ones,
- then to start 'CTE' SQlite patches in Fossil.
Regards,
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
