w4sql sqlite and duckdb expose

1
  ws4sql_sqlite:
2
    image: ghcr.io/proofrock/ws4sql:latest
3
    container_name: ws4sql_sqlite_container
4
    ports:
5
      # Map the container's default port (12321) to the host machine's port 12321
6
      - "12321:12321"
7
    volumes:
8
      # Mount a local directory './data' to the container's '/data' volume
9
      - /stacks/ws_sqlite_data:/data
10
    restart: unless-stopped
11
    command: ["-db", "/data/students.yaml"]
12
    #command: ["--file", "/data/students.sqlite"]

1
$ cat ../ws_sqlite_data/students.yaml
2
database:
3
  type: SQLITE          # SQLITE or DUCKDB. If omitted, defaults to SQLITE
4
  inMemory: false       # If type = SQLITE|DUCKDB. The db is a memory one? If omitted, defaults to false
5
  path: "/data/students.sqlite"   # If type = SQLITE|DUCKDB. The db file path.
6
  id: students   # If omitted and !inMemory, calculates it from the file name (if type = SQLITE|DUCKDB)
7
  disableWALMode: false # If type = SQLITE. Same as before, but moved here.
8
  readOnly: false       # Same as before, but moved here.

1
$ docker compose ps
2
NAME                      IMAGE                             COMMAND                  SERVICE         CREATED             STATUS                       PORTS
3
...
4
ws4sql_sqlite_container   ghcr.io/proofrock/ws4sql:latest   "/ws4sql -db /data/s…"   ws4sql_sqlite   10 minutes ago      Up 2 minutes                 0.0.0.0:12321->12321/tcp, [::]:12321->12321/tcp

1
                __ __             __
2
 _      _______/ // / _________ _/ /
3
| | /| / / ___/ // /_/ ___/ __ `/ /
4
| |/ |/ (__  )__  __(__  ) /_/ / /
5
|__/|__/____/  /_/ /____/\__, /_/
6
                           /_/ v0.17dev7
7
+ sqlite v3.50.3
8
+ duckdb v0.0.1
9
- Parsing config file: /data/students.yaml
10
  + Serving database 'students'
11
  + Using WAL
12
- Web Service listening on 0.0.0.0:12321

1
$ cat /tmp/students.json
2
{
3
    "transaction": [
4
        {
5
            "query": "SELECT * FROM students"
6
        }
7
    ]
8
}
9

10
$ curl -s -X POST -H "Content-Type: application/json" -d @/tmp/students.json http://localhost:12321/students | jq
11
    {
12
    "results": [
13
        {
14
        "success": true,
15
        "resultHeaders": [
16
            "id",
17
            "first_name",
18
            "last_name",
19
            "age"
20
        ],
21
        "resultSet": [
22
            {
23
            "id": 101,
24
            "first_name": "John",
25
            "last_name": "Doe",
26
            "age": 20
27
            }
28
        ]
29
        }
30
    ]
31
    }

1
    $ cat /tmp/students.json
2
    {
3
        "transaction": [
4
        {
5
                "statement": "INSERT INTO students (id, first_name, last_name, age) VALUES (:id, :val1, :val2, :val3)",
6
                "values": { "id": 1, "val1": "Jane", "val2": "Doe", "val3": 40 }
7
            },
8
            {
9
                "query": "SELECT * FROM students"
10
            }
11
        ]
12
    }
13

14
    $ curl -s -X POST -H "Content-Type: application/json" -d @/tmp/students.json http://localhost:12321/students | jq
15
    {
16
    "results": [
17
        {
18
        "success": true,
19
        "rowsUpdated": 1
20
        },
21
        {
22
        "success": true,
23
        "resultHeaders": [
24
            "id",
25
            "first_name",
26
            "last_name",
27
            "age"
28
        ],
29
        "resultSet": [
30
            {
31
            "id": 1,
32
            "first_name": "Jane",
33
            "last_name": "Doe",
34
            "age": 40
35
            },
36
            {
37
            "id": 101,
38
            "first_name": "John",
39
            "last_name": "Doe",
40
            "age": 20
41
            }
42
        ]
43
        }
44
    ]
45
    }