--- title: Best SQLite posts of 2023 | daily.dev description: The most upvoted SQLite posts of 2023, curated by the daily.dev community. canonical: https://daily.dev/tags/sqlite/best-of/2023 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/sqlite/best-of/2023 og:type: website og:site_name: daily.dev og:title: Best SQLite posts of 2023 | daily.dev og:description: The most upvoted SQLite posts of 2023, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of SQLite — 2023 1. 1 [](/posts/upsert-in-sql-pwuw73xan "Upsert in SQL") Article Pointer · 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. 70 2. 2 [](/posts/the-sql-handbook-a-free-course-for-web-developers-mtr8xhzl3 "The SQL Handbook – A Free Course for Web Developers") Article freeCodeCamp · 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. 44 1 3. 3 [](/posts/this-week-in-react-156-server-actions-stale-closures-react-falls-behind-expo-builds-suspense-t-vgylwb8xs "This Week In React #156: Server Actions, Stale Closures, React Falls Behind, Expo Builds, Suspense Throttling, React-Aria, Natuerlich, Obsidiosaurus, Expo-SQLite, Expo DevTools...") Article This 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. 26 1 4. 4 [](/posts/crud-operation-with-sqlite-in-flutter-m0av76yz2 "CRUD Operation With SQLite In Flutter") Article FlutterDevs · 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. 19 1 5. 5 [](/posts/deep-dive-into-database-architecture-storage-and-data--rkwptz6r8 "Deep dive into Database. Architecture, storage and data…") Article ITNEXT · 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. 19 1 6. 6 [](/posts/how-to-perform-crud-operations-javascript-and-sql-example-rshhwkgb8 "How to Perform CRUD Operations – JavaScript and SQL Example") Article freeCodeCamp · 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. 16 7. 7 [](/posts/a-golang-based-open-source-self-hosted-feature-flag-application-u6d040jpb "A Golang based open-source, self-hosted feature flag application") Article Golang News · 4y 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. 15 8. 8 [](/posts/skip-the-api-ship-your-database-bggcfhvjv "Skip the API, Ship Your Database") Article Fly.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. 13 1 9. 9 [](/posts/a-list-of-programming-playgrounds-yg5kd13h4 "A list of programming playgrounds") Article Julia 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. 12 2 10. 10 [](/posts/minimum-viable-chatgpt-plugin-zafe6xkfj "Minimum Viable ChatGPT Plugin") Article Phoenix 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. 11 [](/posts/tracking-sqlite-database-changes-in-git-lgxzfjl3z "Tracking SQLite Database Changes in Git") Article Hacker News · 3y Tracking SQLite Database Changes in Git Learn how to track changes to a SQLite database using Git and view nicely formatted diffs. 10 [See all SQLite archives](/tags/sqlite/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/sqlite/best-of/2023#page","url":"https://daily.dev/tags/sqlite/best-of/2023","name":"Best SQLite Posts of 2023","description":"The most upvoted SQLite posts of 2023, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/sqlite/best-of/2023#items","numberOfItems":11,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/upsert-in-sql-pwuw73xan","name":"Upsert in SQL"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/the-sql-handbook-a-free-course-for-web-developers-mtr8xhzl3","name":"The SQL Handbook – A Free Course for Web Developers"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/this-week-in-react-156-server-actions-stale-closures-react-falls-behind-expo-builds-suspense-t-vgylwb8xs","name":"This Week In React #156: Server Actions, Stale Closures, React Falls Behind, Expo Builds, Suspense Throttling, React-Aria, Natuerlich, Obsidiosaurus, Expo-SQLite, Expo DevTools..."},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/crud-operation-with-sqlite-in-flutter-m0av76yz2","name":"CRUD Operation With SQLite In Flutter"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/deep-dive-into-database-architecture-storage-and-data--rkwptz6r8","name":"Deep dive into Database. Architecture, storage and data…"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/how-to-perform-crud-operations-javascript-and-sql-example-rshhwkgb8","name":"How to Perform CRUD Operations – JavaScript and SQL Example"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/a-golang-based-open-source-self-hosted-feature-flag-application-u6d040jpb","name":"A Golang based open-source, self-hosted feature flag application"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/skip-the-api-ship-your-database-bggcfhvjv","name":"Skip the API, Ship Your Database"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/a-list-of-programming-playgrounds-yg5kd13h4","name":"A list of programming playgrounds"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/minimum-viable-chatgpt-plugin-zafe6xkfj","name":"Minimum Viable ChatGPT Plugin"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/tracking-sqlite-database-changes-in-git-lgxzfjl3z","name":"Tracking SQLite Database Changes in Git"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"SQLite","item":"https://daily.dev/tags/sqlite"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/sqlite/best-of"},{"@type":"ListItem","position":5,"name":"2023"}]}]} ```