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.
Deploy an application on Glitch in 5 steps

Deploy an application on Glitch in 5 steps

5
Comments
3 min read
Data Strategies for a Test Automation Framework

Data Strategies for a Test Automation Framework

21
Comments
4 min read
Document vs Relational Databases

Document vs Relational Databases

45
Comments 7
3 min read
Creating a Transaction Interceptor Using Nest.js

Creating a Transaction Interceptor Using Nest.js

34
Comments 4
5 min read
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

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

29
Comments 3
3 min read
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 4
3 min read
What have the STORED PROCEDURES ever done for us?

What have the STORED PROCEDURES ever done for us?

14
Comments 6
4 min read
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

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

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)

Optimize multiple INSERTs (for Oracle)

7
Comments 4
3 min read
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

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