CODEWITHSUNDEEP
djangocommand-linesqlitepycharm
Bob Stein
Bob Stein

Reputation: 17224

How to get to an interactive SQLite command-line prompt in PyCharm Pro with a Django project?

My Django project uses an SQLite3 database. How can I get to the SQLite command line shell? PyCharm has lots of other handy interactive windows

Why would I want to do this? I've already figured out how to get the SITE_ID. But this would have helped with that. I want to look under the hood for other reasons.

I've already tried View | Tool Window | Database | right-click | Console, but that's not really a command line interface.

I want to be able to type .help somewhere and get to know my database.

Upvotes: 0

Views: 1782

Answers (1)

Christine Schäpers
Christine Schäpers

Reputation: 1318

The db interface (i.e. only allowing proper SQL like SELECT and so on) seems to be the only way to communicate to the db via pycharm.

I'd recommend just using the terminal for this. Type ./manage.py dbshell and you have what you want. Move the terminal to the left and you got sort of the the built in db connection offers. Or to the right, or top, or whereever you want.

Upvotes: 1

Related Questions