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.

HexShift

May 2

Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL

#postgres #sql #serverless #database

3 min read

Vahid Yousefzadeh

May 2

Oracle 23ai — Read-Only User Feature

#oracle #sql #linux #database

2 min read

Judith-Data-Processing-Hacks

Apr 2

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

#programming #datascience #sql #esprocspl

2 min read

Judy

Apr 1

How to simplify nested SQL in applications with esProc

#discuss #programming #devops #sql

4 min read

Dnyaneshwar Vitthal Shekade

Mar 28

Comprehensive SQL Guide for Freshers and Intermediate Learners

#sql #webdev #programming #javascript

9 min read

HexShift

May 1

Using SQLite in the Browser with WebAssembly and React (Local-First Apps with No Backend)

#sql #browser #webassembly #react

3 min read

Apr 30

Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

#postgres #json #sql #mongodb

5 min read

Mar 27

Collation in Database - What you need to know

#database #sqlserver #sql

3 min read

Apr 29

SQL: The Secret Weapon Behind Data Analytics and Data Science

#datascience #database #sql

4 min read

Team TigerData for TigerData (Creators of TimescaleDB)

Apr 29

Connect Any Postgres to Real-Time Analytics

#postgres #datascience #performance #sql

7 min read

Ayra Jett for Bytebase

Apr 29

What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

#mysql #database #sql #tooling

9 min read

Apr 29

Build a Secure Login System with PHP and MySQL: Step-by-Step Guide"

#webdev #security #php #sql

2 min read

Abhilash Kumar | Oracle ACE ♠ for Nabhaas Cloud Consulting

Apr 29

Oracle Database 23ai : DBMS_SEARCH - pure SQL Sorcery | A promising alternative to global indexes.

#sql #oracle #23ai #database

16 min read

Judith-Data-Processing-Hacks

Jun 10

Conditional Grouping — From SQL to SPL #37

#programming #database #sql #esprocspl

2 min read

Roxana Maria Haidiner

Apr 28

Best 7 Logical Database Design Tools in 2025

#database #sql #productivity #architecture

5 min read

InterSystems Developer for InterSystems

Mar 25

SQLAchemy-iris with the latest version Python driver

#python #sql #programming #opensource

6 min read

Sean Drew

Mar 25

Filtering and Exporting SQL Stored Procedures with PowerShell

#sql #sqlserver #powershell

4 min read

Franck Pachot for AWS Heroes

Apr 28

PostgreSQL aborts the transactions on error

#postgres #sql #database #savepoint

3 min read

Apr 28

SQL Tutorial Made Easy: From Basics to Advanced Queries

#programming #beginners #tutorial #sql

3 min read

Apr 27

# PostgreSQL Tutorial: What Really Happens When You Add and Drop Columns 2000 Times in PostgreSQL

#opensource #postgres #sql

2 min read

Apr 28

SQL JOINs Explained: Connecting Data Across Tables

#sql #database #postgres #mysql

6 min read

Matt Luo for Convex Champions

Apr 7

Beyond SQL: How Convex Reimagines the Modern Database — A ClarityText Startup Story

#typescript #database #sql #webdev

7 min read

Zayniddin Atabaev

Apr 26

Node.js uchun ORM tanlaymiz!

#orm #node #sql

2 min read

Sugumar R

Mar 23

Day 1: Getting Started with PSQL: The Powerful SQL DataBase.

#sql #postgres #database

3 min read

Mar 23

Kapper 1.3 supports flows - more Kotlin goodness

#kotlin #coroutines #database #sql

3 min read

loading...