BestHub
Sign in
Tagged articles
159 articles
Page 1 of 2
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 AgentClosed Loop LearningHermes Agent
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.

BenchmarkDatabase designLLM
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.

Backend-as-a-ServiceGoOpenSource
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 SearchMemory Management
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.

Backend-as-a-ServiceOpenSourcePocketBase
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.

Backend-as-a-ServiceGoPocketBase
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 LiteralsDatabase FeaturesSQL
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.

Desktop AppGoSQLite
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.

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

Backward CompatibilityDocumentationEmbedded Database
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.

AutomationGoSQLite
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 LiteralsDatabase FeaturesFILTER clause
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.

SQLitecross-platformdatabase
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.

SQLiteUse Casesdatabase
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.

JOINN+1 QuerySQL
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.

AIDatabase designMCP
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
dbaplus Community
dbaplus Community
Aug 3, 2025 · Databases

Why SQLite Beats MySQL for 90% of Web Apps: Performance & Deployment Insights

A thorough benchmark shows that for typical read‑heavy, single‑server web applications SQLite can be up to twenty times faster than MySQL, while also offering simpler deployment, lower cost, and adequate scalability, though MySQL still wins in high‑concurrency write‑intensive scenarios.

BenchmarkDatabase PerformanceSQLite
0 likes · 10 min read
Why SQLite Beats MySQL for 90% of Web Apps: Performance & Deployment Insights
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.

SQLSQLitemysql
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 LiteralsDatabase FeaturesFILTER clause
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.

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

Database OptimizationSQLSQLite
0 likes · 5 min read
The Origin Story of Covering Indexes in SQLite
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.

Embedded DatabaseMobile DevelopmentSQLite
0 likes · 8 min read
Why SQLite Powers Billions of Devices: Real-World Use Cases Explained
ITPUB
ITPUB
Sep 4, 2024 · Databases

Why SQLite Is the Tiny Yet Powerful Database for Mobile and Embedded Apps

This article introduces SQLite, explains why it is the most widely deployed lightweight SQL engine, outlines its common use cases in mobile, desktop and IoT devices, compares it with MySQL and PostgreSQL, and provides step‑by‑step installation instructions.

Database InstallationEmbedded DatabaseSQLite
0 likes · 6 min read
Why SQLite Is the Tiny Yet Powerful Database for Mobile and Embedded Apps
Java Tech Enthusiast
Java Tech Enthusiast
Sep 2, 2024 · Databases

Understanding SQLite: Usage Scenarios and Advantages

SQLite, a lightweight serverless relational database written in C, powers billions of devices and is used for mobile app storage, embedded systems, offline desktop applications, small‑to‑medium data analysis, and browser‑based acceleration via WebAssembly, supporting languages such as C, C++, Java, Python, and Swift.

Embedded DatabaseIoTSQLite
0 likes · 5 min read
Understanding SQLite: Usage Scenarios and Advantages
Python Programming Learning Circle
Python Programming Learning Circle
Aug 8, 2024 · Fundamentals

10 Useful Python Scripts to Automate Everyday Tasks

This article presents ten practical Python scripts—including data analysis with Pandas, web scraping with BeautifulSoup, file renaming, image resizing, PDF generation, email sending, data backup, password generation, a simple HTTP server, and SQLite backup/restore—to help automate common programming tasks.

EmailSQLitepandas
0 likes · 9 min read
10 Useful Python Scripts to Automate Everyday Tasks
Open Source Tech Hub
Open Source Tech Hub
Jul 9, 2024 · Databases

How to Deploy and Use SQLite-Web: A Web‑Based SQLite Database Manager

This guide introduces SQLite‑Web, a Python‑based web interface for SQLite, explains how to build and run its Docker image, details the command‑line options for configuring ports, hosts, authentication, and other features, and shows how to manage, query, and export SQLite databases through the browser.

DockerPythonSQLite
0 likes · 6 min read
How to Deploy and Use SQLite-Web: A Web‑Based SQLite Database Manager
dbaplus Community
dbaplus Community
Jun 16, 2024 · Databases

How a Few Volunteers Keep the Internet’s Core Software Alive

Despite powering billions of devices, critical components like the TZ time‑zone database and SQLite are maintained by just a handful of volunteers, and the article reveals how this fragile reliance could cause massive disruptions if those small teams were to disappear.

SQLitedatabasesopen source
0 likes · 8 min read
How a Few Volunteers Keep the Internet’s Core Software Alive
Architecture Development Notes
Architecture Development Notes
May 30, 2024 · Backend Development

Build a Fast, Safe Rust Microservice with Actix-web and SQLite

Learn how to create a simple, high‑performance Rust microservice using Actix‑web, Serde, and SQLite, covering environment setup, project structure, core code for CRUD operations, and testing commands, while highlighting Rust’s memory safety, speed, and low runtime overhead.

Backend DevelopmentCRUDMicroservice
0 likes · 10 min read
Build a Fast, Safe Rust Microservice with Actix-web and SQLite
Laravel Tech Community
Laravel Tech Community
May 27, 2024 · Databases

SQLite 3.46.0 Release Highlights and New Features

SQLite 3.46.0 introduces extensive PRAGMA enhancements, new date‑time modifiers, support for underscore digits in numeric literals, a json_pretty() function, significant query planner optimizations, improved JSON handling, and the ability to use large hexadecimal literals as column defaults, all while maintaining its public‑domain, self‑contained nature.

Database EngineJSONPRAGMA
0 likes · 4 min read
SQLite 3.46.0 Release Highlights and New Features
Tencent Cloud Developer
Tencent Cloud Developer
Apr 16, 2024 · Databases

Major Updates and New Features of WCDB 2: Multi‑language Support, SQL Builder, Backup & Recovery, Data Migration, Compression, and Performance Optimizations

WCDB 2 introduces multi-language support (C++, Java, Kotlin), a rewritten SQL builder, fast backup and recovery with sub‑second times, incremental WAL‑based backup, automatic data migration, Zstandard compression, on‑the‑fly column addition, and performance enhancements such as an FTS5 optimizer and interruptible transactions, delivering a robust high‑performance mobile database solution.

Data MigrationSQL BuilderSQLite
0 likes · 47 min read
Major Updates and New Features of WCDB 2: Multi‑language Support, SQL Builder, Backup & Recovery, Data Migration, Compression, and Performance Optimizations
NetEase Cloud Music Tech Team
NetEase Cloud Music Tech Team
Apr 15, 2024 · Mobile Development

Implementation and Optimization of Local Private Domain Search in Cloud Music

The Cloud Music team integrated a lightweight on‑device full‑text engine using SQLite FTS5 with a simple tokenizer, replaced JavaScript matching with SQLite’s bm25(), parallelized queries, and cut search latency by 75%, boosting CTR 13% and average playback by 17 seconds while preserving user privacy.

FTS5Full‑Text SearchPerformance Optimization
0 likes · 15 min read
Implementation and Optimization of Local Private Domain Search in Cloud Music
Open Source Tech Hub
Open Source Tech Hub
Apr 13, 2024 · Databases

How to Use an In‑Memory SQLite Database for Fast, Isolated PHP Unit Tests

This guide explains why an in‑memory SQLite database is ideal for PHP unit testing, outlines its key benefits such as isolation, speed, and resource efficiency, and provides step‑by‑step code examples for setup, data handling, cleanup, exception handling, schema verification, data providers, and transaction testing.

In-Memory DatabasePHPSQLite
0 likes · 9 min read
How to Use an In‑Memory SQLite Database for Fast, Isolated PHP Unit Tests
WeChat Client Technology Team
WeChat Client Technology Team
Apr 9, 2024 · Databases

How WCDB Evolved: Multi‑Language Support, Powerful SQL Builder, and Ultra‑Fast Backup

This article details the major upgrades of WCDB, including expanded language support, a redesigned Winq SQL builder, robust data backup and repair mechanisms, seamless data migration, on‑the‑fly compression, automatic column addition, and performance optimizations such as interruptible transactions and WAL header improvements.

DataBackupMulti-languageORM
0 likes · 49 min read
How WCDB Evolved: Multi‑Language Support, Powerful SQL Builder, and Ultra‑Fast Backup
php Courses
php Courses
Apr 1, 2024 · Databases

Creating SQLite Database Tables with PHP: A Step-by-Step Guide

This tutorial walks through connecting to an SQLite database with PHP, creating a 'users' table using SQL, and verifying the table’s structure through PRAGMA queries, providing complete code examples for each step to help developers understand SQLite integration in web projects.

PHPSQLSQLite
0 likes · 4 min read
Creating SQLite Database Tables with PHP: A Step-by-Step Guide
Ops Development & AI Practice
Ops Development & AI Practice
Mar 22, 2024 · Databases

How to Use SQLite3 in Go: A Step‑by‑Step Guide

This guide walks you through installing the Go SQLite3 driver, opening a database connection, creating tables, inserting records, querying data, and provides a complete runnable example, helping developers integrate lightweight SQLite storage into Go applications efficiently.

GoSQLSQLite
0 likes · 6 min read
How to Use SQLite3 in Go: A Step‑by‑Step Guide
Linux Cloud Computing Practice
Linux Cloud Computing Practice
Mar 13, 2024 · Databases

Unlock SQLite’s 2018 SQL Enhancements: Booleans, Window Functions, Upserts & More

This article explores SQLite’s 2018 SQL feature updates—from boolean literals and truth testing to window functions, FILTER clauses, upsert syntax, column renaming, and related API changes—highlighting syntax details, limitations, and practical examples for developers seeking to leverage these modern capabilities in production.

Database FeaturesSQLSQLite
0 likes · 10 min read
Unlock SQLite’s 2018 SQL Enhancements: Booleans, Window Functions, Upserts & More
ITPUB
ITPUB
Jan 22, 2024 · Databases

Why SQLite Became the World’s Most Popular Embedded Database

This article traces SQLite’s origins from a 2000 Navy project, explains how its first version wrapped GDBM, details its layered architecture and code flow, and shows how Richard Hipp’s philosophy of building every component himself turned SQLite into the ubiquitous embedded database we see everywhere today.

Database ArchitectureEmbedded DatabaseGDBM
0 likes · 10 min read
Why SQLite Became the World’s Most Popular Embedded Database
dbaplus Community
dbaplus Community
Jan 21, 2024 · Databases

Why SQLite Dominates Everywhere: Origins, Architecture, and Secrets

This article explores why SQLite is the world’s most ubiquitous database, tracing its birth from a Navy project, its early implementation atop GDBM, the layered architecture that processes SQL statements, the transition to a B‑tree engine, and the creator’s philosophy of self‑contained software.

Embedded DatabaseGDBMRichard Hipp
0 likes · 10 min read
Why SQLite Dominates Everywhere: Origins, Architecture, and Secrets
21CTO
21CTO
Dec 14, 2023 · Databases

Why esProc SPL Beats SQLite for Lightweight Data Processing

esProc SPL, a pure‑Java, lightweight data‑processing engine, offers richer data source support, built‑in flow control, and easier complex calculations compared to SQLite, making it a powerful alternative for small applications that need database‑like capabilities without the overhead of traditional databases.

JavaSPLSQLite
0 likes · 7 min read
Why esProc SPL Beats SQLite for Lightweight Data Processing
Laravel Tech Community
Laravel Tech Community
Nov 7, 2023 · Databases

SQLite 3.44.0 Release Highlights and New Features

SQLite 3.44.0 introduces enhanced aggregate functions with ORDER BY support, new scalar functions like concat(), string_agg(), expanded strftime() format specifiers, additional C APIs, stricter PRAGMA behavior, improved query planner optimizations, runtime detection of long‑double support, and default UTF‑8 handling in the Windows CLI.

Database EngineSQLSQLite
0 likes · 5 min read
SQLite 3.44.0 Release Highlights and New Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 26, 2023 · Databases

SQL Learning Course Outline and Book Giveaway Announcement

This announcement details a book giveaway sponsored by Tsinghua University Press and presents a comprehensive SQL learning curriculum covering SQLite, MySQL, query fundamentals, subqueries, joins, and advanced database features, complete with micro‑lecture videos and hands‑on exercises.

Book GiveawayDatabase tutorialSQL
0 likes · 9 min read
SQL Learning Course Outline and Book Giveaway Announcement
Liangxu Linux
Liangxu Linux
Oct 10, 2023 · Operations

Master Your Shell History with Atuin: Install, Sync, and Powerful Search

Atuin replaces the traditional shell history with a SQLite‑backed, feature‑rich UI, offering encrypted synchronization across machines, detailed command metadata, and flexible search capabilities, while providing multiple installation methods and shell plugin integrations for zsh, bash, and fish.

SQLiteShellatuin
0 likes · 8 min read
Master Your Shell History with Atuin: Install, Sync, and Powerful Search
Soul Technical Team
Soul Technical Team
Oct 9, 2023 · Databases

Understanding SQLite Log Modes and Fixing Duplicate Message ID Issues in Chat Applications

This article explains SQLite's Rollback and WAL logging modes, compares their performance and concurrency characteristics, investigates a real‑world problem where duplicate IM message IDs appear after app upgrades, and presents a step‑by‑step solution using UNIQUE constraints and index checks to prevent repeated inserts.

SQLiteWALchat-application
0 likes · 26 min read
Understanding SQLite Log Modes and Fixing Duplicate Message ID Issues in Chat Applications
Test Development Learning Exchange
Test Development Learning Exchange
Aug 7, 2023 · Databases

Python Code Examples for Connecting to Common Databases

This article provides concise Python code snippets for connecting to and querying a variety of popular databases—including MySQL, PostgreSQL, SQLite, MongoDB, Oracle, SQL Server, Redis, Elasticsearch, Cassandra, Couchbase, Firebase, DynamoDB, Neo4j, and InfluxDB—illustrating the essential steps for each.

Code ExamplesMongoDBPostgreSQL
0 likes · 8 min read
Python Code Examples for Connecting to Common Databases
php Courses
php Courses
Jul 29, 2023 · Databases

Using SQLite with PHP: Comparison with MySQL and Practical Code Examples

This article compares SQLite and MySQL, outlines SQLite’s advantages and disadvantages, describes scenarios where SQLite is appropriate, and provides a step‑by‑step PHP tutorial with complete code for connecting, creating tables, inserting, querying, updating, deleting, and closing an SQLite database.

PHPSQLitecode
0 likes · 8 min read
Using SQLite with PHP: Comparison with MySQL and Practical Code Examples
Laravel Tech Community
Laravel Tech Community
May 18, 2023 · Databases

SQLite 3.42.0 Release Highlights and New Features

SQLite 3.42.0, the widely used public-domain SQL database engine, introduces features such as FTS5 secure-delete, JSON5 support, new sqlite3_config options, enhanced query planner optimizations, CLI improvements, additional SQL functions, extended PRAGMA integrity_check, subsecond time modifiers, and various bug fixes and performance enhancements.

CLIDatabase EngineFTS5
0 likes · 5 min read
SQLite 3.42.0 Release Highlights and New Features
Open Source Linux
Open Source Linux
Mar 21, 2023 · Databases

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

This article reviews the SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, while comparing SQLite’s support to other major database systems.

FILTER clauseSQLSQLite
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Java Backend Technology
Java Backend Technology
Sep 17, 2022 · 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 other API changes, while comparing SQLite's capabilities to other major database systems.

Boolean LiteralsFILTER clauseSQL
0 likes · 11 min read
What New SQL Features Did SQLite Add in 2018?
Laravel Tech Community
Laravel Tech Community
Sep 7, 2022 · Databases

SQLite 3.39.3 Release Highlights: New JOIN Support, Binary Comparison Operators, and Performance Optimizations

SQLite 3.39.3, the latest version of the widely used embedded SQL database engine, introduces RIGHT and FULL OUTER JOIN support, new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM, additional APIs such as sqlite3_db_name, enhanced file‑name handling, HAVING clause for aggregates, and overall CPU optimizations reducing cycles by about 2.3%.

APIsDatabase EngineRelease Notes
0 likes · 2 min read
SQLite 3.39.3 Release Highlights: New JOIN Support, Binary Comparison Operators, and Performance Optimizations
WeChat Client Technology Team
WeChat Client Technology Team
Aug 30, 2022 · Databases

How WeChat Optimized Its Desktop Database for Speed, Size, and Reliability

This article analyzes the performance and storage problems of the Windows version of WeChat, explains why message growth causes slowness, large file size, and corruption risk, and presents a multi‑pronged solution involving sharding, indexing, payload compression, and robustness improvements that halve database size and boost I/O performance by about ten percent.

Database OptimizationSQLitecompression
0 likes · 11 min read
How WeChat Optimized Its Desktop Database for Speed, Size, and Reliability
Python Programming Learning Circle
Python Programming Learning Circle
Jul 30, 2022 · Backend Development

Python Web Scraping Tutorial: Crawling QDaily, Storing in SQLite, Analyzing Data and Generating a Word Cloud

This tutorial walks through building a simple Python web crawler for the QDaily website, covering target analysis, environment setup, SQLite database creation, data extraction with requests and BeautifulSoup, storing articles and comments, performing basic analysis, and visualizing results with a word cloud.

PythonSQLiteWeb Scraping
0 likes · 6 min read
Python Web Scraping Tutorial: Crawling QDaily, Storing in SQLite, Analyzing Data and Generating a Word Cloud
Open Source Linux
Open Source Linux
Jul 22, 2022 · 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 support, column renaming, and related API changes, while highlighting limitations and compatibility notes compared with other major databases.

Boolean LiteralsSQLSQL features
0 likes · 12 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Top Architect
Top Architect
Jul 21, 2022 · Databases

Overview of SQLite’s New SQL Features in 2018 (Versions 3.22.0–3.26.0)

The article explains SQLite’s 2018 enhancements—including boolean literals, window functions, FILTER clause, UPSERT syntax, and column‑renaming—detailing how these features work, their syntax, limitations, and providing code examples for developers seeking to use SQLite in production environments.

Database FeaturesFILTER clauseSQL
0 likes · 10 min read
Overview of SQLite’s New SQL Features in 2018 (Versions 3.22.0–3.26.0)
MaGe Linux Operations
MaGe Linux Operations
Jul 15, 2022 · Databases

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

SQLite, often underestimated, introduced several powerful SQL enhancements in 2018—including boolean literals, window functions, FILTER clauses, UPSERT syntax, and column renaming—bringing its capabilities closer to major RDBMSes while retaining its lightweight, file‑based design.

Boolean LiteralsDatabase FeaturesSQL
0 likes · 11 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Liangxu Linux
Liangxu Linux
Jul 14, 2022 · Databases

What New SQL Features Did SQLite Add in 2018?

This article reviews the 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 notes.

SQLSQLiteUpsert
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018?