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.
SQLPad - Quick Start With Docker

SQLPad - Quick Start With Docker

9
Comments 4
2 min read
Rails SQL Injections

Rails SQL Injections

9
Comments
5 min read
Exporting a sql database from phpmyadmin and copying it to your local machine when you have lots of foreign key constraints

Exporting a sql database from phpmyadmin and copying it to your local machine when you have lots of foreign key constraints

2
Comments
1 min read
SQL CROSS JOINs

SQL CROSS JOINs

7
Comments 1
2 min read
Run SQL in Slack

Run SQL in Slack

43
Comments 15
2 min read
DynamoDB PartiQL - part II: SELECT

DynamoDB PartiQL - part II: SELECT

8
Comments
9 min read
Enabling pgAudit, pgcrypto and scram-SHA-256 in Distributed SQL

Enabling pgAudit, pgcrypto and scram-SHA-256 in Distributed SQL

11
Comments
7 min read
SQL101 SQL Basics (NoSQL to SQL) all on Oracle Autonomous Database 49:36

SQL101 SQL Basics (NoSQL to SQL) all on Oracle Autonomous Database

3
Comments
1 min read
HarperDB vs. MongoDB vs. PostgreSQL

HarperDB vs. MongoDB vs. PostgreSQL

85
Comments 7
6 min read
DynamoDB PartiQL – part I: INSERT

DynamoDB PartiQL – part I: INSERT

12
Comments
7 min read
Re-Wheel series part 1 - How does Rails' find_each work?

Re-Wheel series part 1 - How does Rails' find_each work?

13
Comments
4 min read
varchar(n) - how big should n be?

varchar(n) - how big should n be?

2
Comments 4
1 min read
Use PowerShell to create a SQL Azure firewall rule for your current IP

Use PowerShell to create a SQL Azure firewall rule for your current IP

6
Comments
3 min read
SQL Join vs Subquery: The Game Changer

SQL Join vs Subquery: The Game Changer

36
Comments 2
3 min read
MSQL Subquery

MSQL Subquery

6
Comments 1
1 min read
Create SQL from CSV files for larger updation or insertion

Create SQL from CSV files for larger updation or insertion

6
Comments
2 min read
What is time-series data, and why are we building a time-series database (TSDB)?

What is time-series data, and why are we building a time-series database (TSDB)?

17
Comments
7 min read
What are SQL Joins? Types of SQL joins explained

What are SQL Joins? Types of SQL joins explained

66
Comments 1
6 min read
Write complex SQL with sub query easily in Rails

Write complex SQL with sub query easily in Rails

9
Comments 3
1 min read
Entity-attribute-value model in relational databases. Should globals be emulated on tables? Part 1.

Entity-attribute-value model in relational databases. Should globals be emulated on tables? Part 1.

4
Comments
7 min read
4 Quick Facts About dbt Testing

4 Quick Facts About dbt Testing

10
Comments
4 min read
Basics SQL - CREATE Database

Basics SQL - CREATE Database

12
Comments
1 min read
Implement a kafka like consumer strategy to process records in your database

Implement a kafka like consumer strategy to process records in your database

6
Comments
3 min read
How To Integrate HoneySQL with PostgreSQL

How To Integrate HoneySQL with PostgreSQL

4
Comments
3 min read
Fast & reliable JSONB deep structure update in PostgreSQL

Fast & reliable JSONB deep structure update in PostgreSQL

19
Comments
4 min read
SQL Cheat Sheet: Top 10 Most Important SQL Commands To Know

SQL Cheat Sheet: Top 10 Most Important SQL Commands To Know

36
Comments 1
3 min read
SQL: DDL Basic command examples

SQL: DDL Basic command examples

7
Comments 4
1 min read
What is "SQL Injection" and how to protect our database?

What is "SQL Injection" and how to protect our database?

9
Comments 2
1 min read
Battling RecordNotUnique in Rails

Battling RecordNotUnique in Rails

10
Comments 3
4 min read
Role based security database design

Role based security database design

14
Comments
3 min read
🚀 3 Tools To Scale and Grow Your Side Projects

🚀 3 Tools To Scale and Grow Your Side Projects

73
Comments 11
3 min read
[Video] How to install the latest stable MariaDB version on CentOS 8

[Video] How to install the latest stable MariaDB version on CentOS 8

15
Comments 1
1 min read
Types of NoSQL Databases

Types of NoSQL Databases

5
Comments
4 min read
The limits of 2 dimensions

The limits of 2 dimensions

9
Comments 2
8 min read
What is mongo DB ? and why it is getting more popularity?

What is mongo DB ? and why it is getting more popularity?

21
Comments 6
2 min read
Cliff - The rust DBMS

Cliff - The rust DBMS

6
Comments 2
1 min read
DuckDB: an embedded DB for data wrangling

DuckDB: an embedded DB for data wrangling

2
Comments
3 min read
Connect the DataBase | SQLite-Python Series

Connect the DataBase | SQLite-Python Series

10
Comments 2
2 min read
Introduction to full-text operators and basic search

Introduction to full-text operators and basic search

6
Comments 2
10 min read
Sinatra CRUD MVC Project

Sinatra CRUD MVC Project

3
Comments
2 min read
How and When to Use SQL Window Functions

How and When to Use SQL Window Functions

7
Comments
2 min read
MySQL or MongoDB? What to Choose for your Next Project?

MySQL or MongoDB? What to Choose for your Next Project?

41
Comments 13
2 min read
Rails 6.1 supports order DESC for find_each, find_in_batches, and in_batches

Rails 6.1 supports order DESC for find_each, find_in_batches, and in_batches

4
Comments
1 min read
How to Install MySQL Workbench On Windows

How to Install MySQL Workbench On Windows

10
Comments 1
3 min read
Kubernetes: running SQL migrations with Kubernetes Job and Helm hook

Kubernetes: running SQL migrations with Kubernetes Job and Helm hook

13
Comments
11 min read
How to Backup and Restore SQL Database from One Server to Another Server

How to Backup and Restore SQL Database from One Server to Another Server

4
Comments
3 min read
XAMPP Installation Step By Step on MacOs

XAMPP Installation Step By Step on MacOs

10
Comments 3
2 min read
QuestDB announces Grafana support

QuestDB announces Grafana support

7
Comments
1 min read
SQL Query Inner Join for SUM Amount

SQL Query Inner Join for SUM Amount

6
Comments 1
3 min read
Beginners guide to Integrating Python and SQL

Beginners guide to Integrating Python and SQL

27
Comments 1
4 min read
DynamicODataToSQL : dotnet OData to SQL query converter

DynamicODataToSQL : dotnet OData to SQL query converter

2
Comments
1 min read
A new TypeScript Postgres query builder

A new TypeScript Postgres query builder

8
Comments
4 min read
Geospatial Data: A New Dimension for .NET

Geospatial Data: A New Dimension for .NET

4
Comments
1 min read
Simple CRUD REST API With Lumen + MySQL + Eloquent ORM

Simple CRUD REST API With Lumen + MySQL + Eloquent ORM

29
Comments 3
8 min read
#003 How to run SQL server on ubuntu; how to (re)start SQL server on ubuntu; how to stop SQL server on ubuntu

#003 How to run SQL server on ubuntu; how to (re)start SQL server on ubuntu; how to stop SQL server on ubuntu

3
Comments 1
1 min read
How to Drop All Tables in PostgreSQL Database

How to Drop All Tables in PostgreSQL Database

6
Comments
4 min read
Two free tools to format SQL queries

Two free tools to format SQL queries

8
Comments
3 min read
Lakers < ActiveRecord::Base

Lakers < ActiveRecord::Base

26
Comments 9
9 min read
Se conectando ao PostgreSQL usando Golang

Se conectando ao PostgreSQL usando Golang

18
Comments 4
11 min read
3 Things I wish I knew about databases two years ago

3 Things I wish I knew about databases two years ago

5
Comments
3 min read
loading...