Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

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.
I deleted our database after 72 hours of no sleep.

I deleted our database after 72 hours of no sleep.

Comments
1 min read
AI Productivity Tips 1 - SQL Companion Bot with Gemini 1.5 Pro

AI Productivity Tips 1 - SQL Companion Bot with Gemini 1.5 Pro

Comments
2 min read
Understanding Your Data: The Essentials of Exploratory Data Analysis

Understanding Your Data: The Essentials of Exploratory Data Analysis

Comments
3 min read
Dynamic SQL Best Practices (or "How to Avoid Both SQL Injection Vulnerabilities and Spaghetti Code")

Dynamic SQL Best Practices (or "How to Avoid Both SQL Injection Vulnerabilities and Spaghetti Code")

1
Comments
11 min read
Navigating Open Source Software: All Your Questions Answered

Navigating Open Source Software: All Your Questions Answered

Comments
7 min read
Securing PHP Applications Against SQL Injection Attacks

Securing PHP Applications Against SQL Injection Attacks

Comments 4
3 min read
Libraries for writing raw SQL safely

Libraries for writing raw SQL safely

Comments
8 min read
Clear duplicate lines and lines having missing values from a csv file #eg24

Clear duplicate lines and lines having missing values from a csv file #eg24

7
Comments 1
1 min read
Introducing Qiu!

Introducing Qiu!

6
Comments
2 min read
PL/SQL scripts, stored procedures, and triggers

PL/SQL scripts, stored procedures, and triggers

Comments
3 min read
Enhancing Laravel Models with a Case-Insensitive Searchable Trait

Enhancing Laravel Models with a Case-Insensitive Searchable Trait

1
Comments
3 min read
🗂️ Understanding SQL Relationships: A Beginner's Guide

🗂️ Understanding SQL Relationships: A Beginner's Guide

1
Comments
3 min read
📝 SQL Cheat Sheet for Developers

📝 SQL Cheat Sheet for Developers

1
Comments 1
3 min read
18 Key Points You Must Know When Creating Tables in MySQL

18 Key Points You Must Know When Creating Tables in MySQL

6
Comments
11 min read
Exploring WAFs: How SafeLine Defends Against Web Attacks

Exploring WAFs: How SafeLine Defends Against Web Attacks

6
Comments
3 min read
Déployer une solution de BI légère avec son premier dashboard en 5 étapes

Déployer une solution de BI légère avec son premier dashboard en 5 étapes

1
Comments
3 min read
Debugging Low Cache Hit Ratio

Debugging Low Cache Hit Ratio

1
Comments 1
14 min read
Mastering SQL: Best Practices for Developers

Mastering SQL: Best Practices for Developers

Comments
1 min read
Calling SQL Developers for assist

Calling SQL Developers for assist

Comments
1 min read
Top 8 Managed Postgres Providers

Top 8 Managed Postgres Providers

2
Comments
8 min read
Essential PSQL 50 Selected Practice Questions with Answers

Essential PSQL 50 Selected Practice Questions with Answers

Comments
14 min read
Schema + Data migration in Prisma (adding a new mandatory field)

Schema + Data migration in Prisma (adding a new mandatory field)

Comments
2 min read
# 🚀 SQL Automation Testing: A Beginner's Guide

# 🚀 SQL Automation Testing: A Beginner's Guide

3
Comments
3 min read
Compare two csv files #eg34

Compare two csv files #eg34

7
Comments 1
1 min read
Essential MtSQL 50 Selected Practice Questions with Answers

Essential MtSQL 50 Selected Practice Questions with Answers

Comments
13 min read
SQL Query Logical Order

SQL Query Logical Order

6
Comments
2 min read
ACID Properties in Database

ACID Properties in Database

3
Comments
2 min read
How to Set Up a PostgreSQL Database on a VPS and Access It Remotely

How to Set Up a PostgreSQL Database on a VPS and Access It Remotely

5
Comments
2 min read
How to check the MySQL version on Windows, so easy that even a five-year-old can learn it

How to check the MySQL version on Windows, so easy that even a five-year-old can learn it

Comments
4 min read
Exploratory Data Analysis Using SQL.

Exploratory Data Analysis Using SQL.

Comments
3 min read
Understanding GROUP BY vs. PARTITION BY in SQL

Understanding GROUP BY vs. PARTITION BY in SQL

2
Comments
4 min read
SQL, split values of two columns respectively and count members of their intersection #eg20

SQL, split values of two columns respectively and count members of their intersection #eg20

7
Comments 1
1 min read
Using Bitmasks for Efficient Data Filtering

Using Bitmasks for Efficient Data Filtering

Comments
1 min read
Build a Database Schema In 5 Steps

Build a Database Schema In 5 Steps

Comments
26 min read
SQL as fast as NoSQL, Bulk Loads, Covering and Partial Indexes

SQL as fast as NoSQL, Bulk Loads, Covering and Partial Indexes

2
Comments
4 min read
SQL, Set different flags for different groups according to whether there are duplicate values #eg19

SQL, Set different flags for different groups according to whether there are duplicate values #eg19

8
Comments 1
1 min read
How Indexing Works in MariaDB and Why It Helps with Optimization

How Indexing Works in MariaDB and Why It Helps with Optimization

1
Comments
9 min read
Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18

Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18

6
Comments 1
1 min read
Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16

Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16

6
Comments 1
2 min read
Postgres major version upgrades with minimal downtime

Postgres major version upgrades with minimal downtime

Comments
4 min read
Enabling Special Needs Education and Empowerment

Enabling Special Needs Education and Empowerment

1
Comments
2 min read
Understanding Database Isolation Levels: An Essential Overview

Understanding Database Isolation Levels: An Essential Overview

9
Comments
3 min read
Transpose Multiple Columns into One Row in Each Group #eg15

Transpose Multiple Columns into One Row in Each Group #eg15

6
Comments 1
1 min read
PostgreSQL Fitness: 10 Essential Maintenance Practices for a Healthy Database

PostgreSQL Fitness: 10 Essential Maintenance Practices for a Healthy Database

1
Comments
3 min read
DBMS - Introduction

DBMS - Introduction

1
Comments 1
1 min read
Uploading Excel Files to SSMS Table

Uploading Excel Files to SSMS Table

Comments
3 min read
Building a D&D 5e Character Generator: A Journey Through SQL and RPG Complexity

Building a D&D 5e Character Generator: A Journey Through SQL and RPG Complexity

17
Comments 5
4 min read
Why Developers should understand SQL Server Performance

Why Developers should understand SQL Server Performance

Comments
2 min read
Fixing a slow join in Postgres

Fixing a slow join in Postgres

4
Comments
7 min read
SQL, mark continuous rows with sequence numbers #eg30

SQL, mark continuous rows with sequence numbers #eg30

8
Comments
1 min read
SQL, get historical status of each ID #eg22

SQL, get historical status of each ID #eg22

8
Comments 1
1 min read
ProjectEvent

ProjectEvent

Comments
3 min read
ProBook

ProBook

Comments
1 min read
Send reminder to employees when tasks are due

Send reminder to employees when tasks are due

2
Comments
2 min read
Celebrating My Achievement: Snowflake Badge 1 Completion 🎉

Celebrating My Achievement: Snowflake Badge 1 Completion 🎉

Comments
2 min read
Understanding Transactions In Databases : Keeping Your Records Consistent 📊💰🔄📚✅

Understanding Transactions In Databases : Keeping Your Records Consistent 📊💰🔄📚✅

Comments
2 min read
NoSQL vs NewSQL vs Distributed SQL: A Comprehensive Comparison

NoSQL vs NewSQL vs Distributed SQL: A Comprehensive Comparison

2
Comments
4 min read
LINQPad for everything(or at least a lot)

LINQPad for everything(or at least a lot)

Comments
3 min read
TypedSQL in Prisma: Type-Safe SQL Made Simple

TypedSQL in Prisma: Type-Safe SQL Made Simple

5
Comments 1
4 min read
Blackboxing SQL in CFScript - Part 1

Blackboxing SQL in CFScript - Part 1

Comments
5 min read
loading...