why dont use local database?

[viponedream]

why dont use local database?

[cpbarry80]

howd you actually get this working?

[warproxxx]

I found google sheet to be easier to update params with my phone. But if you spend some time with @claude and add local db, i'd merge it

[manja316]

We use SQLite for trade tracking in our Polymarket bot and it works well. Schema is simple:

CREATE TABLE trades (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp TEXT NOT NULL,
    strategy TEXT NOT NULL,
    market_slug TEXT,
    side TEXT,
    shares REAL,
    status TEXT DEFAULT 'OPEN',
    pnl REAL,
    dry_run INTEGER DEFAULT 1
);

Benefits over Google Sheets:

• Works offline / no network dependency
• Sub-millisecond queries for position checks during fast markets
• Atomic writes — no partial updates if the bot crashes mid-cycle
• Easy to query with sqlite3 trades.db "SELECT SUM(pnl) FROM trades WHERE status='RESOLVED'" from the CLI

We pair it with JSONL auto-save for each trade decision (via ai-decision-tracer) so there's a separate audit trail that survives even if the DB corrupts.

Happy to put together a PR if @warproxxx is still open to it.

[warproxxx]

Ya open a PR @manja316

I'd be happy to merge it