- cli tool
- npm install nv-remote-tree-db-cli
# npm install nv-remote-tree-db-cli -g
#creat consts.js
#nv_rtree_const -e tag text ftype integer compressed bool btype interger stype interger dtype bigint hex_data text
root@dev:/opt/JS/nv-remote-tree# cat consts.js
......
module.exports = {
ENBALE_PRIM_SRCH,
PRIM_KEY,PRIM_SRCH_TYP,PRIM_TYP,
INTERNAL_KS,INTERNAL_SRCH_TYPS,INTERNAL_TYPS,INTERNAL_CREAT_DICT,
DATA_KS,DATA_SRCH_TYPS,DATA_TYPS,DATA_CREAT_DICT,
DFLT_TAIL_KS,DFLT_TAIL_TYPS,DFLT_TAIL_SRCH_TYPS,DFLT_TAIL_CREAT_DICT,
FULL_SRCH_KS,FULL_SRCH_TYPS,FULL_SRCH_TYPMP,
INTERNAL_AND_DATA_CREAT_DICT,
CNL,SQL_CNL_KSTR,CNL_TYPS,CNL_CREAT_DICT,
reorder,
creat_db_tem_dict,
CONSTS,
}
.....
root@dev:/opt/JS/nv-remote-tree#
#init and fill database
Usage: nv_rtree_creat [options]
Options:
-s, --server db host ip default 127.0.0.1
-n, --name db name
-t, --table_name table name
-m, --max_size max_size of forest, default 1000000
-e, --external external k t k t....
-h, --help usage
#nv_rtree_creat -n jsonpg -t forest -e tag text ftype integer compressed bool btype integer stype integer dtype bigint hex_data text
jsonpg=# \d forest
Table "public.forest"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
//// internal USING ,FOR tree-relation
id | integer | | not null |
fc | integer | | |
rb | integer | | |
pr | integer | | |
lb | integer | | |
lc | integer | | |
////----FOR write-lock/append-lock/disconn-lock/lsib-lock/rsib-lock/ance-lock SUPPORT
////----ALSO FOR rent-mode block-subtree SUPPORT ,SO 8bit not enough, USE i32
eflag | integer | | |
/////-------------FOR GRAPH UPSTREAM/DOWNSTREAM SUPPORT-----
link_to_ary | jsonb | | |
link_from_ary | jsonb | | |
/////-------------FOR VFS SUPPORT------------------------------
tag | text | | |
ftype | integer | | |
compressed | boolean | | |
btype | integer | | |
////-------------FOR MAP JS-TYPE TO PGTYPE SUPPORT------------
stype | integer | | |
dtype | bigint | | |
hex_data | text | | |
/////
extra | jsonb | | not null |
created_at | bigint | | not null |
update_at | bigint | | not null |
Indexes:
"forest_pkey" PRIMARY KEY, btree (id)
jsonpg=# select count(1) from forest;
count
---------
1000000
(1 row)
jsonpg=#
- ISC