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.
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
Wait, what? PK is not needed for HABTM?
tom_donarski_dev profile

Wait, what? PK is not needed for HABTM?

#database #rails #ruby #sql
Comments
2 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.