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.
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
Using Docker & Docker Compose to Improve Your Full Stack App Development

Using Docker & Docker Compose to Improve Your Full Stack App Development

2
Comments
8 min read
Sequelize: Like Mongoose but for SQL

Sequelize: Like Mongoose but for SQL

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