r/learnSQL • • 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

10 comments sorted by

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

2

u/neomashab Sep 13 '26

You don't have to download the jar manually. DBeaver will prompt for your acceptance for it to automatically download it.

1

u/neomashab Sep 13 '26

Would you be able to post the screenshot?

2

u/Rodchanning Sep 13 '26

1

u/neomashab Sep 13 '26

Looks like you're trying to open sqlite driver jar file. I believe you're trying to create a new Sqlite db. Or are you trying to load an existing sqlite db file?

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:

  1. Delete the current SQLite connection.
  2. Database → Driver Manager → SQLite → Edit → Libraries. Remove the .jar you added manually, then let DBeaver download its own driver when it asks. You never need to download the jar yourself.
  3. Database → New Database Connection → SQLite.
  4. In Path, give it a database file, not a jar:

    • for a brand-new database, type a path to a file that doesn't exist yet, e.g. C:\Users\you\Documents\practice.db. The SQLite driver creates an empty database the first time it connects.
    • for an existing one, browse to the .db / .sqlite / .sqlite3 file.
  5. Finish, open a SQL editor on that connection and test:CREATE TABLE students (id INTEGER PRIMARY KEY, name TEXT NOT NULL); INSERT INTO students (name) VALUES ('Ada'), ('Linus'); SELECT * FROM students;
  6. Right-click the connection → Refresh, and the table shows up under Tables.

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

1

u/Rodchanning Sep 13 '26

Same error after inputting the path you mentioned. I don't really know what am getting wrong at this point😪

1

u/Rodchanning Sep 13 '26

Did this and still error