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.
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
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

231
Comments 13
3 min read
Using SQL's TRIM and REPLACE to tidy up your data

Using SQL's TRIM and REPLACE to tidy up your data

8
Comments 1
3 min read
Formatting and dealing with dates in SQL

Formatting and dealing with dates in SQL

9
Comments 1
11 min read
An amazingly simple solution for Mobile Apps to sync with the Cloud using Change Tracking API

An amazingly simple solution for Mobile Apps to sync with the Cloud using Change Tracking API

6
Comments
8 min read
[PT-BR] Funcionalidades do DBeaver

[PT-BR] Funcionalidades do DBeaver

100
Comments 6
2 min read
C#: Bulk Operations for .NET Core (BulkDelete, BulkInsert, BulkMerge, BulkUpdate) is now very simple with RepoDb ORM

C#: Bulk Operations for .NET Core (BulkDelete, BulkInsert, BulkMerge, BulkUpdate) is now very simple with RepoDb ORM

23
Comments 1
7 min read
Data Science is dying out

Data Science is dying out

35
Comments 2
2 min read
Joining database tables

Joining database tables

8
Comments
4 min read
Populate Blazor Dropdown Menu from EF Core Lookup Table

Populate Blazor Dropdown Menu from EF Core Lookup Table

10
Comments
3 min read
Fun interview question: How to update Saint Quartz stones with one line SQL statement in FGO?

Fun interview question: How to update Saint Quartz stones with one line SQL statement in FGO?

6
Comments
2 min read
Storing JSON in Postgres using Node.js

Storing JSON in Postgres using Node.js

18
Comments 2
3 min read
10K RPS REST API with Azure SQL, Dapper and JSON

10K RPS REST API with Azure SQL, Dapper and JSON

7
Comments
4 min read
Embracing the Power of the Self-Referential Join

Embracing the Power of the Self-Referential Join

6
Comments
4 min read
How to: use jsonb_set function in PostgreSQL

How to: use jsonb_set function in PostgreSQL

27
Comments 2
1 min read
Part 2: How to Synchronize relational databases with Dotmim.Sync

Part 2: How to Synchronize relational databases with Dotmim.Sync

9
Comments 4
6 min read
Location Data for Cities and Towns

Location Data for Cities and Towns

6
Comments
2 min read
Building and Running SQL Queries with Knex.js

Building and Running SQL Queries with Knex.js

30
Comments
5 min read
SQL for the Potterhead: Inner Joins

SQL for the Potterhead: Inner Joins

9
Comments
3 min read
How to map column names to class properties with Dapper

How to map column names to class properties with Dapper

11
Comments 3
3 min read
Big Data from the Ground up

Big Data from the Ground up

78
Comments 2
7 min read
C#: What will make you choose RepoDb over Dapper (ORM)

C#: What will make you choose RepoDb over Dapper (ORM)

54
Comments
14 min read
AWS Databases Deep Dive: Season 1 Recap

AWS Databases Deep Dive: Season 1 Recap

63
Comments 1
4 min read
Basic DB Using SQL Server (Part 4) - SQL JOIN

Basic DB Using SQL Server (Part 4) - SQL JOIN

10
Comments
5 min read
I wrote an ORM for SQLite

I wrote an ORM for SQLite

13
Comments
1 min read
YEStifications: Exploring how users engage with notification prompts in the Chrome UX Report

YEStifications: Exploring how users engage with notification prompts in the Chrome UX Report

76
Comments 6
6 min read
How we killed project with NoSQL

How we killed project with NoSQL

31
Comments 19
4 min read
Database Notes 📖

Database Notes 📖

7
Comments
2 min read
Migración de la base de datos SQL local a la base de Azure SQL Database

Migración de la base de datos SQL local a la base de Azure SQL Database

16
Comments
11 min read
Google Cloud BigQuery vs. AWS Redshift

Google Cloud BigQuery vs. AWS Redshift

18
Comments 1
5 min read
Eager Loading VS Lazy Loading in SQLAlchemy

Eager Loading VS Lazy Loading in SQLAlchemy

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

20
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

32
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

25
Comments 2
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

21
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

12
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

38
Comments 2
4 min read
First steps to caching PostgreSQL queries with Redis

First steps to caching PostgreSQL queries with Redis

56
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

22
Comments 4
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
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

API data persistence with relational databases

6
Comments
2 min read
loading...