SQLite 3.47.2 (32-bit)

SQLite 是一款嵌入式關聯式資料庫引擎，以程式庫形式整合進應用程式，提供完整 SQL 查詢能力，卻不需要獨立伺服器或任何設定。它最大的特色是零設定、免管理，資料庫就是一個檔案，且具備 ACID 交易保證，即使系統當機或斷電也能維持資料一致性。本軟體採用公共領域授權，任何商業或私人用途皆可自由使用，是全球部署最廣泛的資料庫之一，許多知名專案都內建它。目前更新相當活躍，近一年內多次釋出修正，在同類工具中屬於主流首選，使用者評價普遍不錯。

這套 32 位元版本特別適合在 Windows 環境下開發輕量級應用，或需要嵌入式資料儲存的情境，例如桌面程式、工具軟體或行動裝置的資料暫存。與 BlueStacks 或 VMware 等大型應用軟體不同，SQLite 是開發者導向的程式庫，取捨在於它不提供圖形介面或網路連線功能，但換來極低的資源占用與部署彈性。授權完全免費且無限制，不過僅提供英文介面，使用上需留意文件與操作皆為英文，對不熟悉 SQL 的初學者可能稍有門檻。

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

The code for SQLite 32bit is in the public domain and is thus free for use for any purpose, commercial or private.

The software is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.

Features and Highlights

• Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
• Zero-configuration - no setup or administration needed.
• Full SQL implementation with advanced features like partial indexes and common table expressions. (Omitted features)
• A complete database is stored in a single cross-platform disk file. Great for use as an application file format.
• Supports terabyte-sized databases and gigabyte-sized strings and blobs.
• Small code footprint: less than 500KiB fully configured or much less with optional features omitted.
• Simple, easy to use API.
• Written in ANSI-C. TCL bindings included. Bindings for dozens of other languages available separately.
• Well-commented source code with 100% branch test coverage.
• Available as a single ANSI-C source-code file that is easy to compile and hence is easy to add to a larger project.
• Self-contained: no external dependencies.
• Cross-platform: Android, *BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows (Win32, WinCE, WinRT) are supported out of the box. Easy to port to other systems.
• Sources are in the public domain. Use it for any purpose.
• It comes with a standalone command-line interface (CLI) client that can be used to administer SQ Lite databases.

How to Use

• Download SQLite (32-bit) from the official website
• Extract the downloaded ZIP file to a preferred location
• Open the Command Prompt and navigate to the SQLite folder
• Run sqlite3.exe to start the SQLite shell
• Create a new database using sqlite3 database_name.db
• Use SQL commands to create tables and insert data
• Query the database using SELECT statements
• Export data with .mode csv and .output filename.csv
• Close the database with .exit or Ctrl + Z

System Requirements

• Operating System: Windows 7, 8, 10, 11 (32-bit)
• Processor: Intel or AMD, 1 GHz or faster
• RAM: 512 MB minimum, 2 GB recommended
• Storage: At least 5 MB free space
• Additional: Command Prompt or compatible terminal

PROS

• Lightweight and fast
• No installation required
• Cross-platform compatibility
• Easy to use with simple commands
• Free and open-source

CONS

• Not ideal for large-scale databases
• Limited concurrent write access
• Lacks built-in user authentication
• No client-server architecture
• Performance issues with high data load

Also Available: SQLite (64-bit) and SQLite for Mac

Download SQLite (32-bit) Latest Version Why is this app published on FileHorse? (More info)