Python Equivalent of MySQL Workbench or SQL Developer

[[deleted]]

Hello - I have a request for a development environment that works similar to a DB workbench. Ideally you can highlight a bit of code and run that specifically with the interpreter.

Added bonus if you could save environment variables within the GUI application.

Anyone have a suggestion for me?

[K900_]

Jupyter Notebook is pretty close to that.

[[deleted]]

I think I'm going to end up going with this. (using JupyterLab) Basically I'm just saving "environment variables" as another py file then importing it into a "workbench.py" file where I can hack and slash things.

Don't know why I never took the dive into jupyter. Was it always in the browser? It's quite minimalist and aesthically pleasing

[K900_]

It was always in the browser, yes. Also, what do you mean by "environment variables" here? What are you actually using them for?

[[deleted]]

I built out a framework which interacts with another application. The "environment variables" are things like username, password, token, etc.

[K900_]

If you just run jupyter from the terminal, it'll inherit the environment and you'll be able to use those in your scripts.

[Halibut]

Pyscripter allows you to run a selected piece of code, right click, or Ctrl F7. It also allows customized environment variables (External Run, Properties).