DEV Community

loading...

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability sort posts by top and latest.
The Ultimate Hasura Development Setup

The Ultimate Hasura Development Setup

Reactions 5 Comments
3 min read
How to create tables on Heroku Postgresql

How to create tables on Heroku Postgresql

Reactions 4 Comments
3 min read
How to Complete a Udemy Course

How to Complete a Udemy Course

Reactions 2 Comments
2 min read
Differences Between MySQL and PostgreSQL

Differences Between MySQL and PostgreSQL

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

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

Reactions 5 Comments
10 min read
Try CrateDB Cloud for free 🐐

Try CrateDB Cloud for free 🐐

Reactions 5 Comments
4 min read
What is CrateDB? 🤔 FAQ

What is CrateDB? 🤔 FAQ

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

Understanding the difference between where and select in Rails

Reactions 12 Comments
3 min read
Cracking the PostgreSQL Interview

Cracking the PostgreSQL Interview

Reactions 35 Comments
6 min read
Handle historical versions on a database record

Handle historical versions on a database record

Reactions 4 Comments 2
4 min read
SQL: Calculate Bussiness Days

SQL: Calculate Bussiness Days

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

What is Amazon RDS? Explained through Comics

Reactions 2 Comments
1 min read
Database Naming Standards

Database Naming Standards

Reactions 99 Comments 6
6 min read
How to monitor backup and restore progress in SQL Server

How to monitor backup and restore progress in SQL Server

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

Obtendo dados de CNPJ's com a API Minha Receita

Reactions 13 Comments 1
7 min read
Fix Your dbt Concurrent Transaction Database Error

Fix Your dbt Concurrent Transaction Database Error

Reactions 2 Comments
1 min read
SQL & database monthly wrap up - February 2021

SQL & database monthly wrap up - February 2021

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

Reacty Loops : fully web-based music production

Reactions 7 Comments
1 min read
Using a PlSql cursor in a FOR loop example

Using a PlSql cursor in a FOR loop example

Reactions 6 Comments
3 min read
How to ace the Facebook data scientist interview

How to ace the Facebook data scientist interview

Reactions 7 Comments
8 min read
One-To-Many Database Relationships Complete How To

One-To-Many Database Relationships Complete How To

Reactions 8 Comments
6 min read
Create and drop oracle table example

Create and drop oracle table example

Reactions 6 Comments
2 min read
How to write a SQL Inner Join

How to write a SQL Inner Join

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

How to create an SQLite database in node.js

Reactions 6 Comments
2 min read
Criando uma API SQL para Twitter com Typescript - Parte 0

Criando uma API SQL para Twitter com Typescript - Parte 0

Reactions 7 Comments
2 min read
Effective SQL - Indexing and denormalizing JSONB

Effective SQL - Indexing and denormalizing JSONB

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

The “insert if not exists” challenge: a solution

Reactions 7 Comments
6 min read
Five classic SQL & database posts - February 2021

Five classic SQL & database posts - February 2021

Reactions 38 Comments
2 min read
How do I add an item to a database without reloading the page?

How do I add an item to a database without reloading the page?

Reactions 9 Comments 8
1 min read
CRUD with C#/SQL in .NET Core

CRUD with C#/SQL in .NET Core

Reactions 6 Comments 2
2 min read
Get your SQL functions in DQL

Get your SQL functions in DQL

Reactions 5 Comments
2 min read
Console.bLog(studyNotes)

Console.bLog(studyNotes)

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

The difference between regular views and materialized views in PostgreSQL

Reactions 7 Comments
1 min read
SQL 101: How Databases and Tables Are Structured

SQL 101: How Databases and Tables Are Structured

Reactions 2 Comments
5 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

Reactions 15 Comments
8 min read
10 Things I Hate About SQL

10 Things I Hate About SQL

Reactions 11 Comments 14
8 min read
SQL query from the view: considered hazardous!

SQL query from the view: considered hazardous!

Reactions 7 Comments 4
5 min read
SQL & database wrap up - January 2021

SQL & database wrap up - January 2021

Reactions 12 Comments 2
2 min read
SQL Server 2019 for Data Professionals

SQL Server 2019 for Data Professionals

Reactions 2 Comments
2 min read
SQL Review

SQL Review

Reactions 2 Comments
2 min read
Introducing SAYN: A Simple Yet Powerful Data Processing Framework.

Introducing SAYN: A Simple Yet Powerful Data Processing Framework.

Reactions 3 Comments 1
5 min read
Slow Queries? 10X Query Performance with a Database Index

Slow Queries? 10X Query Performance with a Database Index

Reactions 5 Comments
5 min read
The Town Analogy for database architecture

The Town Analogy for database architecture

Reactions 1 Comments
3 min read
Sort by timestamps (month and year) in PostgreSQL

Sort by timestamps (month and year) in PostgreSQL

Reactions 5 Comments
1 min read
Get the current unix timestamp in oracle

Get the current unix timestamp in oracle

Reactions 6 Comments
1 min read
WishList Feature for eCommerce App using Java and Spring Boot

WishList Feature for eCommerce App using Java and Spring Boot

Reactions 8 Comments
7 min read
Implementing months_between() function in BigQuery

Implementing months_between() function in BigQuery

Reactions 10 Comments
6 min read
UUIDs vs Auto-Incrementing Primary Keys in SQL

UUIDs vs Auto-Incrementing Primary Keys in SQL

Reactions 22 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)?

Reactions 9 Comments 2
1 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?

Reactions 2 Comments
11 min read
Reporting in Power BI - Quick Steps

Reporting in Power BI - Quick Steps

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

Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

Reactions 2 Comments
14 min read
SQL for Beginners

SQL for Beginners

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

Hacking Ecto: Constructing Ecto Query from Raw SQL

Reactions 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

Reactions 2 Comments
10 min read
Case sensitivity in SQL

Case sensitivity in SQL

Reactions 3 Comments
1 min read
SQLite findings (on JSON and others)

SQLite findings (on JSON and others)

Reactions 6 Comments
3 min read
How to insert date in MySQL using PHP

How to insert date in MySQL using PHP

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

Reactions 6 Comments
8 min read
Three differences between TRUNCATE and DELETE

Three differences between TRUNCATE and DELETE

Reactions 6 Comments
4 min read
loading...