# Ignition SQLite window functions & adding a running total column

**URL:** <https://forum.inductiveautomation.com/t/ignition-sqlite-window-functions-adding-a-running-total-column/44919>\
**Category:** Ignition\
**Tags:** database, ignition80\
**Created:** [March 25, 2021, 6:39pm UTC](https://forum.inductiveautomation.com/t/ignition-sqlite-window-functions-adding-a-running-total-column/44919 "2021-03-25T18:39:32Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [October 11, 2022, 8:04pm UTC](https://forum.inductiveautomation.com/t/ignition-sqlite-window-functions-adding-a-running-total-column/44919/4 "2022-10-11T20:04:42Z")

</div>

Update: SQLite driver upgrade has arrived.

> [@Nightly 8.1 Changelogs - 2022](https://forum.inductiveautomation.com/t/nightly-8-1-changelogs-2022/54636/147):
>
> Weekly Changelog: 8.1.22-b20221010 Platform 6110: Attempts to remove old scheduled backups blocked by macOS sandboxing restrictions, results in NPE Added warnings to the Diagnostics Logs when the deletion of old backups (as part of Scheduled Backups) is prevented by Os restrictions. 2163: Upgrade SQLite JDBC driver Upgrade embedded SQLite and its JDBC driver to 3.39.2.0. Visualization 4236: Color Picker has clipping issues when alpha \< 255 Fixed issue with the clipping region improperly se…

---

_[View the full topic](https://forum.inductiveautomation.com/t/ignition-sqlite-window-functions-adding-a-running-total-column/44919)._