1 unstable release

0.4.0 Feb 18, 2020

#89 in #mobile

GPL-3.0-only

115KB
2K SLoC

MSDB - Mobile Secure DataBase

msdb is a user-friendly, intuitive and standalone database. asciicast

Getting started

Prerequisites

  • rustc installed(building). Nightly channel is recomended, while stable channel should also work.

  • libsodium installed. MSDB relies on sodiumoxide, which is a rust binding for libsodium.

Compiling

cargo build --release

Running

Command line interface

./msdb will initiate a command line interface

Execute script file

./msdb -i SCRIPTNAME will execute commands inside the script

Simple user guide

Structure in one graph

structure

Commands reference

Both commands in the command script and commands in the cli follows the same structure:

COMMAND [COMMAND ARGUMENTS]

Each line in command script will be treated as a command.

Create database / Decrypt(Load) database / Exit / Logout

Only these commands can be executed without loading any database.

  • create DATABASENAME

    Create a database by specifying its name.

  • decrypt DATABASENAME

    Decrypt a database and load it into cache.

  • exit

    Drop everything inside cache and stop the database.

  • logout

    Similear to exit but the command line interface will not exit.

Create(Delete / Modify) Structure / Object / Cell

  • new struct STRUCTNAME

    Create a new structure

  • new OBJECTNAME

    Create a new object (Only work when you are inside a structure)

  • new CELLNAME CELLTYPE CELLCONTENT

    Create a new cell (Only work when you are inside a object)

    Available cell type & cell content:

    1. TYPE = literal; CONTENT = anything in utf-8

    2. TYPE = blob; CONTENT = any filename(file content will be written into database)

    3. TYPE = link; CONTENT = another cell's identifier / another field identifier/another cell's identifier / another structure identifier/another field identifier/another cell's identifier

    4. TYPE = revlink; CONTENT = same as link

  • alter CELLNAME CELLTYPE CELLCONTENT[WIP]

    Change cell content / cell type (Only work when you are inside a object)

  • del CELLNAME CELLTYPE CELLCONTENT

    Delete cell (Only work when you are inside a object)

  • del OBJECTNAME / STRUCTNAME

    Delete object / structure. Note that due to preformance issue, cells in object may not be deleted. If you are willing to sacrifice preformance to minify database storage, please use wipe.

  • wipe OBJECTNAME

    Delete object and every cell related

Select(deselect) Structure / Object / Cell

  • select STRUCTNAME/OBJECTNAME/CELLNAME

    select a structure/object/cell (It will select structure when you are inside database root, and select object if you are inside a structure, etc.)

  • leave

    deselect a structure/object/cell (deselect structure when inside structure, etc.)

Listing / Querying cells

  • ls

    list cells inside object / objects inside structure / structures inside database

  • read CELLNAME [WIP]

    output cell content (Only work when you are inside a object)

  • pwd

    Show current location

Write to disk / Read from disk

Note that due to preformance issue, msdb will not automatically write and/or sync with disk, meaning that everyting you done in database is temporary. You will need following commands to manually do that.

  • sync

    Write database changes onto disk

  • load CELLNAME

    Explicitly specify a cell to be loaded into cache. Normally, cells inside object will not automatically loaded due to slow performance.

Dangerous / Debugging

These commands should not be used unless you are absolutely sure what you are doing.

  • unload STRUCTURENAME

    Explicitly remove structure from cache. May improve performance.

  • setprop NAME VALUE

    Create/alter a metadata propertie. If current location is in database root, it will write to main metadata; if in a structure, it will write to structure metadata; if in a object, it will write to cell-list metadata; if in a cell, it will write to field metadata.

  • getprop

    View metadata properties

Commands for scripting

  • output OUTFILE

    write command result output uinto OUTFILE.

Special note: if you are using a command script, note that if you leave a optional parameter blank (for example, database password when decrypting), msdb will prompt for the parameter.

Support

You may use Github Issues to report bugs. Please note that currently the application is still in early-stage, and there might be many bugs.

License

This project is licensed under the GNU General Public License v3.0 only.

Dependencies

~24MB
~182K SLoC