1
0
Fork 0
Commit graph

6 commits

Author SHA1 Message Date
Matthew Holt
e9a7c03c53
Fix ExFAT crashes; refactor sql.DB handling
The crashes on ExFAT are caused by a bug in the MacOS ExFAT driver. It is unclear whether other OSes are affected too.

https://github.com/mattn/go-sqlite3/issues/1355

We now utilize sqlite's concurrency features by creating a write pool (size 1) and a read pool, and can eliminate our own RWMutex, which prevents reads at the same time as writes. Sqlite's WAL mode allows reads concurrent with writes, and our code is much cleaner.

Still need to do similar for the thumbnail DB.

Also could look into using prepared statements for more efficiency gains.
2025-09-30 12:31:41 -06:00
Matthew Holt
571d469a96 Fix some dashboard charts with future data
Also improve bubble size scaling on the bubble plot
2025-05-17 17:18:41 -06:00
Matthew Holt
3960415d97
Exclude null dates in chart queries
Fixes surprise nulls that cause errors
2025-05-14 14:57:37 -06:00
Matthew Holt
d76a211218
Refactor chart functions into one 2025-01-15 14:55:49 -07:00
Matthew Holt
7123e0d409
Replace ApexCharts with ECharts; UI fixes and improvements 2025-01-15 14:21:55 -07:00
Matthew Holt
bb9151628f
WIP: new entity page; delete almost all DB indexes
Imports are now 4-5x faster and queries are still just about as fast. New indexes should only be created after proving their usefulness.
2025-01-07 13:42:05 -07:00
Renamed from timeline/dashboard.go (Browse further)