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