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.
JSON Primitive Types and Corresponding PostgreSQL Types

JSON Primitive Types and Corresponding PostgreSQL Types

7
Comments
5 min read
MariaDB Quick-tip #7 - Find stored procedure

MariaDB Quick-tip #7 - Find stored procedure

6
Comments
1 min read
Top 5 MariaDB GUI tools in 2022

Top 5 MariaDB GUI tools in 2022

16
Comments
7 min read
Your Old Laptop Is Your New Database Server

Your Old Laptop Is Your New Database Server

166
Comments 12
8 min read
Should I Learn PostgreSQL?

Should I Learn PostgreSQL?

9
Comments
3 min read
Understanding a Data Model

Understanding a Data Model

3
Comments 1
2 min read
Azure SQL Database Tools Part 4: Other Platform Tools

Azure SQL Database Tools Part 4: Other Platform Tools

4
Comments
3 min read
Deriving Ideal Indexes For Your SQL Database: A Guide

Deriving Ideal Indexes For Your SQL Database: A Guide

1
Comments
6 min read
Recursive CTEs in CockroachDB

Recursive CTEs in CockroachDB

Comments
4 min read
Essential SQL commands for database management

Essential SQL commands for database management

21
Comments 1
13 min read
SQL JOINS

SQL JOINS

10
Comments 1
2 min read
MariaDb Quick-tip #6 - Find table or column

MariaDb Quick-tip #6 - Find table or column

4
Comments
2 min read
Will NoSQL Databases Replace SQL Databases in the future

Will NoSQL Databases Replace SQL Databases in the future

8
Comments 1
4 min read
🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

12
Comments
3 min read
Build error SQL46005: Expected FILESTREAM_ON but encountered object instead

Build error SQL46005: Expected FILESTREAM_ON but encountered object instead

Comments
1 min read
The Darker Side of ALTER TABLE: A Guide

The Darker Side of ALTER TABLE: A Guide

2
Comments
5 min read
Default tablet splitting in YugabyteDB 🚀

Default tablet splitting in YugabyteDB 🚀

7
Comments
6 min read
Universe will collapse before you need BIGINT for milliseconds in JavaScript

Universe will collapse before you need BIGINT for milliseconds in JavaScript

7
Comments
2 min read
Cleanly modifying PostgreSQL configurations

Cleanly modifying PostgreSQL configurations

5
Comments 1
4 min read
Two Ways To Create Totals In SQL

Two Ways To Create Totals In SQL

4
Comments
2 min read
Locking-Based Isolation at SQL Server

Locking-Based Isolation at SQL Server

15
Comments
8 min read
Predicting Employee Productivity using Machine Learning with MindsDB

Predicting Employee Productivity using Machine Learning with MindsDB

11
Comments
7 min read
DrizzleORM v0.11 | 18 months into development

DrizzleORM v0.11 | 18 months into development

9
Comments 3
3 min read
Hibernate: Roteiro básico de implementação

Hibernate: Roteiro básico de implementação

4
Comments
4 min read
Distributed query execution in CrateDB: What you need to know

Distributed query execution in CrateDB: What you need to know

1
Comments
7 min read
MariaDB with Replication in Docker

MariaDB with Replication in Docker

9
Comments 2
2 min read
Where are those CloudTrail IP addresses coming from?

Where are those CloudTrail IP addresses coming from?

14
Comments
3 min read
MariaDB Quick-tip #5 - Create a sequence of date and time

MariaDB Quick-tip #5 - Create a sequence of date and time

9
Comments 2
2 min read
Advanced SQL: Going beyond the Basics

Advanced SQL: Going beyond the Basics

11
Comments
11 min read
DB Migration using SQLgateway

DB Migration using SQLgateway

7
Comments
3 min read
Anonymiser les données de PrestaShop

Anonymiser les données de PrestaShop

3
Comments
2 min read
SQL: CRUD for Newbies

SQL: CRUD for Newbies

2
Comments
3 min read
find the partition key with a duplicate covering index local read

find the partition key with a duplicate covering index local read

10
Comments 2
8 min read
Using Flink SQL and Redpanda for stream processing

Using Flink SQL and Redpanda for stream processing

Comments
5 min read
access the local partition only in 🚀 YugabyteDB geo-partitioned tables

access the local partition only in 🚀 YugabyteDB geo-partitioned tables

12
Comments
4 min read
Get Started with Directus Standard Cloud using our pay-as-you-go hourly pricing.

Get Started with Directus Standard Cloud using our pay-as-you-go hourly pricing.

4
Comments
1 min read
Yet Another Post About N + 1 Queries

Yet Another Post About N + 1 Queries

9
Comments
3 min read
Follow Friday: SQL Edition (8 July 2022)

Follow Friday: SQL Edition (8 July 2022)

26
Comments 5
1 min read
Video Game DB PostgreSQL

Video Game DB PostgreSQL

7
Comments 2
1 min read
MariaDb Quick-tip #4 - Random int for each row

MariaDb Quick-tip #4 - Random int for each row

Comments
1 min read
How to Import Data in Oracle SQL Developer Web

How to Import Data in Oracle SQL Developer Web

6
Comments
3 min read
SQL Safety question

SQL Safety question

8
Comments
1 min read
I learned how to use Python to do backend stuff with my frontend experience.

I learned how to use Python to do backend stuff with my frontend experience.

Comments
5 min read
Golang social network explained

Golang social network explained

7
Comments
1 min read
ShardingSphere-Proxy Front-End Protocol Troubleshooting Guide and Examples

ShardingSphere-Proxy Front-End Protocol Troubleshooting Guide and Examples

6
Comments
10 min read
The 4 Types of NoSQL Databases You Need to Know

The 4 Types of NoSQL Databases You Need to Know

2
Comments
6 min read
SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

211
Comments 32
2 min read
SQL: The basics and beyond

SQL: The basics and beyond

7
Comments
7 min read
ShardingSphere-JDBC Driver Released: A JDBC Driver That Requires No Code Modifications

ShardingSphere-JDBC Driver Released: A JDBC Driver That Requires No Code Modifications

3
Comments
5 min read
Speeding Up Bulk Loading in PostgreSQL

Speeding Up Bulk Loading in PostgreSQL

27
Comments 1
4 min read
Security vs. Performance in the SQL World

Security vs. Performance in the SQL World

5
Comments
7 min read
O que é ACID?

O que é ACID?

9
Comments
6 min read
MariaDB Quick-tip #3 - Prepending zeros

MariaDB Quick-tip #3 - Prepending zeros

7
Comments
1 min read
Database Mesh 2.0: Database Governance in a Cloud Native Environment

Database Mesh 2.0: Database Governance in a Cloud Native Environment

3
Comments
9 min read
Optimizing Nested Loop joins on YugabyteDB with jOOQ

Optimizing Nested Loop joins on YugabyteDB with jOOQ

8
Comments
4 min read
OWASP Vulnerability: SQL Injection | iFour Technolab

OWASP Vulnerability: SQL Injection | iFour Technolab

7
Comments
7 min read
Filter database records without SQL

Filter database records without SQL

13
Comments
1 min read
MariaDB Quick-tip #1 - Range of int

MariaDB Quick-tip #1 - Range of int

8
Comments 2
1 min read
How To Install SQL Server on Ubuntu

How To Install SQL Server on Ubuntu

7
Comments
2 min read
Quiz: SQL query

Quiz: SQL query

8
Comments 7
1 min read
loading...