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.
When to Use JSON Data in a Relational Database

When to Use JSON Data in a Relational Database

3
Comments
6 min read
Understanding 'Single' vs "Double" Quotation Marks in PostgreSQL

Understanding 'Single' vs "Double" Quotation Marks in PostgreSQL

1
Comments
3 min read
CRUD and SQL - the basics!

CRUD and SQL - the basics!

64
Comments 9
5 min read
Oracle SQL database with CodeIgniter?

Oracle SQL database with CodeIgniter?

Comments
2 min read
YugabyteDB avoids bloat with the outbox pattern

YugabyteDB avoids bloat with the outbox pattern

3
Comments
6 min read
Back to Basics #3 - Databases and SQL Fundamentals

Back to Basics #3 - Databases and SQL Fundamentals

3
Comments
2 min read
Monitoring Is Not Enough and Understanding Through Observability Is the Key

Monitoring Is Not Enough and Understanding Through Observability Is the Key

Comments
13 min read
SQL and PostgreSQL for Advanced Full-Text Search

SQL and PostgreSQL for Advanced Full-Text Search

1
Comments
5 min read
Handling JSON data in SQL Databases

Handling JSON data in SQL Databases

1
Comments
3 min read
Why do I put a table between the images and the data

Why do I put a table between the images and the data

Comments
4 min read
SQL looks like English is a well-intentioned error

SQL looks like English is a well-intentioned error

12
Comments 5
4 min read
Understanding Custom Functions in DuckDB

Understanding Custom Functions in DuckDB

13
Comments
2 min read
Covering Index nuances: which columns to cover (WHERE, ORDER BY, LIMIT, SELECT)?

Covering Index nuances: which columns to cover (WHERE, ORDER BY, LIMIT, SELECT)?

2
Comments
12 min read
Querying MongoDB Like an SQL DB Using Aggregation Pipeline

Querying MongoDB Like an SQL DB Using Aggregation Pipeline

Comments
8 min read
18 GitHub Repositories You Need to Star Right Now! 🌟🔥

18 GitHub Repositories You Need to Star Right Now! 🌟🔥

65
Comments 5
4 min read
SQL Assistant: Text-to-SQL Application in Streamlit 🤖

SQL Assistant: Text-to-SQL Application in Streamlit 🤖

64
Comments
6 min read
PostgreSQL Backup and Restore Strategies: A Comprehensive Guide

PostgreSQL Backup and Restore Strategies: A Comprehensive Guide

4
Comments
5 min read
How to Write a SQL Subquery with Drizzle ORM

How to Write a SQL Subquery with Drizzle ORM

Comments
2 min read
Unveiling the Potential of the COUNT Function in SQL

Unveiling the Potential of the COUNT Function in SQL

1
Comments
3 min read
The Basics of SQL Joins

The Basics of SQL Joins

Comments
2 min read
SQL - Efficiently Paginate Query Results

SQL - Efficiently Paginate Query Results

Comments
1 min read
How to Create a Front End for a SQL Server Database in 4 Steps

How to Create a Front End for a SQL Server Database in 4 Steps

Comments
21 min read
How I can see what queries run in my mssql server once I exeture them via eloquent model?

How I can see what queries run in my mssql server once I exeture them via eloquent model?

Comments
2 min read
Corrected Code: List Typo

Corrected Code: List Typo

Comments
1 min read
MikroORM 6: Polished

MikroORM 6: Polished

Comments
16 min read
loading...