Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Jun 4 '24

Criei um banco de dados baseado no Universo de One Piece

#sql

4 min read

geraldew

Jun 3 '24

Changing SQL Dialect From Teradata To SQLite

#sql #database #data

14 min read

Juthi Sarker Aka

Jun 3 '24

Key Factors to Consider for Effective Database Design (Constraints, Indexes)

#database #sql

5 min read

vbilopav

Jul 7 '24

Modern Software Architecture is a Joke

#sql #architecture

2 min read

Jul 6 '24

First Steps in SQL Operators: A Beginner's Guide

#operators #steps #guide #sql

2 min read

Judy

Jul 5 '24

The impasse of SQL performance optimizing

#sql #programming #performance #spl

8 min read

Anton Martyniuk

Jul 5 '24

A Complete Guide to Different Types of Joins in SQL

#database #sql #postgres

8 min read

Jul 4 '24

GitHub Copilot and SQL

#sql #csharp #productivity #codenewbie

6 min read

Franck Pachot for YugabyteDB

Jul 4 '24

Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers

#yugabytedb #postgres #sql #database

4 min read

Adam Furmanek for Metis

Jul 4 '24

From development to production what can go wrong with your databases (and how to avoid and fix them)

#sql #database #monitoring

6 min read

Jul 4 '24

Revolutionizing Database Migration: From MongoDB to SQL with AI

#ai #database #mongodb #sql

3 min read

vbilopav

Jul 3 '24

Unit Testing and TDD With PostgreSQL is Easy

#postgressql #tdd #testing #sql

9 min read

Judy

Jul 2 '24

How to Transpose Columns in Each Group to a Single Row

#sql #development #spl

2 min read

Jul 2 '24

Mastering SQL Databases: In-Depth Guide

#sql #sqlserver #programming

2 min read

Emanuel Gustafzon

Jul 2 '24

SQL Course: Challanges

#challenge #sql

2 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.