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.
How to Back Up and Restore MySQL Using mysqldump
dbvismarketing profile

How to Back Up and Restore MySQL Using mysqldump

#sql #mysql #backup
Comments
2 min read
5 Steps to Optimize MySQL Deep Pagination
rebooter_s profile

5 Steps to Optimize MySQL Deep Pagination

#mysql #sql
Comments
4 min read
The Equality Delete Problem in Apache Iceberg
__354f265b41dafa0d901b profile

The Equality Delete Problem in Apache Iceberg

#discuss #database #datascience #sql
Comments
9 min read
Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications
damasosanoja profile

Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications

#supabase #postgressql #database #sql
9
Comments 1
19 min read
Why Your SQL Queries Are Slower Than a Sloth: Deep Dive Into Indexes You’re Probably Misusing
ekwoster profile

Why Your SQL Queries Are Slower Than a Sloth: Deep Dive Into Indexes You’re Probably Misusing

#sql #performance #database #optimization
Comments
4 min read
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)
shiva_shanker_k profile

Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

#vscode #sqlserver #sql #database
30
Comments
4 min read
SQL,PostgreSQL, Database RDBMS, Sql NoSql farqi
elshoddev profile

SQL,PostgreSQL, Database RDBMS, Sql NoSql farqi

#sql #database #nosql #rdbms
Comments
4 min read
🦆 DuckDB: The SQLite of Analytics You Didn’t Know You Needed
sanukhandev profile

🦆 DuckDB: The SQLite of Analytics You Didn’t Know You Needed

#duckdb #sql #dataengineering #datascience
Comments
3 min read
College Student & Course Management System
prian_ss24cb042_1006e0f profile

College Student & Course Management System

#programming #webdev #sql #learning
Comments
3 min read
Day 4 Data Analytics Progress 📈
vengat2505 profile

Day 4 Data Analytics Progress 📈

#sql #mysql #datascience #learning
Comments
1 min read
Database Security Patterns for Web Applications
vanessamadison profile

Database Security Patterns for Web Applications

#database #security #sql #backend
Comments
2 min read
SQLite dot commands: Output mode separator command
mr_destructive profile

SQLite dot commands: Output mode separator command

#sql #sqlite #database #programming
2
Comments
2 min read
The main tasks of a Database Administrator (DBA) by 2025
leandro_nnz profile

The main tasks of a Database Administrator (DBA) by 2025

#database #dba #sql
5
Comments
27 min read
SQLite dot commands: Output mode
mr_destructive profile

SQLite dot commands: Output mode

#sql #sqlite #database #programming
2
Comments
9 min read
How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide
mehul_budasana profile

How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

#googlecloud #gcp #sql #database
6
Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.