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 DB Backups to Azure Storage with Powershell

SQL DB Backups to Azure Storage with Powershell

6
Comments
2 min read
How to do upserts in Knex.js (PostgreSQL)

How to do upserts in Knex.js (PostgreSQL)

35
Comments 4
3 min read
MySQLDump.js

MySQLDump.js

4
Comments
1 min read
Sending a Text Message with SQL (IBMi)

Sending a Text Message with SQL (IBMi)

10
Comments
4 min read
Use Dash to Build BigQuery-Connected Python Web Apps

Use Dash to Build BigQuery-Connected Python Web Apps

6
Comments
3 min read
Remove Duplicate Records via SQL Server's Rank Function

Remove Duplicate Records via SQL Server's Rank Function

9
Comments 2
3 min read
Tweaking Logger Outputs on the Fly

Tweaking Logger Outputs on the Fly

1
Comments
2 min read
Translate rails query to raw sql in rails console

Translate rails query to raw sql in rails console

8
Comments
1 min read
CSV to SQL import using Node, Express and React

CSV to SQL import using Node, Express and React

3
Comments 4
3 min read
E5 - Save Order in Database

E5 - Save Order in Database

3
Comments
3 min read
Migrondi, Simple SQL migrations tool

Migrondi, Simple SQL migrations tool

9
Comments
5 min read
Getting Started with MariaDB using Docker and Node.js

Getting Started with MariaDB using Docker and Node.js

24
Comments 2
4 min read
How Often Do You Dream In Code?

How Often Do You Dream In Code?

4
Comments 8
1 min read
Learn Web Development for Free

Learn Web Development for Free

119
Comments 6
8 min read
Dapper.NET: Custom Columns Mapping

Dapper.NET: Custom Columns Mapping

7
Comments
4 min read
What's an ACID compliant database?

What's an ACID compliant database?

10
Comments
6 min read
Pocket Guide on Sequelize ORM for NodeJS

Pocket Guide on Sequelize ORM for NodeJS

17
Comments
12 min read
60 lines of code Web crawler and search bar with Wget and Manticore

60 lines of code Web crawler and search bar with Wget and Manticore

10
Comments
7 min read
Working with SQL Relations in Go - Part 2

Working with SQL Relations in Go - Part 2

5
Comments
7 min read
A story on indexing and why it is important for modern applications

A story on indexing and why it is important for modern applications

26
Comments 2
4 min read
Merging development and production MS SQL databases for cloud migration

Merging development and production MS SQL databases for cloud migration

6
Comments
12 min read
Visualizing differences in T-SQL code between multiple databases

Visualizing differences in T-SQL code between multiple databases

5
Comments
7 min read
mySQL vs MongoDB - What's the Difference?

mySQL vs MongoDB - What's the Difference?

13
Comments 2
4 min read
Analyzing the politics of COVID-19 through public data

Analyzing the politics of COVID-19 through public data

54
Comments 4
17 min read
SQL: Beyond The Basics

SQL: Beyond The Basics

6
Comments
4 min read
Dolt is Git For Data

Dolt is Git For Data

34
Comments 3
1 min read
Making Datasets Fly with Datasette and Fly

Making Datasets Fly with Datasette and Fly

7
Comments
7 min read
Dapper .NET: Multiple Mapping

Dapper .NET: Multiple Mapping

8
Comments
6 min read
Beginning of a Blog Series

Beginning of a Blog Series

13
Comments
3 min read
Isolation levels and locking in relational databases

Isolation levels and locking in relational databases

21
Comments 1
10 min read
CS Trivia#7: Why is SQL shouting at me?

CS Trivia#7: Why is SQL shouting at me?

24
Comments 8
3 min read
I built my own SQL tester in Python, then rebuilt it again from scratch,here's what I learned.

I built my own SQL tester in Python, then rebuilt it again from scratch,here's what I learned.

24
Comments 2
11 min read
Trick to rebuild summary tables when the existing data have to remain available during the operation

Trick to rebuild summary tables when the existing data have to remain available during the operation

7
Comments
1 min read
You should go Serverless even for your db

You should go Serverless even for your db

6
Comments 2
2 min read
Data Royale: [SQL] vs noSQL

Data Royale: [SQL] vs noSQL

68
Comments 1
4 min read
Dapper.NET: Handling Multiple Resultsets

Dapper.NET: Handling Multiple Resultsets

9
Comments 4
4 min read
Aprenda como VOCÊ pode migrar Base de Dados Local do SQL Server para Azure SQL Database

Aprenda como VOCÊ pode migrar Base de Dados Local do SQL Server para Azure SQL Database

11
Comments
10 min read
Oh look, it's another ORM good/bad thread

Oh look, it's another ORM good/bad thread

5
Comments 1
5 min read
Getting started with Postgres in your React app

Getting started with Postgres in your React app

23
Comments
9 min read
Just in! A New Persistent NoSQL Database (18 KiB only!)

Just in! A New Persistent NoSQL Database (18 KiB only!)

63
Comments 16
5 min read
Bulk Uploading To A MySQL Database: A Quick Guide

Bulk Uploading To A MySQL Database: A Quick Guide

12
Comments
4 min read
Types of queries that can & can't use a B-Tree index

Types of queries that can & can't use a B-Tree index

10
Comments
4 min read
Using SQLite on Unity for Android and iOS

Using SQLite on Unity for Android and iOS

6
Comments
8 min read
How to migrate SQL Databases to a new version

How to migrate SQL Databases to a new version

10
Comments 4
2 min read
Dapper .NET: Multiple Executions

Dapper .NET: Multiple Executions

10
Comments
3 min read
Recursive SQL Queries with PostgreSQL

Recursive SQL Queries with PostgreSQL

50
Comments
7 min read
Creating Professional Reports From MySQL Data

Creating Professional Reports From MySQL Data

13
Comments
3 min read
what are some great resources to learn advanced SQL?

what are some great resources to learn advanced SQL?

5
Comments 2
1 min read
Database Schema Linting

Database Schema Linting

7
Comments
4 min read
Have you heard about Materialized Views in Amazon Redshift?

Have you heard about Materialized Views in Amazon Redshift?

18
Comments 1
4 min read
How To Read a Transaction Log in a SQL Server

How To Read a Transaction Log in a SQL Server

6
Comments
3 min read
Comparison of Two Database Schemas in SQL Server

Comparison of Two Database Schemas in SQL Server

8
Comments
3 min read
Database: SQL or NoSQL

Database: SQL or NoSQL

40
Comments
3 min read
Charting the spread of COVID-19 using data

Charting the spread of COVID-19 using data

68
Comments 2
12 min read
How to write a query with the IN operator using Dapper and NPGSql

How to write a query with the IN operator using Dapper and NPGSql

9
Comments
2 min read
Back To Basics: CRUD Operations with SQL

Back To Basics: CRUD Operations with SQL

9
Comments
3 min read
Trees and the Database.

Trees and the Database.

41
Comments 11
4 min read
Import CSV Data Into SQL Databases From The Terminal

Import CSV Data Into SQL Databases From The Terminal

57
Comments 3
3 min read
Playing with a public dataset, and playing with food

Playing with a public dataset, and playing with food

8
Comments 6
5 min read
Introduction into Window Functions on SQL Server

Introduction into Window Functions on SQL Server

12
Comments
4 min read
loading...