Best of SQLApril 2023

  1. 1
    Article
    Avatar of bytebytegoByteByteGo·3y

    Understanding Database Types

    A complex application usually uses several different databases, each catering to a specific aspect of the application’s needs. In this comprehensive three-part series, we’ll explore the art of database selection. To make the best decision for our projects, it is essential to understand the various types of databases available in the market.

  2. 2
    Article
    Avatar of amplicationAmplication·3y

    SQL Versus NoSQL Databases: Which to Use, When, and Why

    The right choice means we can scale up an application quickly and handle increasing user requests without encountering problems. Choosing the right database for your application is no mean feat, given the number of available databases. There are many differences between SQL and NoSQL databases, such as how they handle relational data, their query languages.

  3. 3
    Article
    Avatar of kdnuggetsKDnuggets·3y

    Using ChatGPT to Learn SQL

    ChatGPT is a large language model trained by OpenAI. It is capable of generating human-like text based on the input it receives. It can be used to answer questions and engage in conversations with people. In this article, I will outline how you can useChatGPT to learn SQL and become proficient in this valuable skill.

  4. 4
    Article
    Avatar of bytebytegoByteByteGo·3y

    EP53: Design effective and safe APIs

    In this video, we're diving into the world of computer memory and storage. We'll talk about the fundamental duo: RAM and ROM - DDR4 and DDR5 - Firmware and BIOS. Join the ByteByteGo Talent Collective to start getting bi-monthly drops of world-class hand-curated engineers.

  5. 5
    Article
    Avatar of supabaseSupabase·3y

    dbdev: PostgreSQL Package Manager

    dbdev is a PostgreSQL package manager that enables publishing libraries and applications for repeatable deployment. It provides a package registry and tooling for third-parties to publish packages. It also supports versioning, namespaces, and offers a more modern development experience. It can be used on any PostgreSQL instance and can be coupled with the Supabase platform for additional possibilities.

  6. 6
    Article
    Avatar of supabaseSupabase·3y

    Supabase Studio 2.0: help when you need it most

    Supabase Studio 2.0 is announced with a ton of new features and enhancements, including Supabase AI for assisted database development, GraphiQL integration, cascade deletes, query performance tool, foreign key selector, improved Postgres roles management, database webhooks support, view table definitions, auto-generated API autodocs, support for many tables, improved JSON editing, and nullable columns.

  7. 7
    Article
    Avatar of hnHacker News·3y

    The “Build Your Own Database” book is finished

    The “Build Your Own Database’s’ book is finished 2023-04-20 01.org. The whole book is available as paperback or ebook.