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.
Exploring New Features in PostgreSQL 17 with Python
rishisharma profile

Exploring New Features in PostgreSQL 17 with Python

#python #postgres #database #sql
Comments
3 min read
Group and Summarize data, and align to the specified sequence #eg31
esproc_spl profile
Judy

Group and Summarize data, and align to the specified sequence #eg31

#sql #development #programming #spl
6
Comments
1 min read
Why Developers should understand SQL Server Performance
icodemechanic profile

Why Developers should understand SQL Server Performance

#developer #sqlserver #database #sql
Comments
2 min read
Boost Your Website Security for Free with SafeLine WAF
lulu_liu_c90f973e2f954d7f profile
Lulu

Boost Your Website Security for Free with SafeLine WAF

#cybersecurity #webdev #sql #opensource
5
Comments
3 min read
How to Downsample Your Data Efficiently
dolphindb profile

How to Downsample Your Data Efficiently

#database #dolphindb #quant #sql
Comments
2 min read
Unlocking the Power of Text-to-SQL with LangDB
berasayantan profile

Unlocking the Power of Text-to-SQL with LangDB

#datascience #sql #tutorial #langdb
2
Comments
3 min read
Cast for type conversion in SQL
allan-pg profile

Cast for type conversion in SQL

#sql #database #mariadb #mysql
1
Comments
2 min read
Overcome the Limitations of Traditional WAFs: How SafeLine Enhances Security
motorbuy6 profile

Overcome the Limitations of Traditional WAFs: How SafeLine Enhances Security

#cybersecurity #sql #opensource #webdev
5
Comments
3 min read
Understanding Data Normalization and Database Design Principles
minhduc159 profile

Understanding Data Normalization and Database Design Principles

#database #dba #sql #databaseadministrator
Comments
2 min read
Basic MySQL Queries: A Comprehensive Guide
nirmalyax profile

Basic MySQL Queries: A Comprehensive Guide

#sql #mysql #database #microsoft
5
Comments
4 min read
Create and Connect to an Azure SQL Database on Heroku: A Step-By-Step Guide
devartteam profile

Create and Connect to an Azure SQL Database on Heroku: A Step-By-Step Guide

#sql #sqlserver #azure #heroku
Comments
1 min read
Creating Unique Slugs on Supabase with PostgreSQL
g5l profile

Creating Unique Slugs on Supabase with PostgreSQL

#opensource #supabase #postgres #sql
1
Comments
3 min read
SQL, mark continuous rows with sequence numbers #eg30
esproc_spl profile
Judy

SQL, mark continuous rows with sequence numbers #eg30

#sql #development #programming #esproc
7
Comments
1 min read
Fundamentals of Transact-SQL (T-SQL) Queries
minhduc159 profile

Fundamentals of Transact-SQL (T-SQL) Queries

#database #sql #dba #administrator
Comments
2 min read
Recommended Project: Creating Stored Procedures for Course Data Retrieval
labby profile
Labby for LabEx

Recommended Project: Creating Stored Procedures for Course Data Retrieval

#labex #sql #mysql #programming
Comments
3 min read
Essential Database Concepts Explained
minhduc159 profile

Essential Database Concepts Explained

#database #dba #sql #administrator
Comments
2 min read
[Resolved] Integrity constraint violation – Fast tips
ilvalerione profile

[Resolved] Integrity constraint violation – Fast tips

#webdev #php #laravel #sql
Comments
3 min read
How To Use The SQL Server ALTER Keyword To Modify Database Objects
amr-saafan profile

How To Use The SQL Server ALTER Keyword To Modify Database Objects

#sql #sqlserver #database
Comments
9 min read
SQL, compute cumulative sums according to the termination condition #eg29
esproc_spl profile
Judy

SQL, compute cumulative sums according to the termination condition #eg29

#sql #development #programming #esproc
7
Comments 1
1 min read
SafeLine: Secure Your Web Applications Effortlessly
lulu_liu_c90f973e2f954d7f profile
Lulu

SafeLine: Secure Your Web Applications Effortlessly

#cybersecurity #sql #webdev #opensource
5
Comments
2 min read
Understanding your data: The Essentials of Exploratory Data Analysis (EDA).
s_ndichu profile

Understanding your data: The Essentials of Exploratory Data Analysis (EDA).

#python #excel #powerbi #sql
Comments
2 min read
SQL, parse json data #eg28
esproc_spl profile
Judy

SQL, parse json data #eg28

#sql #development #programming #esproc
6
Comments
1 min read
IMPORTING DATA USING PYTHON TO MYSQL
allan-pg profile

IMPORTING DATA USING PYTHON TO MYSQL

#python #database #datascience #sql
1
Comments
2 min read
Understanding The ‘AND’ Keyword In SQL Server
amr-saafan profile

Understanding The ‘AND’ Keyword In SQL Server

#sql #sqlserver #database
1
Comments
5 min read
DbGate - a fast cross-database client
amjadmh73 profile

DbGate - a fast cross-database client

#database #data #sql #nosql
Comments
1 min read
A Comprehensive Guide to Materialized Views in MySQL
domfive profile

A Comprehensive Guide to Materialized Views in MySQL

#mysql #sql #database #tutorial
Comments
33 min read
I deleted our database after 72 hours of no sleep.
pragyanatvade profile

I deleted our database after 72 hours of no sleep.

#webdev #learning #sql #beginners
Comments
1 min read
Understanding Your Data: The Essentials of Exploratory Data Analysis
nginacloud profile

Understanding Your Data: The Essentials of Exploratory Data Analysis

#sql #python #learning #eventdriven
Comments
3 min read
Dynamic SQL Best Practices (or "How to Avoid Both SQL Injection Vulnerabilities and Spaghetti Code")
intersystemsdev profile

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

#beginners #tutorial #sql #security
1
Comments
11 min read
Navigating Open Source Software: All Your Questions Answered
observiq profile

Navigating Open Source Software: All Your Questions Answered

#devops #opensource #kubernetes #sql
Comments
7 min read
Clear duplicate lines and lines having missing values from a csv file #eg24
esproc_spl profile
Judy

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

#sql #programming #development #esproc
7
Comments 1
1 min read
🗂️ Understanding SQL Relationships: A Beginner's Guide
nullvoidkage profile

🗂️ Understanding SQL Relationships: A Beginner's Guide

#sql #database #backend #programming
1
Comments
3 min read
📝 SQL Cheat Sheet for Developers
nullvoidkage profile

📝 SQL Cheat Sheet for Developers

#sql #database #cheatsheet #programming
1
Comments 1
3 min read
Mastering SQL: Best Practices for Developers
dbvismarketing profile

Mastering SQL: Best Practices for Developers

#sql
Comments
1 min read
Calling SQL Developers for assist
ndurbala27 profile

Calling SQL Developers for assist

#sql #developer #mysql #database
Comments
1 min read
Top 8 Managed Postgres Providers
shohams profile

Top 8 Managed Postgres Providers

#database #api #architecture #sql
2
Comments
8 min read
Essential PSQL 50 Selected Practice Questions with Answers
tom8daafe63765434221 profile
tom

Essential PSQL 50 Selected Practice Questions with Answers

#sql
Comments
14 min read
Schema + Data migration in Prisma (adding a new mandatory field)
kasir-barati profile

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

#prisma #postgres #node #sql
Comments
2 min read
Essential MtSQL 50 Selected Practice Questions with Answers
tom8daafe63765434221 profile
tom

Essential MtSQL 50 Selected Practice Questions with Answers

#sql #mysql
Comments
13 min read
SQL, concatenate multiple rows of strings and remove duplicates #eg27
esproc_spl profile
Judy

SQL, concatenate multiple rows of strings and remove duplicates #eg27

#sql #development #programming #esproc
11
Comments
1 min read
How to check the MySQL version on Windows, so easy that even a five-year-old can learn it
tom8daafe63765434221 profile
tom

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

#sql #mysql #xamarin
Comments
4 min read
Exploratory Data Analysis Using SQL.
theophilus1320 profile

Exploratory Data Analysis Using SQL.

#analytics #sql #database #datascience
Comments
3 min read
SQL, split values of two columns respectively and count members of their intersection #eg20
esproc_spl profile
Judy

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

#sql #development #programming
7
Comments 1
1 min read
Using Bitmasks for Efficient Data Filtering
devartteam profile
Devart

Using Bitmasks for Efficient Data Filtering

#sql #sqlserver #devart #dbforge
Comments
1 min read
Build a Database Schema In 5 Steps
domfive profile

Build a Database Schema In 5 Steps

#database #mysql #sql #sqlserver
Comments
26 min read
SQL, Set different flags for different groups according to whether there are duplicate values #eg19
esproc_spl profile
Judy

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

#sql #development #programming #esproc
8
Comments 1
1 min read
SQL Complete guide for Interview
madgan95 profile

SQL Complete guide for Interview

#sql #mysql #postgres #database
37
Comments 5
13 min read
Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18
esproc_spl profile
Judy

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

#sql #development #programming #esproc
6
Comments 1
1 min read
Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16
esproc_spl profile
Judy

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

#sql #development #programming #esproc
6
Comments 1
2 min read
Merge multiple files, remove duplicates and sort the result #eg25
esproc_spl profile
Judy

Merge multiple files, remove duplicates and sort the result #eg25

#sql #development #programming #esproc
11
Comments 1
1 min read
Postgres major version upgrades with minimal downtime
cezz profile

Postgres major version upgrades with minimal downtime

#news #postgres #database #sql
Comments
4 min read
Enabling Special Needs Education and Empowerment
rabiezouita11 profile

Enabling Special Needs Education and Empowerment

#laravel #sql #architecture #apimail
1
Comments
2 min read
Transpose Multiple Columns into One Row in Each Group #eg15
esproc_spl profile
Judy

Transpose Multiple Columns into One Row in Each Group #eg15

#sql #development #programming
6
Comments 1
1 min read
Education Connect: Revolutionizing Parent-School Communication
rabiezouita11 profile

Education Connect: Revolutionizing Parent-School Communication

#laravel #sql #architecture #programming
1
Comments
2 min read
Performance Pitfalls: Using Hints in Oracle Database
eric6166 profile

Performance Pitfalls: Using Hints in Oracle Database

#database #oracle #performance #sql
5
Comments
2 min read
Uploading Excel Files to SSMS Table
salonynhp profile

Uploading Excel Files to SSMS Table

#api #dotnet #sql #beginners
Comments
3 min read
Understanding Database Views: Usage, Benefits, and Considerations
senkae_ll profile

Understanding Database Views: Usage, Benefits, and Considerations

#database #sql #mysql #views
Comments
3 min read
SQL, get historical status of each ID #eg22
esproc_spl profile
Judy

SQL, get historical status of each ID #eg22

#sql #development #programming #esproc
8
Comments 1
1 min read
ProjectEvent
rabiezouita11 profile

ProjectEvent

#laravel #sql #websockets #webdev
Comments
3 min read
ProBook
rabiezouita11 profile

ProBook

#sql #laravel #websockets #apimail
Comments
1 min read
loading...