
SQLite
@xf3l1x
f3l1x.io
18.10.2023
Β












SQLite
version: "3.6"
services:
app:
image: nettteapp
ports:
- 8000:80

version: "3.6"
services:
app:
image: netteapp
ports:
- 8000:80
db:
image: mariadb:11.1
environment:
MYSQL_ROOT_PASSWORD: php
MYSQL_DATABASE: php
MYSQL_USER: php
MYSQL_PASSWORD: php
ports:
- 3306:3306
volumes:
- .docker/db:/var/lib/mysql









SQLite


SQLite Streaming




litestream
replicate
-config /data/litestream.ymldbs:
- path: "/data/db.db"
replicas:
- type: s3
bucket: "myapp"
path: "db"
endpoint: "http://s3api.tld"
region: "brno"
access-key-id: "brno"
secret-access-key: "pivo"litestream
restore
-if-replica-exists
-config /data/litestream.yml
/data/db.sqlitelitestream
restore
-v
-if-replica-exists
-config /data/litestream.yml
/data/db.dblitestream
replicate
-config /data/litestream.ymllitestream
restore
-v
-if-replica-exists
-config /data/litestream.yml
/data/db.dblitestream
replicate
-config /data/litestream.yml
-exec "yourapp start"SQLite Streaming
- litestream.io
- developers.cloudflare.com/d1
- github.com/thevahidal/soul
- turso.tech
- sqlitecloud.io
- dbhub.io


github.com/f00b4r/2023-10-flyio-litestream-kuma





xmonitor.fly.dev
Recap
-
SQLite is π -
ββββStreaming is on π₯ -
Litestream is π -
OSS is the way


Time to selfie π·

Thank you!


@xf3l1x
f3l1x.io
