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.

Franck Pachot for YugabyteDB

Jun 22 '22

🚀 hash+hash partitioning+sharding

#yugabytedb #distributed #sql #database

6 min read

kelvinsteve for Tiger Data (Creators of TimescaleDB)

Jun 21 '22

How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7

#postgres #sql #database

16 min read

Jun 21 '22

Deep Insight Into Open Source Databases

#opensource #database #github #sql

5 min read

Jun 20 '22

Keeping track of database schema changes

#sql #git #go #beginners

5 min read

A. Sharif

Jun 20 '22

Notes on PostgreSQL: Common Table Expressions

#postgres #sql #database

7 min read

Softhints

Jun 20 '22

SQL meet Data Science (Pandas) cheat sheet

#sql #python #datascience #datascientyst

1 min read

Ben Halpern for The DEV Team

Jun 15 '22

SQL Has Evolved a Lot In Order To Meet New Challenges — But The Fundamentals Have Remained 🎙

#podcast #sql #database #cloud

1 min read

Shai Almog

Jun 16 '22

Spring Boot Performance Workshop with Vlad Mihalcea

#java #tutorial #sql #programming

11 min read

Mangabo Kolawole

Jun 16 '22

Setup a Testing Environment with Docker and Pytest-Django: PostreSQL schema issue

#django #python #docker #sql

2 min read

Leandro Proença

Jun 13 '22

Resolvendo problema de performance no PostgreSQL com CTE

#sql #postgres #cte

4 min read

Ken Swearengen for CoderPad

Jun 13 '22

Dev Discussions: SQL vs NoSQL with James Quick of PlanetScale

#sql #database #beginners #architecture

4 min read

jeevan wijerathna

Jun 13 '22

SQL Server Database Partitioning

#sql #sqlserver

4 min read

Franck Pachot for YugabyteDB

Jun 12 '22

Nested Loop performance in YugabyteDB

#yugabytedb #distributed #sql #database

12 min read

Manvendra Deo Singh

May 18 '22

How to use SQL Server T-SQL function CHARINDEX in SQL queries

#beginners #sql #database

6 min read

Jun 7 '22

Working With JSON Objects Using SQL

#sql #programming #tutorial #database

3 min read

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