Migrating a blog to PocketBase, detailing the journey through various platforms like Wix, Github Pages, 11ty, Lit, and Obsidian, highlighting the desire for customization and simplification.
Export SQLite database schema to CREATE statements using Dart, SQLite3, and Mustache templating for code generation.
Learn how to implement offline content recommendations using Gemini for text embeddings and SQLite for vector storage, enabling efficient similarity searches for related content in applications like CMS platforms.
Build a WebRTC signal server using PocketBase, a lightweight backend with SQLite, Server Sent Events, and an easy-to-use admin UI.
Build a graph database in Flutter using SQLite and Drift, ideal for modeling relationships between data in applications like social networks, games, and blogs.
Learn how to implement full-text search in SQLite using the fts5 extension by creating virtual tables and keeping the index synchronized with your data.
Use SQLite as a key-value store to efficiently manage settings and non-relational data by creating a table, saving, reading, deleting, and searching values using SQL queries.
Store JSON data in SQLite by creating a table with a path, data (as a string), TTL, created, and updated columns, then use INSERT/REPLACE statements to save and retrieve JSON objects.
SQLite offers efficient, synchronous database access within the UI thread, enabling fast data retrieval and seamless integration for UI-driven applications, even with large datasets.
Learn to build an offline Retrieval-Augmented Generation (RAG) system using SQLite, embeddings, and Google's Gemma models for browser-based document querying, as demonstrated by Google's Rody Davis.
Learn how to compile SQLite to WASM in Firebase Studio using Nix, web preview, and Gemini for a streamlined development workflow.