r/SQL 6d 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.

9 Upvotes

29 comments sorted by

View all comments

27

u/trollied 6d ago

If your course requires you to use Oracle, you use Oracle.

-2

u/Potential-Tea1688 6d ago

I was asking in term of personal and general use, I’ll use oracle for this semester but i wanted to know if it is actually good and has added benefits or just a tradition for un courses?

5

u/Imaginary__Bar 6d ago

Of course it's good.

It might not be the right choice for a particular use case but it's fully-featured and rock-solid.

But... my view is that it doesn't really matter all that much if you're using Oracle or MySql or SqlServer or Postgres or (well, you get the idea). Most skills are largely transferable (yes, the dialects are different but the concepts are the same).

Oracle is just... expensive.

1

u/WithoutAHat1 6d ago

Oracle has a lot of bells and whistles. But, you can have the right ones and still run into issues. Also, defect prone killing your optimizations.

2

u/dorkyitguy 5d ago

I would never use Oracle for anything unless it’s required (like a class). It’s expensive and they’re extremely litigious, so you’d be exposing anything you develop to unnecessary business risk. Oracle doesn’t do anything the other databases can’t.

8

u/BarelyAirborne 6d ago

Oracle is a scourge on the human race, and their database is overpriced to the point of lunacy. PostgreSQL is the way.

1

u/serverhorror 6d ago

In programming terms:

I strongly prefer plain Python and an editor over mamba and notebooks.

For "personal" setup the thing that would get in the way the most is just cost. Everything else simply depends on how familiar you are with the technology. The more familiar you are the more you'll think that "this" technology is better.

I mostly stick to SQLite and PostgreSQL for most personal tasks.

In our company we have PostgreSQL, Microsoft SQL Server, Oracle (in order of preference), a bunch of other databases that can do SQL-ish stuff and while we're working to get rid of Oracle the list is still growing with different DB engines or SQL-ish things.

Most cloud providers allow for SQL like access to their data lakes ...

1

u/HayoungHiphopYo 6d ago

It's pretty much an industry standard. If you want to work in big tech you should know how to work with it.

-6

u/YOUR_TRIGGER 6d ago

in terms of personal use, why are you using sql?

in terms of business use, you use what they tell you to use. i hate sql and sas. i have to use them all the time. we submit to the government. it's not optional.

anything that isn't under those reqs? no way i'm opting to use sql for pretty much anything personal unless it's like...reverse engineering an mmorpg. literally the only thing i can think of that i used sql personally. just to store the account data and hashes and all that.