Starting with SQLite

The recommended package for working with SQLite is sqlite3 , the big drawback is that it's based on callbacks and not on promises, which makes the code more difficult to maintain if you do nested queries. On top, members are not interested in using promises in future releases. However, there is a package created by the well-known Koistya , sqlite which is nothing more than an ES6 + wrapper for sqlite3. Another that I personally use a lot is sequelize , but this is an ORM and is meant for medium / large applications.

  

The API is the same as sqlite3 but instead of callbacks, you must use promises

The first thing you should do is create a table for the users:

  

Note: If you use Node v7.x or Babel, you can benefit from async / await:    const expectedResult = await methodThatReturnPromise();

Connect to SQLite

import db fron 'sqlite';


db.open('estadisticas.db')
  .then(() => {
    console.log('SQLite connected');
  })
  .catch(e => {
    console.log('Cannot connect to SQLite');
    console.log(e);
  });

Queries in SQLite

Queries are in ordinary SQL. For example:

Create a user:

function createUser ({
  uid, username, points, money, level,
  rep, color, time, timerep, timemoney
}) {
  const sql = 'INSERT INTO users (uid, username, points, money' +
              ', level, rep, color, time, timerep, timemoney) ';
  sql += 'VALUES (${uid}, ${username}, ${points}, ${money}, ${level},
         ${rep}, ${color}, ${time}, ${timerep}, ${timemoney})';

  return db.run(sql);
}

createUser({ uid: 'dfudif3', username: 'johndoe', ...)
  .then(() => {
    console.log('Usuario creado');
  })
  .catch(e => {
    console.log('No se pudo crear el usuario: ${e.message}');
  });

The logic you have implemented should not change much, just adapt it to SQL queries.

First of all, your question is very wide, but I will try to help ... First of all it's almost the same as what you do in your json that I guess you use MongoDb but with sql commands.

First you must install the library of sqlite3 with npm, I leave you the link of the official documentation.

https://github.com/mapbox/node-sqlite3

Then

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(':memory:');

db.serialize(function() {
  db.run("CREATE TABLE lorem (info TEXT)");

  var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
  for (var i = 0; i < 10; i++) {
stmt.run("Ipsum " + i);
  }
  stmt.finalize();

  db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
console.log(row.id + ": " + row.info);
  });
});

db.close();

You use it like this, you initialize the libraries, you use db run Create to create the db

And you use INSERT to insert, UPDATE to update the data and DELETE to eliminate them, aaah and SELECT to search for them, it's the same as you have, only you have to save them with sql .

Finally, do not forget to close the db with db.close() after each use.

Greetings

Edition:

Here is an example

var db = new sqlite3.Database(ruta);
db.each("SELECT _id AS _id,huellac FROM personal WHERE _id = $useraux", {
$useraux: id
  },
  function(err, row) {
huellac = row.huellac; //esto es si encuentra uno
  },
  function(err, rows) {
if (rows != 0) { //al terminar la busqueda si no encuentra nada
  insertarBd();
};
  });

function insertarBd() {
  var insertar = db.prepare("INSERT INTO personal VALUES (?,?,?,?,?,?,?,?,?,?,?)");
  insertar.run(id, fechaact, nombre, apellido, cedula, fechanac, subempresa, dpto, acceso, habkyb, huellac);
  insertar.finalize();
}

In the example you can see that I do a search by id , you can do it by the field you want, if it finds a record it is marked there that I show it by console, if not at the end, rows is 0 already that does not find anything and therefore I do a INSERT of the data (I in the example insert data of an employee).

Greetings