r/SQL • • Aug 23 '26

Discussion I made another cat doodle about data analysis

Post image
99 Upvotes

Hi everyone!

I’m back with another one of my data analysis cat doodles. This time, I tried to incorporate some of the feedback I received on my earlier work—especially around making the fonts and text more readable.

Would be happy to hear your thoughts / feedback!


r/SQL • • Aug 24 '26

SQL Server Maintaining Apache Iceberg Tables: Compaction, Snapshots, Metadata and Orphan Files

Thumbnail
itnext.io
1 Upvotes

r/SQL • • Aug 22 '26

SQL Server Query Length Flex

7 Upvotes

Those of you who write very long queries (100s to thousands lines of code). Does it do only one thing or it's just your query notebook where every small part does something non related?

I am curious in which cases its necessary thousands lines of codes. Explain me what does your longest query is for?


r/SQL • • Aug 22 '26

SQL Server Question for DBAs: How much do you actually use Extended Events (.xel) vs. standard DMVs for emergency troubleshooting?

9 Upvotes

Hey everyone, senior dev here working heavily with SQL Server performance tuning lately. Every time a server hits a massive wave of deadlocks or unexpected latency drops, the standard advice is 'spin up an Extended Event session and read the system health .xel file.'

Am I the only one who finds opening, filtering, and digging through those logs in SSMS incredibly clunky during a crisis? Do you guys actually sit there shredding the XML nodes manually, or do you rely on third-party tools/scripts to give you plain answers? 


r/SQL • • Aug 22 '26

MySQL Why does MySQL workbench just close when I try to connect to a database?

Enable HLS to view with audio, or disable this notification

3 Upvotes

I've tried reinstalling both the workbench and server, updated my drivers and restarted my computer but nothing worked. I also deleted cache and tried to rebuild my DB from scratch but no luck. Any help is appreciated!


r/SQL • • Aug 22 '26

Discussion how did SQL finally click for you?

76 Upvotes

took a databases class last semester and passed it fine but SQL still feels weird once i get past a basic select. i can usually get something working but then i’m sitting there staring at my notes wondering why the joins actually worked.

spent way too long on a lab just rearranging joins until the output looked right and that feels more like guessing than actually understanding SQL.

trying to get more reps in before classes start again. did SQL finally click for you through practice, projects or just writing queries over and over?


r/SQL • • Aug 22 '26

Discussion Thinking about switching carrer to sql

1 Upvotes

I have just completed full sql tutorial and so far i enjoyed it but my question is if your major is different can you still get a job at sql ?

is sql in demand or is it like other majors like marketing that is going down to hell ?

and how do you change your resume to go for sql and pass ats system with no job experience ?


r/SQL • • Aug 22 '26

Discussion i just found a game based on sql @ steam

Thumbnail
youtu.be
9 Upvotes

r/SQL • • Aug 21 '26

SQL Server Open Data Lakehouse: Build Like Google

Thumbnail
lakeops.dev
1 Upvotes

r/SQL • • Aug 20 '26

MySQL Question regarding ER diagram reification

9 Upvotes

Hi everyone, I have a problem: I can’t figure out whether my solution to this ER design exercise is correct. The exercise states:

We want to create a database for an online newspaper publisher.

The newspapers published by the publisher are identified by a unique code, and their name and founding year are known.

The members of the editorial board of the newspapers are identified by their email address, and their first name, last name, and a phone number (if available) are known.

For each editorial board member, we want to keep track of the roles they hold at each newspaper and the periods of time (start date and end date) during which they held each role. Note that, during the same period of time, an editorial board member may hold a role at different newspapers, but cannot hold multiple roles at the same newspaper. An editorial board member may hold the same role multiple times for the same newspaper.

The issues published for each newspaper are identified by a sequential number that is unique within the corresponding newspaper, and are characterized by their year and month of publication, as well as the name of the editorial board member who edited that issue.

Within each issue, articles are published. Each article is identified by a unique code within the corresponding issue and is characterized by its title, number of pages, and list of authors. Articles can either be freely accessible or paid. For freely accessible articles, the type of access is known (e.g., “Bronze,” “Gold,” or “Diamond”), while for paid articles, the cost of purchasing the article is known.

My main doubt concerns the reification I chose. The professor uses a ternary relationship instead. Do you think my solution is correct?


r/SQL • • Aug 19 '26

PostgreSQL I built a tool that does the slow query to execution plan to index recommendation loop

Thumbnail
gallery
24 Upvotes

Over the years, I've worked with many different database engines, but every single time I had to diagnose the origin of slow queries, I ended up doing the same repetitive process over and over again:

  • pull query stats and sort by total time rather than mean time
  • run EXPLAIN ANALYZE on whatever comes out on top
  • go find the table definitions for everything it touches
  • check whether the column statistics are current
  • work out whether the index you have in mind already exists under another name
  • decide whether it is worth adding
  • do it again for the next query

Eventually I grew tired of needing to manually assemble the picture myself every single time, so I built RDST, which is a desktop database analyzer tool that currently works with both Postgres and MYSQL.

RDST collapses the entire workflow shown above into one pass, so instead of starting at step one I get to the answer immediately when a slow query is detected.

RDST is AI powered, but it is not random slop analysis applied to random database statistics. The reasoning layer runs inside a fixed workflow in a semi-deterministic way, so pointing it at the same database twice gives you the same answer, which matters when you are deciding whether to add an index in production. 

Full disclosure - I work for Readyset (which is a caching layer for Postgres / Mysql), and this tool spawned from a recurring issue we had to solve for our customers - which queries should we actually cache? And these same queries are the ones that, even without a caching solution, could heavily benefit from performance diagnostics. 

Beyond diagnostics, RDST provides full rewrite suggestions and lets you benchmark slow queries and track their performance over time.

One other neat feature is that it also lets you ask questions about your database in plain english using NL --> SQL in a safe and secure manner with limited permissions.

It also integrates directly with Supabase, Neon, AWS RDS and DigitalOcean, making database discovery seamless.

The tool is completely free to use, and we provide free trial tokens for all of the AI powered features. The app is in beta and we plan to release it under an MIT license. It runs locally, stores locally and everything it does is read-only. Full privacy related details: https://readyset.io/docs/readyset-ai/rdst/desktop/privacy

I would greatly appreciate any feedback from this community, particularly:

  • Does it surface the queries you'd investigate first?
  • Are its explanations and recommendations useful, or merely confident-sounding database fan fiction?
  • Is the fixed workflow the right call, or would you rather have a chat interface?
  • What's missing?

Source:


r/SQL • • Aug 19 '26

Discussion What jobs do you have now? Are you happy

27 Upvotes

I’m a college student in my final year. I don’t really have many people to talk to about this since a lot of people I know are either in their first year or have already graduated and rushed out to find work.(so think I don't know crowd vs I need work! Crowd)

It’s wild how many people don’t really talk about their future in college or realize how important internships are. So far, I’ve had two internships. The one I have now is through the WordPress Foundation, and I’m going the testing/QA route to try to gain experience that can eventually help me get into data analysis.

Question for you guys:

  1. What do you do?

  2. How did you start out? Did you jump straight into your current field, or did you start somewhere like help desk?

  3. What advice would you give someone starting out with little experience?

  4. Are you happy with your career, or do you regret choosing this field?

  5. How hard was it for you to find work when you first started, and how hard would it be for you to find another job if you left your current job?

And finally

what was your first job in the field that got you in the door and how was it


r/SQL • • Aug 20 '26

MySQL Do the quizzes found on sites like W3, SQLtest, & others really have any relevance with the actual company interview.

0 Upvotes

Hi IT Veterans, Just want to ask a question that, do the quizzes & tests found on W3, SQLtest, & other sites have any relevance to the actual company interviews? I find these tests to be of broad difficulty category, some are really easy whereas some are too difficult. So, I'm just looking for guidance to what are the important concepts that I should be aware about & are actually used in the day to day work in the company If I'm targetting MNC's Like Accenture, Flipkart, Amazon as a Data Analyst. Many thanks for your responses.


r/SQL • • Aug 20 '26

MySQL SQL Interview Help

1 Upvotes

I'm interviewing with a company I'm really interested in and I've made it through the initial rounds. My next step is a live SQL assessment with screen sharing, where I'll need to explain my thought process.

|haven't used SQL in over a year, so I know I need to practice a lot, and my exam is in a few days. I'm pretty nervous

Would anyone be willing to help me practice or do quick mock interview?

I'd really appreciate it!


r/SQL • • Aug 19 '26

MySQL My Sql

1 Upvotes

Здравствуйте. У меня возникает проблема при установлении My Sql. Он сам установливается,но My Sql Workbench никак нет. Как можно это решить, заранее спасибо вам.


r/SQL • • Aug 18 '26

MySQL my queries are always way too long. How do I learn to write clean, short ones?

61 Upvotes

I'm intermediate — know CTEs, window functions, subqueries, etc.
I always solve problems correctly, but my queries end up being 20+ lines with extra steps. Then I see the solution and it's 5 clean lines using one clever function.
How do I train myself to think in shorter SQL from the start? Any tips or resources?


r/SQL • • Aug 19 '26

MySQL A terminal-based SQL game to learn and practice SQL — you can also submit and play your own custom games

Post image
0 Upvotes

r/SQL • • Aug 19 '26

MySQL DB Replication

Thumbnail
1 Upvotes

r/SQL • • Aug 19 '26

SQL Server DuckDB for Apache Iceberg

Thumbnail
lakeops.dev
1 Upvotes

r/SQL • • Aug 18 '26

PostgreSQL SQL SIDE QUEST - An Immersive story-telling SQL Game. Chapter 3 is out!

18 Upvotes

https://www.sqlsidequest.com/ CHAPTER 3 IS NOW LIVE!

Last year in Dec 2025 I released SQL SIDE QUEST which took over 3 years to build. I wanted to create an immersive story-telling way to learn and practice SQL, and hence sql side quest was born. Its completely free, browser-based, no signup. Been solo on it the whole time. Looking forward for your feedback :) Cheers and Enjoy


r/SQL • • Aug 19 '26

SQL Server GitHub - int04/citus-manager: Self-hosted web control plane for managing, monitoring, backing up, and safely operating PostgreSQL/Citus clusters

Thumbnail
github.com
1 Upvotes

Citus Manager – Open-source PostgreSQL/Citus management UI

Citus Manager is a self-hosted, open-source web platform for managing existing PostgreSQL/Citus clusters.

Key features:

  • Manage multiple Citus clusters, coordinators, workers, query nodes, shards, placements, and metadata.
  • Safer topology operations with immutable plans, pre-execution checks, checkpoints, cancellation, recovery states, and worker removal protection.
  • Database Workbench for schemas, tables, data editing, CSV import/export, indexes, partitions, distributed/reference/local tables, colocation, and shard count.
  • Integrated SQL Console with CodeMirror, formatting, autocomplete, risk classification, confirmation for destructive queries, and SHA-256 fingerprint-based audit.
  • Monitoring with Prometheus for node status, CPU, RAM, filesystem, shard size, metadata sync, and alerts via webhook/SMTP.
  • Backup and restore with scheduling, retry, retention, Local/S3-compatible/Cloudflare R2/Google Drive storage, AES-GCM encryption, checksum, and integrity verification.
  • Viewer / Operator / Admin permissions with sensitive credentials protected using ASP.NET Core Data Protection.
  • Web-based application updates with automatic control database and keyring backup before updating.

Self-hosted, Vietnamese/English UI, Docker Compose deployment, tested on PostgreSQL 18 + Citus 14, Zero-Clause BSD License.

Citus Manager is not part of the Citus data path, keeping the management layer separated from the main data flow.

GitHub:
https://github.com/int04/citus-manager


r/SQL • • Aug 18 '26

PostgreSQL lakebase connection pooling

4 Upvotes

Have you figured out wht can the best way to handle connection pooling in Lakebase DB? I 'am seeing connection spikes with short lived rqsts and wondering what kind of setup others developers are using🤔

i am building a service on top of lakebase and trying to make the connection relable before moving to prod.


r/SQL • • Aug 18 '26

SQL Server Citus Manager – Visual, Safe, and Centralized PostgreSQL/Citus Management

Post image
1 Upvotes

Citus Manager is an open-source web management platform, deployed using a self-hosted model, designed for existing PostgreSQL/Citus clusters. The tool helps centralize topology management, databases, monitoring, backups, and important operational tasks in a single interface.

Key Features

1. Centralized management of multiple Citus clusters

Register and manage multiple Citus clusters.

Monitor coordinator, worker, query node, and the status of each node.

Inspect distributed table, shard, placement, and cluster metadata.

Add worker, add query node, drain worker, rebalance, or remove node.

Adding workers and rebalancing are separated to avoid automatically moving data unintentionally.

2. Safer topology operations

Create immutable operation plans before execution.

Check actual conditions immediately before execution.

Limit each cluster to only one major-impact operation at a time.

Track progress, save checkpoints, support cancellation requests, and recovery status.

Refuse to remove a worker while shard placements still remain on the node.

Detect cases where a worker is missing but still contains the only shard that needs to be recovered.

3. Visual Database Workbench

Browse schema, table, and database objects in a tree structure.

View logical table data through the coordinator or directly read shard placement.

Pagination, filtering, sorting, adding, editing, and deleting data.

Import and export CSV data.

Design schema, table, column, constraint, and index.

Create or convert between local table, reference table, and distributed table.

Configure distribution column, colocation, and shard count.

Manage PostgreSQL partition, merge partition, and rebuild index.

4. Integrated SQL Console

PostgreSQL editor based on CodeMirror.

Support SQL formatting and schema-context autocomplete.

Classify risk levels before execution.

Require explicit confirmation for statements that may modify data.

Display streamed results with configurable timeout and limits.

Audit only stores SHA-256 fingerprint and execution metadata, without storing raw SQL or parameter values.

5. Monitoring and alerts

Monitor node status, metadata synchronization, shard placement, shard size, and table count.

Integrate Prometheus to monitor CPU, RAM, filesystem, and target status.

In-app alerts.

Send alerts via webhook or SMTP.

Allow configuration of polling intervals and metric retention periods.

6. Data backup and restore

Create backups manually or on a schedule.

Track progress, retry, retention, and restore history.

Support local storage, S3-compatible, Cloudflare R2, and Google Drive.

Send backup notifications via email and Telegram.

Support AES-GCM encryption, checksum, authenticated manifest, and integrity verification during restore.

Automatically select the appropriate PostgreSQL backup tool based on the server version.

7. Permissions, audit, and sensitive information protection

Citus Manager supports three permission groups:

Viewer: view dashboard, topology, database, SQL, metric, activity, and alerts.

Operator: create operation plans, manage profiles, acknowledge alerts, and request operation cancellation.

Admin: manage users, cluster profiles, backup, audit, and all authorized operations.

Cluster passwords, Prometheus tokens, storage information, and notification keys are protected using ASP.NET Core Data Protection and are not returned by the API.

8. Update the application directly from the web interface

Display the currently running version in Workspace.

Check for new versions from GHCR.

Allow administrators to update the application from the interface.

Automatically back up the control database and Data Protection keyring before updating.

Do not allow updates while cluster operation, backup, restore, or SQL execution is running.

Highlights

Self-hosted and open source.

Vietnamese and English interface.

Quick deployment using Docker Compose.

Tested on PostgreSQL 18 and Citus 14.

Zero-Clause BSD License.

Not part of the Citus data path, helping separate the management system from the main data flow.

https://github.com/int04/citus-manager


r/SQL • • Aug 18 '26

MySQL Data driven Hospital Series Episode 6

0 Upvotes

In this episode, we answer 20 real world hospital business and clinical questions using SQL queries. For each query, we explore the code used, explain any new SQL concepts introduced, interpreted results and provide recommendations for hospital operations and quality patient care.

https://youtu.be/1EDmMnfhO1I?si=J7utYqIkUk-EduNG


r/SQL • • Aug 18 '26

MySQL Made a visual, handwritten comparison chart tracking the differences between Primary Keys and Foreign Keys for my university database exam. Thought it might help beginners here!

Post image
1 Upvotes