#Sqlite setup for local app

1 messages · Page 1 of 1 (latest)

fair glen
#

So. I'm building an app that the idea is like a data organisation app. I was previously gonna use just a json file but then yk... It's a bit of a pain to constantly fs update that

#

So asked around and got suggested sqlite.

#

I'm completly lost and can't exactly explain why this is confusing me but basically I just want a "package" / "module" to manage all my data in the same way as mongodb but locally

fair glen
#

Any help?

fluid ibex
#

obviously the queries will be in SQL & not MongoDB syntax

fair glen
#

No I know that.

#

But with setting up and all

#

Using this. https://www.npmjs.com/package/better-sqlite3

npm
better-sqlite3

The fastest and simplest library for SQLite3 in Node.js.. Latest version: 8.5.0, last published: 21 days ago. Start using better-sqlite3 in your project by running npm i better-sqlite3. There are 990 other projects in the npm registry using better-sqlite3.

#

Will it work even if my app crashes?

#

Will it setup upon every restart

#

Does it save it's own .db file in my dir/

fluid ibex
#
  1. if your app crashes, you probably need to restart anyway, refer to 2.
  2. it should setup on restart if you instantiate the db instance inside your main entry point
  3. probably, I'll have a look at the docs
#

not 100% sure where it will save the data, maybe set up a test project & test it

fair glen
#

Will have to do so

#

my whole like vision for this was for me to create a scheme for each “data set” I needed to record them to simply use sqlite to manage an add to that.

#

Don’t exactly know if that’s the whole idea behind it now tho

#

I’m quite lost

#

Will have to do testing haha