been 20 years building database driven application using java + oracle. I found that an app instilled with ORM ended up being a horrible nightmare. stored procedure is way much better in most aspect.
Hi Ray, I respect your decision. What is ORM's deal breaker for you ? ORM performance has increased significantly in recent year. Thank you, Vikas Kerni
I like the Store procedure Approach where we can easily establish a relationship between tables + performing better when we insert a large amount of data using XML + easy to deploy. I found the only drawback is unit testing.
Hi Ajit, People end up writing lot of business logic inside stored procedures which makes it more difficult to unit test and maintain. Take care, Vikas
Hi Vikas. I love the video. Very nice comparison. I’m actually torn between the two. I had someone build an application for me using raw SQL queries via SQLAlchemy and then pass the result to Pandas. Now I’m having a different developer refactor the code to use the django ORM. As a non-developer, I’m not sure what is best for this application. Performance is not critical though the application should be robust. I do plan for the application to evolve considerably. I’m also concerned about finding developers in the future that can pick up up the code and work with it. Any guidance would be appreciated my friend.
I rewatched the video a few times and I think you answered my question already. I think going with the ORM is the way to go for me. Let me know if you have any comments about it.
Hi Kamil, I would not refactor sql queries for existing applications or functionality to ORM. I would definitely refactor stored procedures to ORM on case to case basis. I would definitely use ORM for new applications and functionality. Vikas
Yes, those are certainly important factors I considered. I’m continuing to have my new developer we factor the code to use the Django ORM for many reasons including the fact that I want to expand this application to have new features.
Subscribe to this channel for your regular updates by clicking the following link
rb.gy/u1z0k0
been 20 years building database driven application using java + oracle. I found that an app instilled with ORM ended up being a horrible nightmare. stored procedure is way much better in most aspect.
Hi Ray,
I respect your decision.
What is ORM's deal breaker for you ?
ORM performance has increased significantly in recent year.
Thank you,
Vikas Kerni
Ray,
You have acquired a comfort zone.
I like the Store procedure Approach where we can easily establish a relationship between tables + performing better when we insert a large amount of data using XML + easy to deploy. I found the only drawback is unit testing.
Hi Ajit,
People end up writing lot of business logic inside stored procedures which makes it more difficult to unit test and maintain.
Take care,
Vikas
Thank you for this video. It was really insightful
You are welcome, Damilola
Hi Vikas. I love the video. Thanks for sharing
You are welcome, Shekhar
I use both on same server ~
Hi Vikas. I love the video. Very nice comparison.
I’m actually torn between the two. I had someone build an application for me using raw SQL queries via SQLAlchemy and then pass the result to Pandas. Now I’m having a different developer refactor the code to use the django ORM. As a non-developer, I’m not sure what is best for this application. Performance is not critical though the application should be robust. I do plan for the application to evolve considerably. I’m also concerned about finding developers in the future that can pick up up the code and work with it. Any guidance would be appreciated my friend.
I rewatched the video a few times and I think you answered my question already. I think going with the ORM is the way to go for me. Let me know if you have any comments about it.
Hi Kamil,
I would not refactor sql queries for existing applications or functionality to ORM. I would definitely refactor stored procedures to
ORM on case to case basis. I would definitely use ORM for new applications and functionality.
Vikas
Thank you, and I hope your channel grows. You have great content.
Also you are looking for ease of maintenance and training new developers , ORM is a big plus
Yes, those are certainly important factors I considered. I’m continuing to have my new developer we factor the code to use the Django ORM for many reasons including the fact that I want to expand this application to have new features.
Complex queries can only be written in views and stored procedurs. So Sps are best. Big no to ORM
ORM is a better solution overall I Believe.
1- Fast and continuous delivery
2 - Code versioning
ORM.
project maintainable is first.
Performance is second.