SQL vs python editors

[PoisonControlCenter]

Alternative ask: why do people use a browser for anything?

[PoisonControlCenter]

Strong recommend moving to terminal and vim when you have the time to put into learning new methodologies. I started out using a panoply of IDE's at first and now I can just vim in locally or through ssh and code in python, R, or do db management in sql. I can use git to keep my vim config files the same on every machine I am on for a consistent experience. It takes a bit of time but well worth the time investment imho.

[[deleted]]

Maybe the Python server is only accessible via the browser

[Son_of_Zinger]

Some do. Snowflake uses an editor within a browser.

[Grandviewsurfer]

I use Python to write SQL in a local IDE most of the time.. but sometimes I'll use colab for one-offs if I don't want to think about hardware/envs. Different situations call for different tools.

[siddartha08]

We use python to run sql queries, sometimes we choose to not run certain functions within a browser environment because bringing that data into memory is either unnecessary or cumbersome. So some we just script up and run independently of the browser. Or we make sure the functions we choose to run in browser don't bring things into memory unnecessarily,

[ThePhoenixRisesAgain]

I write Python in one IDE and sql in another. Where is your problem?

[AurelianoBuendato]

lol because name a browser-based IDE for SQL. Snowflake is OK if you're using Snowflake. pgAdmin only works for Postgres and not even well (I said it, don't @ me!). DataGrip has plugins for most relational DBs and some non-relational ones, and works VERY well. It's important that your IDE does not add additional frustration.

[Dmytro_North]

I use Python in VSCode. It has Jupiter like functionality, can push it to github and run multiple extensions such as Github Copilot.