News for hackers. Stuff that matters.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by eastbound on Tuesday July 26, 2022 @03:27PM (#32242777)
I honestly don’t understand how Oracle is still alive. Postgres has so many of these killer features.

Also, I wonder how others do tenant separation, what other solutions there are.

Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by mritchie712 on Tuesday July 26, 2022 @03:31PM (#32242829)
Legacy.

If you have thousands of lines of code relying on Oracle the cost to migrate would be enormous.

Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by gav on Tuesday July 26, 2022 @03:59PM (#32243190)
Ignoring the cost, there's the risk/reward alignment you see in large enterprises.

Imagine you're a new CIO. You know you're probably looking at a 3-5 year tenure at this new company and you want to lead with some big wins to set the tone and show your value.

You're reviewing proposals from your senior leadership. One of the options is an Oracle migration. It could cost a million dollars to migrate, but you'd save a million dollars a year going forward. Oracle runs your mission-critical internal systems, any issues with the migration and the system you migrate to is going to cause significant financial and reputation damage. You'll have to defend this decision if anything goes wrong, i.e. you've absorbed a lot of risk but a lot less upside to you personally.

What do you do? You put the proposal to the side and look for something that has a lot better upside.

Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by beckingz on Tuesday July 26, 2022 @05:28PM (#32244300)
Exactly. The risk/cost profile for migrations is bad: If it goes well, decent return. If it goes poorly, catastrophic.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by slt2021 on Tuesday July 26, 2022 @09:02PM (#32245863)
lift and shift migrations dont really make sense. It would make sense to do architectural rewrite, from on-prem Oracle monolith to cloud native serverless stack for example. Digital transformation, yeah
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by kennethh on Wednesday July 27, 2022 @04:29AM (#32248134)
I worked in a bank previously and we migrated all our databases from Oracle to MS SQL Server. I think we used like 7-8 years to do it so I can understand people who are hesistant to convert. I think the advantages at the time (this was 10 years ago) was lower price for the db servers but also more people who are familiar with Sql Server compared to Oracle.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by toomuchtodo on Tuesday July 26, 2022 @03:35PM (#32242877)
Amazon has a great post on this topic.

https://aws.amazon.com/blogs/aws/migration-complete-amazons-...

I thought it was cool they retrained their Oracle DBAs into other roles as part of the project.

Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by spacemanmatt on Tuesday July 26, 2022 @04:47PM (#32243766)
I work with a few former-Oracle DBAs in a PostgreSQL-flavored consultancy now and they are aces. All the root-cause analysis and organization skills transfer handily.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by paulmd on Tuesday July 26, 2022 @05:12PM (#32244100)
Postgres is functionally and conceptually extremely similar to Oracle. There are a few oddities (in particular, oracle's "nulls are never in indexes" is kinda weird) but the redo log is similar to the WAL, etc. In most cases, similar approaches will perform similarly and experience pretty much transfers over with a few months of experience.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by abraae on Tuesday July 26, 2022 @06:59PM (#32245135)
Oracle has had the ability to do this for decades ("virtual private database"), so whatever is keeping them alive, it's nothing to do with this particular nifty Postgres feature.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by ibejoeb on Tuesday July 26, 2022 @10:08PM (#32246208)
PostgreSQL is a great product, but Oracle has so many more features. Even just in the query language. There's so much power embedded in just the model clause that would be all custom software in Postgres.

If you buy Oracle, you should use Oracle. Like really lean into it. If you really need it, it will be worth the money. I don't like dealing with Oracle sales, but the product is killer.

Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by throwaway787544 on Tuesday July 26, 2022 @06:58PM (#32245127)
They're like a tick. Very good at burrowing in and hard to remove. They have a lot of clients for whom a dozen million dollars is a drop in the bucket, and moving away is a decade-long millions-of-dollars project.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by revskill on Tuesday July 26, 2022 @03:35PM (#32242876)
Sharding is the only scalable way per my experience. The point about scalability here is, i can control the load as the data gets bigger.
Re:Shipping Multi-Tenant SaaS Using Postgres Row-Level Security by Scarbutt on Tuesday July 26, 2022 @05:22PM (#32244225)
oracle has flashback