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.
context-async-sqlalchemy - The best way to use sqlalchemy in an async python application

context-async-sqlalchemy - The best way to use sqlalchemy in an async python application

Comments
10 min read
DATABASE NORMALIZATION IN SQL - 1NF,2NF AND 3NF EXPLAINED (STUDENT - COURSE CASE STUDY

DATABASE NORMALIZATION IN SQL - 1NF,2NF AND 3NF EXPLAINED (STUDENT - COURSE CASE STUDY

Comments
3 min read
DB2 Pract (Packages, subqueries)

DB2 Pract (Packages, subqueries)

Comments
7 min read
How simultaneously swapping unique IDs in Postgres

How simultaneously swapping unique IDs in Postgres

4
Comments
2 min read
SeaORM 2.0: New Entity Format

SeaORM 2.0: New Entity Format

1
Comments
9 min read
Apache Ignite 3.1.0 is now available

Apache Ignite 3.1.0 is now available

Comments
2 min read
Why AI Analytics Tools Are Solving the Wrong Problem

Why AI Analytics Tools Are Solving the Wrong Problem

5
Comments 1
7 min read
cursor

cursor

Comments
3 min read
TypedSql: Turning the C# Type System into a High-Performance SQL Query Engine

TypedSql: Turning the C# Type System into a High-Performance SQL Query Engine

4
Comments 1
17 min read
DevPill 6 - SQLC: how to scaffold your database code

DevPill 6 - SQLC: how to scaffold your database code

Comments
1 min read
Devpill 4 - Database migrations with Migrate

Devpill 4 - Database migrations with Migrate

Comments 1
1 min read
Fixing SQL Injection Vulnerabilities to Strengthen Security

Fixing SQL Injection Vulnerabilities to Strengthen Security

Comments 2
10 min read
Learning .NET from Beginner to Advanced Level's

Learning .NET from Beginner to Advanced Level's

20
Comments 2
22 min read
Demystifying Normalization in RDBMS: From 1NF to 3NF

Demystifying Normalization in RDBMS: From 1NF to 3NF

Comments
5 min read
Understanding the Difference Between Subquery, CTE, and Stored Procedure

Understanding the Difference Between Subquery, CTE, and Stored Procedure

Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.