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.
Multi Tenant Architecture in Software: What Is It and Its Databases Patterns
zeedu_dev profile

Multi Tenant Architecture in Software: What Is It and Its Databases Patterns

#backend #sql #architecture #database
16
Comments 5
4 min read
MariaDB to PostgreSQL: Lessons & Challenges
datamonk_ profile

MariaDB to PostgreSQL: Lessons & Challenges

#mariadb #postgres #database #sql
3
Comments
6 min read
Database Design Principles - Normalization and Denormalization
luca1iu profile

Database Design Principles - Normalization and Denormalization

#sql #database #tutorial
Comments
3 min read
SQL Injection - In Just 5 Minutes!
dzungnt98 profile

SQL Injection - In Just 5 Minutes!

#webdev #sql #security #backend
Comments
3 min read
PostgreSql Tasks - Case study:2
guru_prasanna_01 profile

PostgreSql Tasks - Case study:2

#payilagam #postgres #sql #database
1
Comments
2 min read
How to Import/Export CSV file in pgAdmin
syedamahamfahim profile

How to Import/Export CSV file in pgAdmin

#pgadmin #postgres #sql #csv
Comments
3 min read
Why Developers Are Ditching SQL Pain Points with Open-Source SPL
esproc_spl profile

Why Developers Are Ditching SQL Pain Points with Open-Source SPL

#sql #programming #development #beginners
6
Comments
7 min read
Mastering `SelectMany` in EF Core: SQL Equivalents and Best Practices
ahmedmohamedhussein profile

Mastering `SelectMany` in EF Core: SQL Equivalents and Best Practices

#efcore #sql #webdev #programming
4
Comments
3 min read
SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations
yujin profile

SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations

#tutorial #database #sql #ardenov
3
Comments
3 min read
JSON: A Technical Overview
farlamo profile

JSON: A Technical Overview

#programming #database #sql #postgres
1
Comments
3 min read
Efficient Data Processing in EF Core with the `Chunk` Method in .NET 6+
ahmedmohamedhussein profile

Efficient Data Processing in EF Core with the `Chunk` Method in .NET 6+

#webdev #programming #sql #performance
1
Comments 2
3 min read
How to Create a Trigger in MySQL?
roxana_haidiner profile

How to Create a Trigger in MySQL?

#mysql #sql #database #dbschema
8
Comments 2
2 min read
Performance Tips for Developers Using Postgres and pgvector
shiviyer profile

Performance Tips for Developers Using Postgres and pgvector

#postgres #database #vectordatabase #sql
Comments
3 min read
🔥 ULIDs: The Better Default for Modern Systems – Lessons from Shopify
gigaherz profile

🔥 ULIDs: The Better Default for Modern Systems – Lessons from Shopify

#webdev #database #sql #performance
1
Comments
3 min read
Flexible interval aggregation：From SQL to SPL
esproc_spl profile

Flexible interval aggregation：From SQL to SPL

#programming #sql #beginners #devops
6
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.