Tags / SQLite

SQLite 11 posts

How to Export SQLite Tables to CREATE Statements

Export SQLite database schema (tables and indexes) to CREATE statements using Flutter, SQLite3, and Mustache templating.

2025-01-18 20:43:35.986Z Read post

How to Run Astro SSR and PocketBase on the Same Server

This tutorial demonstrates how to run PocketBase and Astro in server-side rendering (SSR) mode on the same server using Go, providing instructions for project setup and server configuration.

2025-01-18 22:05:53.055Z Read post

How to build a graph database with Flutter

Create a graph database in Flutter using SQLite and the Drift package to model relationships between data, ideal for applications like social networks, games, and blogs.

2025-01-18 21:09:38.105Z Read post

Migrating my Blog to PocketBase

Developer exploring various tech stacks and personal website migrations, including Wix, Github Pages with Jekyll, 11ty, Lit, and Obsidian Publish, to optimize workflow and showcase explorations.

2025-01-20 20:08:23.622Z Read post

How to do Offline Recommendations with SQLite and Gemini

Learn how to implement related content recommendations in your CMS using text embeddings, Google's Gemini API, and a SQLite extension for efficient vector storage.

2025-02-10 12:00:00.000Z Read post

How to Deploy PocketBase to Cloud Run

Deploy PocketBase on Google Cloud Run with features like scaling to zero, infinite storage, and easy backups, using a Cloud Storage bucket for persistent data.

2025-01-18 22:12:22.964Z Read post

How to Build a WebRTC Signal Server with PocketBase

This tutorial demonstrates setting up a WebRTC video calling example using PocketBase as a signaling server with SQLite and Server Sent Events, providing instructions for server setup and collection creation.

2025-01-18 22:32:05.045Z Read post

How to do Full Text Search with SQLite

Implement full-text search in SQLite using loadable extensions like fts5 by creating virtual tables and updating them with data from your database.

2025-01-18 20:49:31.481Z Read post

How to store SQLite as NoSQL Store

Store, manage, and retrieve JSON documents efficiently using SQLite with path-based indexing, TTL support, and built-in JSON functions.

2025-01-18 06:24:22.553Z Read post

Using SQLite as a Key Value Store

Store and manage key-value pairs efficiently using SQLite, a versatile database ideal for settings, user data, and syncing across applications and servers.

2025-01-17 06:54:23.265Z Read post

SQLite on the UI Thread

SQLite is a fast, process-level database library well-suited for UI-driven applications, offering efficient data handling even with large datasets and benefits from strategic indexing and query optimization.

2025-01-18 20:38:57.089Z Read post