Local document storage

Description of tables " User manual "

Viewing data in tables is possible through the built -in query editor for "SQLite" databases


Document storage allows you to organize documentation, instructions for working with different DBMS (Oracle, PostgreSQL and others), server settings, and any other documents in the form of a structured tree with support for internal links. The repository is versioned, i.e. each time the document is changed, a new snapshot is created.

Documentation is stored in a secure storage built on the basis of a SQLite database.  

Opening the Document Editor

Main program window - Editors - Documents editor  

Show document editor.jpg
Creating nodes of the document tree
  1. Press the button "Create new key in catalog"

  2. Enter node names in the field  "Value"

  3. Click the "Save" button

CerebroSQL - Create new key in catalog.j
CerebroSQL - catalog editor.jpg

Formation of the document tree 

Creating root tree entries
  1. Press the button "Insert parent in tree"

  2. In the drop-down list "Parent name" select "root line" and double-click on the desired entry in the "Parent list" field

CerebroSQL - Insert parent in tree.jpg
CerebroSQL - add parent row in tree.jpg
Creating child nodes in the tree
  1. Select a node in the "Tree the documentation" tree

  2. Click the "Insert parent the tree" button

  3. Double click on the desired entry in the "Parent list"

CerebroSQL - Insert parent in tree.jpg
CerebroSQL - Insert children in tree.jpg
Create a new document
  1. Select a node in the "Tree the documentation" tree

  2. Click the "Create new document" button

  3. Fill in the "Caption" field - the name of the document, displayed in the tree

  4. Enter document text

  5. Save the document by clicking the "Save" button

CerebroSQL - create new document.jpg
Additional document options
  1. Press the "Parameter" button

  2. "Exported" flag - enable document export

  3. The "Locked" flag is a change-inhibiting flag.

  4. "Key list" - a list of search keywords

  5. "Information"

    1. An arbitrary set of records of the form "name = value"  

Create hyperlinks to other documents

Hyperlinks are used to open other documents from the current one.

  1. There are two ways to get a link to a document

  2. Open the document search window (Button - Search document )

  3. Select the required document in the list

  4. Press the "Copy link and close" button - the link to the document will be copied to the clipboard

  5. Select text in the document and select "hyperlink" from the context menu

  6. In the "Address" field, paste the copied key

CerebroSQL - hyperlink document.jpg
View Document Versions
  1. Select a document in the tree

  2. In the main window, open the drop-down list "Version"

  3. Select an old snapshot of a document

  4. The document will be displayed in the main window

CerebroSQL - document version.jpg
Controlling the number of document versions

From the drop-down menu of the "Delete document" button select "Number of document versions"

CerebroSQL - number of document version.
CerebroSQL - number of document version
Deleting Document Versions
  1. Select in the tree a document whose version you want to delete or a directory (it is forbidden to delete non-empty directories)

  2. Press the button "Delete documnet/parent row"

  3. In the opened wizard for deleting documents, set receipts opposite the documents that need to be deleted

  4. Press the button "Delete selected document"

  5. The deletion status of each document is displayed in the "Status" field

CerebroSQL  - delete documents.jpg
Moving a document/node to another node
  1. Select document/node in tree

  2. Press the "Move document" button

  3. In the window that opens, select a new node

  4. Press the "Move" button to move

CerebroSQL - move document.jpg

Document templates

Creating a document template
  1. Select a node in the tree

  2. Click the "Create new document" button

  3. Enter the name of the document in the "Caption" field

  4. Create a document of any structure

  5. Specify the name of the template's parent (used to group templates in a tree, menu)

  6. Save the template by clicking the "Save document as template" button

CerebroSQL - Example document template.jpg
Changing the template

  1. Press the button "List template

  2. In the list of templates, find and select the template that you want to change

  3. Press the "Open" button

  4. Without changing the values in the "Caption" and "Template owner" fields, make changes to the template text

  5. Save changes

Deleting a Template

  1. Press the button "List template

  2. In the list of templates, find and select the template that you want to delete

  3. Press the "Delete" button