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.

Gauraw Meherkhamb

Jan 10

SQL Subqueries: Simplified

#sql #subqueries #database #beginners

2 min read

Franck Pachot for AWS Heroes

Jan 12

When are PostgreSQL prepared statements fully prepared for execution?

#postgres #sql #prepared #database

5 min read

Jan 12

Understanding the basics and advanced concepts of RDBMS and SQL for data science and analysis

#python #sql #sqlite #100daysofdatascience

11 min read

Vijay

Jan 12

Analysing Github Stars - Extracting and analyzing data from Github using Apache NiFi®, Apache Kafka® and Apache Druid®

#opensource #github #database #sql

9 min read

Elham Najeebullah

Jan 12

MySQL: How to create One-to-Many Relationship

#database #mysql #sql

6 min read

Henning

Jan 7

The best SQL function you never heard of

#sql #snowflake #oracle

5 min read

Franck Pachot for YugabyteDB

Jan 7

🚀Batched Nested Loop to reduce read requests to the distributed storage

#yugabytedb #sql #distributed #database

8 min read

Franck Pachot for AWS Heroes

Jan 7

Scalable Sequence for PostgreSQL

#postgres #yugabytedb #sql #database

6 min read

Jan 6

Limpando dados antigos de um banco de dados multi-tenant

#sql #database #orm

4 min read

Memgraph for Memgraph

Jan 10

The Benefits of Using a Graph Database Instead of SQL

#memgraph #database #sql #graphdatabase

10 min read

Anatolii Kozlov

Dec 31 '22

One-page Database cheat sheet

#interview #cheatsheet #database #sql

1 min read

Jan 4

Database 101: Data Consistency for Beginners

#beginners #database #sql #architecture

6 min read

Jan 6

SQL Commands Cheat Sheet

#sql #mysql #database #cheat

11 min read

Franck Pachot for YugabyteDB

Jan 6

Parallel export to CSV in YugabyteDB thanks to yb_hash_code() and PostgreSQL-compatibility

#yugabytedb #postgres #distributed #sql

3 min read

Stéphane Burwash for Potloc

Jan 6

Data Analytics at Potloc I: Making data integrity your priority with Elementary & Meltano

#meltano #dbt #dataquality #sql

7 min read

Asif

Jan 11

Get the count of affected rows with ease: The power of the RETURNING clause in Postgres

#postgres #sql #database #webdev

2 min read

Anne Quinkenstein

Dec 12 '22

SQL Cheet Sheat

#sql #beginners

2 min read

Franck Pachot for AWS Heroes

Jan 10

SQL doesn't need the "Single Table Design" but Composite Primary Keys

#sql #dynamodb #composite #keys

13 min read

Shrikanta Mazumder

Jan 9

What is database transaction?

#database #databasetransaction #databaseengineering #sql

2 min read

jbx1279

Jan 9

Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs？

#database #sql #programming #datascience

13 min read

Franck Pachot for YugabyteDB

Dec 19 '22

IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

#oracle #sql #postgres #compatibility

10 min read

Chris Farris for AWS Community Builders

Dec 27 '22

Mapping your AWS attack surface

#sql #cloudsecurity #opensource #aws

6 min read

Asif

Jan 4

Boost Your Query Performance with Function-Based Indexes in PostgreSQL

#postgres #sql #webdev #database

1 min read

Franck Pachot for YugabyteDB

Jan 3

Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

#yugabytedb #postgres #timeseries #sql

4 min read

Franck Pachot for YugabyteDB

Dec 14 '22

INSERT ON CONFLICT returning old values

#postgres #yugabytedb #sql #duplicate