FolderDB

Filesystem based database focused on lightweight data storage and easy data preview

Build using Bun on Debian, published to NPM.
(should work on windows and node too)

Table of contents

• Installation
• Documentation
• Basic usage
• Real world example
• Purpose

Installation

npm i @gambar/folder-db

import FolderDB, { CaseFormat } from '@gambar/folder-db';
// or
const FolderDB = require('@gambar/folder-db').default;
const { CaseFormat } = require('@gambar/folder-db').enums;

const db = new FolderDB({ dbPath: './db' });

Documentation

• Class
• Read
• Write

---

• Numbers
• Strings
• Arrays
• Objects

---

• General
• Time

---

• Enums

Basic usage

const FolderDB = require('@gambar/folder-db').default;
const db = new FolderDB({ dbPath: './db' });

//create a folder to store your users
db.createFolder("users");

//add new user
db.get("users").createFile("random_id_or_hash", { name: "GamBar" });

//update username of user
db.get("users")
  .get("random_id_or_hash")
  .get("name")
  .set("Gamriel");

//add a a new field to user
db.get("users.random_id_or_hash").set("job_title", "Software developer");

//add a timestamp
db.get('users.random_id_or_hash').setTimestamp('updated_at');

//read the user
const myUser = db.get('users.random_id_or_hash').data;
console.log(myUser);

Real world example

database.js

const FolderDB = require('@gambar/folder-db').default;

module.exports = new FolderDB({ dbPath: './db', mergeInstances: true });

Register

const hash = shortHash(req.body.email);

const userFile = await db.get('users').get(hash).data;
if (userFile) return res.status(409).json('User with this email already exists');

db.get('users').createFile(hash, {
  ...req.body,
  password: bcrypt.hashSync(req.body.password, 10),
});

res.cookie('jwt', createJWTCookie({ id: hash }), { httpOnly: true });
res.status(201).json();

Login

const hash = shortHash(req.body.email);

const userFile = await db.get('users').get(hash).data;
if (!userFile) return res.status(404).json('User with this email does not exist');

const validPassword = await bcrypt.compare(req.body.password, userFile.password);
if (!validPassword) return res.status(403).json('Incorrect password');

res.cookie('jwt', createJWTCookie({ id: hash }), { httpOnly: true });
res.status(200).json();

GET /User

const userFile = await db.get('users').get(req.authUser.id).data;
return res.status(200).json(userFile);

Purpose

I really like MongoDB, the document structure is great! But It needs a constantly running service, my projects don't need all that.
I really like SQLite, everything contained in one file is amazing! But SQL relations don't feel right to me, especially pivot tables.
Both need separate apps to visualize my data.

FolderDB is my solution to these problems im having, no services needed, no extra apps needed and its all locally stored.
Seeds and dumps can be easily done. It can be only local with .gitignore. And changes can be done fast trough the code editor.
Exactly what I need for my small applications.

This is not an enterprise solution of course, its a solution that will help me do my silly little websites/discord bots/projects.
Contributors are welcome, if you like the idea and want to imporve it with me, make a PR or even better - contact me and let's talk!

---

Thank you for checking out my project.

---