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 101: How Databases and Tables Are Structured

SQL 101: How Databases and Tables Are Structured

9
Comments
5 min read
The difference between regular views and materialized views in PostgreSQL

The difference between regular views and materialized views in PostgreSQL

7
Comments
1 min read
Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

18
Comments
8 min read
10 Things I Hate About SQL

10 Things I Hate About SQL

15
Comments 16
8 min read
SQL query from the view: considered hazardous!

SQL query from the view: considered hazardous!

8
Comments 4
5 min read
Using a PlSql cursor in a FOR loop example

Using a PlSql cursor in a FOR loop example

4
Comments
3 min read
SQL Server 2019 for Data Professionals

SQL Server 2019 for Data Professionals

2
Comments
2 min read
Create and drop oracle table example

Create and drop oracle table example

5
Comments 1
2 min read
SQL Review - WHERE, SELECT

SQL Review - WHERE, SELECT

3
Comments
2 min read
SQL Learning notes

SQL Learning notes

3
Comments
2 min read
Slow Queries? 10X Query Performance with a Database Index

Slow Queries? 10X Query Performance with a Database Index

5
Comments
5 min read
写给女朋友的 SQL 教程——数据模型

写给女朋友的 SQL 教程——数据模型

2
Comments
1 min read
Reacty Loops : fully web-based music production

Reacty Loops : fully web-based music production

7
Comments 2
1 min read
WishList Feature for eCommerce App using Java and Spring Boot

WishList Feature for eCommerce App using Java and Spring Boot

12
Comments
7 min read
Get the current unix timestamp in oracle

Get the current unix timestamp in oracle

7
Comments
1 min read
Implementing months_between() function in BigQuery

Implementing months_between() function in BigQuery

12
Comments 2
6 min read
UUIDs vs Auto-Incrementing Primary Keys in SQL

UUIDs vs Auto-Incrementing Primary Keys in SQL

30
Comments 1
7 min read
For relational algebra, there will be better alternatives to SQL (the language)?

For relational algebra, there will be better alternatives to SQL (the language)?

8
Comments 2
1 min read
Reporting in Power BI - Quick Steps

Reporting in Power BI - Quick Steps

3
Comments
1 min read
Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

7
Comments
14 min read
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

2
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

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

SQLite findings (on JSON and others)

7
Comments
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
Backup Postgres to S3

Backup Postgres to S3

25
Comments 6
1 min read
Faster SQL Bulk Inserts With C#

Faster SQL Bulk Inserts With C#

15
Comments 2
8 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.

14
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!

11
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
SQL Concepts

SQL Concepts

3
Comments
1 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
Mastering your SQL commands (Part 1)

Mastering your SQL commands (Part 1)

31
Comments
4 min read
Postman vs Sqlite3

Postman vs Sqlite3

2
Comments 2
1 min read
Working with geospatial data in Postgres.

Working with geospatial data in Postgres.

15
Comments
3 min read
Save Money and Frustration on Amazon using Azure Functions

Save Money and Frustration on Amazon using Azure Functions

28
Comments 4
26 min read
EF or Dapper?

EF or Dapper?

2
Comments 8
1 min read
Rails N+1 queries and eager loading

Rails N+1 queries and eager loading

48
Comments 10
3 min read
SQL & Databases

SQL & Databases

4
Comments
1 min read
SQL Aggregate Product

SQL Aggregate Product

6
Comments
1 min read
Make table and index creation faster in a multi-region CockroachDB environment

Make table and index creation faster in a multi-region CockroachDB environment

12
Comments
2 min read
Django: makemigrations and migrate

Django: makemigrations and migrate

5
Comments 2
1 min read
Filtering Data with SQL

Filtering Data with SQL

5
Comments
4 min read
SQL queries I wish I'd known when I started in data. Part 1: the event funnel.

SQL queries I wish I'd known when I started in data. Part 1: the event funnel.

13
Comments
7 min read
5 Reasons to Choose NoSQL Databases

5 Reasons to Choose NoSQL Databases

2
Comments
4 min read
What's a best way to visualize Postgres schema?

What's a best way to visualize Postgres schema?

3
Comments 1
1 min read
loading...