How to have PyCharm show the tables in a Django SQLite database?
I'm not very familiar with Django (I've used more Flask, Web.py, and Falcon), and one thing that I'm finding strange is that when I look at the 'Database' tab in PyCharm, I don't see a list of all of the tables that seem to be getting used in the database:
If I use python manage.py dbshell to start a sqlite3 session and then type .tables, this is the list of tables that I see:
How do I get those tables to be browsable from within the PyCharm database viewer?
python django pycharm
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
add a comment |
I'm not very familiar with Django (I've used more Flask, Web.py, and Falcon), and one thing that I'm finding strange is that when I look at the 'Database' tab in PyCharm, I don't see a list of all of the tables that seem to be getting used in the database:
If I use python manage.py dbshell to start a sqlite3 session and then type .tables, this is the list of tables that I see:
How do I get those tables to be browsable from within the PyCharm database viewer?
python django pycharm
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
1
Have you tried hitting the refresh button in the Database panel? I've found PyCharm is occasionally a little bit slow on the uptake there.
– AKX
Nov 15 '18 at 15:33
Secondly, are you surelocal.dbis the correct database?
– AKX
Nov 15 '18 at 15:33
@AKX that was it, I needed to right-click on the db and select 'Synchronize'. Feel free to post that as the answer and I'll accept / upvote it.
– Nathan Wailes
Nov 15 '18 at 15:34
@AKX or if you think this question should be deleted, I'm OK with that too.
– Nathan Wailes
Nov 15 '18 at 15:35
posted as answer. Glad I could help! :)
– AKX
Nov 15 '18 at 15:40
add a comment |
I'm not very familiar with Django (I've used more Flask, Web.py, and Falcon), and one thing that I'm finding strange is that when I look at the 'Database' tab in PyCharm, I don't see a list of all of the tables that seem to be getting used in the database:
If I use python manage.py dbshell to start a sqlite3 session and then type .tables, this is the list of tables that I see:
How do I get those tables to be browsable from within the PyCharm database viewer?
python django pycharm
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
I'm not very familiar with Django (I've used more Flask, Web.py, and Falcon), and one thing that I'm finding strange is that when I look at the 'Database' tab in PyCharm, I don't see a list of all of the tables that seem to be getting used in the database:
If I use python manage.py dbshell to start a sqlite3 session and then type .tables, this is the list of tables that I see:
How do I get those tables to be browsable from within the PyCharm database viewer?
python django pycharm
python django pycharm
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
asked Nov 15 '18 at 15:31
Nathan WailesNathan Wailes
1,82331238
1,82331238
1
Have you tried hitting the refresh button in the Database panel? I've found PyCharm is occasionally a little bit slow on the uptake there.
– AKX
Nov 15 '18 at 15:33
Secondly, are you surelocal.dbis the correct database?
– AKX
Nov 15 '18 at 15:33
@AKX that was it, I needed to right-click on the db and select 'Synchronize'. Feel free to post that as the answer and I'll accept / upvote it.
– Nathan Wailes
Nov 15 '18 at 15:34
@AKX or if you think this question should be deleted, I'm OK with that too.
– Nathan Wailes
Nov 15 '18 at 15:35
posted as answer. Glad I could help! :)
– AKX
Nov 15 '18 at 15:40
add a comment |
1
Have you tried hitting the refresh button in the Database panel? I've found PyCharm is occasionally a little bit slow on the uptake there.
– AKX
Nov 15 '18 at 15:33
Secondly, are you surelocal.dbis the correct database?
– AKX
Nov 15 '18 at 15:33
@AKX that was it, I needed to right-click on the db and select 'Synchronize'. Feel free to post that as the answer and I'll accept / upvote it.
– Nathan Wailes
Nov 15 '18 at 15:34
@AKX or if you think this question should be deleted, I'm OK with that too.
– Nathan Wailes
Nov 15 '18 at 15:35
posted as answer. Glad I could help! :)
– AKX
Nov 15 '18 at 15:40
1
1
Have you tried hitting the refresh button in the Database panel? I've found PyCharm is occasionally a little bit slow on the uptake there.
– AKX
Nov 15 '18 at 15:33
Have you tried hitting the refresh button in the Database panel? I've found PyCharm is occasionally a little bit slow on the uptake there.
– AKX
Nov 15 '18 at 15:33
Secondly, are you sure
local.db is the correct database?– AKX
Nov 15 '18 at 15:33
Secondly, are you sure
local.db is the correct database?– AKX
Nov 15 '18 at 15:33
@AKX that was it, I needed to right-click on the db and select 'Synchronize'. Feel free to post that as the answer and I'll accept / upvote it.
– Nathan Wailes
Nov 15 '18 at 15:34
@AKX that was it, I needed to right-click on the db and select 'Synchronize'. Feel free to post that as the answer and I'll accept / upvote it.
– Nathan Wailes
Nov 15 '18 at 15:34
@AKX or if you think this question should be deleted, I'm OK with that too.
– Nathan Wailes
Nov 15 '18 at 15:35
@AKX or if you think this question should be deleted, I'm OK with that too.
– Nathan Wailes
Nov 15 '18 at 15:35
posted as answer. Glad I could help! :)
– AKX
Nov 15 '18 at 15:40
posted as answer. Glad I could help! :)
– AKX
Nov 15 '18 at 15:40
add a comment |
1 Answer
1
active
oldest
votes
Posting the comment as an answer:
PyCharm is occasionally a little slow on the uptake for new tables.
The Refresh/Synchronize button on the Database panel usually fixes that.
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53322769%2fhow-to-have-pycharm-show-the-tables-in-a-django-sqlite-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Posting the comment as an answer:
PyCharm is occasionally a little slow on the uptake for new tables.
The Refresh/Synchronize button on the Database panel usually fixes that.
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
add a comment |
Posting the comment as an answer:
PyCharm is occasionally a little slow on the uptake for new tables.
The Refresh/Synchronize button on the Database panel usually fixes that.
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
add a comment |
Posting the comment as an answer:
PyCharm is occasionally a little slow on the uptake for new tables.
The Refresh/Synchronize button on the Database panel usually fixes that.
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
Posting the comment as an answer:
PyCharm is occasionally a little slow on the uptake for new tables.
The Refresh/Synchronize button on the Database panel usually fixes that.
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
answered Nov 15 '18 at 15:39
AKXAKX
43.8k45670
43.8k45670
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53322769%2fhow-to-have-pycharm-show-the-tables-in-a-django-sqlite-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Have you tried hitting the refresh button in the Database panel? I've found PyCharm is occasionally a little bit slow on the uptake there.
– AKX
Nov 15 '18 at 15:33
Secondly, are you sure
local.dbis the correct database?– AKX
Nov 15 '18 at 15:33
@AKX that was it, I needed to right-click on the db and select 'Synchronize'. Feel free to post that as the answer and I'll accept / upvote it.
– Nathan Wailes
Nov 15 '18 at 15:34
@AKX or if you think this question should be deleted, I'm OK with that too.
– Nathan Wailes
Nov 15 '18 at 15:35
posted as answer. Glad I could help! :)
– AKX
Nov 15 '18 at 15:40