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.
Retrieving records in bulk with a list of primary key values in CrateDB

Retrieving records in bulk with a list of primary key values in CrateDB

Comments
3 min read
Normalization in Relational Databases

Normalization in Relational Databases

Comments
3 min read
MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

Comments
3 min read
Thinking Inside The Box: Relational Style Joins in SurrealDB

Thinking Inside The Box: Relational Style Joins in SurrealDB

14
Comments
7 min read
HackTheBox - Writeup Drive [Retired]

HackTheBox - Writeup Drive [Retired]

Comments 1
15 min read
SQL Interview Questions.

SQL Interview Questions.

1
Comments 2
6 min read
How to automate the process of enabling TCP/IP of a sql express server using Power shell scripting

How to automate the process of enabling TCP/IP of a sql express server using Power shell scripting

1
Comments
1 min read
How to track Cloudtrail API calls from all Organizations AWS accounts using Athena

How to track Cloudtrail API calls from all Organizations AWS accounts using Athena

5
Comments
3 min read
🏁🐘Winning Race Conditions With PostgreSQL

🏁🐘Winning Race Conditions With PostgreSQL

43
Comments 2
10 min read
Unlocking the Power of Databases: A Brief Overview of SQL

Unlocking the Power of Databases: A Brief Overview of SQL

3
Comments
9 min read
SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS)

1
Comments
5 min read
Laravel API - Import 1 million records with validation in few seconds.

Laravel API - Import 1 million records with validation in few seconds.

13
Comments
8 min read
How to Connect MSSQL with Node.js

How to Connect MSSQL with Node.js

2
Comments
2 min read
Troubleshooting Database Issues Like a Pro

Troubleshooting Database Issues Like a Pro

Comments
11 min read
Is SQL a declarative language

Is SQL a declarative language

13
Comments 5
5 min read
SQL Database Normalization with Easy Examples

SQL Database Normalization with Easy Examples

2
Comments
2 min read
Exploring LEAD(): Enhancing SQL Data Comparing And Analysis

Exploring LEAD(): Enhancing SQL Data Comparing And Analysis

Comments
2 min read
Using SQLAlchemy to transfer tables to and from IRIS

Using SQLAlchemy to transfer tables to and from IRIS

Comments
7 min read
Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL

Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL

Comments
3 min read
Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

Comments
2 min read
What is SQL and SQLite?

What is SQL and SQLite?

Comments
3 min read
Introduction to SQL Server

Introduction to SQL Server

Comments
4 min read
Laravel: whereIn() vs whereIntegerInRaw() vs find()

Laravel: whereIn() vs whereIntegerInRaw() vs find()

1
Comments
1 min read
Machine-learning life-cycle management using MLflow

Machine-learning life-cycle management using MLflow

3
Comments
29 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
Why should you replace your PostgreSQL with 2000 SQLite databases?

Why should you replace your PostgreSQL with 2000 SQLite databases?

Comments
3 min read
How to write Database Procedures

How to write Database Procedures

Comments
4 min read
Mastering Common Database Objects - Series 1 .. n

Mastering Common Database Objects - Series 1 .. n

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

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

10
Comments
4 min read
How To Create One-to-Many Relationships in SQL

How To Create One-to-Many Relationships in SQL

1
Comments
23 min read
SQL for Beginners

SQL for Beginners

Comments
2 min read
SQL antipatterns: Diplomatic Immunity

SQL antipatterns: Diplomatic Immunity

Comments
9 min read
Distributed Data and NoSQL

Distributed Data and NoSQL

Comments
4 min read
Diving Into Data: Understanding SQL and GraphQL for Junior Developers

Diving Into Data: Understanding SQL and GraphQL for Junior Developers

2
Comments
2 min read
SQL Column Deletion Techniques

SQL Column Deletion Techniques

Comments
2 min read
BigQuery Machine Learning

BigQuery Machine Learning

2
Comments
5 min read
Introduction to PL/SQL

Introduction to PL/SQL

2
Comments
2 min read
Como manipular variáveis locais utilizando SQL Server

Como manipular variáveis locais utilizando SQL Server

Comments
2 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

1
Comments
3 min read
New Database IDE

New Database IDE

1
Comments
3 min read
Inner Join in SQL: A Comprehensive Guide

Inner Join in SQL: A Comprehensive Guide

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

OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

2
Comments
8 min read
Partitioning and Clustering on BigQuery

Partitioning and Clustering on BigQuery

2
Comments 1
3 min read
How come there are tens of thousands of tables in a database

How come there are tens of thousands of tables in a database

7
Comments 1
5 min read
Get list of tables in mysql

Get list of tables in mysql

Comments
1 min read
Ruby Database Setup & Common Commands & CRUD

Ruby Database Setup & Common Commands & CRUD

1
Comments 1
3 min read
I have optimized my work with text-to-SQL translator improved with vector search

I have optimized my work with text-to-SQL translator improved with vector search

8
Comments
3 min read
Basics of RAG with pgVector and Langchain

Basics of RAG with pgVector and Langchain

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

Crafting DDL Statements for an Online Food Ordering Service Database

2
Comments
2 min read
Will Python replace Stored Procedures?

Will Python replace Stored Procedures?

1
Comments
2 min read
A Practical Guide to Caching: What to Cache and When

A Practical Guide to Caching: What to Cache and When

Comments
14 min read
Designing Database Tables for an Online Food Ordering Service

Designing Database Tables for an Online Food Ordering Service

24
Comments
2 min read
Explorando Funções de Agregação no SQL: SUM, MAX, MIN, AVG

Explorando Funções de Agregação no SQL: SUM, MAX, MIN, AVG

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

3
Comments
3 min read
API completa em Golang - Parte 7

API completa em Golang - Parte 7

49
Comments 5
22 min read
UUID in PostgreSQL

UUID in PostgreSQL

62
Comments 7
5 min read
To UUID, or not to UUID, that is the primary key question

To UUID, or not to UUID, that is the primary key question

11
Comments
9 min read
PySpark & Apache Spark - Overview

PySpark & Apache Spark - Overview

Comments
3 min read
Unveiling the Power of Window and Ranking Functions in SQL

Unveiling the Power of Window and Ranking Functions in SQL

6
Comments
4 min read
Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack

Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack

1
Comments 1
4 min read
loading...