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.
Building a User Registration System in .NET Core & C#
clover_luo profile

Building a User Registration System in .NET Core & C#

#aspnet #csharp #dotnet #sql
6
Comments
2 min read
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.