Best of SQL — October 2024

  1. 1
    Video
    Avatar of dreamsofcodeDreams of Code·2y

    SQLc is the perfect tool for those who don't like ORMs

    SQLc is an efficient tool for developers who prefer writing raw SQL queries over using ORMs. It allows for type-safe SQL query generation, fitting neatly within the repository design pattern. SQLc supports multiple programming languages (TypeScript, Kotlin, Python, and Go) and SQL engines (Postgres, MySQL, SQLite). It eliminates boilerplate code, making database interactions more manageable and reusable across codebases. By using SQLc, developers can maintain full control over queries while ensuring type safety and reducing development time.

  2. 2
    Article
    Avatar of communityCommunity Picks·2y

    Step by step, from zero to advanced.

    Regular Expressions (Regex) are strings of characters that follow specific syntax rules used for finding, matching, and editing data. They are applicable in various programming languages like Python, SQL, JavaScript, and tools like Google Analytics. Online resources such as RegexLearn offer tutorials and examples for learning Regex. After completing the learning modules, users can test and practice their knowledge with different levels of Regex tutorials.

  3. 3
    Article
    Avatar of awegoAwesome Go·2y

    Writing raw SQL easier with pgx and sqlc in Go

    Combine pgx, a PostgreSQL driver and toolkit for Golang, with sqlc, a tool that generates type-safe Go code from SQL queries, to streamline database interactions. While ORMs can be limiting for complex queries, pgx and sqlc offer more control and type safety. Using sqlc for CRUD operations and simple queries, and pgx for more complex queries, provides a balanced approach. The post outlines how to set up and use these tools in a Go project.

  4. 4
    Video
    Avatar of youtubeYouTube·2y

    Learn SQL Beginner to Advanced in Under 4 Hours

    This post provides a comprehensive SQL tutorial, covering everything from setting up the MySQL environment to fundamental and advanced SQL topics. It includes exercises on data selection, querying, data cleaning, and exploratory data analysis, with two practical projects at the end. The tutorial is designed for beginners and progresses to advanced topics such as CTEs and temp tables.

  5. 5
    Article
    Avatar of hnasrHussein Nasser·2y

    The Internals of a Primary Index

    A primary key uniquely identifies a row and is typically indexed for fast access. Primary indexes are often clustered, meaning they store full rows. Secondary indexes only store row identifiers, requiring an additional lookup of the primary key to retrieve full rows. Postgres is an exception as it does not use a real primary clustered index; all indexes, including primary, point to the row identifier or tuple id. The tuple id in Postgres is unique and allows direct row access with minimal I/O.

  6. 6
    Article
    Avatar of communityCommunity Picks·2y

    sqlmap: automatic SQL injection and database takeover tool

    sqlmap is an open source tool that automates detecting and exploiting SQL injection vulnerabilities to take over database servers. It supports a variety of database management systems and SQL injection techniques, allows direct database connections, and enables enumeration of database objects, password cracking, file upload/download, and executing commands on the database server's OS. Contributions and bug reports are encouraged, and donations are welcomed to support continued development.

  7. 7
    Article
    Avatar of dockerDocker·2y

    Using an AI Assistant to Script Tools

    The post from Docker Labs GenAI series explores using AI developer tools to enhance the software lifecycle, specifically through integration with Docker. It showcases how to use large language models (LLMs) to transform data and generate SQL queries from JSON outputs, and then suggests transitioning to writing full programs for automation. A JavaScript example is provided, which is executed in a Docker container. The post emphasizes the potential for AI tools to automate repetitive tasks and the practicality of creating isolated sandbox environments to run generated code.

  8. 8
    Article
    Avatar of motherduckMotherDuck·2y

    Introducing the prompt() Function: Use the Power of LLMs with SQL!

    The new prompt() function allows the integration of small language models (SLMs) like OpenAI's gpt-4o-mini into SQL, enabling text summarization and structured data extraction directly within SQL queries. This function is currently in Preview on MotherDuck and supports various use cases such as bulk text summarization and unstructured to structured data conversion. Users can start exploring the function via the Free Trial or Standard Plan, with certain usage quotas in place.

  9. 9
    Article
    Avatar of databricksdatabricks·2y

    Introducing the New SQL Editor

    Databricks announces the public preview of its new SQL editor, designed to enhance productivity with features like multiple statement results, real-time collaboration, improved assistant integrations, and enhanced editor ergonomics. New functionalities such as Quick Fix, AI-generated filters, and Git support for queries are also introduced, aiming to streamline SQL development and collaboration.

  10. 10
    Video
    Avatar of youtubeYouTube·2y

    How I would learn Data Analysis (If i could start over) | Data Analyst Roadmap 2024

    Data analysts play a crucial role in helping organizations make data-driven decisions. Key steps include data collection, data cleaning and pre-processing, exploratory data analysis, and data visualization. Essential skills for the role include knowledge of statistics, Excel, SQL, and Python, along with strong communication skills. To stand out as a fresher, focus on unique projects, leverage data sets of personal interest, and publish dashboards online.

  11. 11
    Article
    Avatar of tokioTokio·2y

    Announcing Toasty, an async ORM for Rust

    Toasty is an asynchronous ORM for Rust, prioritizing ease of use for SQL and NoSQL databases like DynamoDB and Cassandra. It generates Rust code from a schema file, allowing efficient data model management. Toasty aims to balance productivity with performance by minimizing the complexity of traits and lifetimes in its generated code. While still in the early stages and not yet suitable for real-world use, Toasty hopes to bridge the gap in Rust's ecosystem for higher-level web applications.

  12. 12
    Article
    Avatar of dailydoseofdsDaily Dose of Data Science | Avi Chawla | Substack·2y

    Semi, Anti, and Natural Joins in DuckDB SQL

    The post introduces three additional types of SQL joins available in DuckDB: Semi Join, Anti Join, and Natural Join. It highlights the distinctions and use cases for each, such as Semi Join for checking record existence, Anti Join for finding non-matches, and Natural Join for a concise query without explicit join conditions. These joins offer more flexibility and elegance in SQL query writing.

See all SQL archives