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.
Bitmasks in SQL

Bitmasks in SQL

10
Comments
1 min read
Corona Virus Cases Reporting

Corona Virus Cases Reporting

2
Comments
1 min read
Dirty Dynamic SQL

Dirty Dynamic SQL

10
Comments
2 min read
Defensive coding in SQL

Defensive coding in SQL

11
Comments 1
1 min read
Correlation IDs in Django SQL

Correlation IDs in Django SQL

18
Comments
4 min read
Building a Slack Bot that Writes Custom Queries against your Database

Building a Slack Bot that Writes Custom Queries against your Database

4
Comments
3 min read
Tutorial: Automate Text Messages when Database Conditional Changes

Tutorial: Automate Text Messages when Database Conditional Changes

19
Comments
3 min read
Extending the Aerospike JDBC driver with UDFs

Extending the Aerospike JDBC driver with UDFs

6
Comments 1
2 min read
Functions supported by the Aerospike SQL driver

Functions supported by the Aerospike SQL driver

3
Comments 2
3 min read
Speeding up unique constraint checks in Postgres... or not

Speeding up unique constraint checks in Postgres... or not

6
Comments
3 min read
Finding Meow 😺 — the cutest cat from each town using Elasticsearch

Finding Meow 😺 — the cutest cat from each town using Elasticsearch

4
Comments
6 min read
Introduction to the Aerospike JDBC driver

Introduction to the Aerospike JDBC driver

6
Comments
2 min read
AI + Github API = Issue Sentiment Classification

AI + Github API = Issue Sentiment Classification

3
Comments
3 min read
How do you handle database migrations ?

How do you handle database migrations ?

2
Comments
1 min read
Tutorial: Building a Slack Bot that Writes Custom Queries against your Database

Tutorial: Building a Slack Bot that Writes Custom Queries against your Database

6
Comments
3 min read
Tutorial: Create a Dashboard of SQL Datasets

Tutorial: Create a Dashboard of SQL Datasets

7
Comments
3 min read
How to Convert date format to PHP with MYSQLI, using secure queries to avoid SQL injection

How to Convert date format to PHP with MYSQLI, using secure queries to avoid SQL injection

1
Comments
1 min read
Quick Check of SQL Table Contents With Data Visualizers

Quick Check of SQL Table Contents With Data Visualizers

2
Comments
3 min read
What is SQL injection and how do I avoid it in Go?

What is SQL injection and how do I avoid it in Go?

15
Comments 7
5 min read
How to Automate Continuous Database Backup and Restore

How to Automate Continuous Database Backup and Restore

5
Comments
3 min read
Working on a hair professional mobile app (Xamarin, C#, PHP, MySQL)

Working on a hair professional mobile app (Xamarin, C#, PHP, MySQL)

6
Comments
2 min read
Recompile dependent PL/SQL code after changes

Recompile dependent PL/SQL code after changes

5
Comments
2 min read
What is CRUD and how does it help me with my application?

What is CRUD and how does it help me with my application?

5
Comments
7 min read
X-Ray for Your Database

X-Ray for Your Database

7
Comments
8 min read
Tutorial: Schedule SQL Queries on your Database

Tutorial: Schedule SQL Queries on your Database

6
Comments 3
2 min read
The most complete bad word dataset on the internet, and using it in my Python application

The most complete bad word dataset on the internet, and using it in my Python application

20
Comments
1 min read
Supernova introduction

Supernova introduction

4
Comments
2 min read
Working with SQL Relations in Go - Part 5

Working with SQL Relations in Go - Part 5

4
Comments
5 min read
Tutorial: Automate Daily SQL Queries in 4 minutes

Tutorial: Automate Daily SQL Queries in 4 minutes

9
Comments
3 min read
Tutorial: Creating Slack Bots to Track Product Inventory

Tutorial: Creating Slack Bots to Track Product Inventory

6
Comments
3 min read
The 500-foot Cab Ride: Using BigQuery to find out how dirty (sinister?) NYC's cab ride data is

The 500-foot Cab Ride: Using BigQuery to find out how dirty (sinister?) NYC's cab ride data is

9
Comments 1
3 min read
Working with SQL Relations in Go - Part 4

Working with SQL Relations in Go - Part 4

3
Comments
7 min read
SQL Vs NoSQL, Lequel Peut Gérer Facilement Une Base De Données Web Médicale?

SQL Vs NoSQL, Lequel Peut Gérer Facilement Une Base De Données Web Médicale?

4
Comments
12 min read
Tutorial: How to Connect a SQL Database to Google Sheets

Tutorial: How to Connect a SQL Database to Google Sheets

4
Comments
2 min read
Subqueries and Correlated Subqueries

Subqueries and Correlated Subqueries

3
Comments
2 min read
AyeSQL: Writing Raw SQL

AyeSQL: Writing Raw SQL

12
Comments 2
9 min read
Connect to SQLite DB in windows

Connect to SQLite DB in windows

4
Comments
1 min read
MySQLでサブクエリを使ってUPDATE

MySQLでサブクエリを使ってUPDATE

7
Comments
1 min read
Building an end to end Machine Learning Pipeline in Bigquery

Building an end to end Machine Learning Pipeline in Bigquery

7
Comments
5 min read
Introduction to MySQL queries

Introduction to MySQL queries

7
Comments 1
3 min read
Modern data practice and the SQL tradition

Modern data practice and the SQL tradition

17
Comments
2 min read
ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

14
Comments
2 min read
Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

6
Comments
16 min read
Manipulando Datas no Postgres

Manipulando Datas no Postgres

5
Comments
2 min read
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

4
Comments
2 min read
SQL: Select Statements

SQL: Select Statements

7
Comments
3 min read
A (not so) small rant on techniques to copy MySQL database structures

A (not so) small rant on techniques to copy MySQL database structures

6
Comments
4 min read
Visually Creating MySQL Queries With dbForge Studio for MySQL

Visually Creating MySQL Queries With dbForge Studio for MySQL

6
Comments
4 min read
SQL: Table Creation and Basic Queries

SQL: Table Creation and Basic Queries

6
Comments
3 min read
A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

4
Comments
2 min read
Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

16
Comments
6 min read
Temporal tables or JSON storage

Temporal tables or JSON storage

6
Comments
3 min read
Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

7
Comments
1 min read
Why you must add relational database development to your toolkit

Why you must add relational database development to your toolkit

5
Comments
5 min read
Answer: Does the join order matter in SQL?

Answer: Does the join order matter in SQL?

2
Comments
1 min read
Automate SQL Queries in the cloud

Automate SQL Queries in the cloud

6
Comments
1 min read
Basic DB Using SQL Server (Part 1) - Basic commands!

Basic DB Using SQL Server (Part 1) - Basic commands!

9
Comments
3 min read
Makers - Week 4

Makers - Week 4

4
Comments
1 min read
i doing SQL tuning in Company databases but i don't know where to start

i doing SQL tuning in Company databases but i don't know where to start

3
Comments 3
1 min read
Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

5
Comments
8 min read
loading...