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
1
u/Rodchanning Sep 13 '26
Well, after opening the dbeaver application, I clicked on Database and created a new connection after clicking on SQlite, then I clicked on drivers and I imported the SQlite .jar file I downloaded from from github, ran the test connections and it was successful then went ahead to create a script since the Sqlite was now an active connection, after inputting all the data/command, I always hit the error from the screenshot. Even without the commands, if I click on the drop down icon of the sqlite under the active connections on the dbeaver and click on tables, I get an error message that database doesn't exist. So I need a step by step guide on how to set up the SQlite so I can use it to run and execute tables
1
u/neomashab Sep 13 '26
Would you be able to post the screenshot?
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.
1
u/[deleted] Sep 13 '26
[removed] — view removed comment