I have a problem. I’m making an application for run over a Raspberry PI, I initially chose Mongo DB (I really like it!), but in a Raspberry PI this program is slow.
I was looking for a solution and I thought about SQLite. There’s a module maintained by Mapbox that you can find it here.
Let’s do a fast test:
express -e sqlite_express
Open package.json and add a line in dependences:
We’ll put dabase into a dir.
This is app.js code:
module.exports = app;</code></pre>
First we started database going to http://localhost:3000/data/start.
This is the template for view users (views/show.ejs):
This is a very simple sample but it’s a good start.