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.
Go further with Airtable using Postgres Arrays

Go further with Airtable using Postgres Arrays

9
Comments
8 min read
Database Design and the GDPR

Database Design and the GDPR

33
Comments 7
3 min read
Azure Datafactory pricing simplified

Azure Datafactory pricing simplified

5
Comments
4 min read
Database Normalizarion

Database Normalizarion

8
Comments 1
3 min read
Run PostgreSQL + PGAdmin in pods using podman

Run PostgreSQL + PGAdmin in pods using podman

25
Comments 1
3 min read
Use mycli and Learn MariaDB/MySQL comfortably in a terminal!

Use mycli and Learn MariaDB/MySQL comfortably in a terminal!

5
Comments
5 min read
The Future Of Data Science, Data Engineering And Tech: 6 Experts Views On Tech In 2021

The Future Of Data Science, Data Engineering And Tech: 6 Experts Views On Tech In 2021

9
Comments
7 min read
Filter records in a many to many relationship in rails

Filter records in a many to many relationship in rails

9
Comments
2 min read
Weekly Update #004

Weekly Update #004

4
Comments
1 min read
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

8
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

23
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

11
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

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