Best of SQL — April 2024

1. 1
   Article

   DEV·2y

   When to use SQL vs NoSQL

   Choosing between SQL and NoSQL databases can be daunting. SQL excels in data consistency and complex querying, while NoSQL offers scalability and flexibility. Common misconceptions include inflexibility of SQL databases and the lack of transactional support in NoSQL.

   167

   2
2. 2
   Article

   Community Picks·2y

   Database Tips & Tricks

   Improve your understanding of SQL and discover useful features of databases to save development time and optimize performance.

   65

   1
3. 3
   Article

   TigerData (Creators of TimescaleDB)·2y

   10 psql Commands That Will Make Your Life Easier

   Learn 10 psql meta-commands that can make SQL queries on PostgreSQL easier. Explore commands like describing relations, editing the query buffer, toggling expanded output, and more.

   27

   1
4. 4
   Article

   Community Picks·2y

   Using Database Migrations with Golang

   This post discusses using database migrations in services written in Golang. It explains what database migrations are and how they can be written in SQL. It also introduces the go-migrate library for managing SQL migrations in Go.

   21
5. 5
   Article

   freeCodeCamp·2y

   Learn SQL for Analytics

   Learn SQL for Analytics is an 11-hour course on the freeCodeCamp.org YouTube channel. It covers the fundamentals of SQL, includes practical exercises, and is suitable for beginners.

   16
6. 6
   Article

   KDnuggets·2y

   Ultimate Collection of 50 Free Courses for Mastering Data Science

   A comprehensive collection of 50 free courses for mastering data science, covering topics such as Python, SQL, Data Analytics, Business Intelligence, Data Engineering, Machine Learning, Deep Learning, Generative AI, and MLOps.

   16
7. 7
   Article

   SQL Shack·2y

   SQL Performance Tuning tips for newbies

   This post provides basic advice for SQL performance tuning, including enabling and viewing time statistics, interpreting query execution plans, staying updated on new features, and using tools like sp_whoisactive, Extended Events, and Query Store.

   15
8. 8
   Article

   Javarevisited·2y

   Combining Data from Multiple Tables in SQL Without Using JOIN or UNION

   Techniques for combining data from multiple tables in SQL without using JOIN or UNION, including leveraging aggregated subqueries, utilizing EXISTS or NOT EXISTS, selective data insertion, and using temporary tables or CTEs.

   14
9. 9
   Article

   Hacker News·2y

   nalgeon/sqlime: Online SQLite playground

   Sqlime is an online SQLite playground for debugging and sharing SQL snippets. It supports the latest version of SQLite and includes essential extensions. You can connect any local or remote SQLite database, save queries and databases to GitHub, and even get help from the ChatGPT assistant.

   14
10. 10
    Article

    This Dot·2y

    Intro to EdgeDB

    EdgeDB is a graph-relational database that provides a novel approach to handling common pain points in data modeling. It offers a powerful schema system, support for defining relations/associations, computed properties, and access policies. EdgeQL is the query language used to interact with the database. EdgeDB nudges users to move more application logic into the database layer, providing constraints, global variables, contexts, and authorization support out-of-the-box. EdgeDB offers both a basic client for executing queries and a TypeScript query builder for type-safe queries. The CLI and Admin UI provide additional tools for managing EdgeDB projects and databases.

    13
11. 11
    Article

    Code Maze·2y

    How to Show the Generated SQL Query in EF Core

    Learn how to show the generated SQL query in EF Core using the ToQueryString() method and logging capabilities.

    13
12. 12
    Article

    Substack·2y

    The 2024 breaking into data engineering roadmap

    Learn about the necessary skills and steps to break into data engineering in 2024. Topics covered include learning SQL, Python or Scala, distributed compute, data modeling, building a portfolio project, and building a brand for interviews.

    12
13. 13
    Article

    Substack·2y

    SQL vs Python Data Pipelines

    The post discusses the decision of when to use Python and when to use SQL in data pipelines. It emphasizes the importance of striking a balance between the two and making good technical decisions. It also highlights the pitfalls to be careful about in both SQL and Python pipelines.

    11
14. 14
    Article

    Towards AI·2y

    Advanced SQL for Data Analysis —Part 1: Subqueries and CTE

    Learn about subqueries and CTEs in SQL for advanced data analysis.

    10
15. 15
    Article

    GoPenAI·2y

    Vector Database Part 3

    This post discusses the different types of vector databases available, including SQL databases with vector support, NoSQL databases with vector support, dedicated vector databases, and in-memory key-value databases like Redis. It also covers hybrid search, which combines sparse (keyword/lexical) search and dense (vector) search.

    10
16. 16
    Article

    Wawandco·2y

    Blog: Upping the Ante: Performing Batch Inserts with GORM

    This post explores the use of GORM, an ORM for Go, for performing batch inserts. It compares the GORM approach to the go/sql approach and highlights the advantages of using GORM.

    10