Forem

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

entity2sql

7
Comments
2 min read
Embedded database vs Client-Server database (on the same host) performance?

Embedded database vs Client-Server database (on the same host) performance?

3
Comments
1 min read
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

80
Comments 4
6 min read
Tips and tricks for SQL Server database (table) design?

Tips and tricks for SQL Server database (table) design?

4
Comments 1
3 min read
Data Engineering 101: Automating Your First Data Extract

Data Engineering 101: Automating Your First Data Extract

101
Comments
7 min read
Making GraphQL Magic with Sqlmancer 🧙🔮✨

Making GraphQL Magic with Sqlmancer 🧙🔮✨

9
Comments
6 min read
Basic DB Using SQL Server (Part 7) - Set Operations in SQL

Basic DB Using SQL Server (Part 7) - Set Operations in SQL

6
Comments
6 min read
Basic DB Using SQL Server (Part 6)

Basic DB Using SQL Server (Part 6)

6
Comments
5 min read
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.

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

Dark theme in SQL Server Management Studio

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

Hacker-rank SQL Median calculation

8
Comments
1 min read
Learn SQL Injection by hacking a bank app

Learn SQL Injection by hacking a bank app

95
Comments 4
7 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)

9
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

14
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
Avoid This Mistake When Restoring a TDE Protected Database to a New Server

Avoid This Mistake When Restoring a TDE Protected Database to a New Server

6
Comments
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

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

Getting query performance stats with PostgreSQL

24
Comments 1
6 min read
loading...