4 ms·
> I would think that the way to do this would be to The devil as always Is in the details. The real problem comes With stored procedures. Maybe this is why I s
by le-mark 3y ago
> I would think that the way to do this would be to
The devil as always Is in the details. The real problem comes With stored procedures. Maybe this is why I shy away from their used to this day. The last migration I did to Postgres wasn’t too bad; the app had only a few basic stored procedures.
- icedchai 3y agoMany legacy apps use tons of them. In the late 90's there was a style of application development where all DB access went through stored procedures. I find PL/SQL to be terrible.
- marcosdumay 3y agoPL/SQL is terrible. But organizing your Oracle database in a way where you can do everything with only application-accessible statements is even worse. Oracle places still do a lot of stored procedures.
- kamaal 3y agoThere are still tons of PL/SQL developers, and a huge ecosystem that uses these things. Triggers were big at one time too. You will be surprised how H1B 'specialised talent' developers are just people who have worked on these ancient technologies all life, are near impossible to replace so you are left with no options but to hire them. Oracle is a whole different specialisation in itself and its tentacles go very deep and afar.