simdatabase

Installing

Just installing module

$ npm install simple-databse

Quick start

Creating file with

import { SimpleDatabase } from 'simple-database'
const simd = new SimpleDatabase('example.simd')

Adding table columns

simd.addColumn('id', 'number', {
  unique: true
})

// or multi-adding columns

simd.addColumns([{
  name: 'name',
  type: 'string',
  default: 'No Name',
  unique: true
}, {
  name: 'suranme',
  type: 'string',
  unique: true
}])

Insert, update and delete data from table

// inserting into table
simd.insert({
  id: 12345,
  name: 'Kio',
  surname: 'gia'
})

// updating columns where "id" == 12345
simd.update({
  surname: 'Gia'
}, {
  column: 'id',
  operand: 12345
}) 

// delete columns where "name" != Kio
simd.delete({
  column: 'name',
  operator: '!=',
  operand: 'Kio'
})

Getting data

// selecting rows where "name" == Kio
simd.select({
  column: 'name',
  operand: 'Kio'
})
// returns [] 

// or selecting rows where unique column "id" == 12345
simd.selectByUnique({
  column: 'id',
  operand: 12345
})
// returns {} or undefined

// forEach loop 
simd.forEach((row, rowIndex, rows) => {
  // some operation
})

// or select all rows 
simd.getAll
// returns []

Classes

SimpleDatabase

Soon...

Visualizer

Soon...