jSQL is a locally instantiated database for Node.js. It provides the functionalities of a database, unique to a single project, meaning that no configuration from one project will affect another one.
To install jSQL, paste the following command into the terminal at your Node.js project's root folder.
npm install --save DenDen747/jSQL
The full documentation can be found here.
The OR condition selects everything in the table. It doesn't work with broken parameters or layered parameters.
const condition = {
"/": {
"password": [ [ "pass1" ], [ true ] ],
"username": [ [ "user2" ], [ true ] ]
}
}
[
{ email: '[email protected]', username: 'admin', password: 'pass1' },
{ email: '[email protected]', username: 'user2', password: 'pass2' }
]
[
{ email: '[email protected]', username: 'admin', password: 'pass1' },
{ email: '[email protected]', username: 'user2', password: 'pass2' },
{ email: '[email protected]', username: 'user3', password: 'pass3' }
]
Currently, any client that connects can modify the server-config schema.
Only the server should be able to modify it, or no one at all; it could only be changed manually.
enhancementClients can use any username to connect from any network.
There should be a "connect" field for each user in server-config to specify what IP addresses users can connect from.
If the database folder is /database, there should be a query.log file. In the log file, there should be every executed statement attached to an ID. The ID is the result of the statement being executed.
There should also be another folder, /database/backup. In here, there should be folders titled with the according ID in the log file, containing the backups.
The Issue was, that in the parse function, internalDel was initially declared as true. This should be condition independent and was change to be declared as false when under an OR operator and true under and AND operator.
server-config schema anymore; only the server can.connect field for each database userEach user has a connect field, which can be filled with the IP addresses that you want that user to be able to connect from. By default, root has "'localhost'". To allow multiple IP addresses, the following can be used: "'localhost', '64.233.160.0', '66.102.0.0'". "'%'" can be used to allow a connection using that user from any IP address.
View the full documentation here.
Source code(tar.gz)See the servers documentation for more details.
Source code(tar.gz)If a multidimensional object is to be referenced, use a "." to separate the layers.
{
"details.email": [ [ "[email protected]" ], [ true ] ]
}
Columns/keys can no longer have "." in their name, as the period is reserved for multidimensional object referencing.
The full documentation can be viewed here.
The only difference between 1.3.0 and 1.3.1 is that 1.3.1 has better formatted code.
Source code(tar.gz)If a multidimensional object is to be referenced, use a "." to separate the layers.
{
"details.email": [ [ "[email protected]" ], [ true ] ]
}
Columns/keys can no longer have "." in their name, as the period is reserved for multidimensional object referencing.
The full documentation can be viewed here.
Source code(tar.gz)An optional boolean can be bassed in the Database constructor which turns backup on. When backup is on, every time a query is executed, it is logged in a query.log file in the database. Each log has an ID attached. It also creates a backups folder in the database if it doesn't exist, and puts the backup of the database excluding all directories and files named query.log in the backups folder with the according ID. The backup corresponding to the ID in the query.log file is saved as what the database looked like before the statement got executed. A database with backup on can be declared like this:
const jSQL = require("jsql");
const database = new jSQL.Database(__dirname + "/database", true);
The full documentation for initializing a database can be viewed here.
Source code(tar.gz)View new syntax here.
Source code(tar.gz)This is the base release of jSQL. Future updates will be built upon this release.
View the documentation here.
Source code(tar.gz)DolphinDB JavaScript API English | 中文 Overview DolphinDB JavaScript API is a JavaScript library that encapsulates the ability to operate the DolphinDB
Lowdb Small JSON database for Node, Electron and the browser. Powered by Lodash. ⚡ db.get('posts') .push({ id: 1, title: 'lowdb is awesome'}) .wri
PostGraphile Instant lightning-fast GraphQL API backed primarily by your PostgreSQL database. Highly customisable and extensible thanks to incredibly
Please use version 1.x as prior versions has a security flaw if you use user generated data to concat your SQL strings instead of providing them as a
The JavaScript Database Embedded persistent or in memory database for Node.js, nw.js, Electron and browsers, 100% JavaScript, no binary dependency. AP
Aerospike Node.js Client An Aerospike add-on module for Node.js. The client is compatible with Node.js v8.x, v10.x (LTS), v12.x (LTS), and v14.x (LTS)
database-js Wrapper for multiple databases with a JDBC-like connection Database-js implements a common, promise-based interface for SQL database acces
concisedb English | 简体中文 A database library stores JSON file for Node.js. Here is what updated every version if you want to know. API Document Usage B
考拉的 Nest 实战学习系列 readme 中有很多要说的，今天刚开源还没来及更新，晚些慢慢写，其实本人最近半年多没怎么写后端代码，主要在做低代码和中台么内容，操作的也不是原生数据库而是元数据Meta，文中的原生数据库操作也当作复习下，数据库的操作为了同时适合前端和Node开发小伙伴，所以并不是很
RefQL A Node.js library for retrieving data from a PostgreSQL database with an interesting query language included. Introduction RefQL is about retrie
RxDB A realtime Database for JavaScript Applications RxDB (short for Reactive Database) is a NoSQL-database for JavaScript Applications like Websites,
PouchDB – The Database that Syncs! PouchDB is an open-source JavaScript database inspired by Apache CouchDB that is designed to run well within the br
A reactive database framework Build powerful React and React Native apps that scale from hundreds to tens of thousands of records and remain fast ⚡️ W
Lovefield Lovefield is a relational database written in pure JavaScript. It provides SQL-like syntax and works cross-browser (currently supporting Chr
Realm is a mobile database that runs directly inside phones, tablets or wearables. This project hosts the JavaScript versions of Realm. Currently we s
Xmysql : One command to generate REST APIs for any MySql database Why this ? Generating REST APIs for a MySql database which does not follow conventio
This README is for [email protected]. For [email protected], see the 1.x-beta branch. To upgrade, see the upgrade guide. ShareDB ShareDB is a realtime databa
JavaScript Database (JSDB) A zero-dependency, transparent, in-memory, streaming write-on-update JavaScript database for the Small Web that persists to
SwarmDB ABOUT SWARMDB Bluzelle brings together the sharing economy and token economy. Bluzelle enables people to rent out their computer storage space
6 Dec 12, 2022
18.9k Dec 30, 2022
11.7k Jan 4, 2023
6.1k Jan 9, 2023
13.2k Jan 2, 2023
198 Dec 30, 2022
57 Dec 3, 2022
3 Sep 4, 2022
148 Dec 22, 2022
7 Nov 2, 2022
18.6k Dec 31, 2022
15.4k Dec 30, 2022
8.8k Jan 5, 2023
6.8k Jan 3, 2023
5.1k Jan 3, 2023
129 Dec 30, 2022
5.5k Dec 29, 2022
237 Nov 13, 2022
225 Dec 31, 2022