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 Injection

SQL Injection

4
Comments
2 min read
SQL Tip - Weird Behaviour of SUM or any operator When joining more than 2 tables

SQL Tip - Weird Behaviour of SUM or any operator When joining more than 2 tables

4
Comments 1
1 min read
Don't miss this Data for Good panel at MS Create: Data

Don't miss this Data for Good panel at MS Create: Data

16
Comments 1
1 min read
UPDATE … FROM for database normalisation

UPDATE … FROM for database normalisation

6
Comments
1 min read
Example of Stored Procedures in PostgreSQL

Example of Stored Procedures in PostgreSQL

11
Comments 1
2 min read
Move your sql database files to a separate hard drive

Move your sql database files to a separate hard drive

7
Comments
3 min read
Built in String Functions in SQL

Built in String Functions in SQL

5
Comments
2 min read
Autoscaling Azure SQL Hyperscale

Autoscaling Azure SQL Hyperscale

9
Comments
10 min read
DB Administration tools on Linux

DB Administration tools on Linux

4
Comments 2
1 min read
Convert user story of a simple library to ER and Relational diagrams in less than 10mins

Convert user story of a simple library to ER and Relational diagrams in less than 10mins

22
Comments 2
2 min read
Supabase: nine months of building. 03:00

Supabase: nine months of building.

44
Comments 6
2 min read
Advent Of Code 2020 in SQL - Day 1: "Report Repair"

Advent Of Code 2020 in SQL - Day 1: "Report Repair"

2
Comments
4 min read
DRYing up Rails Scopes and Instance Methods

DRYing up Rails Scopes and Instance Methods

5
Comments
4 min read
Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

2
Comments
1 min read
Office Hours With A Data Consultant To Develop Your Data Analytics Strategy For 2021

Office Hours With A Data Consultant To Develop Your Data Analytics Strategy For 2021

5
Comments
8 min read
SQLPad - Quick Start With Docker

SQLPad - Quick Start With Docker

10
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

10
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.

6
Comments
7 min read
Querying JSON and its nested objects with TSQL

Querying JSON and its nested objects with TSQL

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

11
Comments 3
4 min read
Role based security database design

Role based security database design

18
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

10
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
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

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