firestorm-db

firestorm-db

Self hosted Firestore-like database with API endpoints based on micro bulk operations

Installation

npm install --save firestorm-db

JavaScript Part

The JavaScript index.js file is Just an axios wrapper of the library.

How to use it

First you need to configure the address of the API and your token if needed :

require('dotenv').config() // add some env variables
const firestorm = require('firestorm-db')

// ex: 'http://example.com/path/to/firestorm/root/'
firestorm.address(process.env.FIRESTORM_URL)

// only necessary if you want to write or access private collections
// must match token stored in tokens.php file
firestorm.token(process.env.FIRESTORM_TOKEN)

Now you can use it to its full potential:

const firestorm = require('firestorm-db')

// returns a Collection instance
const userCollection = firestorm.collection('users')

// all methods return promises
userCollection.read_raw()
.then(res => console.log(res))
.catch(err => console.error(err))

Collection contructor

Collection takes 1 argument and one optional argument :

• The name of the collection as a String
• The method adder which allows to inject methods to the get methods results, which is a Function taking the element as an argument

const firestorm = require('firestorm-db')

// returns a Collection instance
const userCollection = firestorm.collection('users', el => {
  el.hello = function() {
    console.log(`${el.name} says hello!`)
  }
})

// if you have a 'users' table with a printable field named name
const johnDoe = await userCollection.get(123456789)
// gives { name: "John Doe", hello: function}

johnDoe.hello() // prints out "John Doe says hello!"

Available methods for a collection:

Read operations

Name	Parameters	Description
sha1()	none	Returns the file sha1 hash, may vary from read_raw because read_raw adds ID fields to the entries. Compare with stringify version of your file.
read_raw()	none	Reads the entire collection
get(id)	id: String|Name	Tries to get one element by its key
search(searchOptions, random)	searchOptions: SearchOption[] random?:false|true|Number	Searches collections and returns matching results. You can randomize the ouput order with random as true or a given seed.
searchKeys(keys)	keys: String[] | Number[]	Searches collections with given keys and returns matching results
select(selectOption)	selectOption: { field: String[] }	Improved read_raw with field selection
random(max, seed, offset)	max?: Integer >= -1 seed?: Integer offset?:Integer >= 0	Reads random entries of collection

Search method can take one or more options to filter entries in a collection. A search option studies a field with a criteria and compares it to a value. On string values you can now use the boolean ignoreCase option.

Not all criterias are available depending the field type. There a more options available than the firestore where command allowing you to get better and faster search results.

All search options available

Criteria	Types allowed	Description
'!='	Boolean, Number, String	Searches if the entry field's value is different from yours
'=='	Boolean, Number, String	Searches if the entry field's value is equal to yours
'>='	Number, String	Searches if the entry field's value is greater or equal than yours
'<='	Number, String	Searches if the entry field's value is equal to than yours
'>'	Number, String	Searches if the entry field's value is greater than yours
'<'	Number, String	Searches if the entry field's value is lower than yours
'in'	Number, String	Searches if the entry field's value is in the array of values you gave
'includes'	String	Searches if the entry field's value includes your substring
'startsWith'	String	Searches if the entry field's value starts with your substring
'endsWith'	String	Searches if the entry field's value ends with your substring
'array-contains'	Array	Searches if the entry field's array contains your value
'array-contains-any'	Array	Searches if the entry field's array ends contains your one value of more inside your values array
'array-length-eq'	Number	Searches if the entry field's array size is equal to your value
'array-length-df'	Number	Searches if the entry field's array size is different from your value
'array-length-lt'	Number	Searches if the entry field's array size is lower than your value
'array-length-gt'	Number	Searches if the entry field's array size is lower greater than your value
'array-length-le'	Number	Searches if the entry field's array size is lower or equal to your value
'array-length-ge'	Number	Searches if the entry field's array size is greater or equal to your value

Write operations

Name	Parameters	Description
writes_raw()	none	Writes the entire collection /!\ Very dangerous /!\
add(value)	value: Object	Adds one element with autoKey into the collection
addBulk(values)	value: Object[]	Adds multiple elements with autoKey into the collection
remove(key)	key: String|Name	Remove one element from the collection with the corresponding key
removeBulk(keys)	keys: String[]|Name[]	Remove multiple elements from the collection with the corresponding keys
set(key, value)	key: String|Name, value: Object	Sets one element with its key and value into the collection
setBulk(keys, values)	keys: String[]|Name[], values: Object[]	Sets multiple elements with their corresponding keys and values into the collectionn
editField(obj)	obj: EditObject	Changes one field of a given element in a collection
editFieldBulk(objArray)	objArray: EditObject[]	Changes one field per element in a collection

Edit field operations

Edit objects have and id to get the wanted element, the field they want to edit, an operation, with what to do to this field, and a possible value. Here is a list of operations:

Operation	Value required	Types allowed	Description
set	Yes	any	Sets a field to a given value
remove	No	any	Removes a field from the element
append	Yes	String	Appends string at the end of the string field
invert	No	any	Inverts tate of boolean field
increment	No	Number	Adds a number to the field, default is 1
decrement	No	Number	Retrieves a number to the field, default is -1
array-push	Yes	any	Push an element to the end of an array field
array-delete	Yes	Integer	Removes and element at a certain index in an array field, check array_splice documentation offset for more infos
array-splice	Yes	[Integer, Integer]	Remvoes certains elements, check array_splice documentation offset and length for more infos

PHP files

The PHP files are the ones handling files, read and writes. It also handles GET and POST request to manipulate the database.

PHP setup

The developer has to create 2 files at root of this folder: tokens.php and config.php

tokens.php will contain the tokens inside a $db_tokens value array with the tokens to use. You will use these tokens to write data or read private tables.

config.php stores all of your collections config. You will create a $database_list variable with an array of JSONDatabase instances

<?php
// config.php
require_once('./classes/JSONDatabase.php');

$database_list = array();

$tmp = new JSONDatabase;
$tmp->folderPath = './files/';
$tmp->fileName = 'users';
$tmp->autoKey = false;

$database_list[$tmp->fileName] = $tmp;

$tmp = new JSONDatabase;
$tmp->folderPath = './files/';
$tmp->fileName = 'paths';
$tmp->autoKey = true;

$database_list[$tmp->fileName] = $tmp;
?>

Database will be stored in <foldePath>/<filename>.json and autoKey allows or forbids some write operations.

Files feature

Files API function are detailed in the files.php PHP script. If you do not want to include this functionnality, then just delete this file.

In you have to add 2 new configuration variables to your config.php file:

// whitelist of correct extensions
$authorized_file_extension = array('.txt', '.png');

// subfolder of uploads location, must start with dirname($_SERVER['SCRIPT_FILENAME'])
// to force a subfolder of firestorm installation
$STORAGE_LOCATION = dirname($_SERVER['SCRIPT_FILENAME']) . '/uploads/';

You can now use the wrapper functions in order to upload, get and delete a file. If the folder is accessible from server url, you can directly type its address.

Upload a file

In order to upload a file, you have to give the function a FormData object. This class is generated from forms and is native in modern browsers but in node.js can be imported with form-data package.

File content can be a String, a Blob or an ArrayBuffer.

You have an overwrite option in order to avoid big mistakes or allow user with unique file names.

const firestorm = require('firestorm-db')
firestorm.address('ADRESS_VALUE')
firestorm.token('TOKEN_VALUE')

const form = new FormData()
form.append('path', '/quote.txt')
form.append('file', 'but your kids are gonna love it.', 'quote.txt')
form.append('overwrite', false) // override optional argument (defaults to false)
const uploadPromise = firestorm.files.upload(form)

uploadPromise.then(() => {
  console.log('Upload successful')
})
.catch(err => {
  consoler.error(err)
})

Get a file

You can get a file via its direct file URL location or its content with a request

const firestorm = require('firestorm-db')
firestorm.address('ADRESS_VALUE')

const getPromise = firestorm.files.get('/quote.txt')

getPromise.then(filecontent => {
  console.log(filecontent) // 'but your kids are gonna love it.
})
.catch(err => {
  console.error(err)
})

Delete a file

Because I am a nice guy, I thought about deletion too. So I figured I would put a method to delete the files too.

const firestorm = require('firestorm-db')
firestorm.address('ADRESS_VALUE')
firestorm.token('TOKEN_VALUE')

const deletePromise = firestorm.files.delete('/quote.txt")

deletePromise.then(() => {
  console.log('File successfully deleted')
})
.catch(err => {
  console.error(err)
})

Memory warning

Handling big collections can cause memory allocation issues like :

Fatal error: 
Allowed memory size of 134217728 bytes exhausted (tried to allocate 32360168 bytes)

If you encounter a memory allocation issue, you have to allow more memory through this file /etc/php/7.4/apache2/php.ini with a bigger value here:

memory_limit = 256M

API endpoints

All JS methods correspond in fact to axios request. Read requests are GET request when write requests are POST requests with a JSON data.

You always have the same first keys and the one key per method:

{
  "collection": "<collectionName>",
  "token": "<writeTokenIfNecessary>",
  "command": "<methodName>",
  ...
}