Re:Distinct on: a confusing, unique and useful feature in Po...
by irrational on Friday March 20, 2020 @05:08PM
(#22641678)
Do you mean portable as in able to run on different databases? Your application would have to be fairly simple to achieve that goal. We moved an application from Oracle to Postgres. It took about 2 years to complete.
[ Parent
| on HN ]
Re:Distinct on: a confusing, unique and useful feature in Po...
by cosmotic on Monday March 23, 2020 @07:24PM
(#22669992)
Many applications are built on ORMs which are pretty portable. About the only thing I regularly depend on that is proprietary per RDBMS is "last insert autoincrement id" since it's not part of the SQL standard. Binary blobs is another big one.
Re:Distinct on: a confusing, unique and useful feature in Po...
by cosmotic on Monday March 23, 2020 @07:22PM
(#22669974)
If you start out minimizing proprietary features, its a lot easier to do. Oracle is filled with proprietary features so I'm not surprised it was a lot of work. My application is pretty simple and I converted from mysql to postgres in an afternoon.