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.
Deeply Nested XML and JSON with SQL
pesse profile

Deeply Nested XML and JSON with SQL

#100codeexamples #sql #oracle
Comments
3 min read
Open-source SPL Makes Microservices More 'Micro'
sameerr31916367 profile

Open-source SPL Makes Microservices More 'Micro'

#microservices #programming #sql
5
Comments
5 min read
The evolution of enums
sandordargo profile

The evolution of enums

#database #sql #performance
2
Comments
7 min read
Trending Rust repos of the week 📈
rms profile

Trending Rust repos of the week 📈

#discuss #database #sql
5
Comments
3 min read
SQL tilida ma'lumot kiritish, tahrirlash, o'chirish va o'qish.
azizbektursunov profile

SQL tilida ma'lumot kiritish, tahrirlash, o'chirish va o'qish.

#sql #beginners #webdev #database
Comments
2 min read
Creating a Telegram Desktop App with PostgreSQL and Next.js 🪄
zevireinitz profile

Creating a Telegram Desktop App with PostgreSQL and Next.js 🪄

#javascript #tutorial #sql #nextjs
20
Comments 1
11 min read
100% Code Coverage is a Lie 🎯
balastrong profile

100% Code Coverage is a Lie 🎯

#postgres #sql #howto
42
Comments 13
2 min read
The SQL to CRUD: The Use of Structured Query Language to Create, Read, Update, and Destroy
chukwuma1976 profile

The SQL to CRUD: The Use of Structured Query Language to Create, Read, Update, and Destroy

#webdev #tutorial #ruby #sql
Comments
5 min read
Connect C# to SQL Server
osempu profile

Connect C# to SQL Server

#mongodb #database #sql #productivity
Comments
5 min read
SELECT DISTINCT pushdown to do a loose index scan (skip scan)
franckpachot profile

SELECT DISTINCT pushdown to do a loose index scan (skip scan)

#yugabytedb #postgres #distributed #sql
2
Comments
4 min read
How to Generate and add an SSH key to GitHub
joshhortt profile

How to Generate and add an SSH key to GitHub

#sql #database #entityframework #howto
14
Comments
5 min read
9 ways to tune SQL performance
yogini16 profile

9 ways to tune SQL performance

#sql #performance
Comments
2 min read
Working With Transactions In EF Core
milanjovanovictech profile

Working With Transactions In EF Core

#efcore #dotnet #sql #database
1
Comments
3 min read
XML-Generation in SQL with Namespaces
pesse profile

XML-Generation in SQL with Namespaces

#100codeexamples #sql #oracle #xml
Comments
2 min read
PostgreSQL: âš  when locking though views (TL;DR: test for race conditions and check execution plan with BUFFERS, VERBOSE)
franckpachot profile

PostgreSQL: âš  when locking though views (TL;DR: test for race conditions and check execution plan with BUFFERS, VERBOSE)

#postgres #sql #lock #view
Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.