Anonymous View

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.
Stop Re-running Everything: A Local Incremental Pipeline in DuckDB
markolekic profile

Stop Re-running Everything: A Local Incremental Pipeline in DuckDB

#python #dataengineering #sql #duckdb
Comments
4 min read
Indexando dados intangíveis - otimizando consultas ao banco de dados usando colunas geradas
silvajoaop profile

Indexando dados intangíveis - otimizando consultas ao banco de dados usando colunas geradas

#database #sql #performance #mysql
12
Comments 2
7 min read
Native Auditing Architecture: Embedding Traceability Intelligence within the Database Core.
isabellyarrudaa profile

Native Auditing Architecture: Embedding Traceability Intelligence within the Database Core.

#architecture #database #security #sql
1
Comments
5 min read
Boosting PostgreSQL Query Performance with Materialized Views
mariana_tavares profile

Boosting PostgreSQL Query Performance with Materialized Views

#postgres #performance #sql #analytics
1
Comments
6 min read
SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL
mazinocodes profile

SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

#database #postgres #sql #beginners
8
Comments
3 min read
Go Database Fundamentals: SQL or NoSQL for Your Next Project?
jones_charles_ad50858dbc0 profile

Go Database Fundamentals: SQL or NoSQL for Your Next Project?

#go #database #sql #nosql
5
Comments
9 min read
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.