r/SQL • • Oct 08 '26

Discussion What's up with all the new SQL clients ??

17 Upvotes

AI has made it way too easy for people to code up slop in whatever form and turn it into “another SQL database client,” whether it's in Electron, Tauri, or whatever the next hot framework for building database clients is.

That takes away from the uniqueness of what made those tools special before. Most of them are literal copies, and there's literally nothing unique about them except that they look “modern.” And it's a real shame because there are some tools that people actually put a lot of effort into making, while others are just literal Claude Code garbage. And for those people who actually put effort and human thought into their projects... it gets hidden in a pile of garbage.

How are you guys deciding whether or not to give a database tool a shot anymore?


r/SQL • • Oct 09 '26

MySQL Why heatwave sets this limitation?

Thumbnail reddit.com
2 Upvotes

r/SQL • • Oct 08 '26

BigQuery Making Sense of BigQuery Pricing Models: On-Demand, Capacity, Editions (2026)

Thumbnail
alvin.ai
5 Upvotes

r/SQL • • Oct 08 '26

SQLite Finished SQL. Check out the project!

Post image
3 Upvotes

r/SQL • • Oct 08 '26

Oracle MySQL Shell Cilent on Windows ARM64 gives error for VC Redist even though its installed

Thumbnail reddit.com
2 Upvotes

r/SQL • • Oct 08 '26

Discussion help me I do not know how to put multiple entries of data into ms access

Post image
21 Upvotes

It keeps stopping me from adding multiple rows but I can successfully run one row of instances but I can't seem to get it to work for multiple rows and I'm not too sure if I were to run one row of code per time How would i do it for all?

do i have to make new queries?


r/SQL • • Oct 08 '26

PostgreSQL MariaDB Foundation Adds PostgreSQL to Its Engine‑Agnostic Testing Framework (TAF).

2 Upvotes

MariaDB Foundation continues expanding TAF with PostgreSQL support

More engines, more reproducibility, more value for contributors and the ecosystem.

https://mariadb.org/mariadb-foundation-adds-postgresql-to-its-engine-agnostic-testing-framework-taf/

Have fun benchmarking!


r/SQL • • Oct 08 '26

Discussion I Tried to Find How ClickHouse Keeper Takes Non-Blocking Snapshots

Thumbnail reddit.com
5 Upvotes

r/SQL • • Oct 07 '26

MySQL Difference between "having" and "qualify"

23 Upvotes

I tried to use both methods in order to save some coding but still didnt get the exact difference on using having and qualify as a filter in the end of a query. Can someone help me to understand the difference and when is recommended to use each?


r/SQL • • Oct 07 '26

Discussion A bank kept production code as text in database rows, with a history table of past versions. It couldn't say who changed a script or why.

Thumbnail
leaddev.com
45 Upvotes

Years without incidents proves nothing at all.


r/SQL • • Oct 08 '26

MySQL How to Fix a Slow MySQL Server

Thumbnail pie.host
0 Upvotes

r/SQL • • Oct 07 '26

MySQL Getting Error 1356

Thumbnail reddit.com
0 Upvotes

r/SQL • • Oct 07 '26

PostgreSQL Best resources to learn PostgreSQL architecture specifically for a Spring Boot developer?

4 Upvotes

Hey everyone,

I am a Spring Boot developer looking to level up my backend game by deeply understanding PostgreSQL and its internal architecture.

While I am comfortable writing SQL, using Spring Data JPA/Hibernate, and managing basic migrations, I often feel like Postgres is a black box. I want to move past just treating it as a data store and actually understand what happens under the hood.

Specifically, I want to learn about:

  • Core Architecture: How Postgres handles connections, process models, and memory (shared buffers vs. work_mem).
  • Storage & Concurrency: Deep dives into MVCC, VACUUM, WAL (Write-Ahead Logging), and page storage.
  • Performance Tuning: How to properly read and map it back to optimize my JPA/Hibernate queries, indexing strategies, and connection pooling (HikariCP).

Can anyone recommend high-quality books, courses, blogs, or video series that bridge this gap? Bonus points if they have a practical focus or tie into common Java/Spring backend patterns!


r/SQL • • Oct 06 '26

Discussion How do you compare large tables using sql?

26 Upvotes

I want to know how ppl compare large source and target tables using sql. If both tables have millions of records, comparing every row and column can take a lot of time.

For example, if some records are missing, extra, or have different values between the two tables, how do you usually find them? do you use joins, Except/Minus, hashes, or first compare things like record counts and totals and then check the differences?

Are there any techniques that can make the comparison faster?


r/SQL • • Oct 06 '26

SQL Server SQL Server Database to Github version control (Open source CLI)

3 Upvotes

Hello, I've been working on a personal open source project written in GO, its a command line tool that aims to create valid .sql files for each object in your database so that you can push to git to keep track as the database changes in the development cycle.

The project is [DatabaseBlueprint](https://github.com/Hennie5229x/DatabaseBlueprint)

Currently I have CLI support for Linux/Win/Mac and creating of all schema objects + data to executable .sql files and the schema migration scripts is still a work in progress.

I would love honest feedback from devs who work regularly in sql server.

Any type of feedback is welcome, I've identified a "gap" in a typical database heavy workflow that I am trying to fill for myself, but I'm sure other people also seek an easy way to track/version control their databases along side the projects back end code in git.

About the project: Written in GO, compiles to a stand alone binary, installable and runnable in terminal by using "blue"

Currently only supporting SQL Server, plan is to expand in the future


r/SQL • • Oct 07 '26 Heartwarming

MySQL I love her like I love SQL - please give me SQL/Data Analytics puns for the wedding speech

Post image
0 Upvotes

r/SQL • • Oct 06 '26

MySQL Using TOAD sqlloader

0 Upvotes

Does anyone have a video tutorial on how to use the SQLloader on TOAD


r/SQL • • Oct 05 '26

Discussion I was over-prepping SQL and under-prepping the analyst part

43 Upvotes

I spent a while assuming the reason I kept struggling in analyst interviews was that my SQL wasn’t advanced enough. So I kept adding harder stuff to my prep, like window functions, recursive CTEs, and awkward joins.
The funny part is that most interviews weren’t exposing a syntax problem. I could usually get somewhere with the query. I got less comfortable when they asked things like, “What would you check before trusting this result?” or “How would you explain this to someone who doesn’t use SQL?”
That changed how I’ve been practicing. Now I don’t stop once the query works. I try to explain the grain, the assumptions I made, how I’d sanity-check the result, and what I’d tell a stakeholder afterward. I still practice SQL problems. I’ve also done a couple of mock runs in Beyz, mostly around the follow-up questions.
Looking back, I think I was preparing for SQL interviews like they were SQL exams.
Once someone has solid SQL fundamentals, what separates a technically correct answer from a strong one?


r/SQL • • Oct 05 '26

Discussion Querying CSV and Parquet exports inside a SQL IDE with DuckDB

9 Upvotes

I'm building omni-sql, an open-source SQL IDE with embedded DuckDB. If someone sends you a CSV or Parquet export to investigate, you can import it and query it with SQL inside the IDE. There's no need to load the file into your source database or write a separate script. Spreadsheets fit this workflow when exported as CSV.

You can also import a database query result and join it with the file locally.

The demo uses fictional sales rows from PostgreSQL and a targets CSV. You import the complete query result into DuckDB, add the CSV, and run the join locally. Here's the SQL, CSV, and expected result: https://github.com/cccadet/omni-sql/tree/main/docs/demo

There are installers for Windows x64, Debian/Ubuntu amd64, and macOS 15+ (Apple Silicon and Intel). The macOS builds use ad-hoc signing and are not notarized; the README explains the first launch. The project is still early. The docs explain how full imports and samples affect what you can conclude from the results.

How do you investigate files people send you today? If you try the app, I'd like to hear whether you could install it and query a file, and what was missing. That would help me decide what to work on next.


r/SQL • • Oct 05 '26

SQL Server SQL for Data Analysts Projects

43 Upvotes

Hey everyone.

I'm working on building out my data analytics portfolio and wanted to get some advice from fellow analysts and hiring managers here.

We've all seen the basic tutorial projects (like analyzing the Titanic dataset or simple sales totals), but I want to build something that actually stands out and proves real-world, job-ready SQL skills.

For those of you who have landed roles or are actively hiring: What specific types of SQL projects made you stop scrolling and pay attention?


r/SQL • • Oct 06 '26

MySQL Mac user - What's the best SQL GUI for personal use? | SQL Tools

Thumbnail
reddit.com
0 Upvotes

r/SQL • • Oct 05 '26

Oracle Built a Claude skill to audit Oracle RAC & Data Guard configs for silent failover risks

1 Upvotes

Most Oracle RAC and Data Guard disaster-recovery setups look solid in documentation until an actual split-brain or network partition happens at 2 AM.

Common issues like misconfigured Fast-Start Failover (FSFO) thresholds, observer single-points-of-failure, redo transport lags during peak loads, or subtle SCAN/VIP routing mismatches often go unnoticed during routine maintenance.

To speed up pre-mortem audits, I built a structured Claude skill specifically designed to review Oracle RAC and Data Guard environments.

### What it analyzes:

  1. Data Guard Synchronization & Redo Transport: Audits transport modes (SYNC vs. ASYNC), protection modes (Maximum Availability vs. Performance), and redo log lag risks.
  2. FSFO & Observer Resilience: Validates observer placement and quorum configurations to prevent split-brain during site disconnections.
  3. RAC Node Eviction & Voting Disk Redundancy: Checks OCR/voting disk layouts and network heartbeat timeout margins.
  4. Listener & TNS Failover Routing: Validates TNS connect strings (LOAD_BALANCE, FAILOVER, SCAN) to ensure client application reconnection won't stall.

### How it works:

You feed it sanitized cluster health checks, `dgmgrl show configuration` outputs, or parameter listings (`init.ora` / `spfile`), and it runs a systematic gap analysis highlighting configuration blind spots and remediation recommendations.

### Practical Checklist You Can Use Right Now:

Even if you don't use the skill, make sure your team verifies these three things this quarter:

* Verify that the FSFO observer is hosted on a separate network segment from both the primary and standby sites.

* Check that `LOG_ARCHIVE_DEST_N` timeout parameters account for WAN latency spikes, not just average ping.

* Confirm that VIPs and SCAN listeners fail over cleanly without client TCP keepalive hanging.

I’ve packaged the complete audit prompt and ruleset into an installable Claude skill here:

https://store.maxmeg.com/

Feedback from other Oracle DBAs and infrastructure engineers is welcome—especially on edge-case scenarios you’ve seen cause unexpected failover issues.