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.
New Course: Database Fundamentals

New Course: Database Fundamentals

18
Comments
1 min read
Updating a Django queryset with annotation and subquery

Updating a Django queryset with annotation and subquery

29
Comments
3 min read
BeckDesignRules for Database Developers: Reveals intention – Naming

BeckDesignRules for Database Developers: Reveals intention – Naming

9
Comments
7 min read
Configuring and Managing SSL On Your MySQL Server

Configuring and Managing SSL On Your MySQL Server

10
Comments
6 min read
SQLite Types: To Affinity And Beyond

SQLite Types: To Affinity And Beyond

13
Comments
2 min read
Fun with your Amazon order history

Fun with your Amazon order history

9
Comments 1
1 min read
Getting Started with PostgreSQL Streaming Replication

Getting Started with PostgreSQL Streaming Replication

17
Comments
8 min read
Case Sensitive WHERE Clause

Case Sensitive WHERE Clause

10
Comments
1 min read
SQL tests in your smart framework

SQL tests in your smart framework

15
Comments
6 min read
Using C# LINQ API to perform SQL IN logic at WHERE clause

Using C# LINQ API to perform SQL IN logic at WHERE clause

22
Comments 9
1 min read
How To Import SQL File With PHP

How To Import SQL File With PHP

24
Comments 8
2 min read
SQL Server’s [N]VARCHAR(MAX) and How to Wield It

SQL Server’s [N]VARCHAR(MAX) and How to Wield It

8
Comments
1 min read
Replicate your PostgreSQL database into another server using just one command.

Replicate your PostgreSQL database into another server using just one command.

62
Comments 4
1 min read
DynamoDB PrimaryKey, HashKey, SortKey (RangeKey)

DynamoDB PrimaryKey, HashKey, SortKey (RangeKey)

17
Comments 1
3 min read
Go sql.DB Periodic Error: invalid connection

Go sql.DB Periodic Error: invalid connection

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