Logging is described in the troubleshooting guide: Troubleshooting
Are the logging files stored in sqlite?
No, although I’m working on enabling some persistent logging for later this year I hope (to aid with debugging any issues that did not occur during the current browsing session). It won’t necessarily be in a sqlite file though - it’ll be up to the web browser how and where it stores it on disk.