Unable to use sqlite

[ocrumbs]

Hi,

Thanks for the project, I built this locally and run the binary directly without docker, to be able to use it with sqlite. However, I am getting this error.

Thanks again!

[hkdeman]

Hey! There is a small bug you found here - when running locally - it actually checks for a tmp folder inside the core folder (our backend). If you put your sqlite3 database there - you should be able to find it in this dropdown.

I would recommend using docker/docker-compose - the experience is significantly better and plus you can easily mount the file to /db/ without altering/linking the folder in which it is being used.

We will definitely add this to our docs and fix the bug of showing on the UI as it is super confusing right now!

[ocrumbs]

Thanks for the quick response, I now have tmp folder in place but still facing the same issue. Do you think the issue may be related to the unauthorized graphql response from the server (among other things) preventing from moving further?

I cannot use docker because I will need to eventually run on a machine with no docker installation :unamused:

Thanks !

[hkdeman]

That's unusual. Let me check this out and get back on this thread.

[wbste]

Yeah, same issue here. Tried both the volume mount method and the profiles method. I thought if I set ENVIRONMENT in the compose file to anything but dev it would work, but obviously not... (yes my db name matched the below for testing)

services:
  whodb:
    image: clidey/whodb
    ports:
      - "8080:8080"
    environment:
      WHODB_SQLITE3_1: '{"database":"sample.db"}'

Any chance we could do like a file picker for sqlite files instead?

Or maybe allow mapping an entire directory so we can just add in them at will, like below in a db folder?

docker run -it -v ./db:/db/ -p 8080:8080 clidey/whodb:latest

[hkdeman]

Thank you so much for waiting! We have realized this bug was caused due to change in the schema. We have resolved this and will be releasing next! https://github.com/clidey/whodb/pull/224

[wbste]

Nice! Got it working now! I can add whatever sqlite files i want to the db folder and restart the container and it works! Thanks!

  whodb:
    image: clidey/whodb
    volumes:
      - ./db:/db
  ...

[hkdeman]

This is great! Glad it works now. Would love any feedback, suggestions, and use cases that we can improve on.

[ocrumbs]

:pray: :pray:

Thanks a ton, works very well now .