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 Aurora DSQL with TypeScript, Drizzle, Lambda, and AWS CDK
stevendsanders profile

Exploring Aurora DSQL with TypeScript, Drizzle, Lambda, and AWS CDK

#sql #aws #typescript #postgres
13
Comments
5 min read
Day 4 of SQL Series || SELECT Statement Use cases
akshat0610 profile

Day 4 of SQL Series || SELECT Statement Use cases

#sql #tutorial #beginners #mysql
7
Comments
3 min read
Proximity Search: A Complete Guide for Developers
softheartengineer profile

Proximity Search: A Complete Guide for Developers

#elasticsearch #backend #sql #webdev
7
Comments
3 min read
SQL PATTERNS: ROW_NUMBER, RANK and DENSE_RANK
anwaar profile

SQL PATTERNS: ROW_NUMBER, RANK and DENSE_RANK

#sql #ranking #database #snowflake
8
Comments
2 min read
ChatWithSQL — Secure, Schema-Validated Text-to-SQL Python Library, Eliminating Arbitrary Query Risks from LLMs
sathninduk profile

ChatWithSQL — Secure, Schema-Validated Text-to-SQL Python Library, Eliminating Arbitrary Query Risks from LLMs

#python #sql #ai #programming
5
Comments
3 min read
Understanding and Using Window Functions in SQL
danwycliff profile

Understanding and Using Window Functions in SQL

#sql #windowfunction #database #beginners
Comments
1 min read
SQL: Perform statistics at different granularities based on the time span of the data #85
esproc_spl profile

SQL: Perform statistics at different granularities based on the time span of the data #85

#sql #development #programming #opensource
7
Comments
2 min read
SQL: A Guide to Create a Relational Database with SQLite (and Export to Excel)
tjasper profile

SQL: A Guide to Create a Relational Database with SQLite (and Export to Excel)

#database #sql #softwaredevelopment #tutorial
6
Comments
4 min read
Understanding Sequelize's 'escape' function and why ideally we should avoid using it manually
gemmablack profile

Understanding Sequelize's 'escape' function and why ideally we should avoid using it manually

#sequelize #node #sql #owasp
Comments 2
6 min read
PostgreSQL - lowCalAlt_update2
itsizakb profile

PostgreSQL - lowCalAlt_update2

#sql #database #postgres #webdev
Comments
1 min read
Run a Local 💻 MySQL 🐬 Instance
op3ratordec profile

Run a Local 💻 MySQL 🐬 Instance

#mysql #sql #beginners #database
10
Comments
1 min read
SQL,Classify time-close events into a group and assign them a number #eg84
esproc_spl profile

SQL,Classify time-close events into a group and assign them a number #eg84

#sql #development #developers #spl
7
Comments
1 min read
Improve Your PostgreSQL Database Design and Management with a GUI Tool.
roxana_haidiner profile

Improve Your PostgreSQL Database Design and Management with a GUI Tool.

#postgres #sql #database #dbschema
9
Comments 2
6 min read
Day 3 of SQL Series || Basic Commands
akshat0610 profile

Day 3 of SQL Series || Basic Commands

#sql #tutorial #beginners #mysql
6
Comments
3 min read
End Of Series: SQL Injection Detect & Defend
trixsec profile

End Of Series: SQL Injection Detect & Defend

#sql #mysql #security #cybersecurity
5
Comments 1
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.