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.
MySQL vs MongoDB - Visual Design with Real Data Models
roxana_haidiner profile

MySQL vs MongoDB - Visual Design with Real Data Models

#mysql #mongodb #sql #nosql
11
Comments 2
5 min read
New Tech Talk Proposal 😎 Just Dropped
sarahmatta profile

New Tech Talk Proposal 😎 Just Dropped

#techtalks #womenintech #sql #database
3
Comments 1
2 min read
Getting the Available Ranges from Two Tables — From SQL to SPL #34
judith677 profile

Getting the Available Ranges from Two Tables — From SQL to SPL #34

#programming #database #sql #esprocspl
9
Comments 3
3 min read
MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases
sparsh9 profile

MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases

#database #programming #sql #mongodb
1
Comments 1
2 min read
How Snowflake Copilot Inline Transformed My SQL Analysis Experience
tsubasa_tech profile

How Snowflake Copilot Inline Transformed My SQL Analysis Experience

#snowflake #sql #llm #analytics
6
Comments 2
5 min read
🛡️ Understanding and Exploiting Blind SQL Injection
onyxwizard profile

🛡️ Understanding and Exploiting Blind SQL Injection

#webdev #programming #cybersecurity #sql
Comments 1
3 min read
EF Query vs SQL View in Entity Framework – Which One Would You Choose?
vyavorskyi profile

EF Query vs SQL View in Entity Framework – Which One Would You Choose?

#csharp #efcore #sql #dotnet
Comments 1
3 min read
Is This a Refreshing Way to Understand Association?
esproc_spl profile

Is This a Refreshing Way to Understand Association?

#sql #programming #devops #esproc
6
Comments 1
7 min read
Understanding Database Indexes: A Library Analogy
prashanthm07 profile

Understanding Database Indexes: A Library Analogy

#database #sql #programming
Comments
4 min read
Oracle AI Database 26ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)
vahidusefzadeh profile

Oracle AI Database 26ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

#oracle #database #devops #sql
Comments 1
4 min read
Your PostgreSQL Command Cheat Sheet (But Way More Useful!)
jing_li profile

Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

#programming #postgres #sql #database
3
Comments
6 min read
The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)
peesari_saikaushik_3ff34c profile

The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

#sql #programming
Comments
1 min read
Fixing Getter/Setter Issues in TypeORM Entity(The Clean Way with transformer)
sarwarasik profile

Fixing Getter/Setter Issues in TypeORM Entity(The Clean Way with transformer)

#backend #typeorm #nestjs #sql
Comments
1 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘
op3ratordec profile

PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

#sql #mysql #postgres #database
6
Comments
9 min read
Perbedaan Antara SOQL dan SOSL di Salesforce
andreprasetya25 profile

Perbedaan Antara SOQL dan SOSL di Salesforce

#salesforce #sql
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.