Skip to content
Tagged articles

SQLite

205 articles · Page 1 of 3
java1234
java1234
Nov 11, 2026 · Artificial Intelligence

Tencent Octop: Self-Hosted AI Assistant You Can Run Locally

Octop is Tencent Cloud's open-source, self-hosted AI assistant that runs on your own machine, supports multiple chat platforms, customizable experts, connectors, and knowledge bases, while keeping all data and API keys locally.

ACP protocolAI AgentOctop
0 likes · 10 min read
Tencent Octop: Self-Hosted AI Assistant You Can Run Locally
Old Zhang's AI Learning
Old Zhang's AI Learning
Oct 30, 2026 · Backend Development

Claude Code Memory Plugin Cuts Token Usage 10x, Works Across 18+ AI Coding Tools

The open-source claude-mem plugin adds persistent cross-session memory to Claude Code by capturing context through five hooks and a background worker, then using a three-tier retrieval system (search, timeline, get_observations) to inject only relevant history into new sessions, reducing token consumption by approximately 10x while supporting tools like Codex, Cursor, and OpenCode.

AI coding assistantChromaDBClaude Code
0 likes · 15 min read
Claude Code Memory Plugin Cuts Token Usage 10x, Works Across 18+ AI Coding Tools
51CTO HarmonyOS Developer Community
51CTO HarmonyOS Developer Community
Oct 28, 2026 · Mobile Development

Debug HarmonyOS 7 XiaoYi Skills: From Platform Evaluation to On-Device Testing

This article details a systematic debugging methodology for HarmonyOS 7 XiaoYi skills, showing how to trace discrepancies from platform evaluation reports through tool integration to on-device testing by comparing fixed inputs, expected outputs, and actual results at each execution stage to locate the earliest point of failure.

HTTP TestingHarmonyOSOn-Device Testing
0 likes · 38 min read
Debug HarmonyOS 7 XiaoYi Skills: From Platform Evaluation to On-Device Testing
AI Large-Model Wave and Transformation Guide
AI Large-Model Wave and Transformation Guide
Oct 27, 2026 · Backend Development

OntoL7.0 Architecture: MySQL8 Migration with SQLite Dialect Translation

The article details OntoL7.0's technical architecture after migrating business data to MySQL8, maintaining a single codebase with two isolated data stores (MySQL for business, SQLite for system) plus graph and vector storage, using a dialect translation layer to convert SQLite syntax to MySQL at the driver level.

Backend ArchitectureChromaDBDatabase Migration
0 likes · 5 min read
OntoL7.0 Architecture: MySQL8 Migration with SQLite Dialect Translation
Java Tech Enthusiast
Java Tech Enthusiast
Oct 27, 2026 · Databases

Why WeChat Chooses SQLite for 1.3 Billion Users' Chat Records

WeChat stores 1.3 billion users' chat records locally on devices using SQLite via its WCDB framework, avoiding EB-scale server costs while enabling instant search via FTS5 full-text indexing, with SQLCipher encryption and automatic sharding at 240MB per database file.

ACIDFTS5SQLCipher
0 likes · 16 min read
Why WeChat Chooses SQLite for 1.3 Billion Users' Chat Records
SpringMeng
SpringMeng
Oct 21, 2026 · Databases

SQLite 2018 SQL Features: Window Functions, UPSERT, FILTER Clause & Boolean Logic

This article details SQLite's SQL enhancements from versions 3.22.0 to 3.26.0 in 2018, covering boolean literals with IS [NOT] TRUE/FALSE, window functions with OVER clause limitations, FILTER clause for aggregates, UPSERT via INSERT ON CONFLICT, and column renaming via ALTER TABLE RENAME COLUMN.

FILTER clauseSQLSQL standards
0 likes · 12 min read
SQLite 2018 SQL Features: Window Functions, UPSERT, FILTER Clause & Boolean Logic
IT Services Circle
IT Services Circle
Oct 18, 2026 · Databases

Why WeChat Uses SQLite for 1.3 Billion Users' Chat Records

This article explains why WeChat stores chat records locally using SQLite instead of cloud databases, detailing the cost savings, privacy benefits, and performance advantages of embedded databases, along with WeChat's custom WCDB framework, FTS5 full-text search, encryption, and the trade-offs of local-only storage.

ACIDFTS5SQLCipher
0 likes · 16 min read
Why WeChat Uses SQLite for 1.3 Billion Users' Chat Records
Architect's Tech Stack
Architect's Tech Stack
Oct 10, 2026 · Databases

Why WeChat Stores Billions of Messages in SQLite: The Mobile Database Trade-offs

WeChat uses SQLite for chat storage because its embedded, zero-process design fits mobile constraints; ACID transactions and B+tree indexes ensure message durability and fast pagination; WAL enables concurrent reads/writes; SQLCipher encrypts per-device; sharding by session mitigates single-writer limits, offering a blueprint for local-first apps.

ACIDB+ TreeMobile Database
0 likes · 5 min read
Why WeChat Stores Billions of Messages in SQLite: The Mobile Database Trade-offs
Old Zhang's AI Learning
Old Zhang's AI Learning
Sep 29, 2026 · Artificial Intelligence

Open-Source macOS Audio Studio for Qwen-Audio TTS Built with Gemini 3.8 Flash

The author details the development of an open-source macOS native application for Alibaba's Qwen-Audio-3.1-TTS-Next model, featuring an AI scriptwriter, native creation studio with voice parameter controls, instant playback, project library with A/B testing, and 42 templates, all built using SwiftUI and Gemini 3.8 Flash.

AI audio generationGemini 3.8 FlashQwen-Audio
0 likes · 9 min read
Open-Source macOS Audio Studio for Qwen-Audio TTS Built with Gemini 3.8 Flash
dbaplus Community
dbaplus Community
Sep 27, 2026 · Fundamentals

Why the Creators of Linux, Python, Redis, Nginx & SQLite Are True Geniuses

The article argues that creators of foundational software like Linux, Python, Redis, Nginx, and SQLite are true geniuses due to their exceptional abstraction skills and system-level boundary control, illustrated by real-world cases where their minimal, convergent designs outperform modern complex solutions, and warns that over-reliance on AI tools erodes deep system understanding essential for solving hard production issues.

AI-Assisted CodingLinuxNginx
0 likes · 14 min read
Why the Creators of Linux, Python, Redis, Nginx & SQLite Are True Geniuses
dbaplus Community
dbaplus Community
Sep 20, 2026 · Databases

SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More

This article argues that SQLite, often dismissed as a toy database, can replace specialized systems like Elasticsearch, MongoDB, Kafka, ClickHouse, Redis, and even microservices due to its stability, zero-configuration deployment, built-in full-text search, JSON support, vector extensions, and local-first architecture, reducing operational complexity.

CachingFTS5JSON
0 likes · 25 min read
SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More
Geek Labs
Geek Labs
Sep 14, 2026 · Artificial Intelligence

Stronger AI Coding Agents Burn More Tokens: How roam-code's Code Graph Cuts Costs 63%

roam-code builds a local SQLite code graph using tree-sitter for 28 languages, letting AI agents query precise call relationships instead of grep or RAG, reducing agent turns by 83%, tokens by 80%, and cost by 63% in experiments, while adding deterministic pre-edit context injection and post-edit verification gates.

AI coding agentsDeveloper ToolsMCP
0 likes · 16 min read
Stronger AI Coding Agents Burn More Tokens: How roam-code's Code Graph Cuts Costs 63%
JavaEdge
JavaEdge
Sep 2, 2026 · Operations

OpenClaw 2.0 Upgrade on macOS: Diagnosing Hidden Install Issues & Zero-Downtime Migration

A detailed guide to upgrading OpenClaw from 2026.7.1-2 to 2026.8.1 on macOS, covering diagnosis of a misconfigured installation, Node.js version conflicts, choosing the install.sh path for automatic Node 26 provisioning, step-by-step backup and migration, post-install LaunchAgent reconstruction, and troubleshooting ServiceWorker cache causing QClaw branding.

AI AgentOpenClawSQLite
0 likes · 35 min read
OpenClaw 2.0 Upgrade on macOS: Diagnosing Hidden Install Issues & Zero-Downtime Migration
Niu Liu
Niu Liu
Aug 31, 2026 · R&D Management

Enterprise Codex Governance: Trustworthy Collection, Secure Access, Auditable Lifecycle

This article details the architecture of an enterprise governance platform for Codex AI coding assistants, covering local encrypted collection with 90ms hooks, server-side parsing with tenant isolation, tiered content access (L0–L3) requiring multi-party approval, and operational use cases from deployment health monitoring to employee offboarding with zero-residue verification.

AI coding assistantCodexKMS
0 likes · 17 min read
Enterprise Codex Governance: Trustworthy Collection, Secure Access, Auditable Lifecycle
Java Architect Handbook
Java Architect Handbook
Aug 27, 2026 · Operations

Finally a Handy Nginx Log Analyzer: Introducing NginxPulse

The article presents NginxPulse, a lightweight Nginx log analysis panel built with Go, Gin, Vue3, and SQLite, explains how it compares to heavier solutions like ELK and GoAccess, and provides step‑by‑step Docker, Docker‑Compose, and single‑binary deployment instructions along with useful features such as multi‑site support, remote log fetching, custom log formats, and access control.

DockerGoAccessNginx
0 likes · 8 min read
Finally a Handy Nginx Log Analyzer: Introducing NginxPulse
dbaplus Community
dbaplus Community
Aug 26, 2026 · Information Security

SQLite Got a 9.8 CVE That Was Actually an AI‑Generated Fabrication

An in‑depth investigation reveals that a batch of high‑severity CVE entries for SQLite, including a CVSS 9.8 rating, were fabricated by AI, disproved through independent testing, and later withdrawn by MITRE, exposing flaws in the current vulnerability disclosure process.

AI‑generatedCISACVE
0 likes · 12 min read
SQLite Got a 9.8 CVE That Was Actually an AI‑Generated Fabrication
BirdNest Tech Talk
BirdNest Tech Talk
Aug 25, 2026 · Backend Development

Go database/sql Tutorial: 39 Practical Lessons from Core to ORMs & Tools

This practical Go database/sql tutorial covers 39 lessons spanning core concepts like connection pools, transactions, and isolation levels, compares ORMs (GORM, Bun, XORM) and lightweight tools (sqlx, sqlc, Squirrel), and addresses logging, migration, testing, and production practices using modernc.org/sqlite for runnable examples.

Database MigrationGoORM
0 likes · 5 min read
Go database/sql Tutorial: 39 Practical Lessons from Core to ORMs & Tools
Airbnb Technology Team
Airbnb Technology Team
Aug 20, 2026 · Cloud Native

How Airbnb Built a Scalable, Reliable Kubernetes Sidecar for Dynamic Configuration

The article explains Airbnb's Sitar‑agent sidecar architecture, detailing the end‑to‑end configuration distribution lifecycle, key design choices such as sidecar versus in‑process deployment, pull‑model optimizations, and the migration from Sparkey to SQLite for robust, multi‑language support at massive scale.

Cloud NativeDynamic ConfigurationKubernetes
0 likes · 15 min read
How Airbnb Built a Scalable, Reliable Kubernetes Sidecar for Dynamic Configuration
Old Zhang's AI Learning
Old Zhang's AI Learning
Aug 19, 2026 · Artificial Intelligence

Building an Open‑Source AI Bookkeeping Skill for Codex/WorkBuddy and Feishu CLI

The author created a set of four AI‑driven bookkeeping Skills that let users record, query, and generate monthly HTML reports with a single natural‑language command in WeChat, Codex, WorkBuddy or TraeWork, storing data locally in SQLite and in Feishu multidimensional tables, and released the whole solution as open source.

AICodexFeishu
0 likes · 7 min read
Building an Open‑Source AI Bookkeeping Skill for Codex/WorkBuddy and Feishu CLI
ITPUB
ITPUB
Aug 16, 2026 · Databases

How Oracle’s Grip Is Killing MySQL and Why the ‘Toy’ SQLite Is Rising

Oracle’s 2026 layoffs hit the MySQL team, community contributions fell 44% since 2017, while PostgreSQL climbs, and SQLite—once dismissed as a toy—now powers billions of devices and edge‑computing platforms, boosted by projects like LibSQL, Turso, Cloudflare D1 and Litestream, offering latency advantages over traditional servers.

Database TrendsEdge ComputingMySQL
0 likes · 8 min read
How Oracle’s Grip Is Killing MySQL and Why the ‘Toy’ SQLite Is Rising
Node.js Tech Stack
Node.js Tech Stack
Aug 7, 2026 · Backend Development

Why Ryan Dahl Defied His Promise and Built the celld JavaScript Runtime

After vowing never to create another JavaScript runtime, Ryan Dahl spent over a year developing celld, an open‑source, self‑hosted distributed runtime that brings Cloudflare Workers and Durable Objects to your own machines, using V8, SQLite, Rust async, and S3 for coordination, while exposing its performance trade‑offs and early‑stage limitations.

Cloudflare WorkersDistributed SystemsDurable Objects
0 likes · 12 min read
Why Ryan Dahl Defied His Promise and Built the celld JavaScript Runtime
IT Services Circle
IT Services Circle
Aug 4, 2026 · Industry Insights

The Nameless Engineers Who Write Decades‑Long Error‑Free Code Powering the Physical World

A handful of largely unknown developers create ultra‑reliable embedded software—such as μC/OS, FreeRTOS, MQTT, BusyBox, SQLite and Linux subsystems—that runs in aircraft, medical devices, IoT gadgets and industrial equipment, and they achieve this through extreme size constraints, deterministic timing, exhaustive testing, mandatory code reviews and a commitment to long‑term maintenance.

BusyBoxFreeRTOSLinux
0 likes · 18 min read
The Nameless Engineers Who Write Decades‑Long Error‑Free Code Powering the Physical World
Su San Talks Tech
Su San Talks Tech
Jul 18, 2026 · Artificial Intelligence

Why CodeGraph Is Suddenly Going Viral

CodeGraph, a local‑first code intelligence tool for AI programming assistants, builds a searchable knowledge graph with tree‑sitter and SQLite, cutting tool calls by 71%, token usage by 57% and task time by 46% while keeping data private and requiring only a few minutes to install and use.

AI programmingCodeGraphMCP
0 likes · 16 min read
Why CodeGraph Is Suddenly Going Viral
dbaplus Community
dbaplus Community
Jul 5, 2026 · Databases

Why Dropping SQLite May Be Wrong – Do You Actually Need PostgreSQL for Write Load?

The article re‑examines SQLite’s historic reputation as a test‑only database, showing how SSD‑backed WAL mode, tools like LibSQL/Turso, Litestream, and Cloudflare D1, plus modern JVM support, give SQLite production‑grade performance for read‑intensive, multi‑tenant and edge scenarios, while outlining when PostgreSQL remains necessary.

Cloudflare D1Database PerformanceLibSQL
0 likes · 19 min read
Why Dropping SQLite May Be Wrong – Do You Actually Need PostgreSQL for Write Load?
Fun with Large Models
Fun with Large Models
Jun 27, 2026 · Artificial Intelligence

Quick Guide to LangChain DeepAgents: Exploring the Production‑Grade DeepAgents Code Framework

This article provides a comprehensive walkthrough of the DeepAgents Code repository, explaining its client‑server architecture, module organization, technology stack—including DeepAgents SDK, Textual UI, SQLite persistence, and streaming protocol—and the design rationale behind building a production‑ready AI agent framework.

AI agentsDeepAgentsLangChain
0 likes · 14 min read
Quick Guide to LangChain DeepAgents: Exploring the Production‑Grade DeepAgents Code Framework
IT Services Circle
IT Services Circle
Jun 25, 2026 · Artificial Intelligence

Why Codex Can Exhaust Your SSD: A Full Technical Investigation

The article analyzes how intensive use of OpenAI Codex, especially long‑running agents, continuously writes to its local SQLite logs, causing massive SSD write amplification despite modest file size growth, and details community reports, OpenAI’s fixes, and practical mitigation steps.

AI AgentCodexLogging
0 likes · 14 min read
Why Codex Can Exhaust Your SSD: A Full Technical Investigation
dbaplus Community
dbaplus Community
Jun 21, 2026 · Databases

Why the 20‑Year‑Old N+1 Query Problem Doesn’t Apply to SQLite

The article explains that the classic N+1 query anti‑pattern, harmful on client‑server databases like MySQL, is irrelevant for SQLite because its embedded architecture eliminates network round‑trips, turning hundreds of queries into cheap function calls, and examines the performance data and trade‑offs behind this claim.

Database PerformanceFossilN+1 Query
0 likes · 29 min read
Why the 20‑Year‑Old N+1 Query Problem Doesn’t Apply to SQLite
Coder Trainee
Coder Trainee
Jun 16, 2026 · Artificial Intelligence

Building a Data Analysis AI Agent: From Basics to Real‑World Implementation

This article walks through the design and implementation of a data‑analysis AI agent that converts natural‑language queries into SQL, executes them on a SQLite sales database, generates visualizations, and produces insight reports, complete with architecture diagrams and full Python code examples.

AI AgentLLMLangChain
0 likes · 9 min read
Building a Data Analysis AI Agent: From Basics to Real‑World Implementation
Top Architect
Top Architect
Jun 12, 2026 · Operations

A Lightweight Nginx Log Analyzer That Finally Works

NginxPulse is a lightweight Nginx log analysis panel built with Go‑Gin backend and Vue3 frontend, offering real‑time PV/UV, IP geolocation, multi‑site support, custom log formats, remote log fetching, Docker/Docker‑Compose deployment, single‑binary builds and optional access control, all backed by SQLite.

DockerGoNginx
0 likes · 8 min read
A Lightweight Nginx Log Analyzer That Finally Works
Architect's Tech Stack
Architect's Tech Stack
Jun 4, 2026 · Artificial Intelligence

How TencentDB Agent Memory Cuts Token Usage by 61% and Boosts Task Success

TencentDB Agent Memory, an open‑source hierarchical memory system for long‑running AI agents, offloads tool calls, structures short‑term and four‑layer long‑term memories, and reduces token consumption by 61% while raising task success rate 51% and persona accuracy from 48% to 76%, all running locally with SQLite and no API keys.

AI agentsOpenClawSQLite
0 likes · 4 min read
How TencentDB Agent Memory Cuts Token Usage by 61% and Boosts Task Success
James' Growth Diary
James' Growth Diary
Jun 2, 2026 · Artificial Intelligence

Cross‑Session Retrieval with SQLite FTS5 and LLM Summaries – Hermes Agent’s Four‑Layer Architecture

This article dissects Hermes Agent’s four‑layer cross‑session retrieval system, covering persistent storage, dual‑table FTS5 indexing for CJK and English, a three‑path search strategy, intelligent truncation for LLM prompts, structured summarisation, and a holographic retrieval layer that blends FTS5, Jaccard similarity and HRR vector algebra.

Agent ArchitectureCross-Session RetrievalFTS5
0 likes · 25 min read
Cross‑Session Retrieval with SQLite FTS5 and LLM Summaries – Hermes Agent’s Four‑Layer Architecture
AI Agent Super App
AI Agent Super App
May 29, 2026 · Databases

Why SQLite Is the World's Most Deployed Database—and How to Use It End‑to‑End

SQLite, the server‑less, single‑file database engine, is the most widely deployed database on the planet, powering Android, iOS, browsers and countless desktop apps; this article walks through its core features, Linux installation, command‑line CRUD, language bindings for Python, C, Java and Go, plus practical backup and performance tricks.

C++GoJava
0 likes · 21 min read
Why SQLite Is the World's Most Deployed Database—and How to Use It End‑to‑End
AI Engineering
AI Engineering
May 11, 2026 · Artificial Intelligence

Hermes Agent Desktop Launch: A 24/7 Self‑Evolving AI Assistant with Native UI

The Hermes Agent desktop application, rebuilt from a CLI into a cross‑platform UI, adds multi‑agent coordination, persistent SQLite memory, and a DAG‑based workflow engine, while detailing its layered cache, Git‑tracked self‑evolution, offline requirements, performance and security limitations, and open‑source availability.

AI assistantDAG schedulerElectron
0 likes · 3 min read
Hermes Agent Desktop Launch: A 24/7 Self‑Evolving AI Assistant with Native UI
Shuge Unlimited
Shuge Unlimited
Apr 23, 2026 · Artificial Intelligence

Deep Dive into Hermes Agent: Self‑Improving AI Agent Architecture with 110K+ Stars

Hermes Agent, an open‑source self‑improving AI agent framework that has amassed over 110 K GitHub stars, introduces a native closed‑learning loop, a unified single‑process agent cycle, self‑registering tools, pluggable context compression, multi‑API model support, and a scalable multi‑platform gateway, all built on Python 3.11+, SQLite + WAL, and extensive modular design.

AI AgentHermes AgentMCP
0 likes · 24 min read
Deep Dive into Hermes Agent: Self‑Improving AI Agent Architecture with 110K+ Stars
Tech Verticals & Horizontals
Tech Verticals & Horizontals
Apr 13, 2026 · Artificial Intelligence

Hermes AI Agent Explained in Plain English: Architecture, Installation, and Usage

This article provides a step‑by‑step, non‑technical walkthrough of Hermes, the self‑evolving AI agent from Nous Research, covering its core AIAgent brain, capabilities, one‑line installation, multi‑platform entry points, detailed architecture layers, context handling, SQLite‑based memory, and runtime flow, all illustrated with diagrams and commands.

AI AgentHermesSQLite
0 likes · 7 min read
Hermes AI Agent Explained in Plain English: Architecture, Installation, and Usage
Architect
Architect
Apr 13, 2026 · Artificial Intelligence

How Hermes and OpenClaw Differ in Memory Architecture and Skill Management

The article analyzes Hermes Agent's three‑layer memory system—fact memory stored in tiny Markdown files, session history indexed with SQLite + FTS5, and procedural memory via skill management—then compares each layer to OpenClaw's architecture and explains how to integrate self‑summarizing skills into OpenClaw.

Agent ArchitectureExternal Memory ProviderFTS5
0 likes · 27 min read
How Hermes and OpenClaw Differ in Memory Architecture and Skill Management
Architect
Architect
Mar 7, 2026 · Databases

Why an LLM‑Rewritten SQLite Is 20,000× Slower: Hidden Path Errors and Lessons

A Rust rewrite of SQLite generated largely by an LLM runs a simple primary‑key lookup 20,171 times slower than native SQLite, exposing how seemingly correct code can miss critical system constraints, and illustrating the need for explicit acceptance criteria, benchmark baselines, and governance when using AI‑generated software.

LLMSQLitebenchmark
0 likes · 19 min read
Why an LLM‑Rewritten SQLite Is 20,000× Slower: Hidden Path Errors and Lessons
Tech Musings
Tech Musings
Mar 6, 2026 · Artificial Intelligence

How to Build a Qwen3 Chat UI with Chainlit: Hooks, Auth, and Persistence

Learn how to use the Chainlit Python framework to create a web‑based Qwen3 chat interface, covering its core features, hook mechanisms for data layers, authentication, chat start, message handling, streaming generation, performance monitoring, and session restoration, with full code examples and SQLite persistence.

AIChainlitPython
0 likes · 13 min read
How to Build a Qwen3 Chat UI with Chainlit: Hooks, Auth, and Persistence
Java Web Project
Java Web Project
Mar 3, 2026 · Backend Development

How PocketBase Lets You Spin Up a Full Backend in Minutes

This article introduces PocketBase, an open‑source Go‑based Backend‑as‑a‑Service that bundles SQLite, authentication, file storage, real‑time APIs and an admin UI into a single executable, and walks through its core features, quick‑start steps, a Go integration example, and UI screenshots.

GoOpenSourcePocketBase
0 likes · 5 min read
How PocketBase Lets You Spin Up a Full Backend in Minutes
SpringMeng
SpringMeng
Mar 3, 2026 · Operations

A Lightweight Nginx Log Analyzer Worth Trying

NginxPulse is a lightweight, Docker‑friendly Nginx log analysis panel that offers real‑time PV/UV, IP lookup, multi‑site support, custom log formats, remote log pulling, and access control, with simple deployment via Docker, Docker‑Compose, or a single binary.

DockerGoNginx
0 likes · 7 min read
A Lightweight Nginx Log Analyzer Worth Trying
Shuge Unlimited
Shuge Unlimited
Feb 23, 2026 · Artificial Intelligence

How OpenClaw Memory Gives AI Agents 24/7 Long‑Term Memory

The article explains OpenClaw Memory's design—storing daily and permanent logs as Markdown files, managing them with Git, offering hybrid vector‑BM25 search, applying temporal decay to prioritize recent entries, and comparing SQLite and QMD backends with practical configuration examples and tips.

AI AgentHybrid SearchOpenClaw
0 likes · 14 min read
How OpenClaw Memory Gives AI Agents 24/7 Long‑Term Memory
Top Architect
Top Architect
Feb 16, 2026 · Backend Development

Spin Up a Full Go Backend in Minutes with PocketBase

PocketBase is a Go‑based open‑source backend‑as‑a‑service that bundles an embedded SQLite database, authentication, file storage, real‑time sync and an admin UI into a single executable, allowing developers to launch a fully functional backend in minutes and even embed it directly into Go applications.

OpenSourcePocketBaseSQLite
0 likes · 6 min read
Spin Up a Full Go Backend in Minutes with PocketBase
Architecture Digest
Architecture Digest
Feb 3, 2026 · Backend Development

Build a Full‑Featured Backend in Minutes with PocketBase

This article introduces PocketBase, an open‑source Go‑based Backend‑as‑a‑Service that bundles SQLite, authentication, file storage, real‑time sync and an admin UI into a single executable, and shows how to install, run, and embed it with code examples.

GoPocketBaseSQLite
0 likes · 5 min read
Build a Full‑Featured Backend in Minutes with PocketBase
AI Tech Publishing
AI Tech Publishing
Feb 1, 2026 · Artificial Intelligence

How Clawdbot Implements a Persistent, Search‑Driven Memory System

Clawdbot, an open‑source AI assistant, uses local Markdown files and a SQLite‑based vector index to provide a transparent, searchable, and long‑term memory that separates temporary context from durable storage, enabling autonomous task handling across sessions.

AI assistantClawdbotSQLite
0 likes · 10 min read
How Clawdbot Implements a Persistent, Search‑Driven Memory System
java1234
java1234
Jan 24, 2026 · Operations

A Lightweight Nginx Log Analyzer That Actually Works

NginxPulse is a lightweight, Docker‑ready Nginx log analysis panel built with Go‑Gin backend and Vue3 frontend, offering real‑time PV/UV, IP geolocation, multi‑site support, custom log formats, remote log fetching, and easy deployment via a single command or Compose file.

DockerGoNginx
0 likes · 7 min read
A Lightweight Nginx Log Analyzer That Actually Works
Go Development Architecture Practice
Go Development Architecture Practice
Jan 17, 2026 · Databases

What New SQL Features Did SQLite Add in 2018?

This article reviews SQLite's 2018 enhancements, covering boolean literals, window functions, the FILTER clause, upsert syntax, column‑renaming support, and related API changes, while also noting the remaining limitations compared with other major database systems.

Boolean LiteralsSQLSQLite
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018?
dbaplus Community
dbaplus Community
Dec 14, 2025 · Databases

Mastering SQLite PRAGMA: Boost Performance and Safety on Linux & Windows

This guide explains SQLite's essential PRAGMA commands, compares synchronous modes, distinguishes persistent from session‑level settings, and details key Linux‑Windows differences, providing concrete initialization scripts to optimize speed, reliability, and disk usage.

ConfigurationDatabase PerformanceLinux
0 likes · 10 min read
Mastering SQLite PRAGMA: Boost Performance and Safety on Linux & Windows
ITPUB
ITPUB
Dec 9, 2025 · Databases

Mastering SQLite PRAGMA: Optimize Performance and Persistence Across Linux & Windows

This article explains SQLite's PRAGMA commands, compares synchronous modes and WAL settings, distinguishes persistent from session‑level pragmas, and highlights key Linux‑Windows differences, providing practical examples and a step‑by‑step initialization checklist for reliable database operation.

Database PerformanceLinuxPRAGMA
0 likes · 11 min read
Mastering SQLite PRAGMA: Optimize Performance and Persistence Across Linux & Windows
dbaplus Community
dbaplus Community
Dec 3, 2025 · Databases

Why SQLite Beats PostgreSQL in Embedded Environments – Version Guide & Concurrency Insights

This article compares SQLite and PostgreSQL, presents detailed SQLite version timelines and OS compatibility tables, explains the differences between rollback‑journal and WAL concurrency models, shows a simple multi‑process lock test, and concludes that SQLite 3.45 is the most suitable choice for modern Linux, macOS, Android and iOS deployments.

PostgreSQLSQLiteVersion Compatibility
0 likes · 14 min read
Why SQLite Beats PostgreSQL in Embedded Environments – Version Guide & Concurrency Insights
Code Wrench
Code Wrench
Nov 29, 2025 · Frontend Development

Building a Modern Desktop Chat App with Wails: Go + Vue Made Easy

This article walks through creating a lightweight, cross‑platform desktop chat application using Wails, demonstrating project structure, Go‑to‑frontend API generation, real‑time event communication, SQLite storage, UI implementation with Vue3, image handling, a one‑click dev script, and packaging size advantages.

GoSQLiteVue
0 likes · 10 min read
Building a Modern Desktop Chat App with Wails: Go + Vue Made Easy
Data Party THU
Data Party THU
Nov 5, 2025 · Artificial Intelligence

How to Give LLM Agents Memory, Reflection, and Goal Tracking

This article explains why current LLM agents lose context after each conversation and presents a practical architecture—using SQLite for structured storage, a vector database for semantic retrieval, and LLM‑driven reflection—to add persistent memory, self‑evaluation, and goal‑tracking capabilities that turn agents into learning partners.

Goal TrackingLLMMemory
0 likes · 10 min read
How to Give LLM Agents Memory, Reflection, and Goal Tracking
Data STUDIO
Data STUDIO
Nov 4, 2025 · Artificial Intelligence

How to Build a Memory-Enabled AI Agent with SQLite and Vector Search

This article explains how to give AI agents persistent memory, reflection, and goal‑tracking by storing interaction summaries in SQLite, embedding them for semantic retrieval with a vector database, and using LLM‑generated prompts to recall, reflect, and manage objectives across sessions.

AI AgentGoal TrackingLLM
0 likes · 10 min read
How to Build a Memory-Enabled AI Agent with SQLite and Vector Search
Radish, Keep Going!
Radish, Keep Going!
Nov 2, 2025 · Fundamentals

Tech Roundup: Phone Hacking Risks, Rust Futurelocks, SQLite Concurrency & More

This roundup covers recent security flaws in Google Pixel phones, subtle async Rust pitfalls called Futurelock, SQLite concurrency insights, Debian's Rust mandate, ICE facial‑recognition concerns, open‑source Rubik's cube automation, chaotic attractor visualizations, arXiv policy changes, and the EU chat‑control proposal's defeat.

RustSQLiteTechnology
0 likes · 10 min read
Tech Roundup: Phone Hacking Risks, Rust Futurelocks, SQLite Concurrency & More
BirdNest Tech Talk
BirdNest Tech Talk
Oct 27, 2025 · Artificial Intelligence

How LangChain’s Indexing API Enables Efficient Incremental Updates for RAG Systems

This article explains how LangChain's Indexing API adds state management and synchronization to the classic load‑split‑embed‑store RAG pipeline, detailing the RecordManager component, the index function workflow, key parameters, implementation considerations, and best‑practice code examples for production‑grade vector stores.

FaissIndexing APILangChain
0 likes · 12 min read
How LangChain’s Indexing API Enables Efficient Incremental Updates for RAG Systems
dbaplus Community
dbaplus Community
Oct 11, 2025 · Databases

Why SQLite Is the World’s Most Ubiquitous Database and Its Road to 2050

SQLite, the lightweight embedded SQL engine created by Richard Hipp, powers virtually every smartphone, computer, browser and countless desktop apps, and thanks to its strict backward‑compatible C API, exhaustive documentation, extensive comments, rigorous cross‑platform testing, and a tiny dedicated team, it aims to remain reliable and widely used through 2050.

SQLitebackward compatibilitydocumentation
0 likes · 9 min read
Why SQLite Is the World’s Most Ubiquitous Database and Its Road to 2050
Code Wrench
Code Wrench
Oct 3, 2025 · Backend Development

Build a Go-Powered Automated Stock Screener with SQLite and Vue3 Visualization

This article presents version 2.0 of a Go-based stock analysis system that upgrades data storage to SQLite, adds MA/MACD indicators, modular strategy engines, daily scheduling, and a Vue3 front‑end, providing full code snippets, configuration examples, and deployment instructions.

GoSQLiteStrategy Engine
0 likes · 8 min read
Build a Go-Powered Automated Stock Screener with SQLite and Vue3 Visualization
macrozheng
macrozheng
Sep 29, 2025 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

SQLite, often dismissed as a toy, proves its robustness by adding powerful SQL capabilities in 2018—including boolean literals, window functions, FILTER clauses, upsert syntax, and column renaming—making it a viable choice for production workloads despite lacking a network layer.

New FeaturesSQLSQLite
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Code Ape Tech Column
Code Ape Tech Column
Sep 20, 2025 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article explores SQLite's 2018 enhancements—including boolean literals, window functions, FILTER clauses, upsert syntax, and column renaming—detailing how each feature works, its syntax, and practical code examples, while also clarifying limitations compared to other major database systems.

Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Su San Talks Tech
Su San Talks Tech
Sep 18, 2025 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, with code examples and comparisons to other databases, highlighting its reliability and suitability for production use.

Boolean LiteralsSQLSQLite
0 likes · 11 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Architect
Architect
Sep 17, 2025 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article explores the latest SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering boolean literals, window functions, FILTER clauses, upsert syntax, column renaming, and related API changes, with code examples and practical usage notes.

SQLSQLiteUPSERT
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Architecture Digest
Architecture Digest
Sep 15, 2025 · Databases

When to Choose SQLite Over MySQL? Pros, Cons, and Ideal Use Cases

This article examines SQLite's lightweight nature, cross‑platform support, and easy backup, while discussing its limitations in high‑concurrency scenarios, and provides guidance on when SQLite is appropriate for prototyping or low‑resource environments versus when to avoid it.

Prototype DevelopmentSQLitecross-platform
0 likes · 4 min read
When to Choose SQLite Over MySQL? Pros, Cons, and Ideal Use Cases
Architecture Digest
Architecture Digest
Sep 14, 2025 · Databases

Should You Replace MySQL with SQLite? Pros, Cons, and When to Use It

This article examines SQLite’s tiny footprint and embedded nature, compares it with MySQL, outlines its advantages such as cross‑platform support and easy backup, discusses its drawbacks like poor high‑concurrency handling and lack of remote access, and advises when SQLite is a suitable choice.

EmbeddedSQLitedatabase
0 likes · 4 min read
Should You Replace MySQL with SQLite? Pros, Cons, and When to Use It
Senior Brother's Insights
Senior Brother's Insights
Sep 11, 2025 · Databases

How to Eliminate the N+1 Query Problem with JOINs in SQLite

This article explains the N+1 query performance issue, demonstrates a naïve Python/SQLite implementation that triggers N+1 queries, compares its runtime, and then shows how using SQL JOINs, GROUP BY, and nested data structures can dramatically improve query efficiency and reduce latency.

N+1 QuerySQLSQLite
0 likes · 9 min read
How to Eliminate the N+1 Query Problem with JOINs in SQLite
Alibaba Cloud Native
Alibaba Cloud Native
Sep 2, 2025 · Artificial Intelligence

How AI Can Design Your SQLite Database and Perform Data Analysis

This guide demonstrates using the Tongyi Lingma AI agent to automatically design an SQLite database schema, generate SQL, insert sample data, and conduct data analysis with visual charts, covering all required installations, configurations, prompts, and code snippets.

AIMCPSQLite
0 likes · 6 min read
How AI Can Design Your SQLite Database and Perform Data Analysis
Alibaba Cloud Native
Alibaba Cloud Native
Aug 31, 2025 · Backend Development

How AI Can Auto‑Generate a Complete Java E‑Commerce Order System from 0 to 1

This tutorial walks through using the Lingma AI assistant to automatically create, configure, and run a full Java Maven e‑commerce order project—including environment setup, SQLite persistence, CRUD services, unit tests, and architecture visualization—showing each prompt, command, and generated code snippet.

AI code generationBackend DevelopmentJava
0 likes · 11 min read
How AI Can Auto‑Generate a Complete Java E‑Commerce Order System from 0 to 1
php Courses
php Courses
Apr 28, 2025 · Databases

Python Database Programming: SQLite and MySQL Basics

This tutorial explains how to use Python's sqlite3 module and MySQL connectors to perform essential database operations such as connecting, creating tables, inserting, querying, updating, deleting records, and managing transactions for both SQLite and MySQL.

MySQLSQLSQLite
0 likes · 7 min read
Python Database Programming: SQLite and MySQL Basics
ITPUB
ITPUB
Mar 21, 2025 · Databases

What New SQL Features Did SQLite Add Between Versions 3.22 and 3.26?

This article reviews the SQL enhancements introduced in SQLite from version 3.22.0 through 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, and column‑renaming support, while comparing SQLite's capabilities to other major database engines.

Boolean LiteralsFILTER clauseRename Column
0 likes · 11 min read
What New SQL Features Did SQLite Add Between Versions 3.22 and 3.26?
21CTO
21CTO
Dec 20, 2024 · Databases

Can Rust’s Limbo Outpace SQLite? Inside Turso’s Async Database Rewrite

Limbo, Turso’s Rust‑based rewrite of SQLite, aims for full compatibility while adding memory safety, asynchronous I/O via io_uring, deterministic simulation testing, and WebAssembly compilation, delivering comparable or superior performance on large datasets and showcasing the challenges and benefits of re‑engineering a mature database engine.

Deterministic TestingLimboRust
0 likes · 4 min read
Can Rust’s Limbo Outpace SQLite? Inside Turso’s Async Database Rewrite
Liangxu Linux
Liangxu Linux
Nov 14, 2024 · Databases

Master SQLite with C: Essential Functions and Sample Code

This guide walks through using SQLite's C API—including opening databases, executing queries with and without callbacks, handling results, and performing insert, delete, and display operations—complete with code snippets, table schemas, and compilation instructions.

APIC++SQL
0 likes · 12 min read
Master SQLite with C: Essential Functions and Sample Code
Java Tech Enthusiast
Java Tech Enthusiast
Nov 12, 2024 · Databases

The Origin Story of Covering Indexes in SQLite

The article recounts how SQLite’s creator, D. Richard Hipp, learned about covering indexes from MySQL co‑founder David Axmark at a German PHP conference and, during a trans‑Atlantic Delta flight, added support that lets queries be satisfied entirely from the index, dramatically boosting performance by avoiding table reads.

Covering IndexSQLSQLite
0 likes · 5 min read
The Origin Story of Covering Indexes in SQLite
Smart Era Software Development
Smart Era Software Development
Nov 2, 2024 · Information Security

How an LLM Discovered a Real‑World SQLite Stack Buffer Overflow

Google’s Big Sleep AI agent, built on the Project Naptime framework, used a large language model to analyze recent SQLite commits, identify a previously unknown stack‑buffer‑underflow bug, and generate a reproducible test case, demonstrating that LLMs can effectively perform real‑world vulnerability research.

AI securityBig SleepFuzzing
0 likes · 17 min read
How an LLM Discovered a Real‑World SQLite Stack Buffer Overflow
Java Tech Enthusiast
Java Tech Enthusiast
Oct 9, 2024 · Databases

The History and Development of SQLite by Richard Hipp

SQLite, conceived by D. Richard Hipp after his naval‑ship software work revealed client‑server database fragility, became a self‑contained, byte‑code SQL engine that powers billions of devices—from early Motorola and Symbian adopters to Android’s default storage—maintained by a three‑person core team, an alliance of partners, and a rigorous 100 % MCDC test suite ensuring unmatched reliability.

Richard HippSQLitedatabase
0 likes · 13 min read
The History and Development of SQLite by Richard Hipp
Test Development Learning Exchange
Test Development Learning Exchange
Sep 11, 2024 · Backend Development

Python Concurrency, Asyncio, Flask Web Development, SQLite, and Git Basics

This article introduces Python concurrency models—including threading, multiprocessing, and asyncio—provides step‑by‑step Flask web application examples, demonstrates SQLite database operations, and covers essential Git commands for version control, all with complete code snippets for practical learning.

Backend DevelopmentFlaskGit
0 likes · 8 min read
Python Concurrency, Asyncio, Flask Web Development, SQLite, and Git Basics
dbaplus Community
dbaplus Community
Sep 9, 2024 · Databases

Why SQLite Powers Billions of Devices: Real-World Use Cases Explained

SQLite, the lightweight embedded SQL engine created in 2000, is the world’s most deployed database, powering mobile apps, embedded systems, desktop software, data analysis tasks, and even browser‑based acceleration via WebAssembly, thanks to its zero‑configuration design and broad language support.

SQLiteWebAssemblydata analysis
0 likes · 8 min read
Why SQLite Powers Billions of Devices: Real-World Use Cases Explained