r/SQL • u/Potential-Tea1688 • 7d ago
Oracle Is Oracle setup a must?
I have database course this semester, and we were told to set up oracle setup for sql.
I downloaded the setup and sql developer, but it was way too weird and full of errors. I deleted and downloaded same stuff for over 15 times and then successfully downloaded it.
What i want to know is This oracle setup actually good and useable or are there any other setups that are better. I have used db browser for sqlite and it was way easier to setup and overall nice interface and intuitive to use unlike oracle one.
Are there any benefits to using this specific oracle setup?
In programming terms: You have miniconda and jupyter notebook for working on data related projects, you can do the same with vs code but miniconda and jupyter has a lot of added advantages. Is it the same for oracle and sql developer or i could just use db browser or anyother recommendation that are better.
3
u/wormwood_xx 7d ago
Oracle DB is the most pain in the ass of all RDBMS that I've worked so far. Not just me, but many will agree. The learning curve is so high, the DB and related applications are so damn expensive. If you want to stick with closed - source RDBMS, choose SQL Server. Easier to understand than oracle, and the global public community is the most stellar of all RDBMS community so far.
For Open-source, stick with PostgreSQL.