Locale database + node.js

Navigation
2

I'm working on a project using node.js.

I need to use a local database, but I wanted to reconcile performance with security, and if possible, portability as well.

I only know MS Access (.accdb) and Sqlite3. 

[MS ACCESS]

Prós:       Senha
Contras:    Lento, Tem que instalar o Microsoft JET (pois com ODBC é mais lento ainda)
Plataforma: Windows

[SQLITE3]

Prós:       Rápido, Não precisa instalar nada (o node.js suporta por padrão)
Contras:    Não tem como colocar senha
Plataforma: Várias
OBS: Poderia criptografar os dados, mas um SELECT com 5 mil dados demoraria um pouco
     pra descriptografar cada campo dos registros.

Does anyone know of any other local database that I can use, and if possible do not need to install anything on the computer (at most one module on node.js), and that works at least on Windows and Linux?

I saw Firebird in the benchmark it was very fast, but I did not understand if it is local, because I saw an example that is the path of the file, but it also had an IP. Could anyone talk more about it?

Thank you.

    
asked by anonymous 13.11.2015 / 20:08

1 answer

1

There are many options for your need.

Check out this library TaffyDb ,

  

an opensouce library that brings database resources to your   applications.

Features:

  

Small file size, extremely fast JavaScript queries   powerful database selection engine Centric inspired features   such as counting, updating, and inserting   Robust browser Easily extended with its own functions   Compatible with any DOM library (jQuery, YUI, Dojo, etc.)   Compatible with Server Side JS

Another Alternative

These days I discovered an interesting feature, called DIVSHOT , a html5 hosting platform, which was just bought by google to integrate with another technology called FireBase , tailored for developer performance and productivity.

Check out the features above and see if it fits your needs.

    
13.11.2015 / 20:34
How to detect which js file is being used by the class of an element? DataTable create and populate table dynamically with server-side pagination