Difference between revisions of "Miradb"

From ArchWiki
Jump to navigation Jump to search
(edit)
(Tag: Blanking)
(Undo revision 570474 by Nodeclient (talk) can't just blank the page; it needs to be archived or removed by an admin)
(Tag: Undo)
Line 1: Line 1:
 +
[[Category:Database]]
 +
[[en:MiraDB]]
 +
{{Remove|Duplicates upstream documentation. Abuse.}}
 +
[https://miradb.com/docs/ MiraDB] an object database is a light-weight database management system in which information is represented in the form of objects as used in javascript programming.
  
 +
 +
<div class="noautonum">__TOC__</div>
 +
 +
== Installation ==
 +
 +
[[Install]] the {{aur|miradb}} package. The installation default directory  {{ic|/usr/bin/miradb}}
 +
 +
== Usage ==
 +
; you need to first switching to the (root) user before start miradb.
 +
  {{ic|$ su root}}
 +
 +
: register bash command (one-time):
 +
  $ sh /usr/bin/miradb/service
 +
 +
=== terminal ===
 +
: specific commands to [ start | stop | restart | status ]
 +
  $ miradb start
 +
 +
=== Query Guide ===
 +
: MiraQuery is a standard regular expression for storing, manipulating and retrieving data in databases. Our Querie tutorial will teach you how to use let's beginning.
 +
 +
==== UNIQUE ====
 +
: returns a dataset that contains only one observation for each unique combination of values for the strings in A specified in column.
 +
 +
 +
  {{hc|query|UNIQUE COLUMN <COLUMN_NAME> TABLE <TABLE_NAME>;}}
 +
 +
  {{hc|example usage|
 +
    db.query("UNIQUE COLUMN pass TABLE user",function(data,err){
 +
      console.log(data);
 +
    });
 +
  }}
 +
 +
==== SELECT ====
 +
:the returned all the columns from the table
 +
  {{hc|query|SELECT TABLE <TABLE_NAME>;}}
 +
:the returned the number of rows
 +
  {{hc|query|SELECT TABLE <TABLE_NAME> COUNT;}}
 +
:the returned selected columns in the table
 +
  {{hc|query|SELECT TABLE <TABLE_NAME> COLUMN [COLUMN_NAME];}}
 +
:the returned specify the number of records range (start-end)  '''LIMIT [1,5]'''
 +
  {{hc|query|SELECT TABLE <TABLE_NAME> LIMIT [START_NUMBER,END_NUMBER];}}
 +
:finds rows that contain a specific string value in a column.
 +
  {{hc|query|SELECT TABLE <TABLE_NAME> COLUMN [COLUMN_NAME] FIND ["SEARCH_STRING"];}}
 +
:used in search for similar string of in a column
 +
  {{hc|query|SELECT TABLE <TABLE_NAME> COLUMN [COLUMN_NAME] FIND ["SEARCH_STRING"] LIKE;}}
 +
 +
 +
  {{hc|example usage|
 +
    db.query("SELECT TABLE user;",function(data,err){
 +
      console.log(data);
 +
    });
 +
  }}
 +
 +
==== UPDATE ====
 +
: used to modify the existing records in a table.
 +
 +
  {{hc|query|UPDATE ROW <TABLE_NAME> COLUMN [COLUMN_NAME] VALUE [STRING] FIND [COLUMN_NAME,"STRING"];}}
 +
 +
  {{hc|example usage|
 +
    db.query("UPDATE ROW user COLUMN ["user","pass","mail"] VALUE ["olivia","3333","olivia@example.com"] FIND ["user","mason"];",function(data,err){
 +
        console.log(data);
 +
    });
 +
  }}
 +
 +
==== ADD ====
 +
: insert new record in a data table.
 +
  {{hc|query|ADD ROW  COLUMN [COLUMN_NAME] VALUE [STRING];}}
 +
: create new column in a data table.
 +
  {{hc|query|ADD COLUMN [COLUMN_NAME] TABLE <TABLE_NAME>;}}
 +
 +
 +
  {{hc|example usage|
 +
    db.query("ADD ROW COLUMN ["user","pass","mail"] VALUE ["arvin","6666","arvin@example.com"];",function(data,err){
 +
      console.log(data);
 +
    });
 +
  }}
 +
 +
==== RENAME ====
 +
: not ready yet
 +
==== DELETE ====
 +
: not ready yet
 +
==== CREATE ====
 +
: not ready yet
 +
==== DROP ====
 +
: not ready yet
 +
==== LIST ====
 +
: not ready yet

Revision as of 00:32, 5 April 2019

Tango-edit-cut.pngThis section is being considered for removal.Tango-edit-cut.png

Reason: Duplicates upstream documentation. Abuse. (Discuss in Talk:Miradb#)

MiraDB an object database is a light-weight database management system in which information is represented in the form of objects as used in javascript programming.


Installation

Install the miradbAUR package. The installation default directory /usr/bin/miradb

Usage

you need to first switching to the (root) user before start miradb.
 $ su root 
register bash command (one-time):
 $ sh /usr/bin/miradb/service

terminal

specific commands to [ start | stop | restart | status ]
 $ miradb start

Query Guide

MiraQuery is a standard regular expression for storing, manipulating and retrieving data in databases. Our Querie tutorial will teach you how to use let's beginning.

UNIQUE

returns a dataset that contains only one observation for each unique combination of values for the strings in A specified in column.


query
UNIQUE COLUMN <COLUMN_NAME> TABLE <TABLE_NAME>;
example usage
    db.query("UNIQUE COLUMN pass TABLE user",function(data,err){ 
      console.log(data); 
    });
   

SELECT

the returned all the columns from the table
query
SELECT TABLE <TABLE_NAME>;
the returned the number of rows
query
SELECT TABLE <TABLE_NAME> COUNT;
the returned selected columns in the table
query
SELECT TABLE <TABLE_NAME> COLUMN [COLUMN_NAME];
the returned specify the number of records range (start-end) LIMIT [1,5]
query
SELECT TABLE <TABLE_NAME> LIMIT [START_NUMBER,END_NUMBER];
finds rows that contain a specific string value in a column.
query
SELECT TABLE <TABLE_NAME> COLUMN [COLUMN_NAME] FIND ["SEARCH_STRING"];
used in search for similar string of in a column
query
SELECT TABLE <TABLE_NAME> COLUMN [COLUMN_NAME] FIND ["SEARCH_STRING"] LIKE;


example usage
    db.query("SELECT TABLE user;",function(data,err){ 
      console.log(data); 
    });
   

UPDATE

used to modify the existing records in a table.
query
UPDATE ROW <TABLE_NAME> COLUMN [COLUMN_NAME] VALUE [STRING] FIND [COLUMN_NAME,"STRING"];
example usage
    db.query("UPDATE ROW user COLUMN ["user","pass","mail"] VALUE ["olivia","3333","olivia@example.com"] FIND ["user","mason"];",function(data,err){ 
        console.log(data); 
    });
   

ADD

insert new record in a data table.
query
ADD ROW  COLUMN [COLUMN_NAME] VALUE [STRING];
create new column in a data table.
query
ADD COLUMN [COLUMN_NAME] TABLE <TABLE_NAME>;


example usage
    db.query("ADD ROW COLUMN ["user","pass","mail"] VALUE ["arvin","6666","arvin@example.com"];",function(data,err){ 
      console.log(data); 
    });
   

RENAME

not ready yet

DELETE

not ready yet

CREATE

not ready yet

DROP

not ready yet

LIST

not ready yet