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.
Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

8
Comments 3
13 min read
We used CosmosDB instead of a relational database, here's what we went through and learned.

We used CosmosDB instead of a relational database, here's what we went through and learned.

10
Comments 2
4 min read
Dark theme in SQL Server Management Studio

Dark theme in SQL Server Management Studio

12
Comments 1
2 min read
Hacker-rank SQL Median calculation

Hacker-rank SQL Median calculation

8
Comments
1 min read
My Back-end Adventures - Setting up a local database (Postgres)

My Back-end Adventures - Setting up a local database (Postgres)

9
Comments
4 min read
SQL for dummies

SQL for dummies

10
Comments
5 min read
My Back-end Adventures - Intro

My Back-end Adventures - Intro

37
Comments 5
2 min read
Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

10
Comments 2
4 min read
SQL injection for developers

SQL injection for developers

128
Comments 5
12 min read
What is the best way store column metadata in SQLite (like, is JSON or is Date)

What is the best way store column metadata in SQLite (like, is JSON or is Date)

7
Comments 6
1 min read
Jupyter Notebooks + IBMi

Jupyter Notebooks + IBMi

15
Comments 2
4 min read
Azure SQL and Site Reliability

Azure SQL and Site Reliability

13
Comments
8 min read
What SQLite CAN actually do

What SQLite CAN actually do

33
Comments 1
3 min read
Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

13
Comments 4
5 min read
Getting query performance stats with PostgreSQL

Getting query performance stats with PostgreSQL

24
Comments 1
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.