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.
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
How to Automate Dumping for SQL Databases

How to Automate Dumping for SQL Databases

13
Comments 7
3 min read
Documenting the DB: Data dictionaries

Documenting the DB: Data dictionaries

35
Comments
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
Welcome to SQL: Modifying Databases and Tables

Welcome to SQL: Modifying Databases and Tables

6
Comments
10 min read
SQL concepts from A to Z

SQL concepts from A to Z

865
Comments 20
14 min read
#100CodeExamples – Only one active protocol

#100CodeExamples – Only one active protocol

6
Comments
2 min read
Best Tutorial For Java & SQL?

Best Tutorial For Java & SQL?

8
Comments 12
1 min read
Breaking Postgres with Too Many Tables

Breaking Postgres with Too Many Tables

47
Comments 5
3 min read
Is SQL Really A Game Changer For Data Science Careers?

Is SQL Really A Game Changer For Data Science Careers?

24
Comments 1
4 min read
How to simplest Turing Machine works on postgreSQL

How to simplest Turing Machine works on postgreSQL

7
Comments
5 min read
Connect Flask to a Database with Flask-SQLAlchemy

Connect Flask to a Database with Flask-SQLAlchemy

26
Comments 1
9 min read
Database models and ERDs for Newbs Part: 5

Database models and ERDs for Newbs Part: 5

5
Comments
3 min read
Database models and ERDs for Newbs Part: 4

Database models and ERDs for Newbs Part: 4

9
Comments
3 min read
AlaSQL: A Real Database for Web Browsers (and Node.js)

AlaSQL: A Real Database for Web Browsers (and Node.js)

70
Comments 9
5 min read
Power of ActiveRecord and when to stop using it

Power of ActiveRecord and when to stop using it

16
Comments 2
3 min read
Database models and ERDs for Newbs Part: 3

Database models and ERDs for Newbs Part: 3

4
Comments
2 min read
Everything you need to know about (Relational) Databases

Everything you need to know about (Relational) Databases

324
Comments 7
16 min read
Elixir Phoenix: How I Turned A Function Into Raw SQL And Then Into An Ecto Query

Elixir Phoenix: How I Turned A Function Into Raw SQL And Then Into An Ecto Query

14
Comments
4 min read
Event Storage in Postgres, Multi-tenant

Event Storage in Postgres, Multi-tenant

66
Comments 10
6 min read
From CSVs to Tables: Infer Schema Data Types From Raw Spreadsheets

From CSVs to Tables: Infer Schema Data Types From Raw Spreadsheets

7
Comments
8 min read
Implement ORM Data Models with SQLAlchemy

Implement ORM Data Models with SQLAlchemy

2
Comments 1
6 min read
Running Fast SQL on DynamoDB Tables

Running Fast SQL on DynamoDB Tables

7
Comments
4 min read
Database models and ERDs for Newbs Part: 2

Database models and ERDs for Newbs Part: 2

7
Comments
2 min read
History Tables

History Tables

8
Comments
7 min read
Explicit Entity State

Explicit Entity State

4
Comments
2 min read
Starting With SQL

Starting With SQL

54
Comments 4
4 min read
Database models and ERDs for Newbs Part: 1

Database models and ERDs for Newbs Part: 1

4
Comments
2 min read
You Can Do it in SQL, Stop Writing Extra Code for it

You Can Do it in SQL, Stop Writing Extra Code for it

521
Comments 103
5 min read
#100CodeExamples – PL/SQL BOOLEAN to INT

#100CodeExamples – PL/SQL BOOLEAN to INT

5
Comments
2 min read
USING DATABASE TRIGGERS IN POSTGRESQL

USING DATABASE TRIGGERS IN POSTGRESQL

21
Comments 2
5 min read
Databases in Python Made Easy with SQLAlchemy

Databases in Python Made Easy with SQLAlchemy

12
Comments
10 min read
DB2: Restart Identity

DB2: Restart Identity

7
Comments
1 min read
Find a Specific Column In An Unknown SQL Table

Find a Specific Column In An Unknown SQL Table

12
Comments 4
2 min read
A PRIMER ON POSTGRESQL STORED FUNCTIONS (PL/pgSQL)

A PRIMER ON POSTGRESQL STORED FUNCTIONS (PL/pgSQL)

21
Comments
5 min read
Clone schema in PostgreSQL

Clone schema in PostgreSQL

18
Comments 7
1 min read
Run migrations in schemas in PostgreSQL

Run migrations in schemas in PostgreSQL

7
Comments
2 min read
The semantics of Elasticsearch’s nested datatype and query operator

The semantics of Elasticsearch’s nested datatype and query operator

6
Comments
4 min read
Back Up and Restore Your SQL Database

Back Up and Restore Your SQL Database

8
Comments 1
4 min read
2018 in review: 5 most viewed posts of this year on my blog

2018 in review: 5 most viewed posts of this year on my blog

15
Comments
3 min read
SQL Clause is coming to town!

SQL Clause is coming to town!

51
Comments 4
1 min read
#100CodeExamples – SYSDATE vs. CURRENT_DATE

#100CodeExamples – SYSDATE vs. CURRENT_DATE

9
Comments
2 min read
Conditional Column Join in SQL

Conditional Column Join in SQL

25
Comments 5
2 min read
Authentication Hashing in SQLAlchemy

Authentication Hashing in SQLAlchemy

17
Comments
4 min read
Explain DB2 query

Explain DB2 query

8
Comments
1 min read
Build a Basic App with Spring Boot and JPA using PostgreSQL

Build a Basic App with Spring Boot and JPA using PostgreSQL

8
Comments
19 min read
Start DB Schema Migration with "goose"

Start DB Schema Migration with "goose"

19
Comments 1
4 min read
#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup

#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup

8
Comments
3 min read
Using Scenic and SQL views to aggregate data

Using Scenic and SQL views to aggregate data

4
Comments
4 min read
Ways of Seeing: ORMS & SQL Views

Ways of Seeing: ORMS & SQL Views

55
Comments 5
7 min read
Combining SQL queries with UNION

Combining SQL queries with UNION

11
Comments
5 min read
loading...