Skip to main content
Question

SQLITE Version 3.8.3 and InlineQueryFactory

  • October 31, 2017
  • 4 replies
  • 28 views
rwhittington
Contributor
Forum|alt.badge.img+2

Hello Safers. Hope all is well.

Im wanting to use the InlineQuerier to do a WITH RECURSIVE select.

Trying to make a path from a tree stored in a relational model. Very much like this example: https://academy.vertabelo.com/blog/do-it-in-sql-recursive-tree-traversal/

Unfortunately I found that WITH support is not in version 3.8.2 of sqlite (which looks like what FMEs is using) WITH support was added with 3.8.3. Are there any plans to upgrade with future releases of FME? Or some way to patch it. Any other suggestions or workarounds? I guess I could write to a different database that supports WITH and read back. However, I was trying stay all with file based tables. Thanks in advance.

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.

4 replies

fmelizard
Safer
Forum|alt.badge.img+20
  • fmelizardSafer
  • Safer
  • 3719 replies
  • November 1, 2017

Hi @rwhittington, there is an existing idea to have better keep up with SQLite updates, please check out Keep Up with SQLITE Updates. I suggest you up-vote on the idea and if possible, add a comment regarding your use case (i.e.- to be able to use WITH in queries).

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • November 1, 2017

Can confirm that even FME 2018 Beta b18175 seems to be on SQLite version 3.8.2

bruceharold
Supporter
Forum|alt.badge.img+19
  • bruceharoldSupporter
  • Supporter
  • 349 replies
  • November 1, 2017
There is an idea post somewhere to support actual graph databases like Neo4j and Stardog, looking at the SQL statement to traverse a graph makes my brain hurt :-)

 

 

rwhittington
Contributor
Forum|alt.badge.img+2
  • rwhittingtonContributor
  • Author
  • Contributor
  • 14 replies
  • November 2, 2017

Thanks for the comments everyone. Yea @bruceharold any time I think of solution using recursion makes my head hurts as well. and yet there is a lot of hierarchical data stored in relational tables because sql is very fast. Oracle specific hierarchical queries help; if you are on that platform. I like the power that the InlineQuerier (sqlite cache) provides for constructing complex relationships in a workflow. I'm sure we could solve this with lists and/or adjacent features which also make my head hurt. The Aggregator can construct hierarchies for geometry with parent/child ids so I might try creating some dummy geometry to see if that approach is easier. Thanks and good eve from Texas.

Community Stats

32,090
Posts
121,871
Replies
39,731
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.