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.
Hashing in Presto/Athena
dendihandian profile

Hashing in Presto/Athena

#sql #athena #presto
1
Comments
1 min read
Oracle AI Database 26ai (23.7) — Materialized Expression Columns
vahidusefzadeh profile

Oracle AI Database 26ai (23.7) — Materialized Expression Columns

#oracle #sql #linux #database
1
Comments
1 min read
How to Use SQL in Go
coding-with-patrik profile

How to Use SQL in Go

#sql #go #tutorial #programming
Comments
6 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has đŸ˜»
op3ratordec profile

Features I Wish MySQL Had but Postgres 🐘 Already Has đŸ˜»

#postgres #mysql #sql #database
5
Comments 2
5 min read
How to Create a New MySQL User and Grant All Permissions
msnmongare profile

How to Create a New MySQL User and Grant All Permissions

#mysql #sql #database #programming
Comments
2 min read
10 SQL Anti-Patterns You Must Avoid in Production
cristiansifuentes profile

10 SQL Anti-Patterns You Must Avoid in Production

#sql #database #performance #advancedsql
2
Comments
2 min read
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond
cristiansifuentes profile

SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

#sql #database
Comments
2 min read
How to check the same status of data in each row within a group with esProc
esproc_spl profile

How to check the same status of data in each row within a group with esProc

#programming #devops #sql #esproc
6
Comments
2 min read
Top 10 AI Reporting Tools in 2025
janeksmietanek profile

Top 10 AI Reporting Tools in 2025

#ai #sql #datascience
11
Comments
8 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd
konstantinas_mamonas profile

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

#database #sql #programming #performance
8
Comments
4 min read
Optimizing SQL queries for your AI Agents.
sten profile

Optimizing SQL queries for your AI Agents.

#ai #sql #python #database
6
Comments 2
4 min read
How to Self-Host PostgreSQL (with Monitoring)
therealfloatdev profile

How to Self-Host PostgreSQL (with Monitoring)

#sql #postgres #monitoring #devops
1
Comments
2 min read
Ecto for Elixir: A Beginner's Guide to Database Interactions
actor-dev profile

Ecto for Elixir: A Beginner's Guide to Database Interactions

#elixir #ecto #database #sql
1
Comments
3 min read
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
judith677 profile

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

#programming #dataengineering #sql #esprocspl
6
Comments 1
2 min read
SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications
adityabhuyan profile

SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

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