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

50
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)

72
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

327
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
loading...