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

8
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

30
Comments 2
1 min read
Part 2: How to Synchronize relational databases with Dotmim.Sync
Cover image for Part 2: How to Synchronize relational databases with Dotmim.Sync

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

10
Comments 4
6 min read
Location Data for Cities and Towns
Cover image for 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
Cover image for Building and Running SQL Queries with Knex.js

Building and Running SQL Queries with Knex.js

30
Comments
5 min read
Fun interview question: How to update Saint Quartz stones with one line SQL statement in FGO?
Cover image for 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
2 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for Eager Loading VS Lazy Loading in SQLAlchemy

Eager Loading VS Lazy Loading in SQLAlchemy

28
Comments
4 min read
Deploy an application on Glitch in 5 steps
Cover image for 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
loading...