r/SQL • u/Mindless-Piece-47 • 18h ago

MariaDB MariaDB Foundation has been pushing hard toward transparent, reproducible performance change detection.

0 Upvotes

0 comments

r/SQL • u/Suspicious_Orchid770 • 19h ago

Discussion What’s next for DORA?

leaddev.com

2 Upvotes

What does the legacy of DORA say about the modern tech industry?

2 comments

r/SQL • u/withvicky_ • 19h ago

Discussion Career advice

23 Upvotes

I'm 27M. Hey everyone, my life has been a little different from that of most people, and I don't have a strong educational background.

Right now, I'm working at a grocery store, but I want to improve my life and learn some stable, valuable skills that can help me earn a reliable income.

I've come across these four skills:

Python

SQL

Excel/Spreadsheets

Power BI/Tableau

I don't know much about these skills or their demand, competition, value, and future prospects.

Technology is constantly evolving, trends are changing, and AI is replacing some jobs. The value of different skills also changes over time.

Before I start learning, I want to understand whether these are the right skills to invest my time in for a stable career and income in the long run.

I'd appreciate your advice. Should I go for these skills, or would you recommend something else?

14 comments

r/SQL • u/Total-Produce-8745 • 14h ago

SQL Server DBeaver Community vs Beekeeper Studio: which do you actually use day to day?

15 Upvotes

Genuinely want to hear from people who’ve used both DBeaver and Beekeeper Studio in real work, not just tried them once.

DBeaver Community is free and supports almost every database under the sun, but some people find it clunky. Beekeeper Studio has a free open-source edition plus paid tiers, and it gets mentioned a lot for being cleaner and faster.

Which one do you reach for daily, and why?

If you’ve paid for a database GUI (either one, or something else), was it worth it over the free version? What tipped it for you?

For teams: does anyone share connections or saved queries across the team, and how do you handle that? Do you have a team plan in place with either provider?

Any dealbreakers on either side, like performance, database support, stability, or UI?

Not looking for a best tool ever answer, just real experiences and feedback. Would especially love to hear from people working at larger orgs or with stricter security requirements.

12 comments

Subreddit

Posts

Wiki

News and Notes on the Structured Query Language

r/SQL

The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions.

Members Active

292.8k

Sidebar

The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions.

Filter Posts

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]
[Oracle]
[MS SQL]
[PostgreSQL]
etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Help posts

If you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1),
  a.field2,
  SUM(b.field4) 
FROM a INNER JOIN b 
  ON a.key1 = b.key1 
WHERE a.field8 = 'test' 
GROUP by a.field1, 
  a.field2 
HAVING SUM(b.field4) > 5 
ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

Learning SQL

A common question is how to learn SQL. Please view the Wiki for online resources.

Note /r/SQL does not allow links to basic tutorials to be posted here. Please see this discussion. You should post these to /r/learnsql instead.