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.
SQL Server vs PostgreSQL: A Practical Comparison for Modern Developers
arthus15 profile

SQL Server vs PostgreSQL: A Practical Comparison for Modern Developers

#database #microsoft #postgres #sql
2
Comments 1
3 min read
SQL INJECTION
rodrino_adolfokupessala_ profile

SQL INJECTION

#beginners #sql #security #webdev
Comments
1 min read
Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale
sangwoo_rhie profile

Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale

#nestjs #firebase #sql #pushnotifications
1
Comments
12 min read
XML External Entity (XXE) Injection: A Complete Guide for Developers
irorochad profile

XML External Entity (XXE) Injection: A Complete Guide for Developers

#xmlexternalentity #sql #xxe #programming
Comments
18 min read
SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY
rebooter_s profile

SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

#sql #mysql
Comments
5 min read
3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)
md_pabel_fe07e07449db7326 profile

3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)

#security #sql #tutorial #wordpress
2
Comments
3 min read
Text2SQL on xxxx's of tables?
danshalev7 profile

Text2SQL on xxxx's of tables?

#sql #falkordb #opensource
Comments
1 min read
Simple vs Complex: When to Level Up Your Solutions
pepefeliblu profile

Simple vs Complex: When to Level Up Your Solutions

#architecture #complexity #engineering #sql
Comments
5 min read
Streaming SQL Engine: Lightweight Cross-Data Source Integration for Resource-Constrained Environments.
theodore_p_9749548f7dd03 profile

Streaming SQL Engine: Lightweight Cross-Data Source Integration for Resource-Constrained Environments.

#architecture #dataengineering #python #sql
10
Comments
1 min read
From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence
wellallytech profile

From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence

#sql #python #dataengineering #duckdb
2
Comments
3 min read
Stop Manually Tracing Azure Synapse Dependencies
chrhiswagat profile

Stop Manually Tracing Azure Synapse Dependencies

#database #sql #opensource #dataengineering
Comments
1 min read
PostgreSQL SQL Recap: Building Strong Foundational SQL Skills
auyeungdavid_2847435260 profile

PostgreSQL SQL Recap: Building Strong Foundational SQL Skills

#postgres #sql #beginners
1
Comments
4 min read
TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today
web_dev-usman profile

TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

#tailwindcss #database #sql #programming
5
Comments 1
4 min read
Part 8: Databricks Pipeline & Dashboard
ktnl profile

Part 8: Databricks Pipeline & Dashboard

#analytics #dataengineering #tutorial #sql
Comments
2 min read
Part 4: Building the Bronze Layer with Auto Loader and Delta Lake
ktnl profile

Part 4: Building the Bronze Layer with Auto Loader and Delta Lake

#architecture #dataengineering #tutorial #sql
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.