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.
Array Expansion in Flink SQL

Array Expansion in Flink SQL

10
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
Mastering SQL: Comprehensive Guide To Structured Query Language

Mastering SQL: Comprehensive Guide To Structured Query Language

173
Comments 7
5 min read
Clustering in BigQuery (Dynamic Filters & External Queries)

Clustering in BigQuery (Dynamic Filters & External Queries)

Comments
3 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
PostgreSQL Cheat Sheet

PostgreSQL Cheat Sheet

13
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

14
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?

7
Comments 4
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
loading...