# Sequential Numbers for Database ID

**URL:** <https://discourse.nodered.org/t/sequential-numbers-for-database-id/8360>\
**Category:** General\
**Created:** [25 February 2019 10:48 UTC](https://discourse.nodered.org/t/sequential-numbers-for-database-id/8360 "2019-02-25T10:48:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stylo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/stylo/32/14221_2.png) [@Stylo](https://discourse.nodered.org/u/Stylo)\
**Post date:** [25 February 2019 10:48 UTC](https://discourse.nodered.org/t/sequential-numbers-for-database-id/8360/1 "2019-02-25T10:48:12Z")

</div>

Hi there,

I'm currently working on a node-red project in which I'm displaying data from an SQLite database. For various tables, I want to have a unique ID for each entry. Is there a way to incorporate a sequential number generator into the function that'll be pulling the data from the database?

Thanks.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [25 February 2019 11:39 UTC](https://discourse.nodered.org/t/sequential-numbers-for-database-id/8360/2 "2019-02-25T11:39:58Z")

</div>

In the sqlite docs lookup autoincrement, or google it.