search

wbh1 / grafana-sqlite-to-postgres

Grafana SQLite to Postgres Database Migrator
MIT License
100 stars 26 forks source link

Dockerfile: compile the latest sqlite3 from source #33

Closed weakcamel closed 2 years ago

weakcamel commented 2 years ago

the latest sqlite3 binary supports UFT-8 better which makes it indirectly solve #19

weakcamel commented 2 years ago

Unfortunately, the UTF-8 problems have re-occurred for me while re-testing import from scratch and I'm still facing them:

FATAL[2022-08-26T12:58:23Z] ❌ pq: invalid byte sequence for encoding "UTF8": 0xe7 0x18 0x9b INSERT INTO "data_keys" VALUES('<redacted>',1,'root','secretKey.v1',<REDACTED>,'2022-08-25 15:37:01','2022-08-25 15:37:01','2022-08-25/root@secretKey.v1') - failed to import dump file to Postgres.

( just like https://github.com/wbh1/grafana-sqlite-to-postgres/issues/28#issuecomment-1228477984 )

I ended up using https://polyglot.jamie.ly/programming/2019/07/01/grafana-sqlite-to-postgres.html

See https://github.com/wbh1/grafana-sqlite-to-postgres/issues/28#issuecomment-1234533053