0 views collected around this technical thread.
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.
This guide explains how to access Android SQLite databases via adb shell sqlite3, create and run complex shell scripts, and manage app permissions and users through ADB commands, providing practical examples for debugging and automation.
The article explains why the widely embedded SQLite database relies on the Fossil version‑control system rather than Git, highlighting Fossil’s simplicity, better situational awareness, lower management overhead, and more suitable user experience for SQLite’s needs.
This article introduces ten common Python database interaction patterns—from basic CRUD operations and table creation to advanced transaction handling, batch inserts, and stored procedures—culminating in a complete user‑registration system example that demonstrates how to combine these techniques effectively.
This guide demonstrates how to read and write common file types—including TXT, CSV, JSON, XML, Excel, YAML, Parquet, and HDF5—as well as how to connect to SQLite databases and perform web scraping using Python's standard libraries and popular third‑party packages.
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.
This guide explains how to embed SQLite in browser‑based applications using sql.js, covering npm and CDN loading methods, configuration for bundlers, database creation, query execution, import/export techniques, persistent storage, and Node/Electron usage with detailed code examples.
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.
This article recounts how SQLite was created by Richard Hipp to solve reliability issues on a U.S. Navy destroyer, evolved from a simple file‑based engine into an open‑source, B‑Tree powered embedded database that now powers billions of devices, smartphones, browsers, and applications worldwide.
This article reviews the SQL enhancements added to SQLite between versions 3.22.0 and 3.26.0, covering boolean literals, window functions, the FILTER clause, INSERT … ON CONFLICT (upsert), column renaming, and related API updates.
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.
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.
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.
This article presents a collection of reusable Python utility interfaces—including data validation, HTTP request handling, file read/write, JSON parsing, date‑time formatting, symmetric encryption, SQLite persistence, image resizing, exception handling, and configuration loading—each illustrated with concise code examples to improve code readability and testability.
This article presents a collection of reusable Python utility interfaces—including data validation, HTTP request handling, file read/write, JSON parsing, date‑time formatting, symmetric encryption, SQLite persistence, image resizing, exception handling, and configuration loading—each illustrated with concise code examples to improve code readability and testability.
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.
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.
Despite powering the modern internet, essential software like the TZ time zone database and SQLite are maintained by just a handful of volunteers, highlighting the fragility of critical infrastructure and the insufficient financial support from large corporations.
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.
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.