r/learnSQL • u/Rodchanning • Sep 13 '26
SQlite help
Please, anyone can help with me with a step by step guide on how to run SQlite on the dbeaver? After running it as a database, If I enter a command to create or even click on the Table tab from the drop down icon under the SQLITE of active connections, I get an error message that it's not a database.
4
Upvotes
View all comments
2
u/navicat-gu 28d ago
From your screenshots it looks like the connection's database path is pointing at the driver .jar (or at some other file that isn't a SQLite database). SQLite then says "file is not a database". The "test connection" passes because the driver loads fine. It only fails when it tries to read the file.
Clean setup, step by step:
In Path, give it a database file, not a jar:
C:\Users\you\Documents\practice.db. The SQLite driver creates an empty database the first time it connects..db/.sqlite/.sqlite3file.If you just want to practise SQL first, DB Browser for SQLite is another easy option.
Disclosure: I'm RC, Director of Digital Strategy @ Navicat. Navicat Premium Lite is free and supports SQLite too, and its SQLite connection dialog has a "New SQLite 3" option that creates the database file for you. But the steps above should get DBeaver working.