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.
SQL is 50 Years Old. What Can We Learn From Its Success?

SQL is 50 Years Old. What Can We Learn From Its Success?

5
Comments
11 min read
SQL for Beginners

SQL for Beginners

4
Comments
4 min read
Hacking Ecto: Constructing Ecto Query from Raw SQL

Hacking Ecto: Constructing Ecto Query from Raw SQL

6
Comments
3 min read
Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

2
Comments
10 min read
Step by step guide on how to create an Asp.Net Core MVC CRUD, Ef Core code first approach

Step by step guide on how to create an Asp.Net Core MVC CRUD, Ef Core code first approach

25
Comments
8 min read
SQLite findings (on JSON and others)

SQLite findings (on JSON and others)

7
Comments 1
3 min read
Bulk Update: Active Record Vs. native SQL

Bulk Update: Active Record Vs. native SQL

12
Comments 1
5 min read
How to dump your sql database into a sql file

How to dump your sql database into a sql file

2
Comments
1 min read
Different Types of SQL JOINs

Different Types of SQL JOINs

6
Comments 2
2 min read
Get The Most Out of Your Postgres Database with SeeQR

Get The Most Out of Your Postgres Database with SeeQR

2
Comments
4 min read
Window Functions, Visualized - Rankings

Window Functions, Visualized - Rankings

4
Comments
3 min read
Faster SQL Bulk Inserts With C#

Faster SQL Bulk Inserts With C#

15
Comments 2
8 min read
Backup Postgres to S3

Backup Postgres to S3

29
Comments 6
1 min read
Sort by timestamps (month and year) in PostgreSQL

Sort by timestamps (month and year) in PostgreSQL

7
Comments
1 min read
Assembling a query optimizer with Apache Calcite

Assembling a query optimizer with Apache Calcite

6
Comments
9 min read
How to parse Time in GOLANG work with SQL.

How to parse Time in GOLANG work with SQL.

15
Comments 4
2 min read
Window Function Calls in Postgres - a Visual Introduction

Window Function Calls in Postgres - a Visual Introduction

7
Comments
4 min read
Online Laravel migration!

Online Laravel migration!

13
Comments
1 min read
REDIS: NOSQL DBS

REDIS: NOSQL DBS

3
Comments
1 min read
Mastering your SQL commands (Part 2)

Mastering your SQL commands (Part 2)

19
Comments
3 min read
Who has ever integrated SQLITE3 with Django?, in Jupyterlab?

Who has ever integrated SQLITE3 with Django?, in Jupyterlab?

2
Comments
1 min read
The SQL Savant: Outer Joins in SQL

The SQL Savant: Outer Joins in SQL

9
Comments
3 min read
RDBMS Concept

RDBMS Concept

3
Comments
2 min read
Becoming a SQL Guru with Recursive CTEs

Becoming a SQL Guru with Recursive CTEs

5
Comments
5 min read
Linq2DB CRUD Operations

Linq2DB CRUD Operations

11
Comments
2 min read
loading...