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.
Modern data practice and the SQL tradition

Modern data practice and the SQL tradition

17
Comments 1
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

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

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

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

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