Skip to content

DEV Community

select * from SQL

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

tag moderators

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

Aug 4

Query Execution Plan inside SQL Server

#sql #programming #database

4 min read

Huzaifa

Aug 4

Case Study: How Company X Leveraged Apache AGE to Enhance Fraud Detection

#postgres #database #apache #sql

3 min read

Aug 3

Is Your Latest Data Really the Latest? Check the Data Update Mechanism of Your Database

#datascience #database #sql #bigdata

6 min read

Franck Pachot for YugabyteDB

Jul 25

SQL for low code applications: SQLPage

#yugabytedb #postgres #lowcode #sql

2 min read

Vladimir Mihailenco

Jul 28

PostgreSQL Faceted navigation and search

#postgres #programming #tutorial #sql

4 min read

Rodrigo Mansueli for Supabase

Jul 25

Safeguarding Data Integrity with pg-safeupdate in PostgreSQL and Supabase

#postgres #sql #database #webdev

3 min read

Ivan N

Aug 3

Batch rename BigQuery tables with SQL

#bigquery #gcp #sql #regex

3 min read

Kenzo Castañeda

Jul 19

Creating a GraphQL API from a Data Lake: Data Engineering (Part 1)

#graphql #sql #python #datascience

11 min read

Olajide Olaniyan

Jul 18

Sampling in PostgreSQL with BERNOULLI Function

#postgres #database #sql #datascience

3 min read

Huzaifa

Jul 17

Real Time Recommendation Systems with Apache AGE

#postgressql #sql #postgres #apache

3 min read

Pratim Bhosale for SurrealDB

Jul 25

What are Multi-Model Databases?

#database #surrealdb #beginners #sql

6 min read

Franck Pachot for AWS Heroes

Jul 24

PostgreSQL Optimizer Hints Discussion

#postgres #sql #hints #optimizer

4 min read

Huzaifa

Jul 24

Integrating AGE with Apache Spark: Power of Distributed Computing for Graph Analytics

#apache #postgres #sql #database

3 min read

Jul 14

Generating an Access Token for Azure SQL Database Using Service Principal and Client Secret using PowerShell

#azure #cloud #sql #powershell

2 min read

Bala Madhusoodhanan

Jul 10

Method Madness: Cast Your Vote

#discuss #poll #programming #sql

1 min read

NijjohUnno

Jul 13

Demystifying SQL: An Introduction to SQL Using SQL Server

#sql #database #datascience #dataanalysis

4 min read

Aug 1

Creating a SQL Database Context in a .NET Framework WinForms Application with EntityFramework

#devexpress #winform #csharp #sql

3 min read

Jul 12

Exploring MS SQL Server Triggers

#sql #sqlserver #database

2 min read

Rafaela Carvalho

Jul 12

Ordenando e Agrupando seus Dados no SQL

#datascience #sql #beginners #tutorial

2 min read

Huzaifa

Jul 12

Unlocking the Power of Graph Analytics with Apache AGE

#apache #database #postgres #sql

3 min read

JS for ZenStack

Jul 26

Soft Delete: Dealing With Unique Constraint in Real-World Case

#webdev #database #sql #typescript

2 min read

Rafaela Carvalho

Jul 8

Trabalhando com funções de agregação no SQL

#datascience #sql #beginners #tutorial

2 min read

Jul 5

What are the Set Operators in SQL?

#sql

3 min read

Daniela Barazarte

Jul 3

Structured Query Language (SQL)| Explicación Completa (Definición, uso, estructura y ejemplo con MySQL)

#database #sql #development

3 min read

Tom Nats for Starburst

Jul 26

Introduction to Apache Iceberg in Trino

#iceberg #trino #sql #opensource

5 min read

Jul 7

Mastering the Art of Optimizing Complex SQL Queries

#sql #database #datascience #productivity

2 min read

Jason Shin

Jul 24

[sqlx-ts] compile-time checked queries without DSL in Typescript

#typescript #sql #rust #opensource

4 min read

Franck Pachot for YugabyteDB

Jun 30

Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

#yugabytedb #postgres #distributed #sql