# Node-red-node-sqlite: possible to set db file in input msg?

**URL:** https://discourse.nodered.org/t/node-red-node-sqlite-possible-to-set-db-file-in-input-msg/14079
**Category:** General
**Created:** [7 August 2019 04:20 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-possible-to-set-db-file-in-input-msg/14079 "2019-08-07T04:20:31Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![thatcadguy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/thatcadguy/32/5273_2.png) [@thatcadguy](https://discourse.nodered.org/u/thatcadguy)
#### Post date: [7 August 2019 04:20 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-possible-to-set-db-file-in-input-msg/14079/1 "2019-08-07T04:20:31Z")

</div>

Is it possible to set the database file dynamically using a property in the input message? The directory holding my SQLite database may change.

---

<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: [7 August 2019 07:49 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-possible-to-set-db-file-in-input-msg/14079/2 "2019-08-07T07:49:19Z")

</div>

I do not think that is possible.

---

<div class="post-metadata">

### Author: ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)
#### Post date: [7 August 2019 08:05 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-possible-to-set-db-file-in-input-msg/14079/3 "2019-08-07T08:05:27Z")

</div>

Depends which of the sqlite nodes you are using.  
If you search on [flows.nodered.org](http://flows.nodered.org) you will find  
[https://flows.nodered.org/node/node-red-contrib-queued-sqlite](https://flows.nodered.org/node/node-red-contrib-queued-sqlite)  
which would appear from the README to do what you want.

---

<div class="post-metadata">

### Author: ![thatcadguy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/thatcadguy/32/5273_2.png) [@thatcadguy](https://discourse.nodered.org/u/thatcadguy)
#### Post date: [7 August 2019 14:55 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-possible-to-set-db-file-in-input-msg/14079/4 "2019-08-07T14:55:19Z")

</div>

Thanks @Colin and @ukmoose, think I'll just stick to the original though. Not having a lot of faith in 3rd party nodes these days.
