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.
SQL vs NoSQL

SQL vs NoSQL

5
Comments
1 min read
SQL - Sub Queries

SQL - Sub Queries

6
Comments
2 min read
Python and SQL

Python and SQL

7
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

7
Comments
3 min read
Hacktoberfest 2021 with QuestDB community

Hacktoberfest 2021 with QuestDB community

13
Comments 2
2 min read
How to Drop Multiple Databases in PostgreSQL

How to Drop Multiple Databases in PostgreSQL

5
Comments
5 min read
SQL for detecting contiguous and non-contiguous date spans

SQL for detecting contiguous and non-contiguous date spans

7
Comments
5 min read
SQL to derive subsequences

SQL to derive subsequences

2
Comments
4 min read
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

7
Comments
5 min read
SQL - Stored Procedure 📦

SQL - Stored Procedure 📦

34
Comments 1
1 min read
SQL: How to consult the database.

SQL: How to consult the database.

4
Comments
2 min read
DELETE on SQL

DELETE on SQL

2
Comments
1 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

7
Comments
5 min read
Little known vulnerability with ORMs and query builders

Little known vulnerability with ORMs and query builders

5
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1

Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1

8
Comments 2
4 min read
Top 5 MySQL GUI tools in 2021

Top 5 MySQL GUI tools in 2021

9
Comments
10 min read
Improving Backend Performance, Part 3/3: Fast Analytics

Improving Backend Performance, Part 3/3: Fast Analytics

7
Comments
4 min read
Improving Backend Performance Part 2/3: Using Database Indexes

Improving Backend Performance Part 2/3: Using Database Indexes

4
Comments
4 min read
DBMS Employee and Department

DBMS Employee and Department

6
Comments
1 min read
DBMS Student table

DBMS Student table

28
Comments
2 min read
SQL vs NoSQL Databases

SQL vs NoSQL Databases

2
Comments
1 min read
What’s new with BigQuery ?

What’s new with BigQuery ?

6
Comments
5 min read
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

7
Comments
6 min read
SQL Constraints

SQL Constraints

3
Comments
4 min read
10 no-brainer best practices that boost API security

10 no-brainer best practices that boost API security

2
Comments
5 min read
Flatten Pandas dataframe MultiIndex

Flatten Pandas dataframe MultiIndex

4
Comments 1
2 min read
The Data Engineer Roadmap 🗺

The Data Engineer Roadmap 🗺

63
Comments 4
4 min read
Boost Secondary Index Queries with Index Only Scan

Boost Secondary Index Queries with Index Only Scan

7
Comments
11 min read
Implementing a Task Queue in SQL

Implementing a Task Queue in SQL

4
Comments 1
7 min read
Calculate Distance between 2 Geo Locations in PHP MySQL

Calculate Distance between 2 Geo Locations in PHP MySQL

36
Comments 3
2 min read
How Python and SQL are Changing the Hedge Fund Industry

How Python and SQL are Changing the Hedge Fund Industry

12
Comments
4 min read
Elasticsearch for Beginners and SQL Developers

Elasticsearch for Beginners and SQL Developers

3
Comments
1 min read
First NoSQL For SQL Developers

First NoSQL For SQL Developers

3
Comments 1
2 min read
Learn SQL: Microsoft SQL Server - Episode 1: Introduction

Learn SQL: Microsoft SQL Server - Episode 1: Introduction

31
Comments 2
8 min read
Run SQL Server in Docker container

Run SQL Server in Docker container

7
Comments
1 min read
Building a Smart Contract Application Using bSQL and Daml

Building a Smart Contract Application Using bSQL and Daml

6
Comments
10 min read
Primary Keys in SQL

Primary Keys in SQL

10
Comments 1
2 min read
A Detailed Report on SQL INJECTION

A Detailed Report on SQL INJECTION

3
Comments
6 min read
Open Source SQL Parsers

Open Source SQL Parsers

3
Comments
4 min read
Learning MySQL with basic SQL Commands

Learning MySQL with basic SQL Commands

8
Comments
6 min read
SQL Anti-pattern: Never Use Boolean Flags

SQL Anti-pattern: Never Use Boolean Flags

5
Comments
3 min read
Introduction to the Join Ordering Problem

Introduction to the Join Ordering Problem

5
Comments
4 min read
SQL Server to React in 60 Seconds With Prisma

SQL Server to React in 60 Seconds With Prisma

53
Comments 1
5 min read
How we sync Stripe to manage trials and subscriptions

How we sync Stripe to manage trials and subscriptions

3
Comments
3 min read
What's New in PostgreSQL 14?

What's New in PostgreSQL 14?

6
Comments
5 min read
Introducing Tabulamax

Introducing Tabulamax

5
Comments 3
1 min read
Best practices for AWS Athena

Best practices for AWS Athena

27
Comments 2
3 min read
A Data Spider in Recursive SQL

A Data Spider in Recursive SQL

5
Comments
11 min read
🚀 The Missing SQL Basics Crash Course

🚀 The Missing SQL Basics Crash Course

116
Comments 11
12 min read
Replacing Segment Computed & SQL Traits With dbt & RudderStack Warehouse Actions

Replacing Segment Computed & SQL Traits With dbt & RudderStack Warehouse Actions

5
Comments
11 min read
Hindsight 20/20: Querying Any Point in Time

Hindsight 20/20: Querying Any Point in Time

5
Comments
2 min read
Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

6
Comments
1 min read
How To Fix Slow MariaDB Replication Lag

How To Fix Slow MariaDB Replication Lag

6
Comments
2 min read
How to Create Reports from SQL Server Databases with List & Label to Have More Time for ...hm, Let's Say, Sweets 🍭

How to Create Reports from SQL Server Databases with List & Label to Have More Time for ...hm, Let's Say, Sweets 🍭

7
Comments
2 min read
FAQ: blockchain technology in bSQL

FAQ: blockchain technology in bSQL

2
Comments
2 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

169
Comments 26
5 min read
SQL - Resumo para iniciantes

SQL - Resumo para iniciantes

2
Comments
4 min read
SQL Lock to give you shock

SQL Lock to give you shock

3
Comments
2 min read
Four Database APIs

Four Database APIs

9
Comments
15 min read
Making SQLite Easy with Codesphere!

Making SQLite Easy with Codesphere!

13
Comments
2 min read
loading...