.open ':memory:'
attach 'aiox.db' as ssd;
attach 'ramdisk/aiox.db' as ram;
drop view if exists period193hrs;
CREATE VIEW if not exists period193hrs as select * from ram.ir UNION select * from ssd.ir where dt >= (select datetime(max(dt), '-193 hour') from ram.ir) order by dt;

.databases
.tables
