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.
What is Object-Relational Mapping? How to Roll-Your-Own JavaScript ORM

What is Object-Relational Mapping? How to Roll-Your-Own JavaScript ORM

61
Comments 1
14 min read
7 reasons why learning SQL is still important for Rails developers

7 reasons why learning SQL is still important for Rails developers

18
Comments 1
5 min read
Experimenting Flyway with SQL Server

Experimenting Flyway with SQL Server

7
Comments
2 min read
Welcome to SQL 3: Building Relationships and Combining Data Sets

Welcome to SQL 3: Building Relationships and Combining Data Sets

11
Comments 1
10 min read
Managing High Availability in PostgreSQL – Part II

Managing High Availability in PostgreSQL – Part II

11
Comments
11 min read
Build a Secure Node.js App with SQL Server

Build a Secure Node.js App with SQL Server

38
Comments 1
23 min read
Database Management Systems For Application Development: Introduction

Database Management Systems For Application Development: Introduction

10
Comments
2 min read
Simple Tips for PostgreSQL Query Optimization

Simple Tips for PostgreSQL Query Optimization

20
Comments
5 min read
#100CodeExamples – Constants in PL/SQL and SQL

#100CodeExamples – Constants in PL/SQL and SQL

8
Comments
3 min read
How much difference does adding an index to a database table make?

How much difference does adding an index to a database table make?

11
Comments
3 min read
Documenting the DB: Data dictionaries

Documenting the DB: Data dictionaries

36
Comments
3 min read
How to Automate Dumping for SQL Databases

How to Automate Dumping for SQL Databases

13
Comments 7
3 min read
Prevent SQL Injections

Prevent SQL Injections

17
Comments 4
5 min read
Often your solution is one (more) google search away

Often your solution is one (more) google search away

14
Comments
2 min read
Welcome to SQL 2: Working With Data Values

Welcome to SQL 2: Working With Data Values

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