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.

Antonello Zanini for Writech

Jan 19 '24

Partitioning a Billion-Row Table of Soccer Data Using Data Context

#data #sql #database #startup

8 min read

Antonello Zanini for Writech

Jan 19 '24

When to Use JSON Data in a Relational Database

#database #sql #json #data

6 min read

Antonello Zanini for Writech

Jan 19 '24

Improving Performance in a Hierarchical SQL Table Structure with Column Propagation

#database #sql #data #webdev

9 min read

Joseph Petty for Appsmith

Jan 19 '24

Understanding 'Single' vs "Double" Quotation Marks in PostgreSQL

#sql #postgres #programming #database

3 min read

Jan 8 '24

CRUD and SQL - the basics!

#webdev #sql #beginners #programming

5 min read

Gurpinder Singh

Jan 18 '24

Oracle SQL database with CodeIgniter?

#oracle #beginners #sql #tutorial

2 min read

Franck Pachot for YugabyteDB

Jan 18 '24

YugabyteDB avoids bloat with the outbox pattern

#yugabytedb #postgres #distributed #sql

6 min read

Lucas Rafaldini

Jan 17 '24

Back to Basics #3 - Databases and SQL Fundamentals

#database #sql #beginners #coding

2 min read

Adam Furmanek for Metis

Jan 17 '24

Monitoring Is Not Enough and Understanding Through Observability Is the Key

#sql #database #postgres #observability

13 min read

Tom Nijhof

Jan 17 '24

SQL and PostgreSQL for Advanced Full-Text Search

#sql #postgres #database #backend

5 min read

Jan 17 '24

Handling JSON data in SQL Databases

#json #sql #database #webdev

3 min read

Tom Nijhof

Jan 17 '24

Why do I put a table between the images and the data

#database #sql #designpatterns #webdev

4 min read

Judy

Jan 15 '24

SQL looks like English is a well-intentioned error

#discuss #programming #devops #sql

4 min read

angu10

Jan 16 '24

Understanding Custom Functions in DuckDB

#pandas #duckdb #udf #sql

2 min read

Franck Pachot for YugabyteDB

Jan 15 '24

Covering Index nuances: which columns to cover (WHERE, ORDER BY, LIMIT, SELECT)?

#yugabytedb #postgres #sql #distributed

12 min read

Jan 15 '24

Querying MongoDB Like an SQL DB Using Aggregation Pipeline

#mongodb #sql #webdev #database

8 min read

Jan 13 '24

SQL Assistant: Text-to-SQL Application in Streamlit 🤖

#database #sql #datascience #python

6 min read

Arjun Vijay Prakash

Jan 24 '24

18 GitHub Repositories You Need to Star Right Now! 🌟🔥

#programming #sql #productivity #github

4 min read

Jan 14 '24

PostgreSQL Backup and Restore Strategies: A Comprehensive Guide

#database #postgres #sql #backup

5 min read

Dave Gray

Jun 16 '24

How to Write a SQL Subquery with Drizzle ORM

#sql #drizzle #orm #mysql

2 min read

Nathalia Friederichs

Dec 13 '23

Unveiling the Potential of the COUNT Function in SQL

#programming #database #sql #learning

3 min read

Anil Singh

Jan 12 '24

Import data from Excel to SQL Server or Azure SQL Database | Convert Excel Files to Databases Quickly

#excel #sql #sqlserver #import

1 min read

Anil Singh

Jan 12 '24

How to Create a database in SQL Server 2022?

#sql #sqlserver #database

1 min read

Jan 11 '24

The Basics of SQL Joins

#discuss #sql #webdev #basic

2 min read

Dec 11 '23

SQL - Efficiently Paginate Query Results

#sql #programming #beginners #tutorial

1 min read

loading...