0

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.

Community
  • 1
  • 1
Bob Stein
  • 16,271
  • 10
  • 88
  • 101

1 Answers1

1

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.

Chris Schäpers
  • 1,238
  • 10
  • 17
  • Thanks, but from my manage.py window (Ctrl-Alt-R) dbshell closes that window and brings up two Django Consoles. Though `manage.py dbshell` works great from the windows command line (Alt-F12). – Bob Stein Aug 20 '15 at 02:07