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.
This SQL solution is GENIUS!!🤩

This SQL solution is GENIUS!!🤩

1
Comments
2 min read
Eliminar todos los procedimientos almacendos con un sentencia SQL Server.

Eliminar todos los procedimientos almacendos con un sentencia SQL Server.

1
Comments
1 min read
sqltrace: A low-code intrusion library that provides SQL tracing capabilities

sqltrace: A low-code intrusion library that provides SQL tracing capabilities

6
Comments
2 min read
Journey to SQLAlchemy for Beginners - The Genesis

Journey to SQLAlchemy for Beginners - The Genesis

2
Comments
3 min read
Snowflake data pipeline with Kestra

Snowflake data pipeline with Kestra

1
Comments 1
6 min read
Stored data in local SQLite.NET Database | iFour Technolab

Stored data in local SQLite.NET Database | iFour Technolab

5
Comments
5 min read
Building real-time chat apps with GraphQL streaming subscriptions

Building real-time chat apps with GraphQL streaming subscriptions

1
Comments
5 min read
pg_hint_plan: Get the right plan without surprises

pg_hint_plan: Get the right plan without surprises

1
Comments
1 min read
Designing SQL databases for rock solid data quality

Designing SQL databases for rock solid data quality

33
Comments 3
5 min read
An Introduction to SQL

An Introduction to SQL

1
Comments
5 min read
Moving rows from one table to the other 🐘 🚀

Moving rows from one table to the other 🐘 🚀

Comments
2 min read
Use case - daily limit: SELECT FOR UPDATE vs. UPDATE RETURNING in 🐘Aurora and 🚀YugabyteDB

Use case - daily limit: SELECT FOR UPDATE vs. UPDATE RETURNING in 🐘Aurora and 🚀YugabyteDB

2
Comments
7 min read
An Introduction to Database

An Introduction to Database

Comments
5 min read
Hackathon: Build a space-themed application (and win a MacBook)

Hackathon: Build a space-themed application (and win a MacBook)

8
Comments
2 min read
Database GUIs in JavaScript

Database GUIs in JavaScript

183
Comments 13
5 min read
The Principle of Apache Doris SQL Parsing

The Principle of Apache Doris SQL Parsing

Comments
13 min read
Declarative vs. Application side Foreign Key referential integrity

Declarative vs. Application side Foreign Key referential integrity

3
Comments
10 min read
SQL or NoSQL - How to choose the suitable one for you

SQL or NoSQL - How to choose the suitable one for you

3
Comments
4 min read
What are SQL joins? Types of SQL joins explained

What are SQL joins? Types of SQL joins explained

8
Comments 1
13 min read
What is a NoSQL database?

What is a NoSQL database?

6
Comments
3 min read
Write SQL Queries With Confidence (TypeScript + Postgres)

Write SQL Queries With Confidence (TypeScript + Postgres)

10
Comments 2
3 min read
How To Sync Data Between Two Databases

How To Sync Data Between Two Databases

10
Comments
2 min read
How To Visualize MindsDB Predictions with Tableau.

How To Visualize MindsDB Predictions with Tableau.

5
Comments
6 min read
Source code gen in Flutter & Dart: How to create a builder to generate SQL code

Source code gen in Flutter & Dart: How to create a builder to generate SQL code

2
Comments
13 min read
Data Sharing: Why Upstream Solutions Work Best

Data Sharing: Why Upstream Solutions Work Best

6
Comments
4 min read
What is EC2-Other?

What is EC2-Other?

Comments
6 min read
Data modeling crash course

Data modeling crash course

42
Comments 3
13 min read
SQL for Data Engineering

SQL for Data Engineering

5
Comments 2
32 min read
PostgreSQL Indexing: Apa, Mengapa, dan Bagaimana Menerapkannya

PostgreSQL Indexing: Apa, Mengapa, dan Bagaimana Menerapkannya

1
Comments
5 min read
How FullText index works in MySQL

How FullText index works in MySQL

5
Comments
3 min read
pg_stat_statements with pg_hint_plan

pg_stat_statements with pg_hint_plan

5
Comments
3 min read
Flatiron School Software Development - Phase 3 Recap

Flatiron School Software Development - Phase 3 Recap

Comments
2 min read
We Love Ruby {Method Chaining}

We Love Ruby {Method Chaining}

Comments
3 min read
Please Don't (Manually) Parameterize Your SQL Queries

Please Don't (Manually) Parameterize Your SQL Queries

1
Comments
3 min read
Flutter database inspector storage_view

Flutter database inspector storage_view

145
Comments 8
2 min read
Difference between joins and foreign key in DBMS

Difference between joins and foreign key in DBMS

15
Comments
4 min read
Using Indexes in MySQL

Using Indexes in MySQL

4
Comments 1
4 min read
EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

5
Comments 2
6 min read
How can I avoid multiple deduction from stocks in my SQL db in php while loop?

How can I avoid multiple deduction from stocks in my SQL db in php while loop?

7
Comments
2 min read
Apache PySpark for Data Engineering

Apache PySpark for Data Engineering

6
Comments 4
9 min read
UNPIVOT to key-value pair in Oracle SQL

UNPIVOT to key-value pair in Oracle SQL

1
Comments
1 min read
Stuck in SQL query

Stuck in SQL query

6
Comments 4
2 min read
MySQL Queries: Basics of MySQL

MySQL Queries: Basics of MySQL

13
Comments
9 min read
Book summary: SQL Antipatterns

Book summary: SQL Antipatterns

5
Comments 1
9 min read
Data Tokenization in Snowflake

Data Tokenization in Snowflake

1
Comments
9 min read
SQL Server Query Optimizer. And how it can hang your business.

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

3
Comments
8 min read
Expect the unexpected...

Expect the unexpected...

1
Comments
5 min read
Common technical decisions you will make when building a SaaS product from scratch.

Common technical decisions you will make when building a SaaS product from scratch.

8
Comments
2 min read
My first CRUD in Python without ORM

My first CRUD in Python without ORM

2
Comments
4 min read
Read local partition first, then global if not found locally

Read local partition first, then global if not found locally

5
Comments
7 min read
Django eficiente - select_related

Django eficiente - select_related

Comments
3 min read
MariaDB Quick-tip #7 - Find stored procedure

MariaDB Quick-tip #7 - Find stored procedure

5
Comments
1 min read
how to search jsonb column in Postgresql ( not nested column )

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

5
Comments 2
1 min read
Is it possible to reference one column as multiple foreign keys? ( PostgreSQL )

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

5
Comments 5
1 min read
SQL Injection Hacker Challenge

SQL Injection Hacker Challenge

Comments
3 min read
MariaDB Quick-tip #8 - All foreign key constraints

MariaDB Quick-tip #8 - All foreign key constraints

4
Comments
1 min read
Visual Studio Database Project and Always Encrypted

Visual Studio Database Project and Always Encrypted

6
Comments
4 min read
Now AWS supports setting up connectivity between your RDS database and EC2 compute instance in 1-click

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

6
Comments
2 min read
How Would You Make It: Efficient and optimized way of tracking unread message per user

How Would You Make It: Efficient and optimized way of tracking unread message per user

1
Comments 5
5 min read
pg_hint_plan with subqueries

pg_hint_plan with subqueries

2
Comments
4 min read
loading...