Sergej Herbert

icon company Erlenbach Development GbR icon location Berlin, Germany

Results 35 comments of Sergej Herbert

Unable to Fetch Data from SQLite Database : attempt to write a readonly database (1544)

And sadly your "steps to reproduce" only work on your machine I think. Could you provide me a debug level grafana log file when the error occurs?

Unable to Fetch Data from SQLite Database : attempt to write a readonly database (1544)

> The command PRAGMA journal_mode; return wal According to the SQLite docs this is not a good setup for a read only file system. See link: https://www.sqlite.org/wal.html#read_only_databases

Please handle SQLITE_BUSY gracefully

> I volunteer to make a PR with this documentation. Sounds good. Feel free to open a PR or another issue if you need more details.

Getting unsigned int result for signed int

Could you provide a CTE that does not work? Something in the shape of this ```sql with data(time, text, city) AS (VALUES (724125600, 'annotation London', 'London'), (724161600, 'annotation New York',...

select load_extension()

I must say I am not too familiar with loading extensions in SQLite. I am not sure yet where the issue is but could you provide some more details? I.e....