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.
How Excel is Used in Real-World Data Analysis
joshua_kitemange_aa00f47e profile

How Excel is Used in Real-World Data Analysis

#datascience #sql #github #beginners
4
Comments 2
2 min read
Integration testing tRPC and in memory MySQL database.
pietro_palmesi_b8b68ba0f6 profile

Integration testing tRPC and in memory MySQL database.

#t3 #nextjs #vitest #sql
1
Comments
5 min read
Which LLM writes the best SQL?
tbperegrine profile

Which LLM writes the best SQL?

#ai #analytics #database #sql
Comments
10 min read
Create Columns from Distinct Values of a Column — From SQL to SPL #26
judith677 profile

Create Columns from Distinct Values of a Column — From SQL to SPL #26

#programming #esprocspl #database #sql
6
Comments 1
1 min read
Solving One-to-Many Update Issues in Status Tracking Systems
galisetty_priyatham_c1a49 profile

Solving One-to-Many Update Issues in Status Tracking Systems

#java #sql #programming #webdev
3
Comments 5
1 min read
Why Transactional Databases Matter: Concepts, Use Cases, and Examples
rizkytegar profile

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

#sql #database
2
Comments 2
3 min read
Kapper 1.5: Celebrating Java's 30th Birthday with Blazing Fast Record Mapping
driessamyn profile

Kapper 1.5: Celebrating Java's 30th Birthday with Blazing Fast Record Mapping

#java #kotlin #sql #kapper
Comments 1
4 min read
Substring from a Column of Strings — From SQL to SPL #25
judith677 profile

Substring from a Column of Strings — From SQL to SPL #25

#programming #database #sql #esprocspl
5
Comments 1
2 min read
🛡️ Examining the Database in SQL Injection Attacks
onyxwizard profile

🛡️ Examining the Database in SQL Injection Attacks

#sql #hacktoberfest #cybersecurity #webdev
Comments 1
4 min read
Total under Recursive Relationship — From SQL to SPL #33
judith677 profile

Total under Recursive Relationship — From SQL to SPL #33

#programming #database #sql #esprocspl
7
Comments 1
2 min read
Navigating the Landscape of Data-Modeling – A Comprehensive Guide
chaets profile

Navigating the Landscape of Data-Modeling – A Comprehensive Guide

#database #datamodel #dataworld #sql
Comments 3
4 min read
Read-Only Session in Oracle AI Database 26ai
vahidusefzadeh profile

Read-Only Session in Oracle AI Database 26ai

#news #database #security #sql
Comments
1 min read
How to install PostgreSQL on macOS: Step-by-Step Instructions
saif_uddin profile

How to install PostgreSQL on macOS: Step-by-Step Instructions

#sql #postgressql #programming #database
Comments
1 min read
Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App
aomuiz profile

Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App

#webdev #reactnative #react #sql
2
Comments
4 min read
Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)
mandarg13 profile

Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)

#sql #postgres #database #softwareengineering
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.