Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
select * from SQL
Follow
Hide
Posts on tips and tricks, using and learning about SQL for database development and analysis.
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Exploring New Features in PostgreSQL 17 with Python
Rishi Sharma
Rishi Sharma
Rishi Sharma
Follow
Aug 24
Exploring New Features in PostgreSQL 17 with Python
#
python
#
postgres
#
database
#
sql
Comments
Add Comment
3 min read
Group and Summarize data, and align to the specified sequence #eg31
Judy
Judy
Judy
Follow
Aug 23
Group and Summarize data, and align to the specified sequence #eg31
#
sql
#
development
#
programming
#
spl
6
 reactions
Comments
Add Comment
1 min read
Why Developers should understand SQL Server Performance
Rajan Arora
Rajan Arora
Rajan Arora
Follow
Aug 23
Why Developers should understand SQL Server Performance
#
developer
#
sqlserver
#
database
#
sql
Comments
Add Comment
2 min read
Boost Your Website Security for Free with SafeLine WAF
Lulu
Lulu
Lulu
Follow
Aug 22
Boost Your Website Security for Free with SafeLine WAF
#
cybersecurity
#
webdev
#
sql
#
opensource
5
 reactions
Comments
Add Comment
3 min read
How to Downsample Your Data Efficiently
DolphinDB
DolphinDB
DolphinDB
Follow
Aug 22
How to Downsample Your Data Efficiently
#
database
#
dolphindb
#
quant
#
sql
Comments
Add Comment
2 min read
Unlocking the Power of Text-to-SQL with LangDB
Sayantan Bera
Sayantan Bera
Sayantan Bera
Follow
for
LangDB
Aug 22
Unlocking the Power of Text-to-SQL with LangDB
#
datascience
#
sql
#
tutorial
#
langdb
2
 reactions
Comments
Add Comment
3 min read
Cast for type conversion in SQL
allan-pg
allan-pg
allan-pg
Follow
Aug 21
Cast for type conversion in SQL
#
sql
#
database
#
mariadb
#
mysql
1
 reaction
Comments
Add Comment
2 min read
Overcome the Limitations of Traditional WAFs: How SafeLine Enhances Security
MotorBuy6
MotorBuy6
MotorBuy6
Follow
Aug 20
Overcome the Limitations of Traditional WAFs: How SafeLine Enhances Security
#
cybersecurity
#
sql
#
opensource
#
webdev
5
 reactions
Comments
Add Comment
3 min read
Understanding Data Normalization and Database Design Principles
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 19
Understanding Data Normalization and Database Design Principles
#
database
#
dba
#
sql
#
databaseadministrator
Comments
Add Comment
2 min read
Basic MySQL Queries: A Comprehensive Guide
Nirmalya Mondal
Nirmalya Mondal
Nirmalya Mondal
Follow
Aug 23
Basic MySQL Queries: A Comprehensive Guide
#
sql
#
mysql
#
database
#
microsoft
5
 reactions
Comments
Add Comment
4 min read
Create and Connect to an Azure SQL Database on Heroku: A Step-By-Step Guide
Devart
Devart
Devart
Follow
Aug 19
Create and Connect to an Azure SQL Database on Heroku: A Step-By-Step Guide
#
sql
#
sqlserver
#
azure
#
heroku
Comments
Add Comment
1 min read
Creating Unique Slugs on Supabase with PostgreSQL
Gabriel Debona
Gabriel Debona
Gabriel Debona
Follow
Aug 23
Creating Unique Slugs on Supabase with PostgreSQL
#
opensource
#
supabase
#
postgres
#
sql
1
 reaction
Comments
Add Comment
3 min read
SQL, mark continuous rows with sequence numbers #eg30
Judy
Judy
Judy
Follow
Aug 22
SQL, mark continuous rows with sequence numbers #eg30
#
sql
#
development
#
programming
#
esproc
7
 reactions
Comments
Add Comment
1 min read
Fundamentals of Transact-SQL (T-SQL) Queries
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 18
Fundamentals of Transact-SQL (T-SQL) Queries
#
database
#
sql
#
dba
#
administrator
Comments
Add Comment
2 min read
Recommended Project: Creating Stored Procedures for Course Data Retrieval
Labby
Labby
Labby
Follow
for
LabEx
Aug 17
Recommended Project: Creating Stored Procedures for Course Data Retrieval
#
labex
#
sql
#
mysql
#
programming
Comments
Add Comment
3 min read
Essential Database Concepts Explained
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 17
Essential Database Concepts Explained
#
database
#
dba
#
sql
#
administrator
Comments
Add Comment
2 min read
[Resolved] Integrity constraint violation – Fast tips
Valerio
Valerio
Valerio
Follow
for
Inspector.dev
Aug 17
[Resolved] Integrity constraint violation – Fast tips
#
webdev
#
php
#
laravel
#
sql
Comments
Add Comment
3 min read
How To Use The SQL Server ALTER Keyword To Modify Database Objects
Amr Saafan
Amr Saafan
Amr Saafan
Follow
for
Nile Bits
Aug 17
How To Use The SQL Server ALTER Keyword To Modify Database Objects
#
sql
#
sqlserver
#
database
Comments
Add Comment
9 min read
SQL, compute cumulative sums according to the termination condition #eg29
Judy
Judy
Judy
Follow
Aug 21
SQL, compute cumulative sums according to the termination condition #eg29
#
sql
#
development
#
programming
#
esproc
7
 reactions
Comments
1
 comment
1 min read
SafeLine: Secure Your Web Applications Effortlessly
Lulu
Lulu
Lulu
Follow
Aug 21
SafeLine: Secure Your Web Applications Effortlessly
#
cybersecurity
#
sql
#
webdev
#
opensource
5
