Cause oracle likely has a lot of low level hacks for some of its code (features, fixes, etc), which means that virtualizing it isn't so straight forward.

For some insight into maintaining the oracle db codebase: https://news.ycombinator.com/item?id=18442941

Franky, OracleDB is an old dinosaur. I do currently have work in it, but would be glad to never have to touch it again.

and some people said Macs are good for software developer even better than windows PC.

its kinda true because of macos is unix based. software develoment on front end app no issue on apple silicon but when it comes backend app, then this issue come out as u need to mingle with drivers/kernel that current backend solution is only optimize on x86/x64 or special platform like ibmpower/sparc

no one said Macs are for DBA.. owai...

Oracle is very powerful one leh ..
Where can u get bitmap index ?
SQL server didn't offer that ...
Though I hv been working in SQL server since my first career

wtf 2023 still using oracledb

full stack developer crying..

many companies using oracle db, do u think huge companies will easily migrate data to new databases?

I also started with SQL server but eventually u will come across Oracle if u switch company or work with different customers.

Very, very sorry to hear that. You're a much better/stronger/more patient person than I will ever be.

docker macos should be buleh

or use your apple silicon as thin client and remote into a windows server spec-ed properly to do development (e.g. 32gb ram/1tb storage)

invest in vps la brudder

During the intel era, this was true. Cause you can get a MBP, have bootcamp for pure windows env, or easily virtualise. The base env of macOS is unix based, so most of the unix tools work out of the box.

When they moved to their own arm based cpus, a lot of compatiblity break. Rosetta is pretty awesome, but devs sure suffer as you go lower level tech stacks.

PostfreSQL has bitmap indexes.

Nowadays got many services providing postgreSQL as service also, so you don't even have to maintain the version or hardware.



Luckily we have dedicated DBAs for more tedious stuff. Its still a PITA db to work on, feels like using some pre-svn version control vs git

Docker on mac sucks

Postgre client tools sux..unlike Oracle u have the SQL developer and ssms for SQL server .
SQL developer sux too la.bestest is ssmsvery friendly .
Oracle without semicolon at the end of statement will give error .sooo lame..

Got sucks meh? I use tableplus and I love it for many DBs. Even can connect to oracle.

Personally i think this sort of strictness is actually good

Postgre don't have official client tools .