yamlbase 0.7.2

A lightweight SQL server that serves YAML-defined tables over standard SQL protocols
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

database:
  name: "secure_db"
  auth:
    username: "dbadmin"
    password: "securepass123"

tables:
  users:
    columns:
      id: "INTEGER PRIMARY KEY"
      username: "VARCHAR(50) NOT NULL UNIQUE"
      email: "VARCHAR(100) NOT NULL"
      created_at: "TIMESTAMP DEFAULT CURRENT_TIMESTAMP"
    data:
      - id: 1
        username: "alice"
        email: "alice@example.com"
        created_at: "2024-01-15 10:30:00"
      - id: 2
        username: "bob"
        email: "bob@example.com"
        created_at: "2024-01-16 14:22:00"
  
  sensitive_data:
    columns:
      id: "INTEGER PRIMARY KEY"
      user_id: "INTEGER REFERENCES users(id)"
      data_type: "VARCHAR(50)"
      encrypted_value: "TEXT"
      created_at: "TIMESTAMP DEFAULT CURRENT_TIMESTAMP"
    data:
      - id: 1
        user_id: 1
        data_type: "api_key"
        encrypted_value: "encrypted_key_here"
      - id: 2
        user_id: 2
        data_type: "token"
        encrypted_value: "encrypted_token_here"