3

After updating PyCharm (version 2017.1), PyCharm does not display sqlite3 database tables anymore.

I've tested the connection and it's working.

In sqlite client I can list all tables and make queries.

Someone else has get this problem? And in this case could solve anyway?

Caco
  • 1,601
  • 1
  • 26
  • 53
  • [this](https://www.jetbrains.com/help/pycharm/2016.3/working-with-the-database-tool-window.html#open_db_tool_window) may or may not help – Divins Mathew Mar 28 '17 at 16:55

5 Answers5

2

I am using PyCharm Professional v2017.3.

In Database pane, click the plus button and add Data Source -> Sqlite (Xerial). Data Sources and Drivers settings will open up where you will see Driver: Sqlite (Xerial). This does not mean drivers are fully installed. Look at the bottom-left of the pain for a message. If it has a warning sign about missing files, install missing files. Otherwise it will say no objects.enter image description here

Avi Kaminetzky
  • 1,489
  • 2
  • 19
  • 42
2

Yeah, Pycharm seems stupid on that, I've stubled upon the solution with a bunch of luck:

  1. Make sure you have all schemas shown: db->Schemas
  2. Still, the tables do not show..until you select the db and hit Reload: Cmd+R or Context menu
Huge
  • 661
  • 7
  • 14
1

After clicking on the View => Tools => Window => Database click on the green plus icon and then on Data Source => Sqlite (Xerial). Then, on the window that opens install the driver (it's underneath the Test Connection button) that is proposing (Sqlite (Xerial)).

That should do it both for db.sqlite3 and identifier.sqlite. I have never any problem with Sqlite database, showing on PyCharm IDE.

nik_m
  • 11,825
  • 4
  • 43
  • 57
  • @Caco. If you press the `Test Connection` button and you get a success, what does the `Details` *link* (next to it) shows? – nik_m Mar 28 '17 at 17:04
  • Details of `Test Connection`: `Database: SQLite (ver. 3.16.1) Identifier case sensitivity: mixed (plain), mixed (delimited) Driver (JDBC2.1): SQLiteJDBC (ver. native)` – Caco Mar 28 '17 at 17:08
  • I suppose that you hit synchronise, don't you? – nik_m Mar 28 '17 at 17:13
  • Yes, when I make any changes in the database I hit synchronize to update Pycharm database representation. – Caco Mar 28 '17 at 17:17
0

It might be stupid thing but consider that you have to connect actual DB and not only indentifier.

The fastest way is to double tap on the DB file in the file explorer and Pycharm will automatically suggests everything.

Pycharm screen

Nikoloz Magradze
  • 1
  • 1
  • @NameVergessen Can you tell me what exactly doesn't work? If you want to see the DB sqlite tables just double tap on the db.sqlite3 file and it suggests to create a connection. Btw it's not a fix it's a suggestion ;) – Nikoloz Magradze Dec 08 '22 at 17:47
0

UPDATE:

I am using Pycharm 2022.3.2 Version. I was trying the hit and try method for hours now and it seemed to work for me.

  1. View-> Tool Windows-> Databasesenter image description here
  2. Once Databases Open on the left side pane. Click on the + button and choose `Data source from Pathenter image description here
  3. Then choose the path of your db.sqlite3 file and click openenter image description here
  4. After that Choose the drive from the drop down and choose sqlite and click OK enter image description here
  5. The db should work fine now and tables should be populated as per the data. Atleast mine did. Try this and let me know if that works!!! enter image description here
nraza
  • 19
  • 4