Best of SQLite2023

  1. 1
    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.

  2. 2
    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.

  3. 3
    Article
    Avatar of twirThis Week In React·3y

    This Week In React #156: Server Actions, Stale Closures, React Falls Behind, Expo Builds, Suspense Throttling, React-Aria, Natuerlich, Obsidiosaurus, Expo-SQLite, Expo DevTools...

    This Week In React #156: Server Actions, Stale Closures, React Falls Behind, Expo Builds, Suspense Throttling, React-Aria, Natuerlich, Obsidiosaurus, Expo-SQLite, Expo DevTools. This week, we've got many articles from the React and React-Native community.

  4. 4
    Article
    Avatar of flutterdevsFlutterDevs·3y

    CRUD Operation With SQLite In Flutter

    Learn how to perform CRUD operations with SQLite in Flutter using the provider package. The article provides an introduction to Flutter and explains how to add the necessary dependencies, create models and database helpers, and implement CRUD operations in Flutter apps. It also includes code examples and showcases the final output.

  5. 5
    Article
    Avatar of itnextITNEXT·3y

    Deep dive into Database. Architecture, storage and data…

    A database is an organized collection of structured information, or data, typically stored electronically in a computer system. DBMS is the interface between the database and its end users or programs. It allows to retrieve, update and manage the organization and optimization of information. It also facilitates the monitoring and control of databases.

  6. 6
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    How to Perform CRUD Operations – JavaScript and SQL Example

    In this article, I'll show you how to connect a back end database to your data collection process. The plan involves tossing some HTML, JavaScript, and the tiny database engine SQLite into a bowl, mixing vigorously, and seeing what comes out. This article comes from my Complete LPI Web Development Essentials Study Guide course.

  7. 7
    Article
    Avatar of glcGolang News·3y

    A Golang based open-source, self-hosted feature flag application

    Flipt is an open-source, self-hosted feature flag application that allows you to run experiments across services in your environment. It can be deployed within your existing infrastructure so that you don’t have to worry about your information being sent to a third party or the latency required to communicate across the internet.

  8. 8
    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.

  9. 9
    Article
    Avatar of jvnsJulia Evans·3y

    A list of programming playgrounds

    A list of programming playgrounds I really like using (and making!) Programming playgrounds. I got thinking about how I didn't have a great list of playgrounds to refer to. So I asked Mastodon for links to cool playgrounds. Here's what I came up with.

  10. 10
    Article
    Avatar of phoenix-filesPhoenix Files·3y

    Minimum Viable ChatGPT Plugin

    ChatGPT plugin is essentially a manifest file and an OpenAPI spec, to tell ChatGPT how to consume an API. The only prerequisite is a searchable database; this can be anything that accepts text queries and returns data you want, from SQLite full text search to a third party API like Algolia.

  11. 11
    Article
    Avatar of hnHacker News·3y

    Tracking SQLite Database Changes in Git

    Learn how to track changes to a SQLite database using Git and view nicely formatted diffs.