Best of Database — February 2024

1. 1
   Article

   gitconnected·2y

   🐼 Mastering SQL Joins

   This post explores the concept of table joins in SQL, covering different join types such as inner join, left join, and right join. It also discusses how to identify and handle orphan records in a database.

   448

   5
2. 2
   Article

   Community Picks·2y

   Improve your SQL skills X2 in 5 minutes

   Learn how to advance your SQL skills by working with CTEs and window functions. Discover the importance of SQL for managers and how it can help answer business questions and assist with technical designs. Explore the different types of window functions available in SQL.

   419

   9
3. 3
   Article

   Community Picks·2y

   How to Optimize Slow SQL Queries

   Learn how to identify and optimize slow SQL queries, including methods such as using parameterized queries, configuring the database for optimal performance, and properly indexing columns. Continuous feedback tools and monitoring can help in finding and optimizing these queries.

   202

   5
4. 4
   Article

   Towards Dev·2y

   3 Essential SQL Tricks You Absolutely Need to Know

   Learn three essential SQL tricks that can improve efficiency and analytical capabilities. Topics include using Common Table Expressions (CTEs), creating Partial Indexes for faster searches, and implementing Conditional Aggregation in SQL queries.

   172

   9
5. 5
   Article

   FREEK.DEV·2y

   Is it time to ditch MySQL and PostgreSQL for SQLite?

   Evaluate the potential of SQLite as a replacement for MySQL and PostgreSQL in production web applications.

   44

   5
6. 6
   Article

   freeCodeCamp·2y

   How to Build a Mobile Quiz App with React Native, ChatGPT and Supabase

   Learn how to build a mobile quiz app with React Native, ChatGPT, and Supabase. The tutorial covers authentication, database storage, and ranking users based on their scores. Requires basic knowledge of React Native and data fetching in React applications.

   40

   1
7. 7
   Article

   InfoWorld·2y

   Why developers should put the database first

   Developers are being advised to prioritize the database in their application development journey. Data is considered the most important element of computing and should be the first choice in the technology stack. Various options, such as SQLite, NoSQL databases, and Neurelo, can help developers put the database first.

   39
8. 8
   Article

   Vlad Mihalcea·2y

   PostgreSQL Performance Tuning Settings

   Explore various PostgreSQL performance tuning settings and why Aiven uses different values compared to the default ones.

   34
9. 9
   Article

   Substack·2y

   What are Semi, Anti, and Natural Joins in SQL?

   This post introduces three types of joins in SQL: semi join, anti join, and natural join. It explains the differences between these joins and their use cases. The post also provides examples and visual summaries of each join.

   32
10. 10
    Article

    ITNEXT·2y

    Why UUID7 is better than UUID4 as clustered index in RDBMS

    This post discusses the differences between UUID version 4 and UUID version 7 as clustered indexes in RDBMS. It explores the pros and cons of using UUIDs instead of sequential IDs and explains why UUID v7 was faster than UUID v4.

    31

    1
11. 11
    Article

    Python in Plain English·2y

    Setting up PostgreSQL and PgAdmin4 using Docker: A Simplified Approach.

    This post provides a simplified approach to setting up PostgreSQL and PgAdmin4 using Docker. It explains the benefits of containerization and guides readers through the process of installing Docker, running the Hello World container, and setting up PostgreSQL and PgAdmin4 containers. The post emphasizes the ease and efficiency of managing databases with containerization.

    25

    2
12. 12
    Article

    Web Tools Weekly·2y

    HTML/CSS Tools, JSON/DB, Testing Tools

    The post discusses unique properties and methods for specific HTML elements, CSS and HTML tools, and JSON and database tools.

    24

    1
13. 13
    Article

    EverSQL·2y

    SQL Optimization: a comprehensive developer’s guide

    This post provides a comprehensive guide on optimizing SQL queries. It covers topics such as optimizing SELECT, INSERT, and DELETE SQL queries and provides tips on using indexes, improving joins, filtering, and more. The post also introduces EverSQL by Aiven, a tool that can provide performance insights and SQL optimization suggestions.

    23
14. 14
    Article

    SQL Shack·2y

    Finding Duplicates in SQL

    This post explains the different ways to find duplicate values in SQL using DISTINCT and COUNT, GROUP BY and COUNT, and ROW_NUMBER functions. It provides examples and guidance on how to use these functions to identify duplicates in single columns or across multiple columns. The post also highlights the importance of managing duplicates in data storage and processing.

    23
15. 15
    Article

    Laravel News·2y

    Easy management of your application settings with Setting Pro

    Setting Pro is a package for easy management of application settings in Laravel. It offers flexible storage options, caching, queue support, event triggers, a global helper function and facade, and more. Visit the GitHub repo for installation instructions and more information.

    18
16. 16
    Article

    Community Picks·2y

    How we use migrations during early product development

    The post discusses how migrations are used during early product development, where all migrations are kept in a single file called 'initial_migration'. Edits are made to this file instead of creating new migration files to accommodate frequent schema changes. The 'migrate:fresh' command is used to rebuild the migrations. Once the app goes live, new migration files are created for schema changes.

    16

    1
17. 17
    Article

    Pointer·2y

    How Uber Serves Over 40 Million Reads Per Second from Online Storage Using an Integrated Cache

    Uber has built an integrated caching solution called CacheFront for their in-house distributed database called Docstore. CacheFront helps Uber serve over 40 million reads per second from online storage, overcoming challenges such as low-latency read access, high scalability, and cost efficiency.

    14

    1
18. 18
    Article

    Medium·2y

    How to Find the Best Stocks in the Stock Market Using AI

    Learn how to use AI to find the best stocks in the stock market using the NexusTrade Platform. Discover the features of intelligent stock screening and the implementation process. Also, explore the MongoDB Aggregation Framework for executing complex queries.

    12
19. 19
    Article

    Hacker News·2y

    Form to database, instantly

    Build forms on top of your Postgres, MySQL or MSSQL database without using custom React forms or messy ETL from spreadsheets.

    11
20. 20
    Article

    ITNEXT·2y

    MongoDB Compass — Convert Text into Queries with AI-Powered Natural Language

    Learn how MongoDB Compass revolutionizes query generation using AI-powered natural language. Explore use cases, import datasets using MongoDB tools, and create queries based on country information in MongoDB Compass.

    11

    1
21. 21
    Article

    Hacker News·2y

    readysettech/readyset: Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hoo

    ReadySet is a transparent database cache for Postgres & MySQL that improves performance and scalability without requiring app rewriting or manual cache invalidation. It is wire-compatible with Postgres and MySQL and can be used with existing ORMs or database clients.

    11
22. 22
    Article

    DEV·2y

    🏁🐘Winning Race Conditions With PostgreSQL

    This post discusses race conditions in databases, particularly in PostgreSQL, and provides solutions for avoiding them. It covers cases of simple uniqueness, compound uniqueness, compound multiple uniqueness, and compound referential uniqueness. The article also mentions the use of transactions, advisory locks, and the SERIALIZABLE transaction isolation level. Overall, it offers techniques to handle and prevent race conditions in database operations.

    11
23. 23
    Article

    Towards Dev·2y

    Day 18 : Learn Node.JS in 30 days (Beginners)

    This post provides a beginner's guide to using Node.js and SQL to perform fundamental queries on a database table. It covers topics such as inserting data, selecting data, updating data, and deleting data using SQL commands. The post also includes examples of various SQL queries and their syntax.

    11

    1
24. 24
    Article

    Medium·2y

    Working with data storages in Rust

    This post explains how to create an agnostic trait-based storage in Rust. It covers topics such as async, new-type idiom, dynamic dispatching, and sqlx.

    11
25. 25
    Article

    JOOQ·2y

    What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check

    Learn the recommended way to check for the existence of values in SQL and the difference between using LIMIT and COUNT(*) for checking the number of rows.

    10