Best of SQL — June 2025

1. 1
   Article

   freeCodeCamp·49w

   How Attackers Steal Data from Websites (And How to Stop Them)

   Web attackers use various methods to steal data including phishing emails, SQL injection, cross-site scripting (XSS), brute force password attacks, malware, man-in-the-middle attacks, outdated software exploitation, and insecure API integrations. Defense strategies include user education, multi-factor authentication, input validation, HTTPS implementation, regular software updates, secure coding practices, and proper API security. The stolen data often ends up on the dark web where it's sold for identity theft and further attacks.

   188

   1
2. 2
   Video

   Laravel Daily·50w

   3 Tools to Draw/Manage Database Schema

   Three visual database design tools are showcased for Laravel developers: DrawDB for drag-and-drop visual schema creation, DBDiagram.io for code-based DBML syntax with version control benefits, and RunSQL for testing queries on mock data. The workflow demonstrates using AI to generate database schemas, visualizing relationships, and converting designs to Laravel migrations without writing initial code.

   76
3. 3
   Article

   Atomic Spin·49w

   Tips & Tricks for Better AI Prompts

   Effective AI prompt engineering requires structured formatting with clear sections like Instructions, Context, and Examples. Keep prompts concise rather than verbose, as AI models excel at inferring from limited examples. Using markdown-style sectioning and asking AI to help craft system prompts can significantly improve response accuracy and reliability.

   69
4. 4
   Article

   DuckDB·49w

   Faster Dashboards with Multi-Column Approximate Sorting

   Advanced multi-column sorting techniques using space filling curves (Morton and Hilbert encodings) and truncated timestamps can significantly improve query performance on columnar data formats. These methods enable approximate sorting across multiple columns simultaneously, allowing diverse dashboard queries to benefit from min-max indexes and row group pruning. Experiments on flight data show Hilbert encoding provides the most consistent performance across different query patterns, while sorting by truncated timestamps (year-level granularity) combined with Hilbert encoding works best for time-filtered queries.

   42
5. 5
   Article

   Awesome Go·48w

   Best Database Migration Tools for Golang

   A comprehensive guide comparing five database migration tools for Go applications: Goose (lightweight and SQL-focused), Migrate (CLI-first with broad database support), Gormigrate (GORM-integrated), SQLx (custom migration workflows), and Flyway (enterprise-grade). Each tool is explained with practical code examples, use cases, and a comparison table to help developers choose based on project size, team needs, and database requirements. The guide includes best practices for versioning, testing, and implementing transactional migrations.

   35
6. 6
   Article

   ByteByteGo·47w

   EP168: AI Vs Machine Learning Vs Deep Learning Vs Generative AI

   Explains the hierarchical relationship between AI, machine learning, deep learning, and generative AI, with AI as the overarching field and each subsequent term representing more specialized subsets. Covers SQL query execution through database subsystems including transport, query processor, execution engine, and storage engine. Lists 20 key AI agent concepts from basic agents to multi-agent systems and swarm intelligence. Describes RabbitMQ's message broker architecture using exchanges, queues, and bindings for routing messages between producers and consumers.

   34
7. 7
   Article

   Collections·49w

   Introducing the PostgreSQL Extension for VS Code

   Microsoft released a comprehensive PostgreSQL extension for Visual Studio Code that brings database management capabilities directly into the IDE. The extension features schema visualization, natural language database queries through GitHub Copilot integration, migration script generation, SQL IntelliSense, local Docker server creation, connection management, and query history tracking. This tool aims to replace traditional database management applications by providing a unified development environment for PostgreSQL workflows.

   32
8. 8
   Article

   Hacker News·46w

   sirius-db/sirius

   Sirius is a GPU-native SQL engine that integrates with existing databases like DuckDB through the Substrait query format. It delivers approximately 10x performance improvements over CPU-based query engines on TPC-H benchmarks while maintaining the same hardware costs. The system supports NVIDIA GPUs with compute capability 7.0+ and CUDA 11.2+, offering deployment options through AWS AMIs, Docker images, or manual installation. Sirius handles common SQL operations including filtering, joins, aggregations, and ordering, though it currently has limitations around data size constraints, row count limits, and partial NULL column support.

   24

   1
9. 9
   Article

   Community Picks·47w

   Database Schema Visualization & Security

   PandaView is a database tool that transforms SQL schemas into interactive ERD diagrams while providing security vulnerability detection and performance optimization recommendations. It offers one-click exports, identifies SQL injection risks and permission gaps, and uses AI to suggest indexing strategies for improved query performance.

   15
10. 10
    Article

    DuckDB·46w

    Discovering DuckDB Use Cases via GitHub

    DuckDB team demonstrates how to discover and analyze DuckDB usage across GitHub repositories by querying the GitHub API with DuckDB itself. The approach involves using DuckDB's HTTP capabilities to fetch repository data, processing JSON responses with SQL, and automating the workflow with GitHub Actions to generate daily reports in Markdown format. The solution includes pagination handling, data filtering, and visualization of historical trends through Git commit analysis.

    14

    1
11. 11
    Article

    DBconvert·47w

    MySQL ↔ PostgreSQL Schema Conversion: The Real-World Guide

    A comprehensive guide covering bidirectional schema conversion between MySQL and PostgreSQL databases. Details complete type mapping tables for both directions, handling of constraints, foreign keys, comments, and edge cases like zero dates and identifier length limits. Includes comparison with other migration tools and covers advanced features like deferred foreign key creation and universal constraint handling across different database environments.

    10
12. 12
    Article

    Tigris·49w

    Get your data ducks in a row with DuckLake

    DuckLake is a new data lakehouse solution that separates metadata storage from data storage, storing metadata in SQL databases (Postgres, MySQL, DuckDB, SQLite) while keeping data in object storage. This architecture enables concurrent writes, eliminates egress fees when using services like Tigris, and allows querying from anywhere. The solution combines relational and non-relational data seamlessly, supports time-travel queries through snapshots, and can scale from laptop development to production workloads without complex infrastructure setup.

    10