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.
Get started with Dapper .NET

Get started with Dapper .NET

18
Comments
6 min read
Regex: from a backup file list to a RESTORE script in under 2 minutes

Regex: from a backup file list to a RESTORE script in under 2 minutes

6
Comments
5 min read
A deeper dive into Sequelize queries: dynamic field names, the Op object, and raw SQL insertions
Cover image for A deeper dive into Sequelize queries: dynamic field names, the Op object, and raw SQL insertions

A deeper dive into Sequelize queries: dynamic field names, the Op object, and raw SQL insertions

30
Comments 3
3 min read
How to Extract Knowledge from Wikipedia, Data Science Style
Cover image for How to Extract Knowledge from Wikipedia, Data Science Style

How to Extract Knowledge from Wikipedia, Data Science Style

9
Comments
7 min read
Java(Spring Boot) Best Database Practices

Java(Spring Boot) Best Database Practices

6
Comments
2 min read
Building REST API with Python, Flask and Azure SQL

Building REST API with Python, Flask and Azure SQL

19
Comments
4 min read
How to use Change Data Capture (CDC) with Postgres

How to use Change Data Capture (CDC) with Postgres

23
Comments 5
3 min read
What have the STORED PROCEDURES ever done for us?

What have the STORED PROCEDURES ever done for us?

15
Comments 6
4 min read
Adventures in SQL Source Control with SSDT
Cover image for Adventures in SQL Source Control with SSDT

Adventures in SQL Source Control with SSDT

13
Comments 2
7 min read
Coding Bootcamp - Backend #3 - Databases, SQL, and knex

Coding Bootcamp - Backend #3 - Databases, SQL, and knex

6
Comments
5 min read
T-SQL CRUD procedures auto-generator

T-SQL CRUD procedures auto-generator

39
Comments 2
4 min read
Why you must add relational database development to your toolkit
Cover image for 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
First steps to caching PostgreSQL queries with Redis

First steps to caching PostgreSQL queries with Redis

61
Comments
5 min read
The Best MYSQL Courses for Beginners
Cover image for The Best MYSQL Courses for Beginners

The Best MYSQL Courses for Beginners

12
Comments
5 min read
Using the IFS variable to do things with CSV files

Using the IFS variable to do things with CSV files

5
Comments
5 min read
Optimize multiple INSERTs (for Oracle)
Cover image for Optimize multiple INSERTs (for Oracle)

Optimize multiple INSERTs (for Oracle)

7
Comments 4
3 min read
How to Synchronize relational databases with Dotmim.Sync
Cover image for How to Synchronize relational databases with Dotmim.Sync

How to Synchronize relational databases with Dotmim.Sync

23
Comments 6
5 min read
User management for Node.js & MySQL using Sequelize and PassportJS

User management for Node.js & MySQL using Sequelize and PassportJS

35
Comments 6
8 min read
API data persistence with relational databases
Cover image for API data persistence with relational databases

API data persistence with relational databases

10
Comments
3 min read
SQL Story of unbroken chains of events (daily/weekly streaks)

SQL Story of unbroken chains of events (daily/weekly streaks)

21
Comments 2
7 min read
Introduction to Profiling and Optimizing SQL Queries for Software Engineers

Introduction to Profiling and Optimizing SQL Queries for Software Engineers

14
Comments 2
11 min read
Complete MySQL Course: Beginner to Advanced
Cover image for Complete MySQL Course: Beginner to Advanced

Complete MySQL Course: Beginner to Advanced

30
Comments
1 min read
Notes on Migrating from MS SQL Server to PostgreSQL

Notes on Migrating from MS SQL Server to PostgreSQL

9
Comments
8 min read
API data persistence with relational databases
Cover image for API data persistence with relational databases

API data persistence with relational databases

6
Comments
2 min read
The Wild SQL Query I Wrote For Work This Week

The Wild SQL Query I Wrote For Work This Week

61
Comments 1
7 min read
loading...