forked from tangled.org/core
Something went wrong. Try again.
1.3 kB · 60 lines
Go
at ci
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061package db
import ( "database/sql"
_ "github.com/mattn/go-sqlite3")
type DB struct { db *sql.DB}
func Setup(dbPath string) (*DB, error) { db, err := sql.Open("sqlite3", dbPath) if err != nil { return nil, err }
_, err = db.Exec(` pragma journal_mode = WAL; pragma synchronous = normal; pragma foreign_keys = on; pragma temp_store = memory; pragma mmap_size = 30000000000; pragma page_size = 32768; pragma auto_vacuum = incremental; pragma busy_timeout = 5000;
create table if not exists known_dids ( did text primary key );
create table if not exists public_keys ( id integer primary key autoincrement, did text not null, key text not null, created text not null default (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')), unique(did, key), foreign key (did) references known_dids(did) on delete cascade );
create table if not exists _jetstream ( id integer primary key autoincrement, last_time_us integer not null );
create table if not exists events ( rkey text not null, nsid text not null, event text not null, -- json created integer not null default (strftime('%s', 'now')), primary key (rkey, nsid) ); `) if err != nil { return nil, err }
return &DB{db: db}, nil}