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.
How to Manage Your SQL Server Database Effectively
auyeungdavid_2847435260 profile

How to Manage Your SQL Server Database Effectively

#database #sqlserver #sql #sqlserverdatabaseproject
6
Comments 1
3 min read
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.