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
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
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
SQL: Recursive calculation of tree like hierarchical structure #eg83
esproc_spl profile

SQL: Recursive calculation of tree like hierarchical structure #eg83

#sql #development #spl #developers
6
Comments
2 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
Just-in-Time Database Access
op3ratordec profile

Just-in-Time Database Access

#database #sql #productivity #security
5
Comments
2 min read
Updating from System.Data.SqlClient to Microsoft.Data.SqlClient
deadlydog profile

Updating from System.Data.SqlClient to Microsoft.Data.SqlClient

#net #c #sql
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.