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 To Select Data From Databases Using SQL

SQL 101: How To Select Data From Databases Using SQL

7
Comments
4 min read
Search MySQL Like Google Using Match and Full-Text Search

Search MySQL Like Google Using Match and Full-Text Search

18
Comments
7 min read
PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

7
Comments 2
1 min read
Compiling MariaDB from Source - On FreeBSD

Compiling MariaDB from Source - On FreeBSD

7
Comments
2 min read
First steps with SQL

First steps with SQL

2
Comments
3 min read
How can i create a CRON operation to add numbers based on timed events in my database.

How can i create a CRON operation to add numbers based on timed events in my database.

6
Comments
1 min read
Dev life is easy with node-mssql

Dev life is easy with node-mssql

16
Comments 1
2 min read
Reimagining the SQL Curriculum: Change How SQL is Taught

Reimagining the SQL Curriculum: Change How SQL is Taught

4
Comments
9 min read
Farewell to our Enterprise License

Farewell to our Enterprise License

5
Comments
4 min read
Let's talk about Views

Let's talk about Views

5
Comments
2 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

115
Comments 5
6 min read
Emacs as SQL client with LSP

Emacs as SQL client with LSP

37
Comments 1
5 min read
SQL Review - How to create an ERD in MySQL

SQL Review - How to create an ERD in MySQL

3
Comments
1 min read
SQLite - a developer's best friend

SQLite - a developer's best friend

28
Comments 6
8 min read
Understanding ActiveRecord left outer joins

Understanding ActiveRecord left outer joins

11
Comments
5 min read
Announcing EFCore.FSharp

Announcing EFCore.FSharp

11
Comments 1
3 min read
How Can i create a Secure SignIn Portal In PHP after Using Password Hash on SignUp Page.

How Can i create a Secure SignIn Portal In PHP after Using Password Hash on SignUp Page.

7
Comments 5
2 min read
SQL tips that will make you productive from day1 at your job.

SQL tips that will make you productive from day1 at your job.

4
Comments
1 min read
Understanding ActiveRecord inner joins

Understanding ActiveRecord inner joins

10
Comments
7 min read
PostgreSQL kümelemede Patroni kullanımı

PostgreSQL kümelemede Patroni kullanımı

12
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

12
Comments 1
5 min read
Database Naming Standards

Database Naming Standards

237
Comments 20
6 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

9
Comments
5 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
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

12
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
The Ultimate Hasura Development Setup

The Ultimate Hasura Development Setup

9
Comments
3 min read
Cracking the PostgreSQL Interview

Cracking the PostgreSQL Interview

55
Comments
6 min read
SQL Review - Differences Between MySQL and PostgreSQL

SQL Review - Differences Between MySQL and PostgreSQL

9
Comments 2
4 min read
Becoming A Data Analyst

Becoming A Data Analyst

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

11
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

7
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

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

Get your SQL functions in DQL

6
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

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

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

SQL Review - WHERE, SELECT

3
Comments
2 min read
loading...