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 Get the Raw SQL Query from Laravel Query Builder
msnmongare profile

How to Get the Raw SQL Query from Laravel Query Builder

#sql #laravel #programming #beginners
1
Comments
3 min read
Oracle AI Database 26ai — Automatic SQL Transpiler Feature
vahidusefzadeh profile

Oracle AI Database 26ai — Automatic SQL Transpiler Feature

#sql #oracle #database #linux
Comments
1 min read
Building an ELT Pipeline with Python and SQL Server: A Netflix Dataset Walkthrough
oramirezperera profile

Building an ELT Pipeline with Python and SQL Server: A Netflix Dataset Walkthrough

#python #sql #elt
7
Comments 1
6 min read
Deduplicate between an uncertain number of columns：SQL VS SPL #15
esproc_spl profile

Deduplicate between an uncertain number of columns：SQL VS SPL #15

#sql #programming #devops #esproc
7
Comments
2 min read
Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript
vzakharchenko profile

Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

#atlassian #forge #drizzle #sql
Comments
2 min read
The Life of a Query in SQL - It's More Dramatic Than You Think 😨
locnguyenpv profile

The Life of a Query in SQL - It's More Dramatic Than You Think 😨

#database #sql #programming #beginners
5
Comments
2 min read
One SQL Query That Could Destroy Your Entire Database (And How Hackers Use It)
yuvasec profile

One SQL Query That Could Destroy Your Entire Database (And How Hackers Use It)

#cybersecurity #sql #php #privacy
6
Comments
5 min read
Payment data processing
shounak_das_2b2eadc87d9f6 profile

Payment data processing

#backenddevelopment #python #sql
Comments
1 min read
Foreign Keys: A must in SQL, but not in a Document Database?
franckpachot profile

Foreign Keys: A must in SQL, but not in a Document Database?

#mongodb #sql #database #postgres
21
Comments
7 min read
Hacker rank's Median SQL Solution
meghanananju profile

Hacker rank's Median SQL Solution

#sql #hackerrank #tircky #programming
1
Comments
3 min read
The World Is Too Messy for SQL to Work
franckpachot profile

The World Is Too Messy for SQL to Work

#sql #database #relational #document
21
Comments 15
10 min read
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within
mikekenneth77 profile

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

#duckdb #sql #database #performance
3
Comments
6 min read
(Beyond) The Art of Database Indexing
benedetto_proietti profile

(Beyond) The Art of Database Indexing

#schema #nosql #sql #bigdata
1
Comments
3 min read
Desire for Structure (read “SQL”)
benedetto_proietti profile

Desire for Structure (read “SQL”)

#schema #nosql #sql #bigdata
1
Comments
10 min read
SQL Temporary Tables: A Quick and Practical Guide
dbvismarketing profile

SQL Temporary Tables: A Quick and Practical Guide

#sql
1
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.