Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Katie

Aug 11 '22

UNPIVOT to key-value pair in Oracle SQL

#database #sql #oracle

1 min read

Sep 8 '22

Stuck in SQL query

#challenge #sql #todayilearned #mysql

2 min read

Sep 9 '22

MySQL Queries: Basics of MySQL

#mysql #sql #database #datascience

9 min read

Horia Constantin

Sep 6 '22

Book summary: SQL Antipatterns

#sql

9 min read

Jānis Veinbergs for DEAC European Data Center Operator

Aug 3 '22

SQL Server Query Optimizer. And how it can hang your business.

#sql #performance

8 min read

Robertopaolo Ramirez

Sep 2 '22

My first CRUD in Python without ORM

#beginners #python #docker #sql

4 min read

Franck Pachot for YugabyteDB

Sep 1 '22

Read local partition first, then global if not found locally

#sql #distributed #database #yugabytedb

7 min read

Aug 31 '22

Django eficiente - select_related

#django #python #orm #sql

3 min read

Aug 30 '22

how to search jsonb column in Postgresql ( not nested column )

#help #sql #postgres

1 min read

Aug 29 '22

Is it possible to reference one column as multiple foreign keys? ( PostgreSQL )

#help #postgres #sql

1 min read

Aug 9 '22

MariaDB Quick-tip #8 - All foreign key constraints

#mysql #sql #mariadb

1 min read

Learn2Skills for AWS Community Builders

Aug 26 '22

Now AWS supports setting up connectivity between your RDS database and EC2 compute instance in 1-click

#aws #security #sql #cloud

2 min read

Franck Pachot for AWS Heroes

Aug 23 '22

pg_hint_plan with subqueries

#postgres #pghintplan #sql #join

4 min read

Aug 23 '22

MariaDd Quick-tip #10 - Select table definition

#sql #mysql

2 min read

Franck Pachot for YugabyteDB

Aug 19 '22

Parallelizing aggregates in YugabyteDB

#yugabytedb #distributed #sql #count

4 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.