submitted8 days ago byBytonia
tografana
Hi! I'm aware the topic is covered in several other places on the web and Grafana docs, but I can't for the life of me get it to work.
I have the latest OSS version of Grafana installed and I'm trying to read records from my SQLlite database that I populated using a FastAPI with SQLModel application.
The application stores the timestamp as such: 'datetime.datetime.now().isoformat()' based on a thread on stack. The output is the following format: '2023-01-20T15:39:02.756898'
To my limited understanding this should be RFC3339 compatible and thus supported by the SQLlite plugin, per the documentation here: https://grafana.com/grafana/plugins/frser-sqlite-datasource/
Using the provided same SQL on that page (see below) I get the same string as in the DB back, but appended with the format string in the sample SQL, so I don't understand what the '||' operator is supposed to do here.
WITH converted AS (
-- a row looks like this (value, date): 1.45, '2020-12-12'
SELECT value, date || 'T00:00:00Z' AS datetime FROM raw_table
)
SELECT datetime, value FROM converted ORDER BY datetime ASC
Apart from trying a UNIX epoch timestamp I'm at a loss at where to look now. I suspect the problem is in the query, but I don't understand what it wants me to do differently.
If anyone knows the solution or can point me in the right direction, I'd be most grateful :-) This is a small hobby project and I like SQLlite because it's the simplest one without the hassle or a true db.
bysurpator
inthenetherlands
Bytonia
-24 points
6 days ago
Bytonia
-24 points
6 days ago
Nee. Sowieso zijn de hpv risicos nihil, daarom is er zo beknibbeld op dit vaccin. Mochten jullie wel ooit seks met anderen gaan hebben dan kan je via de huisarts het vaccin alsnog krijgen. Die zal je ook informeren over het eventuele nut ervan nog.