Best of SQL — November 2024

  1. 1
    Article
    Avatar of communityCommunity Picks·2y

    7+ Free PostgreSQL Hosting Platforms for Developers in 2024

    Several cloud providers offer free tiers for PostgreSQL hosting, ideal for developers working on small projects, personal experiments, or startup MVPs. Notable platforms include Neon, Supabase, EdgeDB, Xata, Tembo, Vercel Postgres, Koyeb, Aiven, and Nhost. These options provide scalable, fully managed databases with features like autoscaling, database branching, and integrated authentication, allowing developers to focus on development without worrying about infrastructure costs.

  2. 2
    Article
    Avatar of logrocketLogRocket·2y

    Drizzle vs. Prisma: Which ORM is best for your project?

    Drizzle and Prisma are two popular ORMs used for data access and migrations. Prisma offers a high level of abstraction, simplifying data interactions and auto-generating queries, making it suitable for developers prioritizing speed and productivity. However, this comes at the cost of less control over SQL queries. Drizzle provides a more SQL-first approach, giving developers granular control and precise query execution, but requires more manual handling and SQL knowledge. Both ORMs support TypeScript integration and have different approaches towards migrations and validation, with Prisma being more automated and Drizzle favoring manual control.

  3. 3
    Article
    Avatar of communityCommunity Picks·2y

    PostgreSQL Performance Optimization Techniques Quiz

    Test your skills and enhance your knowledge of PostgreSQL performance tuning through this quiz. It covers crucial topics like optimizing queries, selecting appropriate indexing strategies, configuring parameters, and improving efficiency for high-performance workloads. Suitable for both aspiring database specialists and experienced DBAs.

  4. 4
    Video
    Avatar of fireshipFireship·2y

    SQLite and its weird new fork “libSQL”

    SQLite, originally created for the US Navy, is a widely deployed, serverless SQL database. Its open-source nature has led to the fork named libSQL, which adds server mode and enhanced features like replication, encryption, and WebAssembly triggers. These improvements support unique databases per user, offering better performance and scalability, particularly in serverless environments.

  5. 5
    Article
    Avatar of systemdesigncodexSystem Design Codex·2y

    The Journey of a SQL Query Through a Database

    An SQL query undergoes several steps through a database before returning results. Starting with the Transport Subsystem for authentication, it moves to the Query Processor for parsing and optimization. The Execution Engine then executes the query plan by coordinating with the Storage Engine, which manages data consistency, locking, buffering, and recovery.

  6. 6
    Article
    Avatar of lobstersLobsters·2y

    What I Wish Someone Told Me About Postgres

    Learn about essential tips and practices for working with Postgres that aren't always clear from the documentation. Covers topics like data normalization, useful psql shortcuts, handling NULLs, the importance of indexing, and managing locks. Also addresses the use of JSONB for flexible data storage and the potential pitfalls of long-running transactions.

  7. 7
    Article
    Avatar of frankelA Java geek·2y

    DuckDB in Action

    DuckDB in Action by Mark Needham, Michael Hunger, and Michael Simons offers a detailed guide to DuckDB with a step-by-step approach. The book covers DuckDB basics, advanced SQL queries, and its integration with ecosystems like Python’s Pandas and Apache Spark. Despite being informative, the book struggles with focus, fluctuating between teaching DuckDB and general SQL learning.

  8. 8
    Video
    Avatar of youtubeYouTube·2y

    I Tried 50 Data Analyst Courses. Here Are Top 5

    Many online courses in data analytics are lengthy and filled with fluff, but some are genuinely worthwhile. Key recommended courses include the Google Analytics Certificate for web and marketing analytics, Microsoft Power BI Certification (PL-300) for data visualization and SQL (DP-300) for database skills, DataCamp's hands-on training tracks offering discounts on certification exams, Tableau Certified Data Analyst credential, and Harvard's comprehensive Data Science Professional Certificate. These courses offer industry-recognized credentials that validate skills employers seek in data analysts.

  9. 9
    Article
    Avatar of motherduckMotherDuck·2y

    The Data Warehouse powered by DuckDB SQL

    MotherDuck combines the power of DuckDB SQL with cloud services to offer a flexible and powerful data warehousing solution. It includes robust capabilities for data ingestion, transformation, and analysis, leveraging SQL and additional native Python APIs for complex tasks. Its built-in AI features enhance usability for business users, data scientists, and developers. MotherDuck supports a wide range of file formats and storage solutions, and offers advanced analytical functions, including Machine Learning algorithms, to solve complex business problems efficiently.

  10. 10
    Article
    Avatar of tdsTowards Data Science·2y

    The Four Pillars of a Data Career

    Breaking into a data career typically requires proficiency in four pillars: spreadsheets (Excel), SQL, visualization tools (Tableau or Power BI), and scripting languages (Python or R). The post suggests focusing on Excel for entry-level roles, with additional recommendations for learning SQL basics, creating standard charts in visualization tools, and understanding programming essentials in scripting languages.

  11. 11
    Article
    Avatar of csharpcornerC# Corner·1y

    Data Cleansing in SQL Server

    Data cleansing is essential for accurate analysis and decision-making. This guide covers techniques like removing duplicates, handling missing values, correcting inconsistencies, standardizing data formats, removing outliers, and validating data using SQL Server. Examples from the AdventureWorks2022 database illustrate these methods, ensuring data reliability and consistency.

  12. 12
    Article
    Avatar of crunchydataCrunchy Data·2y

    8 Steps in Writing Analytical SQL Queries

    Writing complex SQL queries involves starting with simple queries and progressively adding complexity while verifying accuracy at each step. Key steps include defining desired data, investigating and sampling data, confirming simplicity, adding joins cautiously, performing summations, and rigorously debugging. SQL's power lies in its ability to utilize simple, standardized logic blocks to extract accurate data from complex structures.

  13. 13
    Article
    Avatar of hnHacker News·2y

    Why I love Rust for tokenising and parsing

    The post discusses the author's development of a SQL analysis tool using Rust, emphasizing its benefits, including syntax checks, embedded runtime, and high-quality error messages. It highlights Rust's macros for reducing code duplication, table-driven tests similar to Go, and showcases efficient error handling and character matching using Rust’s features. The author plans to create an LSP server for SQL after completing the static analysis part of the project.

  14. 14
    Article
    Avatar of duckdbDuckDB·1y

    DuckDB Tricks – Part 3

    This blog post delves into various advanced features and performance optimization techniques for DuckDB, particularly focusing on convenient methods for handling table operations and improving the processing speed of Parquet and CSV files. It includes practical examples using the Dutch railway services dataset, demonstrating column renaming with pattern matching, data loading with globbing, reordering Parquet files, and employing Hive partitioning to speed up queries significantly.

  15. 15
    Article
    Avatar of rubylaRUBYLAND·2y

    Poking around PostgreSQL full-text search: a beginners primer

    Exploring the basics of PostgreSQL's full-text search, this primer delves into turning documents into tokens and then into normalized lexemes for advanced querying. It covers query processing, various query parsing methods, and concludes with ranking results based on lexeme frequency and density. Ideal for beginners, it demonstrates how PostgreSQL’s full-text search addresses challenges of basic search operators.

  16. 16
    Video
    Avatar of teej_dvTJ DeVries·2y

    Octane: A Query Builder for OCaml

    Octane is an OCaml library designed for constructing type-safe SQL queries, offering a more confident interaction with databases. Unlike traditional ORMs or Active Record patterns, Octane focuses on maintaining the typic safety inherent in OCaml, ensuring that operations like creating tables, inserting records, and writing queries are reliable and less error-prone. The library turns SQL strings into type-safe OCaml functions, enhancing developer confidence and reducing runtime errors.

See all SQL archives