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