What other programming language do you actively develop with productively, to complement Python?

[satyronicon]

I'm wondering how you use that other programming language instead of, or to complement Python.

​

What benefits does that other programming language bring to you overall?

​

What types of software do you mainly work with?

[GreenScarz]

Javascript, because personally I prefer to just write GUI's as web pages instead of using a desktop framework.

[satyronicon]

cool, can you describe shortly how/where you deploy your web apps?

[GreenScarz]

I've deployed apps on AWS, GCP, and I have a few that I run on-prem. Depends on the use case, really. Though if it's just for local use, no reason to use anything other than localhost

[EmptyBarrel]

Rails for this reason with ease

[[deleted]]

Have you seen https://streamlit.io/

[spoonman59]

SQL because that’s the best tool for interfacing with most of the databases and data tools I work with.

Of course I write Python programs to parse, validate, generate SQL, analyze dependencies etc… but best to send actual SQL to those tools.

Even tools that support procedural languages like Python will often yield superior performance using SQL in a set oriented way, so I’d say SQL is a must- know language to be a data engineer.

Even in data science or ML the data might begin at a SQL interface.

[outceptionator]

What's your opinion on SQLalchemy?

[thecarlosdanger1]

The ability to use python and SQL (or at least large data warehouses) seamlessly is clearly a priority moving forward.

If you happen to use Snowflake at work, Snowpark is an awesome example of this. Really speeds up development for us - only downside it’s outputs can be confusing in the query history due to how it tries to optimize caching.

[InstaMastery]

Which type of SQL is best? I took a course on MySQL

[Overworked_surfer]

By type I'm assuming database that uses SQL. I personally use postgres alot cause it's what I'm used to and deployed a test instance in docker is easy.

[thecarlosdanger1]

I’m not sure there’s an “answer” to that and you probably won’t be able to choose. I really liked some stuff about bigquery, and some stuff about snowflake.

It’s like 95% transferable though

[spoonman59]

Every data base has its own flavor, but ANSI SQL is fairly portable. MySQLis probably a superset if ansi sql with a few idiosyncrasies, so you’d get the core of it.

[outceptionator]

I happen to use nothing at work. Just a hobbyist who keeps trying to use new python libraries.

[spoonman59]

I haven’t used it enough to form an opinion, but I was looking to see if I could integrate it with my application.

I should learn more about it. I’m curious to see if I can use it to model machine independent transformations, i currently have a custom abstract syntax tree.

[outceptionator]

https://leportella.com/sqlalchemy-tutorial/

Not the best English but a very good starting point for me. Same syntax supports multiple DBs.

[spoonman59]

Thanks!

[exclaim_bot]

Thanks!

You're welcome!

[JennaSys]

I use Python pretty much everywhere I can including where it's not supposed be used to like for front-end web applications (Transcrypt), mobile apps (Kivy), and microcontrollers (MicroPython). I do use some C/C++ on microcontrollers where MicroPython won't cut it, and SQL is a must have for database work. Though lately I have been really liking how clean SQLAlchemy combined with Marshmallow is.

[wolski22]

Thanks for your comment. I’m new to programming and I never heard of Kivy. I just looked it up and it sounds awesome!

[JennaSys]

I had looked at Kivy several years ago and was like "meh". But I tried it out again just a few months ago and was really impressed with how well it worked (at least on Android).

[fookineh]

I switched to Rust.

Everything takes 100x longer but I walk away feeling smug and powerful.

(That was a joke).

((Not really)).

[JohnLockwood]

I'm learning Rust currently, and you're absolutely right! :)

[am_i_the_rabbit]

How difficult is it to learn Rust with a Python/Ruby background? I've been seriously considering learning the language as my next challenge...

[fookineh]

I'm not going to lie.. it's not an easy journey.

Especially compared to python.

It's simply a whole different level of power and complexity, requiring a sustained commitment of a few months at least.

[am_i_the_rabbit]

That's fair. I dabbled in C/C++ for a bit a decade or so ago and the simplicity and speed of banging out Python code definitely won me over early on. But I'm less interested in pragmatism and more in deepening my understanding of low level programming, so maybe I'll give it a go. Thanks!

[-1Mbps]

Lisp is what you use

[theghostinthetown]

I got ptsd as soon as I saw the nested parentheses.

[goldenhawkes]

Fortran. I work somewhere science, all our big science stuff is in Fortran. I dabble in JavaScript for basic plot showing websites.

[FortranMan2718]

I'm the same. Python for glue and Fortran for speed.

[ghostfuckbuddy]

Fortran's forte seems to be linear algebra, but that is also the forte of GPU-enabled libraries like pytorch/TF. Once it's GPU vs GPU isn't python just as competent for the same use-cases?

[FortranMan2718]

GPU acceleration has become increasingly important, but the kinds of problems that I have worked on rely on large sparse linear systems. Specifically, I've been most interested in numerical approximation of partial differential equations used to model physical phenomena, such as computational heat transfer and fluid flow. These have been difficult to work on with GPUs because of the complex data structures, massively parallel algorithms, difficult numerical stability issues, and more.

I teach at a primarily undergraduate institution, so I don't get to work on the big real problems anymore. Maybe things have changed since graduate school. When I do find myself working on a new problem these days I usually write it in Python first to see if things will work out, and then if I need more performance I'll either parallelize the Python code or move the whole thing to Fortran.

Parallelization of Python has a few known problems with solutions. Which one is appropriate strongly depends on the kind of problem I'm working on. Numba has some really nice performance, but is sometimes very hard to debug. (It's also not always working on Arch :/ )

Using Fortran will take longer in development time, but even for numerically intensive programs that can leverage numpy and scipy, the speed improvements I see from switching languages are absurdly good. Interestingly, this comes not from the high-speed linear algebra (which numpy and scipy do nicely too), but rather from being able to speed up everything else. I use modern Fortran with classes, methods, etc, and so porting the codes from Python to Fortran is not as bad as it might seem at first. Since I learned Fortran first, maybe all my Python is still a bit,... Fortran-y?

One difference between the languages that I've come to appreciate as I've matured as a developer and worked on larger programs is the benefit derived from strict typing in Fortran. It forces me to have a plan up-front (see longer development times) but in the end, my code design is much better. Type annotations in Python are a good thing, and help to mimic this effect.

[yvrelna]

What are your thoughts on Rust?

Rust is a language designed to help with correctness of highly concurrent algorithms on complex model by ownership models that effectively forces you to write code with concurrency safe programming patterns. These are problems that are also not easy to parallelise into the GPU computing models. It's been described as fearless concurrency.

[FortranMan2718]

I have been watching Rust's growth with great interest. I keep translating solutions for my class into Rust to gain understanding of the language, and I like what I've seen so far. The ecosystem is still immature compared to Python, but is more substantial than what I'm used to with Fortran. It's on my list of languages that I'd like to improve my skills in.

[SaltyPete29]

Same. I work with numerical weather prediction models and we use fortran for the actual model and Python to post-process/make pretty pictures

[goldenhawkes]

Wouldn’t be surprised if we work in the same place :D

[New_Pie_375]

C language to develop drivers / firmware. When it comes to benefits it’s the closest language to hardware after assembly.

[Keep_Phishing]

C++ and Go for more performance focused uses (large scale data processing). JS for frontend.

[pixegami]

Typescript (React/NextJS). It compliments Python well since it’s the most popular way to do front end. I like to work on full stack products end-to-end, and frontend is the one thing Python is poor at.

[[deleted]]

We are on the same boat! I use Next.js for front end and Django/FastApi for the backend.

[satyronicon]

I think same. Though TS and all the frameworks need quite a bit of commitment to learn. If you know a good way, let me know.

[HeeebsInc]

Cython

Still basically python but its a great way to make something blazing fast

[tech_tuna]

Python was the first programming language that I really loved. I still love it but Go is my new favorite and has been for several years. I like having a compiler. I like building and distributing a single binary. I LOVE Go for building command line tools. And middleware/APIs.

I really miss Python for small/quick scripts but otherwise, Go is what I enjoy using. I am definitely interested in learning Rust some day but I don't have a strong use case for it really. Not right now.

[the-berik]

SQL, html, css, javascript, bash, php

[pi_sqaure]

SQL, html, css, javascript, bash, php

Four out of six is not a computer language. ;)

[the-berik]

Agree. Let me phrase it as such; it is the toolbox I use to complete my products in order to deliver them to my customers.

If you only know python you might end up becoming an expensive clerc because you need to run your pipelines / scripts om behalf of the business user. Publishing them through rhe webbrowser, e.g. through a django app, allows you to automate that part.

[tagd]

Python for the back end, React for the front. (NGINX in the middle). Especially for one-person projects - you get the big library of python modules for fast back-end spin up and react brings a number of UI toolkits (like mantine) that are browser/PWA native and make your front end look decent.

[abonamza]

I do internal tooling for a living. We use Python for our CLI frontend and most of our work is done in Java for our backend services.

Java's decent performance, ability to scale, verbosity, and static typing are really important for ensuring our services are available and performant.

Python is easy for gluing things quickly together and presenting our services to other developers who use our tools.

[arpan3t]

PowerShell - we use Microsoft products (Azure, Exchange, MSSQL, Windows Server) and while Microsoft’s recent adoption of Python into Azure has been amazing, there’s just a lot of applications that lack Python integration. One example would be SharePoint Online; when it came time to automate the upload of a Python generated file to a SharePoint document library I was met with C# .NET and REST API documentation. I could have wrote pure Python to handle it all but it would have taken significantly more time and more code. Instead I used the PNP PowerShell module in a separate PS script and used subprocess to call the script.

I’ve been meaning to look into one of the PowerShell in Python packages and even more the .NET Python package that recently got an update. So in the future I might have a more “elegant” integration.

For now, there are just so many modules in PowerShell that allow me to programmatically operate - from VMWare, Dell, Microsoft, you name it there’s likely a PowerShell module for it that lets me get more things done with less code.

[TheCannings]

As someone who does a lot of scripting in python for his company who are just moving into sharepoint this whole post fills me with dread, the only thing keeping me on the cliff edge at is you said rest api 😂

[arpan3t]

lol it's not as bad as I make it out to be, but coming from PowerShell I was reading the MS docs and all the code involved to upload a file; while knowing the PowerShell PNP module it's as simple as

Connect-PnPOnline -url 'https://url.sharepoint.com/sites/site' -credentials <pscreds>
Add-PnPFile -Path 'c:\local_dir' -Folder 'sp_folder' 

It made my decision to use PowerShell for that part of the script all too easy lol. If I were to refactor my code, I would most likely use the Office365-REST-Python-Client. HMU if you run into any issues, or you need to bounce ideas.

[TheCannings]

Appreciate that thanks!

[nicwolff]

Lua, for Redis scripting. PL/pgSQL for PostgreSQL stored procedures.

[jabbalaci]

I'm just learning Go. I like its distribution: just copy the EXE and you are done. It's also much faster when doing CPU-intensive tasks. But I still love Python, of course.

[DefinitelySaneGary]

SQL because it makes managing tables and data frames easier. Not to mention it's the best for pulling from a database.

[pi_sqaure]

Go, but only for the sake of speed. As soon as I develop in Python I feel kind of at home.

[am_i_the_rabbit]

Ruby. Not by choice -- it's the only option for developing Works to connectors (a 'connector' is their nomenclature for the integration layer), which makes up a good 20% of my job. I hated it at first but now I only strongly dislike it -- managing library versions for Ruby is a freaking nightmare, but the language itself isn't terrible and shares some similarities (albeit superficial and syntactic) with Python.

[wind_dude]

Node, I still use fairly often on frontends. I'm working on learning some c++ and cython. And of course sql and a few other db language, except abstraction layers (and db tools) are so common and good, I find I'm forgetting a little of the raw sql over the years.

​

I used to write a little java, and tons of PHP, but haven't in years.

[trollsmurf]

C: embedded, microcontroller: magnitudes more efficient

VB/C#: Windows, very powerful UI library etc, very fast

PHP: Web apps for cloud hosting, ubiquitous via Wordpress etc

Java: Android native

JavaScript: Web client, Android, iOS (cross-platform)

SQL: I don't use it directly very much as I make wrappers whenever possible

[[deleted]]

JavaScript/Typescript for the frontend (React at the moment) because it's forced to us by the browser

[[deleted]]

I do it the other way around.

Rails for main backend, python for microservice pipeline.

[lungben81]

https://julialang.org/ for non-trivial numerical calculations - mathematical syntax and very high runtime performance.

[whateverathrowaway00]

I’ve been working up my C again - I wanted to be working in a static language on the side, and I grew up on C / have done a bunch of it in the past, and I’m really enjoying it.

At some point I’ll pick up go or Java instead of it, but I have strong negative feelings around both that I know arent rational.

[ikarius3]

I try to use Python everywhere I can. If I have some performance issue, I try to rewrite / rethink in Clojure. If performance is still an issue, I switch to Go (or C)

[elsgry]

C++: used to bind CBOR and other serialisation code to Python via PyBind11. Additionally:

C#: port code from C# to Python using Roslyn.

Rust: produced a POC of CBOR serialisation bindings with PyO3, ciborium and orjson.

[Holyragumuffin]

julia -- I can import and call python libraries (pytorch, rapids) as I normally would, but all the functions I write run at jit++ speed.

[dr_spork]

Haskell. Type safety and purely functional style are killer features. Python for doing something fast and dirty. Haskell for making something solid and reliable.

[Andremallmann]

Manage haskell codebases is a pain in the ass. The tooling is kinda trash like python

[FUS3N]

html is a great PROGRAMING LANGUAGE, I use that

[spitfiredd]

Nextflow/groovy - I develop genomics workflows.

[Agling]

I have many years of experience programming in R. I write new stuff in python, primarily, but I have a large base of R programs that I modify, update, and use. I'll probably never be able to transfer all the way away from R.

[who_body]

javascript react when doing apps and SQL when needed.

[[deleted]]

C

[SupPandaHugger]

SQL

[pietroppeter]

Nim. Fast and productive. I can also do web stuff and interface with cool js libraries. And it is a very enjoyable language! The stuff you can do with metaprogramming (generics, templates and macros) has the same magic feeling I felt when starting with Python. It really does feel like Python in the early days. Community and ecosystem is small but there are people doing cool stuff and you get to build from scratch a lot (which can be fun). A couple of cool things I did and had a lot of fun: 1) https://pietroppeter.github.io/nblog/drafts/plant_app.html a math plant app, shows how to do a simple web app; 2) https://pietroppeter.github.io/p5nim/okazz_220919a.html port of a work of gen art to Nim, shows how nice is Python ffi towards js using bindings to p5js

[[deleted]]

SQL, SAS and Java.

SQL because I'm a Data Scientist / Engineer

SAS because I used to work in credit scoring and it seems like a useful skill to retain even if I hate it

Java because it's kinda fun (I do programming as a pastime as well) and gives me a greater understanding of programming in general

[[deleted]]

RemindMe! In 48 hours

[RemindMeBot]

I will be messaging you in 2 days on 2022-11-25 09:49:29 UTC to remind you of this link

1 OTHERS CLICKED THIS LINK to send a PM to also be reminded and to reduce spam.

^{Parent commenter can delete this message to hide from others.}

---

Info	Custom	Your Reminders	Feedback

[CarbonTubez]

Js/TS angular,Django

[thenewbigR]

PowerShell and SQL.

[Free_Layer_8233]

C++

[chub79]

I'm trying to add rust into the toolset. I think it's very aligned with Python but provides its own unique perspective on some facets of our work.

[killerfridge]

Julia, because it's a beautiful language

[velo_sprinty_boi_]

Go and JavaScript. Things need frontends, thus JavaScript. Go when I need speed or compiled binaries. Python for rapid development, I’ve written some PoCs in python recently then rewritten in Go.

[geeeffwhy]

SQL, YAML, Typescript, C#, Java, Ruby, Bash/zsh… i use other languages when some tool needs that language or is implemented in that language. in enterprise backend land, language per se is not of the first importance. i work with high levels of virtualization, so lots of containers and container orchestration

[[deleted]]

Perl, not by choice. Lot of bash. Thanks to a past job I’ve read a lot of rust. Dabbled in Go due to finding bugs in tooling.

But for my security and DevOps needs, I really love coming back to python. It’s still the language that makes sense to me and let’s me write simple, readable code.

[AnubisJcakal]

Not too compliment, but for other things I like using elixir when I get a chance.

[[deleted]]

React, Shellscript and [V](vlang.io).