Ignition 8.1.2 appears to be using SQLite 3.23.1: [image] Window functions were added 2.5 years ago in version 3.25.0 . Is there a way to get access to these in Ignition? Perhaps another SQLite driver? Alternatively, how would one write a query to return a column plus a running total column withou…

[image] witman: I am still curious if there’s a way to get a newer version of SQLite in Ignition as it seems like a good solution for smaller amounts of data that is mostly static. Technically, you might be able to drop in a new sqlite JDBC driver (SQLite JDBC drivers are usually just pretty …

Ignition SQLite window functions & adding a running total column

Ignition

witman October 11, 2022, 8:04pm 4

Update: SQLite driver upgrade has arrived.

1 Like