The Wayback Machine - https://web.archive.org/web/20230424160137/https://dev.to/t/sql

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.
The old MySQL bug (detective story)

The old MySQL bug (detective story)

1
2 min read
When To Use SQL vs NoSQL: An Expert Guide to Databases

When To Use SQL vs NoSQL: An Expert Guide to Databases

1
11 min read
620. Not Boring Movies leetcode solution

620. Not Boring Movies leetcode solution

5
1 min read
610. Triangle Judgement

610. Triangle Judgement

4
1 min read
1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

5
1 min read
Range indexes for LIKE queries in YugabyteDB

Range indexes for LIKE queries in YugabyteDB

8 min read
AI tool to automatically write, optimize, edit, and debug SQL

AI tool to automatically write, optimize, edit, and debug SQL

2 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

1
5 min read
How does the in-memory database bring memory’s advantage into play?

How does the in-memory database bring memory’s advantage into play?

12 min read
A Worthy Sequel: An Overview of Next-Gen NoSQL Databases

A Worthy Sequel: An Overview of Next-Gen NoSQL Databases

2
4 min read
607. Sales Person leetcode solution

607. Sales Person leetcode solution

4
1 min read
SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases

SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases

3 min read
Resources to learn pl/sql for free

Resources to learn pl/sql for free

5
1 min read
SQL Versus NoSQL Databases: Which to Use, When, and Why

SQL Versus NoSQL Databases: Which to Use, When, and Why

16
9 min read
Stored Procedures in SQL database

Stored Procedures in SQL database

2
2 min read
SQL 102:Intermediate SQL

SQL 102:Intermediate SQL

7 min read
How to convert CSV to SQL insert statements?

How to convert CSV to SQL insert statements?

2
2 min read
Thrilled to share with you all our AI Chatbot tool for data warehouses: Findly.ai!

Thrilled to share with you all our AI Chatbot tool for data warehouses: Findly.ai!

2
1 min read
Cloud ETL Pipeline in Azure

Cloud ETL Pipeline in Azure

1
12 min read
How to validate your prisma raw query results

How to validate your prisma raw query results

1
2 min read
Python to SQL and back again... an Object-Relational Mapping tale.

Python to SQL and back again... an Object-Relational Mapping tale.

3 min read
Apache AGE:A quick overview.

Apache AGE:A quick overview.

3
1 min read
Scalable bounded COUNT DISTINCT in YugabyteDB

Scalable bounded COUNT DISTINCT in YugabyteDB

6 min read
Transactions - difference between SQL, SQLAlchemy and Django ORM

Transactions - difference between SQL, SQLAlchemy and Django ORM

2 min read
Problem solving with SQL: Case Study #1 — Danny’s Diner

Problem solving with SQL: Case Study #1 — Danny’s Diner

10 min read
Polars for Analytics an Introduction

Polars for Analytics an Introduction

3
2
3 min read
How to choose the right streaming database

How to choose the right streaming database

12
7 min read
Deep Drive SQL ( part 01 )

Deep Drive SQL ( part 01 )

10 min read
Everything you wanted to know about Auto Increment but were afraid to ask

Everything you wanted to know about Auto Increment but were afraid to ask

1
6 min read
When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

2 min read
SQL Indexes Basics in Rails

SQL Indexes Basics in Rails

2
4 min read
Loop on static content to upsert many rows in Oracle SQL

Loop on static content to upsert many rows in Oracle SQL

1
1 min read
Performance Enhancement: Conversion Funnel Analysis

Performance Enhancement: Conversion Funnel Analysis

9 min read
SQL fundamentals: understanding Join Tables

SQL fundamentals: understanding Join Tables

1
5 min read
DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

2 min read
Quick and Handy Tips for Everyday PostgreSQL Tasks

Quick and Handy Tips for Everyday PostgreSQL Tasks

2 min read
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

1
2 min read
🔄 Self-reference Laravel Model

🔄 Self-reference Laravel Model

6
3 min read
How to write an anonymous PL/SQL function and use it in your SQL statement

How to write an anonymous PL/SQL function and use it in your SQL statement

3 min read
Propagated Transactions for Node.js Applications

Propagated Transactions for Node.js Applications

15
4 min read
How Change Data Capture (CDC) Works with Streaming Database

How Change Data Capture (CDC) Works with Streaming Database

7
8 min read
Why SQL is right for Infrastructure Management

Why SQL is right for Infrastructure Management

1
1
24 min read
Get started with libSQL, a next-gen fork of SQLite

Get started with libSQL, a next-gen fork of SQLite

7
13 min read
Movie rating web application

Movie rating web application

7 min read
Simulating Streaming Data for Fraud Detection with Datagen CLI

Simulating Streaming Data for Fraud Detection with Datagen CLI

27
1
5 min read
Full-text search com PostgreSQL

Full-text search com PostgreSQL

9 min read
Updating timestamps automatically in Supabase

Updating timestamps automatically in Supabase

1 min read
UPSERT in YugabyteDB

UPSERT in YugabyteDB

2
6 min read
Essential SQL Commands for Data Science Tasks

Essential SQL Commands for Data Science Tasks

2
7 min read
🏺Database Architecture - History Over State

🏺Database Architecture - History Over State

6
1
8 min read
Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

1
4 min read
Jazz up a CLI project with color and sound!

Jazz up a CLI project with color and sound!

1
4 min read
ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

6 min read
SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

1
1
7 min read
How to compose SQL queries based on values from CSV file?

How to compose SQL queries based on values from CSV file?

2 min read
IN Subquery Optimization

IN Subquery Optimization

5 min read
How to delete large records in batches

How to delete large records in batches

3 min read
Securely connect to an Amazon RDS via PrivateLink using SQL

Securely connect to an Amazon RDS via PrivateLink using SQL

3 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

3 min read
Insight Findings from A Case Study of Customers Leaving Credit Card Services

Insight Findings from A Case Study of Customers Leaving Credit Card Services

10 min read
loading...