Skip to main content
Released

Keep up with SQLITE updates

Related products:FME Form
siennaatsafe
david_r
takashi
rwhittington
+3
  • siennaatsafe
    siennaatsafe
  • david_r
    david_r
  • takashi
    takashi
  • rwhittington
    rwhittington
  • crayxt
  • ekkischeffler
    ekkischeffler
  • bo
    bo
  • samuelvaldez

bo
Contributor
  • Contributor

The current version included in SQLITE is almost three years old - 2013-12-06 (3.8.2). There have been quite a few enhancements...

This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

6 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • August 6, 2016

Yikes. Didn't realize that. I'll check into this.


david_r
Evangelist
  • November 1, 2017

It seems even the latest 2018 Beta is using version 3.8.2...


rwhittington
Contributor
Forum|alt.badge.img+1
  • Contributor
  • November 1, 2017

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)


daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • December 22, 2017

Hi @bo, @rwhittington,

The latest betas of FME 2018 have been updated to SQLite 3.20.1.


fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • December 23, 2017
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.

 

 


david_r
Evangelist
  • January 3, 2018
Excellent, thanks!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings