I was more curious if IF was using anything other than Django's ORM. I just worded my question poorly. I was more trying to ask if you used any ORM aside from what Django provides. I don't have any experience with any Python ORM.
Recently I have just been trying to use more Python tools more for the experience. I'm in System Engineering and our DA/BI person left around 2018. So the company put that job on top of my DBA / Infra role.
Python is the one area I haven't ever gotten deep into or had the time. I write mostly PowerShell and SQL. So lately I have been reading a lot in regard to Python and I was just surprised at how a lot of people doing Python don't actually do or in some cases know a lot of raw SQL or writing their own cursor stuff. Not even for application troubleshooting and support. Which got me wondering about the norm for web apps and if most people using a full stack web framework like Django were just using their out of the box ORM solutions, writing their own code for it, or something else.
It all sort of stemmed from the company I work for being acquired and me transitioning all of our DA and BI stuff to their large BI team. During the transition, I was a little surprised how one or two needed me to write a CTE or Stored Proc for them. But they all seemed to know Python. Which is where I am personally lacking.
I've been ingesting a lot of data from random APIs and writing things to insert into Postgres DBs and then analyzing that data using various Python methods. And writing all of that Python and my questions on cursors / a single cursor with multiple queries being met with "just use an ORM" had me curious what IF and other places using Django were doing.
I don't have any experience with Heroku. I've mostly worked with AWS and Azure. I use Azure Runbooks and PowerShell for a lot for automating higher end Infra such as updating domain accounts when HR data is updated or added.
This all stems from me not wanting to regress or stop moving forward after I transition all the BI stuff away. I definitely don't ever want to do data science as a career ever. But I still am fascinated with things like Pandas. You can pivot an entire dataframe with a line of code. And Pythom in general is useful because there's a package library for anything that cuts work in half by just writing a script to leverage those.
Thanks for the insight.
Do you feel like Heroku scales pretty well?