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.
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

10
Comments
17 min read
Understanding Database Normalization and the Importance of 1NF

Understanding Database Normalization and the Importance of 1NF

2
Comments
3 min read
Bulk Insert, Bulk Delete, Bulk Update with Dapper by Bulk.Dapper

Bulk Insert, Bulk Delete, Bulk Update with Dapper by Bulk.Dapper

Comments
2 min read
What is Querying a Database? Everything You Need to Know

What is Querying a Database? Everything You Need to Know

5
Comments
2 min read
How to use pgbench to test PostgreSQL® performance

How to use pgbench to test PostgreSQL® performance

Comments
5 min read
Query Documents from PostgreSQL like MongoDB

Query Documents from PostgreSQL like MongoDB

Comments
1 min read
Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

Comments
3 min read
How To Master PostgreSQL Performance Like Never Before

How To Master PostgreSQL Performance Like Never Before

1
Comments
14 min read
Harnessing SQL's PRECEDING and FOLLOWING: Advanced Data Analysis with Window Functions

Harnessing SQL's PRECEDING and FOLLOWING: Advanced Data Analysis with Window Functions

4
Comments 1
8 min read
B-Tree vs. LSM-Tree: measuring the write amplification on Oracle Database and YugabyteDB

B-Tree vs. LSM-Tree: measuring the write amplification on Oracle Database and YugabyteDB

Comments
10 min read
Integrate sqlite with Nodejs ! 🔥

Integrate sqlite with Nodejs ! 🔥

17
Comments 1
2 min read
SQL Injection attack

SQL Injection attack

Comments
2 min read
Handling NEW and OLD Immutability in PostgreSQL Triggers

Handling NEW and OLD Immutability in PostgreSQL Triggers

Comments
2 min read
Exploring the Database Spectrum. A Look at SQL and NoSQL Technologies.

Exploring the Database Spectrum. A Look at SQL and NoSQL Technologies.

1
Comments
11 min read
YugabyteDB Transactional Load with Non-transactional COPY

YugabyteDB Transactional Load with Non-transactional COPY

Comments
3 min read
What's the equivalent of pageinspect in YugabyteDB?

What's the equivalent of pageinspect in YugabyteDB?

Comments
15 min read
Understanding ON DELETE CASCADE and ON UPDATE CASCADE in SQL Foreign Key Relationships

Understanding ON DELETE CASCADE and ON UPDATE CASCADE in SQL Foreign Key Relationships

3
Comments
3 min read
My Data Engineering Library

My Data Engineering Library

Comments
2 min read
Utilizando o Prisma com TypeScript e SQLite: Um Guia Prático

Utilizando o Prisma com TypeScript e SQLite: Um Guia Prático

Comments
4 min read
Adding sequence duplicate records in MySQL without a window function

Adding sequence duplicate records in MySQL without a window function

21
Comments
3 min read
Python Database Connectivity and SQL Basics for EDA 🐍📊

Python Database Connectivity and SQL Basics for EDA 🐍📊

6
Comments
4 min read
SQL for Beginners

SQL for Beginners

Comments
2 min read
SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

6
Comments
11 min read
How to Move Your WordPress Site to a New Host

How to Move Your WordPress Site to a New Host

Comments
3 min read
The Ultimate SQL SELECT Cheat Sheet

The Ultimate SQL SELECT Cheat Sheet

4
Comments
3 min read
Understanding How Databases Utilize Indexes

Understanding How Databases Utilize Indexes

1
Comments
5 min read
Introducing Hatchify: Low-code libraries for React, Node, and Sequelize

Introducing Hatchify: Low-code libraries for React, Node, and Sequelize

9
Comments
4 min read
What is a Relational Database for Beginners

What is a Relational Database for Beginners

3
Comments
2 min read
Mastering Pattern Matching in SQL: A Practical Guide from PATINDEX to LIKE

Mastering Pattern Matching in SQL: A Practical Guide from PATINDEX to LIKE

2
Comments
3 min read
Choosing Between Insert Functions and Raw Queries: A Practical Guide

Choosing Between Insert Functions and Raw Queries: A Practical Guide

1
Comments 1
4 min read
All joins in PostgreSQL: Tutorial

All joins in PostgreSQL: Tutorial

Comments
2 min read
ActiveRecord::Originator, a RubyGem indicating the origin of the SQL

ActiveRecord::Originator, a RubyGem indicating the origin of the SQL

3
Comments
4 min read
PostGreSql-StoryFrom(Day89-100)

PostGreSql-StoryFrom(Day89-100)

Comments
19 min read
Frugal SQL data access with Athena and Blue / Green support

Frugal SQL data access with Athena and Blue / Green support

5
Comments
4 min read
Comparing Snowflake Dynamic Tables with dbt

Comparing Snowflake Dynamic Tables with dbt

Comments
5 min read
Optimizing Database Performance with Views Functions and Triggers in PostgreSQL

Optimizing Database Performance with Views Functions and Triggers in PostgreSQL

1
Comments
6 min read
Crafting DDL Statements for an Online Food Ordering Service Database

Crafting DDL Statements for an Online Food Ordering Service Database

Comments
2 min read
Oracle Database: How to Create/Delete New User and Grant Privilege?

Oracle Database: How to Create/Delete New User and Grant Privilege?

Comments
2 min read
Why You Should Use a Database

Why You Should Use a Database

1
Comments
3 min read
How to Create a SQL Server GUI in 4 Steps

How to Create a SQL Server GUI in 4 Steps

2
Comments
21 min read
OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

1
Comments
8 min read
ORM vs Pure SQL: Which to Choose?

ORM vs Pure SQL: Which to Choose?

33
Comments 18
1 min read
ER Diagram Sample for Ecommerce Project

ER Diagram Sample for Ecommerce Project

6
Comments
3 min read
Fortifying Postgres With Byzantine Fault Tolerance

Fortifying Postgres With Byzantine Fault Tolerance

Comments
8 min read
Indexing Best Practices

Indexing Best Practices

Comments
4 min read
YAML-based Database Docu

YAML-based Database Docu

Comments
2 min read
Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

Comments
2 min read
Reset IDs postgresql database - snippet

Reset IDs postgresql database - snippet

Comments
1 min read
SQL vs NoSQL: Which to Choose?

SQL vs NoSQL: Which to Choose?

14
Comments
1 min read
SQL vs NoSQL: ¿Cuál Elegir?

SQL vs NoSQL: ¿Cuál Elegir?

5
Comments
1 min read
ORM vs SQL Puro: ¿Cuál Elegir?

ORM vs SQL Puro: ¿Cuál Elegir?

2
Comments
2 min read
Understanding SQL: The Language of Relational Databases

Understanding SQL: The Language of Relational Databases

Comments
3 min read
Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

Comments
3 min read
Handling Migrations on NestJS with TypeORM

Handling Migrations on NestJS with TypeORM

8
Comments
2 min read
GroupBy and Join in Spark

GroupBy and Join in Spark

1
Comments
2 min read
Day-8 14 Frequently Asked SQL Query Interview Questions

Day-8 14 Frequently Asked SQL Query Interview Questions

1
Comments
3 min read
Top Asking SQL vs Mongo Queries

Top Asking SQL vs Mongo Queries

Comments
12 min read
Unleash the Speed Demon Within: Top 20 SQL Query Optimization Techniques

Unleash the Speed Demon Within: Top 20 SQL Query Optimization Techniques

9
Comments 1
7 min read
Mastering Data Analysis with SQL: The Power of the ROW_NUMBER() Function

Mastering Data Analysis with SQL: The Power of the ROW_NUMBER() Function

1
Comments
5 min read
The difficulty of SQL stems from relational algebra

The difficulty of SQL stems from relational algebra

15
Comments 1
6 min read
loading...