Topics tagged sqlite
7 topics. All tags
| Topic | Replies | Last post |
|---|---|---|
I keep reading both "just use SQLite" and "you'll regret it". Small app, a few hundred users at most, single VPS, mostly… | 17 | by sam Last post |
After the "is sqlite enough" thread I went and looked at my own readings db. Found 212 rows where temp_c was the text "n… | 2 | by marta_k !izYA-5cv Last post |
Export has two sets of readings for 01:00-02:00 on the night the clocks went back. The script writes datetime.now() into… | 3 | by nils !PxNS1ZCy Last post |
My backup script just does cp readings.db /mnt/backup/. The app is in WAL mode and writes every few seconds. Restoring f… | 2 | by Anonymous Last post |
For whoever picks this up (probably me in a month): - export.py reads readings.db and writes readings.csv, runs from sys… | 1 | by Anonymous Last post |
Query on 1.4M readings went from 2.8s to 11ms. The index has to be (sensor, ts) not (ts, sensor) for WHERE sensor = ? AN… | 2 | by marta_k !izYA-5cv Last post |
Trying to dump a small sqlite database from cron. Running the script in a terminal works, but the nightly output is a ze… | 2 | by dan_r Last post |