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.yml
dbs:
  - 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.sqlite
litestream 
	restore 
	-v 
	-if-replica-exists
	-config /data/litestream.yml 
	/data/db.db
litestream
	replicate 
	-config /data/litestream.yml
litestream 
	restore 
	-v 
	-if-replica-exists
	-config /data/litestream.yml 
	/data/db.db
litestream
	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

2023-10-18 - SQLite streaming

By Milan Felix Šulc

2023-10-18 - SQLite streaming

  • 248