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.
Ordering fuzzy search results by relevancy using trigrams
Cover image for Ordering fuzzy search results by relevancy using trigrams

Ordering fuzzy search results by relevancy using trigrams

6
Comments
5 min read
Rule-based Query Optimization
Cover image for Rule-based Query Optimization

Rule-based Query Optimization

4
Comments
7 min read
Best Practices to Become a Data Engineer
Cover image for Best Practices to Become a Data Engineer

Best Practices to Become a Data Engineer

9
Comments
11 min read
How to make the most out of #100DaysOfCode
Cover image for How to make the most out of #100DaysOfCode

How to make the most out of #100DaysOfCode

7
Comments
3 min read
SqlAlchemy: simplify complex joins

SqlAlchemy: simplify complex joins

5
Comments
3 min read
Understanding 'Cursor' in SQL
Cover image for Understanding 'Cursor' in SQL

Understanding 'Cursor' in SQL

4
Comments 1
1 min read
SQL Migrations with Cobra & Golang Migrate
Cover image for SQL Migrations with Cobra & Golang Migrate

SQL Migrations with Cobra & Golang Migrate

19
Comments
4 min read
Relational vs Non-Relational Database | Simple Explanation 🚀
Cover image for Relational vs Non-Relational Database | Simple Explanation  🚀

Relational vs Non-Relational Database | Simple Explanation 🚀

3
Comments 1
4 min read
SQLAlchemy Core in Python: Getting Started
Cover image for SQLAlchemy Core in Python: Getting Started

SQLAlchemy Core in Python: Getting Started

5
Comments
2 min read
4 Free AWS courses on PostgreSQL
Cover image for 4 Free AWS courses on PostgreSQL

4 Free AWS courses on PostgreSQL

4
Comments 1
1 min read
Sequelize's "Super Many-to-Many" Associations
Cover image for Sequelize's "Super Many-to-Many" Associations

Sequelize's "Super Many-to-Many" Associations

7
Comments 1
4 min read
How Database Load Balancing Completes the 3-Tiered Architecture

How Database Load Balancing Completes the 3-Tiered Architecture

6
Comments
5 min read
Should SQL Query through REST API be a GET or a POST?

Should SQL Query through REST API be a GET or a POST?

8
Comments 8
1 min read
Daily Share Price Notifications using Python, SQL and Africas Talking - Part One
Cover image for Daily Share Price Notifications using Python, SQL and Africas Talking - Part One

Daily Share Price Notifications using Python, SQL and Africas Talking - Part One

24
Comments 6
12 min read
I want to manually delete rows, so tell me about all referenced tables
Cover image for I want to manually delete rows, so tell me about all referenced tables

I want to manually delete rows, so tell me about all referenced tables

6
Comments
1 min read
PIVOT-UNPIVOT

PIVOT-UNPIVOT

7
Comments
1 min read
Flask app with postgreSQL
Cover image for Flask app with postgreSQL

Flask app with postgreSQL

6
Comments
1 min read
Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python
Cover image for Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

11
Comments 1
15 min read
Oracle Cheat Sheet
Cover image for Oracle Cheat Sheet

Oracle Cheat Sheet

43
Comments 2
5 min read
What is Stored Procedure in SQL
Cover image for What is Stored Procedure in SQL

What is Stored Procedure in SQL

6
Comments
1 min read
How Database Load Balancing Completes the 3-Tiered Architecture

How Database Load Balancing Completes the 3-Tiered Architecture

5
Comments
5 min read
Loading Test Data into PostgreSQL
Cover image for Loading Test Data into PostgreSQL

Loading Test Data into PostgreSQL

6
Comments 1
9 min read
Custom traits in Apache Calcite
Cover image for Custom traits in Apache Calcite

Custom traits in Apache Calcite

4
Comments
7 min read
Combining SQL outer joins with inner joins

Combining SQL outer joins with inner joins

5
Comments
2 min read
Getting started with PostgreSQL Set Operators
Cover image for Getting started with PostgreSQL Set Operators

Getting started with PostgreSQL Set Operators

7
Comments
4 min read
loading...