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.
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.