This article reviews the SQLite enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering Boolean literals, window functions, the FILTER clause, UPSERT syntax, column renaming, and related API changes, while comparing them to other major database systems.
SQLite, often underestimated, has added powerful SQL capabilities in 2018—including true/false literals, advanced boolean checks, window functions, FILTER clauses, upsert support via INSERT ON CONFLICT, and column renaming—bringing its feature set closer to major databases while retaining its lightweight, file‑based architecture.
The article walks through building a minimal SQLite‑style database in Go, covering memory‑disk page storage, B‑tree indexing, simple SQL parsing for INSERT and SELECT, row serialization, a pager that flushes pages, and a basic REPL, while highlighting current single‑page limits and future extensions.
SQLite version 3.38.0 introduces new JSON operators compatible with MySQL and PostgreSQL, built‑in JSON functions, added unixepoch() and auto/julianday modifiers for date/time, renamed printf() to format(), enhanced virtual table interfaces, CLI columnar output options, and query planner optimizations using Bloom filters and balanced merge trees.
This article details the 2021 overhaul of iOS WeChat's full‑text search, covering engine selection, segment‑merge optimization, a new VerbatimTokenizer, multi‑level separator support, table schema choices, asynchronous index updates, and extensive performance gains across chat, contacts, and favorites.
This article introduces the PrettyTable Python library, explains how to install it, demonstrates creating tables with headers, adding rows and columns, importing data from CSV, databases, or HTML, and shows various output formats and styling options for clear command‑line presentation.
This article details Youku’s practical experience developing HarmonyOS widgets, covering Ability packaging, mixed Android‑HarmonyOS builds, card UI designs, lifecycle callbacks, data fetching via WebView, local caching with SQLite, update strategies, and lessons learned for future mobile development on HarmonyOS.
This tutorial walks through setting up Python 2.7 on Ubuntu, then demonstrates how to install, connect to, and perform CRUD operations with four different databases—SQLite, MySQL, LMDB, and LevelDB—showing complete example scripts and summarizing the key differences between relational and key‑value stores.
This guide walks you through creating a client‑side static Wikipedia by downloading a dump, converting it to a SQLite database compiled to WebAssembly, and building a JavaScript front‑end that can be deployed on any static‑file host.
Discover how althttpd, the minimalist C‑based web server created by SQLite’s author Richard Hipp, powers the high‑traffic SQLite.org site with minimal resources, its simple design philosophy, low‑cost hardware usage, and why it makes an excellent learning project for developers.
A programmer needed to create a billion‑row SQLite test database within a minute, found a naïve Python script unbearably slow, applied batch inserts and SQLite PRAGMA tweaks, then compared CPython, PyPy, and Rust implementations, ultimately achieving sub‑minute runtimes with Rust and highlighting best‑practice optimizations.
This guide demonstrates two methods to reset the Grafana admin password: directly editing the SQLite database file with SQL commands and using the grafana-cli tool, including all required shell commands and screenshots.
This guide explains Go’s built‑in testing framework, assertion libraries, table‑driven and sub‑tests, and demonstrates how to mock functions, structs, interfaces, databases, and Redis using tools such as ngmock, gomock, sqlmock and miniredis, while covering test setup, teardown, coverage handling, and best‑practice insights.
The article recounts how Richard Hipp created SQLite—a tiny, fully embedded 900 KB database written in a single C file—that now powers billions of devices, and how his later Althttpd web server handles hundreds of thousands of requests daily, illustrating his prolific open‑source legacy.
This guide walks you through installing SQLite, using a graphical management tool, understanding its data types and keywords, and performing core database operations such as creating, viewing, exporting, attaching, and detaching databases, all with practical command‑line examples and screenshots.
This article provides a comprehensive, step‑by‑step guide to SQLite, covering table creation, deletion, data manipulation, queries, index management, view creation, trigger usage, and transaction control, complete with code examples and illustrative screenshots for developers of all levels.
This article explains how enterprises can evaluate their needs and compare four popular open‑source relational databases—MySQL, PostgreSQL, MariaDB, and SQLite—covering licensing, performance, language support, strengths, and limitations to guide an informed selection.
When selecting an open‑source database, enterprises must assess their specific data needs, understand licensing differences, and weigh the strengths and weaknesses of popular options such as MySQL, PostgreSQL, MariaDB, and SQLite, as this guide details.
This article walks through using Google’s Room ORM in an Android project to create a SQLite database, define entities and DAOs, set up a singleton database instance, and implement add, query, fuzzy search, and delete operations via a simple UI.
This article explains how iOS obtains the night‑mode launch image by analyzing the naming pattern of cached images, inspecting the SQLite‑based applicationState.db file, extracting the XBApplicationSnapshotManifest entry, and reconstructing the actual image path using system‑level data structures.
This guide demonstrates how to extract a macOS Chrome user's browsing URLs and timestamps from the History SQLite database, save them to a text file, and automatically email the file daily using Python scripts, a shell wrapper, and a crontab scheduled task.
This tutorial walks Python developers through using the built‑in sqlite3 library to create, query, and manage SQLite databases, demonstrates how to connect with SQL clients like DBeaver, and shows seamless integration with Pandas data frames for advanced data handling.
The article presents Sponsor, a lightweight ORM‑style wrapper for Android’s native SQLite that uses runtime annotations and dynamic proxies to generate Retrofit‑like, type‑safe CRUD APIs, automatically handling table creation, upgrades, and threading while keeping performance overhead negligible for SDK developers.
SQLite 3.32.0, the latest release of the world’s most widely used database engine, introduces approximate ANALYZE support, a bytecode virtual table, new SQL functions, expanded parameter limits, numerous CLI enhancements, and behavior changes that align the LIKE operator with PostgreSQL, offering developers richer functionality and improved compatibility.
This guide shows how to generate hourly slow‑query reports from MySQL slow‑log files by using pt‑query‑digest’s timeline feature, filtering with sed, importing the data into SQLite with termsql, and then querying the results to identify hotspot periods and recurring patterns.
This article explains what SQL injection is, demonstrates a SQLite example that injects malicious code to drop a table, and then shows how to prevent such attacks using parameterized queries, input validation, and secure coding practices.
This article explains what SQL injection is, demonstrates a vulnerable SQLite example that drops a table using malicious input, shows why the attack works, and provides practical prevention techniques such as using parameterized queries, input validation, unpredictable table names, and regular backups to secure databases.
This tutorial walks through creating a web‑based server monitoring tool that tracks CPU load and disk usage, using Vue.js with Element UI and Echarts for the frontend and a Python Flask backend with SQLite for data storage and API delivery.
This article explains how to handle high‑concurrency instant‑messaging scenarios by designing message deduplication, optimizing SQLite write performance with batch inserts and WAL mode, improving query speed with indexes and caching, and reducing UI refresh overhead through delayed and scroll‑aware updates.
This guide walks through using Python's requests and BeautifulSoup libraries to simulate Zhihu login, extract user profiles, retrieve answer likers, download avatars, fetch all answers for a question, and store the collected data in a SQLite database.
This article explains how to build a Python‑based Dash web application that parses Chrome's SQLite history file, extracts URLs, visit counts and timestamps, and visualizes the data with Plotly charts, covering project structure, key functions, file handling, and deployment steps.
This article examines Kotlin Multiplatform's evolution, detailing native compilation, cinterop bindings, platform libraries, bidirectional Swift/Objective‑C interop, and practical cross‑platform implementations for logging, file I/O, and SQLite, while outlining future directions and tooling recommendations.
This article explains how Android applications can create and use SQLite databases—including custom file paths and no‑Context scenarios such as UIAutomator tests—by detailing standard SQLiteOpenHelper usage, source‑code analysis, and three methods for customizing database locations.
This article compares SQLite, MySQL, and PostgreSQL across architecture, features, scalability, use cases, and limitations, helping developers choose the most suitable relational database for their specific application requirements.
This article introduces SQLiteLint, a runtime analysis tool that automatically checks SQLite usage in mobile apps for index problems, redundant indexes, SELECT *, AUTOINCREMENT, missing prepared statements, and without‑rowid opportunities, enabling developers to catch performance issues before release.
This article walks through creating a Python web crawler for Zhihu, covering simulated login, fetching user profiles, extracting answer likers, downloading avatars, gathering all answers for a question, and storing the collected data in a SQLite database.
This article explains how WeChat Android tackles the challenge of Chinese homograph full‑text search by using SQLite FTS5, comparing word‑based and character‑based indexing schemes, introducing a custom tokenizer, and detailing preprocessing and performance results.
An in‑depth look at SQLite’s Write‑Ahead Logging (WAL) mode and the asynchronous checkpoint optimization used in WeChat’s WCDB, covering implementation details, performance gains, A/B test results, and practical code examples for enabling these features on Android.
This guide walks through installing and using four Python‑compatible databases—SQLite, MySQL, LMDB, and LevelDB—covering environment setup, core APIs, common CRUD patterns, and complete runnable examples to help developers choose and operate each storage engine effectively.
This article provides a comprehensive guide to Android's Room persistence library, covering the creation of Entity classes, defining Data Access Objects (DAO), building the RoomDatabase, handling foreign keys, embedded objects, query methods, LiveData and RxJava return types, as well as database migrations and type converters for complex data types.
This article details how to create a simple Chinese pinyin input method using a Hidden Markov Model, training data from Jieba, storing probability matrices in SQLite, and implementing the Viterbi algorithm in Python, complete with code snippets and performance observations.
This article explains the principles of SQLite’s Full‑Text Search extension, details WeChat’s architecture for mobile search, and shares practical performance‑tuning techniques—including custom tokenizers, offset function improvements, and SQL‑level ranking—to achieve sub‑50 ms query times on billions of records.
This article compares FMDB and WCDB, detailing smooth migration steps, benchmark results showing WCDB's superior write and multithreaded performance, reduced code complexity, built‑in encryption, statistics and repair tools, and provides practical guidance for developers considering a database switch.
This article chronicles the development of WCDB, WeChat’s open‑source mobile database, detailing its early challenges, performance bottlenecks, security risks, concurrency improvements, cross‑platform collaboration, and future roadmap for a more reliable and efficient data layer on iOS and Android.
This article examines WCDB’s design principles for efficient, complete, and easy-to-use client-side databases, explains the pitfalls of SQL string concatenation such as code redundancy, debugging difficulty, and injection attacks, and describes how WCDB’s WINQ abstraction and ORM layer safely encapsulate SQLite syntax to enable concise, compile-time-checked queries.
This comprehensive SQLite tutorial walks beginners through what SQLite is, how to install it on Windows and Linux, essential syntax, CRUD operations, database objects, functions, and language-specific programming interfaces, providing step‑by‑step instructions and visual aids for practical mastery.
This article chronicles the development of WCDB, Tencent WeChat's open‑source mobile database, detailing its early platform challenges, performance and security improvements, cross‑platform collaboration, and future plans to enhance usability, speed, and reliability.
WeChat’s WCDB component tackles pervasive SQLite corruption on mobile devices by combining dump‑based, backup, and B‑tree parsing recovery methods, achieving up to 78% success while supporting encrypted databases, large data volumes, and seamless user experience.
This article provides a comprehensive overview of SQLite, covering its file‑based embedded architecture, type affinity, core components, supported data types, essential API functions, transaction management, and techniques for storing and retrieving binary data in embedded applications.
This article introduces WCDB, the official WeChat mobile database component, covering its architecture, ORM macros, WINQ integrated query, multithreaded high‑concurrency support, corruption repair, and advanced usage such as as‑redirection, chainable calls, and custom field binding for iOS/Mac development.
This article walks through building a Python web scraper for Zhihu, covering login simulation, extracting user profiles, answer likers, followers, avatars, and all answers of a question, and storing the collected data in SQLite, while highlighting challenges like captcha and anti‑scraping limits.
Facing a 0.02% SQLite corruption rate that threatened years of chat history, the WeChat mobile team identified three main causes—insufficient space, power loss, and sync failures—and implemented space management, full sync settings, and master‑table backups, halving damage and doubling repair success.
WeChat reduced its SQLite chat‑record corruption rate by over 50% by optimizing storage space, enforcing full file synchronization (including iOS fullfsync), and implementing a dual‑backup strategy for the master table with CRC checks and pre‑allocated space, dramatically improving repair success.
This tutorial demonstrates how to build a single, reusable SQLite library in Free Pascal using CodeTyphon, covering platform‑specific APIs, export conventions for Android, iOS, PC, and detailed compilation and usage examples across Android, iOS, macOS, Linux, and Windows.
This talk details how Tencent's iOS engineers tackled SQLite performance bottlenecks by redesigning multithreaded concurrency, optimizing Busy Retry handling, leveraging WAL and mmap, and applying low‑level I/O and lock improvements, resulting in dramatic reductions in UI lag and CPU waste for heavy‑use users.
This article explains how WeChat's iOS client tackled SQLite performance bottlenecks by introducing multi‑handle threading, enabling WAL mode, redesigning the Busy‑Retry mechanism, and applying I/O enhancements such as preserving WAL size and mmap usage, resulting in over 90% reduction in perceived lag.
This article explains SQLite's Virtual Database Engine (VDBE) architecture, its LR‑based grammar compilation using Lemon, compares it with Lua's virtual machine, and details the instruction set, execution flow, and stack versus register implementations.
This article introduces SQLite, a lightweight ACID‑compliant relational database widely used in mobile devices, detailing its zero‑configuration design, key features, limitations, transaction and locking mechanisms, and the Write‑Ahead Logging mode that enables concurrent reads and writes.
This article details a multi‑stage performance overhaul of a large‑scale chat application's SQLite database, covering trace‑based I/O analysis, view caching with Fragments, table‑splitting experiments, index size reduction, and the development of a PageTracer tool to quantify page‑level gains.
