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