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.
PostgreSQL kümelemede Patroni kullanımı

PostgreSQL kümelemede Patroni kullanımı

11
Comments
5 min read
The Wrong Migration

The Wrong Migration

6
Comments
3 min read
Python with MySQL

Python with MySQL

5
Comments
7 min read
Build a fuzzy search with PostgreSQL

Build a fuzzy search with PostgreSQL

11
Comments 1
5 min read
Database Naming Standards

Database Naming Standards

101
Comments 20
6 min read
SQL: Basics to Advanced in a Nutshell

SQL: Basics to Advanced in a Nutshell

10
Comments 2
8 min read
Handle historical versions on a database record

Handle historical versions on a database record

4
Comments 2
4 min read
EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

8
Comments
5 min read
SQL: Calculate Bussiness Days

SQL: Calculate Bussiness Days

2
Comments 2
1 min read
What is Amazon RDS? Explained through Comics

What is Amazon RDS? Explained through Comics

2
Comments
1 min read
How to create tables on Heroku Postgresql

How to create tables on Heroku Postgresql

13
Comments 3
3 min read
Understanding the difference between where and select in Rails

Understanding the difference between where and select in Rails

14
Comments
3 min read
Cracking the PostgreSQL Interview

Cracking the PostgreSQL Interview

55
Comments
6 min read
The Ultimate Hasura Development Setup

The Ultimate Hasura Development Setup

8
Comments
3 min read
SQL Review - Differences Between MySQL and PostgreSQL

SQL Review - Differences Between MySQL and PostgreSQL

9
Comments 2
4 min read
Building an event information portal with ASP.NET 5 & DotVVM

Building an event information portal with ASP.NET 5 & DotVVM

7
Comments
10 min read
Fix Your dbt Concurrent Transaction Database Error

Fix Your dbt Concurrent Transaction Database Error

4
Comments
1 min read
What is CrateDB? 🤔 FAQ (1)

What is CrateDB? 🤔 FAQ (1)

4
Comments 2
3 min read
Best Practices Working with Billion-row Tables in Databases

Best Practices Working with Billion-row Tables in Databases

4
Comments
2 min read
How to monitor backup and restore progress in SQL Server

How to monitor backup and restore progress in SQL Server

5
Comments
2 min read
One-To-Many Database Relationships Complete How To

One-To-Many Database Relationships Complete How To

10
Comments 4
7 min read
How to ace the Facebook data scientist interview

How to ace the Facebook data scientist interview

6
Comments
8 min read
How to Complete a Udemy Course

How to Complete a Udemy Course

11
Comments
2 min read
Effective SQL - Indexing and denormalizing JSONB

Effective SQL - Indexing and denormalizing JSONB

38
Comments
4 min read
The “insert if not exists” challenge: a solution

The “insert if not exists” challenge: a solution

7
Comments
6 min read
CRUD with C#/SQL in .NET Core

CRUD with C#/SQL in .NET Core

6
Comments 2
2 min read
Obtendo dados de CNPJ's com a API Minha Receita

Obtendo dados de CNPJ's com a API Minha Receita

25
Comments 4
7 min read
Get your SQL functions in DQL

Get your SQL functions in DQL

5
Comments
2 min read
How to write a SQL Inner Join

How to write a SQL Inner Join

7
Comments
2 min read
How to create an SQLite database in node.js

How to create an SQLite database in node.js

7
Comments
2 min read
Console.bLog(studyNotes)

Console.bLog(studyNotes)

4
Comments
5 min read
SQL 101: How Databases and Tables Are Structured

SQL 101: How Databases and Tables Are Structured

8
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

13
Comments 15
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

6
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

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

UUIDs vs Auto-Incrementing Primary Keys in SQL

28
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
Case sensitivity in SQL

Case sensitivity in SQL

3
Comments
1 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

23
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
loading...