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.
Data Analysis with SQL

Data Analysis with SQL

6
Comments
12 min read
Exploring 15 Futuristic Databases That Will Transform the Tech WorldūüĆé

Exploring 15 Futuristic Databases That Will Transform the Tech WorldūüĆé

Comments
10 min read
How to Optimize SQL Queries With ChatGPT and Metis

How to Optimize SQL Queries With ChatGPT and Metis

1
Comments
6 min read
Online Rolling Upgrade in YugabyteDB Managed

Online Rolling Upgrade in YugabyteDB Managed

1
Comments
11 min read
Employees Management System (EMS)

Employees Management System (EMS)

Comments
4 min read
Recursion with PostgreSQL Follow-Up 3 - Finding the Right Path

Recursion with PostgreSQL Follow-Up 3 - Finding the Right Path

1
Comments
9 min read
PostgreSQL 16 Installation on Ubuntu 22.04

PostgreSQL 16 Installation on Ubuntu 22.04

3
Comments 1
2 min read
Security Vulnerabilities Developers Needed to Know

Security Vulnerabilities Developers Needed to Know

Comments
9 min read
Discover the Hidden Powers of PostgreSQL: Lateral Joins and JSON Columns Decoded!

Discover the Hidden Powers of PostgreSQL: Lateral Joins and JSON Columns Decoded!

Comments
2 min read
Understanding SQL Query Execution Plan Before Creating Indexes to Optimize Costs

Understanding SQL Query Execution Plan Before Creating Indexes to Optimize Costs

5
Comments
3 min read
SPL computing performance test series: associate tables and wide table

SPL computing performance test series: associate tables and wide table

Comments
6 min read
Delete Duplicate Emails

Delete Duplicate Emails

5
Comments
2 min read
Troubleshooting PostgreSQL High CPU Usage - Part 2

Troubleshooting PostgreSQL High CPU Usage - Part 2

8
Comments
5 min read
A Comprehensive Guide to SQL: Common Functions and Best Practices

A Comprehensive Guide to SQL: Common Functions and Best Practices

1
Comments
3 min read
How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

36
Comments 1
5 min read
7 reasons why a user would need to query Amazon S3 directly

7 reasons why a user would need to query Amazon S3 directly

Comments
3 min read
Fazendo Comandos SQL

Fazendo Comandos SQL

14
Comments
4 min read
A Different Type of SQL Recursion with PostgreSQL

A Different Type of SQL Recursion with PostgreSQL

1
Comments
9 min read
From console to rows - the processing of a query in Postgres

From console to rows - the processing of a query in Postgres

1
Comments
2 min read
Understanding Joins in SQL

Understanding Joins in SQL

6
Comments 2
3 min read
Bitmap Scan in YugabyteDB

Bitmap Scan in YugabyteDB

1
Comments
9 min read
How to simplify database operations using MySQL stored procedures

How to simplify database operations using MySQL stored procedures

Comments
7 min read
how to run multiple queries in .txt file on sql plus

how to run multiple queries in .txt file on sql plus

5
Comments
1 min read
Generating migrations for gorm with Atlas

Generating migrations for gorm with Atlas

4
Comments
3 min read
Implementing hassle-free audits in the SQL database

Implementing hassle-free audits in the SQL database

11
Comments
11 min read
IF-THEN-ELSE in SQL WHERE CLAUSE

IF-THEN-ELSE in SQL WHERE CLAUSE

5
Comments
4 min read
Tudo que você precisa saber sobre SQL

Tudo que você precisa saber sobre SQL

25
Comments 3
21 min read
Learning basic SQL with me:

Learning basic SQL with me:

8
Comments
4 min read
Let’s Create an End-to-End Web Scraping Pipeline With Scrapy!

Let’s Create an End-to-End Web Scraping Pipeline With Scrapy!

4
Comments
10 min read
Getting Started with SQL: A Beginners Hands-On Guide!

Getting Started with SQL: A Beginners Hands-On Guide!

16
Comments
7 min read
Memory behind Postgres

Memory behind Postgres

2
Comments
2 min read
Enhancing Symfony Application Performance: Overcoming Many-to-Many Challenges with Postgres and ClickHouse

Enhancing Symfony Application Performance: Overcoming Many-to-Many Challenges with Postgres and ClickHouse

2
Comments
5 min read
"Mastering AutoMapper: Simplifying Object Mapping in .NET"

"Mastering AutoMapper: Simplifying Object Mapping in .NET"

7
Comments 2
7 min read
YugabyteDB Cost-Based Optimizer and cost model for Distributed LSM-Tree

YugabyteDB Cost-Based Optimizer and cost model for Distributed LSM-Tree

2
Comments
7 min read
Database Review: Top Five Missing Features from Database APIs

Database Review: Top Five Missing Features from Database APIs

10
Comments 1
6 min read
What Are Window Functions in SQL & How To Use Them

What Are Window Functions in SQL & How To Use Them

1
Comments
6 min read
Transaction Internals: Fast Path vs Multi-Shard

Transaction Internals: Fast Path vs Multi-Shard

1
Comments
1 min read
Simple and Efficient Full Text Search using Django and Postgres

Simple and Efficient Full Text Search using Django and Postgres

8
Comments
7 min read
Postgres Join Methods in YugabyteDB

Postgres Join Methods in YugabyteDB

1
Comments
12 min read
Exploring PostgreSQL: Foreign Data Wrappers (FDW).

Exploring PostgreSQL: Foreign Data Wrappers (FDW).

2
Comments
3 min read
SQL Commands

SQL Commands

2
Comments
2 min read
MariaDB Installation Made Easy: A Guide for Arch-Based Linux Users

MariaDB Installation Made Easy: A Guide for Arch-Based Linux Users

3
Comments
2 min read
SQL + Docker: The combo for Quick and Safe Query Testing

SQL + Docker: The combo for Quick and Safe Query Testing

4
Comments
5 min read
Multi-Tenant SaaS Architecture with Entity Framework

Multi-Tenant SaaS Architecture with Entity Framework

10
Comments 2
10 min read
Conway's game of life...in pure SQL [Postgres]! ūüí™ūüŹľūü§Į

Conway's game of life...in pure SQL [Postgres]! ūüí™ūüŹľūü§Į

81
Comments 19
9 min read
Unleashing the Power of Graph Databases: Apache AGE in industries

Unleashing the Power of Graph Databases: Apache AGE in industries

2
Comments
3 min read
count(*): The Most Efficient Way to Count Rows in Your Table

count(*): The Most Efficient Way to Count Rows in Your Table

7
Comments
2 min read
Case Study: How Company X Leveraged Apache AGE to Enhance Fraud Detection

Case Study: How Company X Leveraged Apache AGE to Enhance Fraud Detection

2
Comments
3 min read
Hold your horses Postgres - how to debug high CPU usage

Hold your horses Postgres - how to debug high CPU usage

3
Comments
8 min read
Garanta a Eficiência: Escolhendo entre tipos String no SQL

Garanta a Eficiência: Escolhendo entre tipos String no SQL

35
Comments 7
4 min read
PL/Python in YugabyteDB

PL/Python in YugabyteDB

2
Comments
3 min read
Navigating Databases with Python: A Beginner-Friendly Guide

Navigating Databases with Python: A Beginner-Friendly Guide

3
Comments
5 min read
Comprehensive Guide: Deploying and Debugging Custom Webhooks on Supabase & PostgreSQL

Comprehensive Guide: Deploying and Debugging Custom Webhooks on Supabase & PostgreSQL

9
Comments
5 min read
How To Seamlessly Integrate Sequelize with Node.js and JavaScript for Database Monitoring

How To Seamlessly Integrate Sequelize with Node.js and JavaScript for Database Monitoring

12
Comments
16 min read
Nulls are equal in distinct but inequal in unique.

Nulls are equal in distinct but inequal in unique.

6
Comments
3 min read
Simplify Complex SQL Queries with Common Table Expressions (CTEs)

Simplify Complex SQL Queries with Common Table Expressions (CTEs)

88
Comments 16
2 min read
Entendendo JOINs no SQL: Unindo Tabelas Como um Profissional

Entendendo JOINs no SQL: Unindo Tabelas Como um Profissional

Comments
2 min read
A Quick Guide: Creating Join Tables with SQLAlchemy

A Quick Guide: Creating Join Tables with SQLAlchemy

7
Comments 2
4 min read
Apache AGE and Machine Learning: Enhancing Analytics with Graph Databases

Apache AGE and Machine Learning: Enhancing Analytics with Graph Databases

2
Comments
3 min read
PostgreSQL Faceted navigation and search

PostgreSQL Faceted navigation and search

Comments
4 min read
loading...