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.
Optimistic lock on Ruby on Rails

Optimistic lock on Ruby on Rails

12
Comments
3 min read
A Deeper Dive Into SQL

A Deeper Dive Into SQL

6
Comments 2
3 min read
Find the N+1 Query Problem in Rails Apps in Under 5 Mins 04:34

Find the N+1 Query Problem in Rails Apps in Under 5 Mins

29
Comments
1 min read
TIL PostgreSQL-style $facet

TIL PostgreSQL-style $facet

6
Comments
1 min read
What is SQL - Part 1

What is SQL - Part 1

8
Comments
3 min read
[Facts Alert]When to use which one ?MySQL Vs MongoDB

[Facts Alert]When to use which one ?MySQL Vs MongoDB

6
Comments 4
3 min read
Advanced SQL - PostgreSQL

Advanced SQL - PostgreSQL

6
Comments
2 min read
Understanding multiple joins in ActiveRecord

Understanding multiple joins in ActiveRecord

18
Comments
5 min read
Anything I Want With Sequel And Postgres

Anything I Want With Sequel And Postgres

8
Comments 3
7 min read
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

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

Emacs as SQL client with LSP

38
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

13
Comments 1
5 min read
Database Naming Standards

Database Naming Standards

257
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

12
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

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