DEV Community

select * from SQL

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

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
DuckDB: When You Don’t Need Spark (But Still Need SQL)
konstantinas_mamonas profile

DuckDB: When You Don’t Need Spark (But Still Need SQL)

#database #sql #productivity #programming
Comments
2 min read
Why uber ditched postgres for mysql: What every developer can learn from it
dev_tips profile

Why uber ditched postgres for mysql: What every developer can learn from it

#webdev #programming #postgres #sql
2
Comments
46 min read
The Five Levels Of SQL
mendy_kevin_94ec1db73e1df profile

The Five Levels Of SQL

#sql #data #database #postgres
2
Comments 3
3 min read
Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL
hexshift profile

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

#postgres #sql #serverless #database
3
Comments
3 min read
Oracle AI Database 26ai — Read-Only User Feature
vahidusefzadeh profile

Oracle AI Database 26ai — Read-Only User Feature

#oracle #sql #linux #database
Comments
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
judith677 profile

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

#programming #datascience #sql #esprocspl
5
Comments 1
2 min read
Comprehensive SQL Guide for Freshers and Intermediate Learners
dnyaneshwarshekade profile

Comprehensive SQL Guide for Freshers and Intermediate Learners

#sql #webdev #programming #javascript
Comments
9 min read
Using SQLite in the Browser with WebAssembly and React (Local-First Apps with No Backend)
hexshift profile

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

#sql #browser #webassembly #react
6
Comments 2
3 min read
Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)
franckpachot profile

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

#postgres #json #sql #mongodb
3
Comments
5 min read
Collation in Database - What you need to know
richardmr36 profile

Collation in Database - What you need to know

#database #sqlserver #sql
Comments
3 min read
SQL: The Secret Weapon Behind Data Analytics and Data Science
joseph_hinga_mwangi profile

SQL: The Secret Weapon Behind Data Analytics and Data Science

#datascience #database #sql
4
Comments 3
4 min read
Connect Any Postgres to Real-Time Analytics
tigerdata_dev profile

Connect Any Postgres to Real-Time Analytics

#postgres #datascience #performance #sql
1
Comments
7 min read
What's New in MySQL 9 🧐 - a DBA's Perspective 🥸
op3ratordec profile

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

#mysql #database #sql #tooling
8
Comments
9 min read
Build a Secure Login System with PHP and MySQL: Step-by-Step Guide"
gyoussef03 profile

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

#webdev #security #php #sql
2
Comments
2 min read
Oracle Database 23ai : DBMS_SEARCH - pure SQL Sorcery | A promising alternative to global indexes.
abhilash8 profile

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

#sql #oracle #23ai #database
Comments
16 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.