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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78

# Example YamlBase configuration for MySQL 8.0+ clients
# This demonstrates the new caching_sha2_password authentication support

# Optional: Define authentication (if not provided, uses default root/password)
auth:
  username: "myapp_user"
  password: "secure_password_123"

databases:
  myapp_db:
    # Users table with various data types
    users:
      columns:
        - name: id
          type: integer
          primary_key: true
        - name: username
          type: varchar(50)
          unique: true
        - name: email
          type: varchar(100)
        - name: created_at
          type: timestamp
        - name: is_active
          type: boolean
        - name: profile
          type: json
          nullable: true
      data:
        - id: 1
          username: "alice"
          email: "alice@example.com"
          created_at: "2024-01-15 10:30:00"
          is_active: true
          profile: '{"interests": ["coding", "music"], "age": 28}'
        - id: 2
          username: "bob"
          email: "bob@example.com"
          created_at: "2024-01-16 14:45:00"
          is_active: true
          profile: null
        - id: 3
          username: "charlie"
          email: "charlie@example.com"
          created_at: "2024-01-17 09:15:00"
          is_active: false
          profile: '{"interests": ["sports"], "age": 32}'

    # Products table demonstrating decimal types
    products:
      columns:
        - name: id
          type: integer
          primary_key: true
        - name: name
          type: varchar(100)
        - name: price
          type: decimal(10,2)
        - name: stock_quantity
          type: integer
        - name: category
          type: varchar(50)
      data:
        - id: 1
          name: "Laptop"
          price: 999.99
          stock_quantity: 15
          category: "Electronics"
        - id: 2
          name: "Mouse"
          price: 29.99
          stock_quantity: 50
          category: "Electronics"
        - id: 3
          name: "Notebook"
          price: 4.99
          stock_quantity: 200
          category: "Stationery"