Best of SQL — July 2025

  1. 1
    Article
    Avatar of strongdmstrongdm·47w

    PostgreSQL vs. MySQL: Differences for Tech Leaders & Teams

    PostgreSQL excels at complex, write-heavy workloads with advanced SQL features, rich data types like JSONB, and strict ACID compliance, making it ideal for financial systems and analytics. MySQL prioritizes speed and simplicity for read-heavy applications, offering lightweight architecture perfect for web apps, CMSs, and MVPs. PostgreSQL provides superior extensibility, query optimization, and enterprise features, while MySQL delivers faster performance for simple queries and lower resource consumption. The choice depends on workload complexity, data consistency requirements, and scalability needs.

  2. 2
    Article
    Avatar of lonely_programmerLonely Programmer·44w

    How SQL works....

  3. 3
    Video
    Avatar of youtubeYouTube·45w

    Website Hacking for Beginners | SQL Injection

    A beginner-friendly demonstration of SQL injection attacks using a fake banking website. Shows how attackers can bypass login forms by manipulating SQL queries with techniques like '1=1' logic and comment injection (--). Explains the vulnerability occurs when user input isn't properly validated, allowing unauthorized access and potential data theft. Emphasizes this is one of the top three OWASP critical vulnerabilities and mentions advanced tools like Burp Suite and SQLMap for automated attacks.

  4. 4
    Article
    Avatar of communityCommunity Picks·47w

    When to Choose NoSQL Over SQL

    Explores when to choose NoSQL over SQL databases from a backend developer's perspective, using practical examples like e-commerce product catalogs and IoT sensor data. Covers real-world trade-offs including schema flexibility, performance considerations, and eventual consistency. Discusses polyglot persistence architectures that combine multiple database technologies for optimal results, emphasizing that the choice depends on specific system requirements rather than one being universally better.

  5. 5
    Video
    Avatar of devopstoolboxDevOps Toolbox·45w

    SQLite Is ULTIMATE Choice For 99% of Projects

    SQLite is a powerful, lightweight database that's widely deployed across mobile devices and applications. Despite being perceived as a beginner tool, it offers ACID compliance, can scale to 100TB, requires no separate server process, and supports advanced features like Write-Ahead Logging (WAL) for improved concurrent performance. The article explores SQLite's core features, demonstrates its durability and transaction handling, and introduces LibSQL, a distributed fork designed for modern cloud applications that addresses traditional SQLite's concurrency limitations.

  6. 6
    Article
    Avatar of tinybirdTinybird·44w

    Why LLMs struggle with analytics

    LLMs face significant challenges when working with analytical data, struggling with tabular data interpretation, SQL generation accuracy, and complex database schemas. The key to successful agentic analytics lies in providing comprehensive context through detailed documentation, semantic models, and sample data rather than expecting perfect SQL generation. Building query validation loops with error feedback, using LLM-as-a-judge evaluators, and focusing on business understanding over technical perfection enables more reliable analytical insights.

  7. 7
    Article
    Avatar of antonzAnton Zhiyanov·45w

    Redka: Redis re-implemented with SQL

    Redka is a Redis-compatible server and Go module that reimplements Redis functionality using SQL databases (SQLite or PostgreSQL) as the backend. It supports five core Redis data types (strings, lists, sets, sorted sets, hashes) and offers both standalone server and embedded library usage. While not matching Redis performance, Redka handles tens of thousands of operations per second and provides benefits like SQL introspection, embedded caching for Go apps, and simplified testing environments.

  8. 8
    Article
    Avatar of infoworldInfoWorld·45w

    Database design tips for developers

    A comprehensive guide covering essential database design practices to prevent schema degradation over time. Key recommendations include using simple 'ID' primary keys for all tables, avoiding spaces in naming conventions, using plural table names, implementing clear foreign key labeling patterns, indexing all queried fields, enforcing referential integrity, and separating SQL from application code. Additional best practices cover proper data types, timestamp fields, stored procedures, and avoiding common pitfalls like boolean null states and string-based state management.

  9. 9
    Article
    Avatar of duckdbDuckDB·46w

    DuckLake 0.2

    DuckLake 0.2 introduces significant improvements including secrets management for credentials, enhanced Parquet file settings, relative schema/table paths for better organization, name mapping for existing Parquet files, scoped settings at schema and table levels, and partition transforms. The update includes automatic migration from v0.1 and adds new functions like ducklake_list_files for better system integration.

  10. 10
    Article
    Avatar of detlifeData Engineer Things·46w

    The Ultimate Roadmap to Become a Data Engineer in 2025 (With Free Resources)

    A comprehensive guide for becoming a data engineer in 2025, covering essential skills like SQL, Python, and data modeling, along with big data technologies like Apache Spark and cloud platforms. The roadmap emphasizes free learning resources and practical experience, highlighting that mastering core principles enables quick adaptation to new tools in the rapidly evolving data engineering landscape.

  11. 11
    Article
    Avatar of motherduckMotherDuck·44w

    Summer Data Engineering Roadmap

    A comprehensive 3-week structured learning roadmap for aspiring data engineers covering foundational skills (SQL, Git, Linux), core engineering concepts (Python, cloud platforms, data modeling), and advanced topics (streaming, data quality, DevOps). The guide provides curated resources and a progressive learning path from beginner to intermediate level, emphasizing practical skills needed for full-stack data engineering roles.

  12. 12
    Video
    Avatar of webdevcodyWeb Dev Cody·44w

    How to find performance issues in SQL query

    A practical guide to identifying and fixing SQL query performance issues using the EXPLAIN command and database indexing. The tutorial demonstrates how to analyze a complex query with multiple joins and subqueries, use AI tools to interpret query execution plans, and implement indexes to dramatically reduce query costs from 10,000 to 29. Key techniques include enabling ORM logging to capture raw SQL, using database tools to run EXPLAIN statements, and strategically adding indexes on foreign keys and frequently queried columns.

  13. 13
    Article
    Avatar of thoughbotthoughbot·45w

    The hard truth about soft deletion

    Soft deletion marks records as deleted without removing them from the database, preserving data for recovery and compliance. However, it introduces significant complexity including the need to consistently exclude deleted records from queries, handle dependent record deletion properly, update indexes and constraints, and manage potential conflicts during restoration. The author suggests evaluating alternatives like better backups, improved UI design, or accepting the tradeoffs based on specific business needs rather than implementing soft deletion by default.

  14. 14
    Article
    Avatar of postgresPostgreSQL·45w

    PostgreSQL 18 Beta 2 Released!

    PostgreSQL 18 Beta 2 is now available for download, containing previews of all features planned for the final release. The PostgreSQL Global Development Group encourages community testing to identify bugs and issues before the stable release expected around September/October 2025. Key fixes in Beta 2 include improvements to pg_get_process_memory_contexts() function, pg_dump handling for complex table names, and changes to default statistics behavior. Users can upgrade using standard major version upgrade strategies like pg_upgrade or pg_dump/pg_restore, though production use is not recommended for beta versions.

  15. 15
    Article
    Avatar of faunFaun·45w

    How to Implement Robust WAF Protection for Web Applications: Block SQL Injection, XSS, and DDoS Attacks

    A comprehensive guide to implementing AWS WAF protection for web applications, covering deployment of a vulnerable test application (DVWA) on EC2, CloudFront distribution setup, and WAF configuration with managed rules for SQL injection and XSS protection. Includes custom rate limiting rules, S3 logging setup, and practical testing methods to verify protection against common web attacks.

See all SQL archives