DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub
deployhq profile

How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub

#ai #docker #dbhub #sql
Comments
10 min read
Optimizing SQL LIKE Security, Performance and Best Practices
intersystemsdev profile

Optimizing SQL LIKE Security, Performance and Best Practices

#sql #programming #beginners #tutorial
Comments
10 min read
SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL
ibrahimabdulrasaq profile

SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

#sql #data #analytics #analyst
Comments
4 min read
Using LIKE with Variables and Patterns in SQL
intersystemsdev profile

Using LIKE with Variables and Patterns in SQL

#sql #programming #tutorial
Comments
10 min read
A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files
nchika profile

A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files

#showdev #sql #go
Comments
3 min read
Computed columns in D365FO – Using Correlated Subqueries with Real SQL
ni_klaus_4eb1581f851becee profile

Computed columns in D365FO – Using Correlated Subqueries with Real SQL

#dynamics365fo #sql #tutorial
1
Comments
2 min read
How I Automated 90% of Data Requests Using LLM-Powered SQL Generation
osmanuygar profile

How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

#ai #python #sql #architecture
5
Comments 2
7 min read
Database Transactions and ACID Properties: Guaranteeing Data Consistency
outdated-dev profile

Database Transactions and ACID Properties: Guaranteeing Data Consistency

#database #sql #softwareengineering #acid
Comments
8 min read
EP 13: SQL Injection Isn't Dead - It Just Evolved
hrishikesh_dalal_ced8f95e profile

EP 13: SQL Injection Isn't Dead - It Just Evolved

#database #security #backend #sql
1
Comments
3 min read
PART 5 — The Rise of Network SQL (N-SQL)
peacebinflow profile

PART 5 — The Rise of Network SQL (N-SQL)

#lawn #sql #nsql #programming
4
Comments
26 min read
dupl
query_filter_591122b53770 profile

dupl

#sql #dataengineering #backend #database
Comments
1 min read
catalog
query_filter_591122b53770 profile

catalog

#code #database #sql
Comments
1 min read
Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join
rebooter_s profile

Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join

#sql #mysql #sqlflash
Comments
5 min read
Introducing the All-New SLS SQL Copilot
observabilityguy profile

Introducing the All-New SLS SQL Copilot

#sql #programming
Comments
15 min read
I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.
zeredbaron profile

I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.

#sql #python #ai #security
6
Comments 2
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.