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.
Helping PostgreSQL® professionals with AI-assisted performance recommendations

Helping PostgreSQL® professionals with AI-assisted performance recommendations

5
Comments
3 min read
Introduction to Amazon Athena: A Fast and Cost-Effective Serverless Query Service

Introduction to Amazon Athena: A Fast and Cost-Effective Serverless Query Service

3
Comments
3 min read
Learn SQL in 7 days - (SDET)

Learn SQL in 7 days - (SDET)

6
Comments 1
3 min read
Working with multi-queries in CodeIgniter

Working with multi-queries in CodeIgniter

Comments
2 min read
Python Projects with SQL: Strategies for Effective Query Management

Python Projects with SQL: Strategies for Effective Query Management

14
Comments 2
9 min read
Fix "The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server" while importing a D365FO .bacpac

Fix "The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server" while importing a D365FO .bacpac

Comments
2 min read
How To Build a Data Analytics Dashboard

How To Build a Data Analytics Dashboard

Comments 1
22 min read
Understanding the Differences Between SQL and MySQL

Understanding the Differences Between SQL and MySQL

Comments
3 min read
How to Execute SQL Commands In Another File from the PostgreSQl psql shell in Windows

How to Execute SQL Commands In Another File from the PostgreSQl psql shell in Windows

2
Comments 1
3 min read
More foreign-key joins

More foreign-key joins

6
Comments
5 min read
MindsDB + Docker: Utilizando SQL e containers para integrações com IA

MindsDB + Docker: Utilizando SQL e containers para integrações com IA

10
Comments 1
13 min read
Mastering Data Definition Language (DDL) statements in SQL

Mastering Data Definition Language (DDL) statements in SQL

2
Comments
5 min read
Understanding Data Manipulation Language(DML) statements in SQL

Understanding Data Manipulation Language(DML) statements in SQL

Comments
5 min read
Constraints in SQL: Enforcing Data Integrity

Constraints in SQL: Enforcing Data Integrity

Comments
3 min read
YB-Master, the YugabyteDB Universe control plane

YB-Master, the YugabyteDB Universe control plane

1
Comments
5 min read
SQL: Get records having min/max value per group

SQL: Get records having min/max value per group

12
Comments 1
2 min read
Key Considerations for Effective Database Table Design

Key Considerations for Effective Database Table Design

4
Comments
4 min read
ChatGPT: Your Guide to SQL Query Translation between Databases.

ChatGPT: Your Guide to SQL Query Translation between Databases.

Comments
6 min read
10 Ways ChatGPT is Revolutionizing SQL Practices.

10 Ways ChatGPT is Revolutionizing SQL Practices.

Comments
5 min read
How to Avoid SQL Injection: A Comprehensive Guide

How to Avoid SQL Injection: A Comprehensive Guide

25
Comments 6
3 min read
Array Expansion in Flink SQL

Array Expansion in Flink SQL

7
Comments
6 min read
Streamlining Hotel Management with Python CLI and ORM

Streamlining Hotel Management with Python CLI and ORM

Comments
4 min read
Introducing OpenMLDB’s New Feature: Feature Signatures — Enabling Complete Feature Engineering with SQL

Introducing OpenMLDB’s New Feature: Feature Signatures — Enabling Complete Feature Engineering with SQL

6
Comments
4 min read
Then let’s talk about discreteness, and what are the advantages of Java over SQL?

Then let’s talk about discreteness, and what are the advantages of Java over SQL?

6
Comments 1
5 min read
"Top Linux Interview Questions and Answers for Aspiring System Administrators"

"Top Linux Interview Questions and Answers for Aspiring System Administrators"

3
Comments
3 min read
Clustering in BigQuery (Dynamic Filters & External Queries)

Clustering in BigQuery (Dynamic Filters & External Queries)

Comments
3 min read
Mastering SQL: Comprehensive Guide To Structured Query Language

Mastering SQL: Comprehensive Guide To Structured Query Language

165
Comments 6
5 min read
All Your Monitoring Solutions Are Just Wrong

All Your Monitoring Solutions Are Just Wrong

Comments
8 min read
Find What You Need: Pattern Matching in SQL

Find What You Need: Pattern Matching in SQL

Comments
4 min read
MginDB: In-Memory, Schema-less, and Limitless

MginDB: In-Memory, Schema-less, and Limitless

Comments
2 min read
Inside GmOwl: A Guide to Quiz Functionality

Inside GmOwl: A Guide to Quiz Functionality

Comments
2 min read
Jerseys as Join Tables: Using Real-World Examples to Understand Relationships Between Data

Jerseys as Join Tables: Using Real-World Examples to Understand Relationships Between Data

1
Comments
6 min read
VERİ TABANI SUNUCUSU

VERİ TABANI SUNUCUSU

5
Comments 2
6 min read
Seamlessly Load Data from Different Data Sources into Blazor Charts

Seamlessly Load Data from Different Data Sources into Blazor Charts

Comments
12 min read
PostgreSQL Cheat Sheet

PostgreSQL Cheat Sheet

12
Comments 2
5 min read
MySQL to BigQuery Migration (Syntax & Other Conversions)

MySQL to BigQuery Migration (Syntax & Other Conversions)

Comments
3 min read
Managing Data with SQL: CRUD Operations Made Simple

Managing Data with SQL: CRUD Operations Made Simple

1
Comments
4 min read
EF Core Migrations: A Detailed Guide

EF Core Migrations: A Detailed Guide

1
Comments
9 min read
Database indexing and selectivity

Database indexing and selectivity

1
Comments
1 min read
Practical Experiments for Optimizing Django query with the power of SQL joins

Practical Experiments for Optimizing Django query with the power of SQL joins

5
Comments
7 min read
How to setup MySql on MacOS using Brew.

How to setup MySql on MacOS using Brew.

Comments
1 min read
Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite

Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite

12
Comments 4
12 min read
Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

2
Comments
4 min read
Dapper mappings, which is best?

Dapper mappings, which is best?

6
Comments 2
2 min read
From GUI to CLI: Transforming my query workflow with usql and jq

From GUI to CLI: Transforming my query workflow with usql and jq

2
Comments 1
3 min read
Inside SQL Joins

Inside SQL Joins

2
Comments
4 min read
Populating a table in PostgreSQL with one million records of random data.

Populating a table in PostgreSQL with one million records of random data.

2
Comments
1 min read
The main methods of joining tables in PostgreSQL.

The main methods of joining tables in PostgreSQL.

Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

Comments
2 min read
How to avoid N+1 query using SQL views (materialized) in Rails application

How to avoid N+1 query using SQL views (materialized) in Rails application

Comments
3 min read
Oracle SQL vs MySQL: A Comprehensive Comparison

Oracle SQL vs MySQL: A Comprehensive Comparison

2
Comments
3 min read
Mastering Oracle SQL Interview Questions: Tips and Answers

Mastering Oracle SQL Interview Questions: Tips and Answers

2
Comments
2 min read
Multi-Tenant SaaS Architecture - Database Per Tenant

Multi-Tenant SaaS Architecture - Database Per Tenant

3
Comments 1
6 min read
Crash on clock skew: performance vs availability

Crash on clock skew: performance vs availability

2
Comments
7 min read
Fetching Data (Next.js)

Fetching Data (Next.js)

1
Comments
2 min read
Foreign-key pre-join

Foreign-key pre-join

6
Comments
5 min read
⚡️ Gowebly CLI now supports the PocketBase framework

⚡️ Gowebly CLI now supports the PocketBase framework

7
Comments 1
2 min read
Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

7
Comments
17 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS

OLAP: CUBE, ROLLUP, AND GROUPING SETS

3
Comments 1
4 min read
Advisory/Custom/Application Lock with YugabyteDB

Advisory/Custom/Application Lock with YugabyteDB

Comments
5 min read
loading...