coleifer / sqlite-web

Web-based SQLite database browser written in Python
MIT License
3.35k stars 331 forks source link

Primary Key Not Recognized #165

Closed rileyamos closed 1 week ago

rileyamos commented 1 week ago

I'm running a docker container with a new instance of sqlite-web. The primary key of my table is not recognized which prevents the edit/delete functionality in the content tab. Primary Key is not checked for column id in the structure -> columns table even though it can be seen in the schema above.

CleanShot 2024-09-11 at 09 43 16@2x

coleifer commented 1 week ago

The docker image on dockerhub is hopelessly out-of-date most likely that's the issue. You can build the docker image yourself, the Dockerfile is included in the repo.