Best of SQL — September 2023

  1. 1
    Article
    Avatar of tinybirdTinybird·3y

    Build a Real-time Dashboard: Step-by-Step Guide

    Build a real-time dashboard from scratch using Tinybird, Tremor, and Next.js.

  2. 2
    Article
    Avatar of pointerPointer·3y

    Upsert in SQL

    This article discusses the concept of upsert in SQL and explains how it works in different database management systems (DBMS) like MySQL, SQLite, and PostgreSQL. It provides examples and code snippets for each DBMS to demonstrate the various ways to perform upsert operations.

  3. 3
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    The SQL Handbook – A Free Course for Web Developers

    The SQL Handbook is a free and open text-based handbook for Web Developers. Try the interactive version of this SQL course on Boot.dev, complete with coding challenges and projects. Watch the video walkthrough of this course on FreeCodeCamp's YouTube channel.

  4. 4
    Article
    Avatar of communityCommunity Picks·3y

    Designing and Modeling the Database with Mongoose

    This comprehensive guide provides step-by-step instructions for crafting a scalable MongoDB database design and modeling it effectively using Mongoose ODM. The data layer often acts as the cornerstone that underpins an application's business logic and user experience. The right design depends on your needs and how you intend to interact with the data.

  5. 5
    Article
    Avatar of mattrickardMatt Rickard·3y

    TypeScript Type System Hacks

    TypeScript's type system is Turing Complete. You can model algebraic data types (unions, intersections, tuples, conditional types, mapped types, and more. In TS 4.1, template literal types were introduced, making it easy to do string manipulation within the type system.

  6. 6
    Article
    Avatar of communityCommunity Picks·3y

    getnokori/api: Nokori API

    Nokori API is a universal data layer that allows developers to connect SQL databases and third-party APIs easily. It provides functionality for user authentication and transactional email. Documentation and instructions for running locally are available.

  7. 7
    Article
    Avatar of flydotioFly.io·3y

    Skip the API, Ship Your Database

    Skip the API, Ship Your Database, and LiteFS Cloud: managed backups and point-in-time restores for LiteFS. LiteFS uses a program called Corrosion that gossips state between all our servers. It tracks VM statuses, health checks, and a plethora of other information for each server.

See all SQL archives