The current version included in SQLITE is almost three years old - 2013-12-06 (3.8.2). There have been quite a few enhancements...
Released
Keep up with SQLITE updates
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+1- Contributor
Some thoughts and rational on this topic....below is a reference to the current select syntax tree where you can see WITH and CTE stuff that was added after 3.8.2. I'm no expert on CTE (basic intro below); but can see the power of having the ability to define materialized (intermediate) tables within the same select statement; A very powerful feature to add the FME workflows using InlineQuery. In my own workflows I have started to utilize sql lite files as a better intermediate (ODS of sorts) that kind of replaces what in the past we used .ffs files for since it allows dataset iteration through WHERE clause and Joiner.
We all know how integral sqlite is to mobile/embedded development (see reference below) so it would be nice to be able to replicate advanced queries used in application development inside of an FME workflow.
https://sqlite.org/syntax/select-stmt.html
https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-cte-basics/
https://github.com/yapstudios/YapDatabase/wiki/SQLite-version-(bundled-with-OS)
+24- Safer
Hi @bo, @rwhittington,
The latest betas of FME 2018 have been updated to SQLite 3.20.1.
+22- Safer
The idea here is a very good one and could never be "closed", but we've just upgraded to the second from top sqlite release. We'll work to stay atop this in the releases ahead. In the meantime, do let us know if you find the latest features useful.