# Not possible to use sqlite3 locally with node-red-node-sqlite anymore?
**URL:** https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318
**Category:** General
**Created:** [15 October 2020 18:51 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318 "2020-10-15T18:51:41Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@moarli](https://discourse.nodered.org/u/moarli)
#### Post date: [15 October 2020 18:51 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/1 "2020-10-15T18:51:41Z")
Do I really have to use [https://www.sqlitedb.com/](https://www.sqlitedb.com/) to use node-red-node-sqlite? I've found a lot of tutorials and it seems like everyone is using a local instance of sqlite3, but I just can't add a local database. It asks me for API URL and API KEY instead. Description in node-red also says I need an account. Is the local version deprecated?
Thnx for your help.
---
### Author:  [@knolleary](https://discourse.nodered.org/u/knolleary)
#### Post date: [15 October 2020 19:10 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/2 "2020-10-15T19:10:14Z")
Hi @moarli, welcome to the forum.
The node provided by node-red-node-sqlite is designed to work with local sqlite database files - it doesn't do anything with a cloud service. So I'm not sure what is asking you for an API URL and KEY, but it certainly isn't the node from node-red-node-sqlite.
---
### Author:  [@moarli](https://discourse.nodered.org/u/moarli)
#### Post date: [15 October 2020 19:19 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/3 "2020-10-15T19:19:45Z")
Thnx for the quick reply @knolleary. Here are some screenshots. 1. I got this when I configure the node
 2. And this if I try to add a new db 
---
### Author:  [@knolleary](https://discourse.nodered.org/u/knolleary)
#### Post date: [15 October 2020 19:21 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/4 "2020-10-15T19:21:19Z")
That is not node-red-node-sqlite.
If you open up the palette manager, can you check exactly which sqlite node you have installed?
---
### Author:  [@moarli](https://discourse.nodered.org/u/moarli)
#### Post date: [15 October 2020 19:32 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/5 "2020-10-15T19:32:22Z")
---
### Author:  [@moarli](https://discourse.nodered.org/u/moarli)
#### Post date: [15 October 2020 19:33 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/6 "2020-10-15T19:33:49Z")
I just achieved to use the local db with a dirty hack: I edited the flow.json from the node-red folder after importing a flow from a community member and changed the db name from the config node.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [15 October 2020 19:38 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/7 "2020-10-15T19:38:28Z")
Have you had another sqlite node installed? If so have you uninstalled it and have you restarted node-red after you removed it?
---
### Author:  [@moarli](https://discourse.nodered.org/u/moarli)
#### Post date: [15 October 2020 19:42 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/8 "2020-10-15T19:42:06Z")
OMG. You are right @Colin. I had node-red-contrib-sqlitedb installed. But I've removed and restarted node red after that. How do I get rid of that now completely?
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [15 October 2020 19:45 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/9 "2020-10-15T19:45:01Z")
Go to your .node-red folder and run
`npm list node-red-contrib-sqlitedb`
`npm list -g node-red-contrib-sqlitedb`
---
### Author:  [@moarli](https://discourse.nodered.org/u/moarli)
#### Post date: [15 October 2020 19:50 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/10 "2020-10-15T19:50:49Z")
OK. That's embarrassing: @Colin npm list showed "empty" twice. But a reboot did the job 🤦♂️ thnx for your effort!
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [15 October 2020 19:53 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/11 "2020-10-15T19:53:09Z")
Well that is very odd, I have no idea why a reboot would fix it when a node red restart didn't.
I wonder whether it could have been a browser caching issue, not sure exactly how though.
---
### Author:  [@moarli](https://discourse.nodered.org/u/moarli)
#### Post date: [15 October 2020 19:55 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/12 "2020-10-15T19:55:59Z")
Anyway, thnx @Colin @knolleary
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [29 October 2020 19:56 UTC](https://discourse.nodered.org/t/not-possible-to-use-sqlite3-locally-with-node-red-node-sqlite-anymore/34318/13 "2020-10-29T19:56:01Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.