The documentation mentions kratos supporting SQLite. I have a reference application that I want kratos to integrate with.
I ran the default docker image, built from source but couldn’t get kratos to start. It kept complaining
Unable to connect to database, retrying. error="unsupported dialect 'sqlite3'".
Then I went to the Github Releases page which indicated that there were indeed 2 assets with one being for
sqlite. I tried with that binary and kratos at least started ( I don’t want to rant about the amount of configuration changes that I had to do between the 2 versions - the released binary and my built from source binary; I understand that this is alpha / sandbox software ). The binary specified with
sqlite starts up with the right URI configurations, but doesn’t honor the DSN value from the configuration ( No database file created. I can’t skip the configuration either ). The other “normal” (pre-)release binary doesn’t work either.
My questions are as follows :
- Why are there 2 separate binaries?
- Why one specific for
sqliteand not the other database drivers?
- Did I miss seeing some documentation somewhere?
I couldn’t find any topics here, issues on Github or any mention in the documentation about this caveat which I have already spent many hours trying to figure out.
- Why is the normal application trying to use the
I tried replacing the only valid reference I could find ( though it didn’t seem that was where the error message originated from ).
- Why does the
sqlitebinary get it right?
- Can the 2 binaries be merged?
- If I wanted to build the
sqlitebinary from source ( for the sake of the
profile_ui), how would I go about achieving it?