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.
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

4
Comments
2 min read
SQL: Select Statements

SQL: Select Statements

7
Comments
3 min read
A (not so) small rant on techniques to copy MySQL database structures

A (not so) small rant on techniques to copy MySQL database structures

6
Comments
4 min read
Visually Creating MySQL Queries With dbForge Studio for MySQL

Visually Creating MySQL Queries With dbForge Studio for MySQL

6
Comments
4 min read
SQL: Table Creation and Basic Queries

SQL: Table Creation and Basic Queries

6
Comments
3 min read
A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

4
Comments
2 min read
Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

16
Comments
6 min read
Temporal tables or JSON storage

Temporal tables or JSON storage

6
Comments
3 min read
Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

7
Comments
1 min read
Answer: Does the join order matter in SQL?

Answer: Does the join order matter in SQL?

2
Comments
1 min read
Automate SQL Queries in the cloud

Automate SQL Queries in the cloud

6
Comments
1 min read
Basic DB Using SQL Server (Part 1) - Basic commands!

Basic DB Using SQL Server (Part 1) - Basic commands!

9
Comments
3 min read
Makers - Week 4

Makers - Week 4

4
Comments
1 min read
i doing SQL tuning in Company databases but i don't know where to start

i doing SQL tuning in Company databases but i don't know where to start

3
Comments 3
1 min read
Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

5
Comments
8 min read
Answer: SQL Server - How to lock a table until a stored procedure finishes

Answer: SQL Server - How to lock a table until a stored procedure finishes

6
Comments
1 min read
Importing geo-partitioned data… the easy way

Importing geo-partitioned data… the easy way

3
Comments 1
1 min read
λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

8
Comments
3 min read
How to deploy project local to production server using gulp?

How to deploy project local to production server using gulp?

6
Comments 1
1 min read
What is an execution plan?

What is an execution plan?

5
Comments
1 min read
MySQL reserved words checker for Laravel migrations on PhpStorm

MySQL reserved words checker for Laravel migrations on PhpStorm

4
Comments
1 min read
Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

10
Comments
6 min read
Query optimization: from a few weeks to 24 hours

Query optimization: from a few weeks to 24 hours

16
Comments
4 min read
Introduction to Relational Database and SQL

Introduction to Relational Database and SQL

7
Comments
1 min read
14 SQL Query Performance Tuning Tips

14 SQL Query Performance Tuning Tips

10
Comments
9 min read
loading...