Скачать бесплатно SQLite 3.10.2

Версия:	3.10.2
Разработчик:	SQLite
Операционка:	Windows 7 / 8 / XP / Vista
Обновление:	14.04.2016
Русский язык:	Нет

Скачать бесплатно SQLite 3.10.2

SQLite – небольшая кросплатформенная библиотека, включающая в себя полноценный изолированный транзакционный движок, поддерживающий основный набор функций и возможностей по работе cо встраиваемыми базами данных типа SQL. Они используются повсеместно, начиная от ведения учета на небольших предприятиях и обеспечения работы простых сайтов, заканчивая поддержанием функционирования крупных промышленных комплексов и мобильных гаджетов. Скачать SQLite вместе с ее исходным кодом можно бесплатно, например, с нашего сайта.

Главная особенность программы – отсутствие необходимости проводить инсталляцию сервера, служб, их настройку и запуск для работы с БД. Не нужно также создавать новую базу данных – все это интегрировано в SQLite в виде динамических библиотек (dll-файлов).

Очередным преимуществом SQLite является транзакционность – последовательная обработка информации по частям: пока работа с одной частью не завершится успешно, другие действия не выполняются. Эта особенность SQLite позволит избежать проблем при возникновении неполадок или прерыванию работы (случайная перезагрузка компьютера или отключение от сети).

В отличие от большинства подобных продуктов, SQLite работает с хранимыми на жестком диске файлами напрямую. Готовая база данных со связанными таблицами и индексами хранится в одном файле.

Перед очередным релизом SQLite проходит многомилионные автоматические тесты, с которыми без проблем справляется с результатом в 100% для всех мобильных и стационарных платформ.

Для пользователей, знающих язык программирования C, предлагается скачать исходный код SQLite и скомпилировать из него программу с требуемым функционалом, удалив все лишние функции, вследствие чего размер утилиты может равняться 500 и даже 300 КБ.

SQLite (64-bit)

SQLite 3.35.4 (64-bit) LATEST

Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64

SQLite (64-bit) 2021 full offline installer setup for PC

SQLite 64-bit is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for the software is in the public domain and is thus free for use for any purpose, commercial or private. Download SQLite Offline Installer Setup 64bit for Windows PC! SQLite 64-bit 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.

Also Available: Download SQLite for Mac

How to Install Sqlite3 on Windows 10

Sqlite is a serverless relational database management system, what we called as an embedded database. It is very lightweight and very easy to use. In this article we are going to see how to install sqlite database on Microsoft windows 10 operating system.

Sqlite3 installation file for windows 10 is a zip file, which contains the sqlite3.exe. What we have to do is Download and extract zip file to hard drive, then access the sqlite3.exe from the windows 10 command line.

Download sqlite3 for Windows 10

Go to sqlite3 download page and download the sqlite-tools zip file to your hardrive(Under the Precompiled Binaries for Windows).

Once you extract the zip file, you will find sqlite3.exe file, which is the command line shell we use to create and manage sqlite databases.

Create sqlite3 folder inside C Drive

Now create a folder called sqlite3 inside the C drive and copy the sqlite3.exe file to the folder you created.

Basically that’s all we have to do. We can now create sqlite databases using windows command prompt by moving to C:\sqlite3 directory.

Example : Create sqlite database and table.

To create a database first open the Windows 10 command prompt(Start menu > All Apps > Windows System > Command Prompt). Then move to the C:\sqlite3 folder using cd command.

Then use the sqlite3 command followed by the name of the database to create a database.

It is not necessary to use .db extension to the database name. You can put any extension you want or if you want, you can create the database without extension.

Add Sqlite3 to Windows Path Variable

There is one more thing we could do. We can add sqlite to the Windows PATH variable, even though it is not essential. If we add Sqlite to the Windows 10 PATH variable we can access the sqlite3 command without moving to the C:\sqlite3 folder.

• Open Advanced System Properties ( Control Panel > System and Security > System > Advanced System Settings).
• Click Environment Variables.
• Under the system variables, Select the PATH variable and click edit.
• Append ;C:\sqlite3 at the end of the value and click ok(Do not forget the semicolon).

A Sqlite database is a one single file, which you can move to anywhere in your computer. Also you can move a database from one operating system to another without any problem.

Sqlite download windows 10

SQLite Download Page

Source Code
sqlite-amalgamation-3350400.zip (2.35 MiB)	C source code as an amalgamation, version 3.35.4. (sha3: 8c91c8f6a893a208059ede1803a0ace6da3c7faeaf72395a28458c0256059f0f)
sqlite-autoconf-3350400.tar.gz (2.82 MiB)	C source code as an amalgamation. Also includes a «configure» script and TEA makefiles for the TCL Interface. (sha3: de6bf86326ca33b55ea455e7499ddf8f8dd2a94005f70351284465db544c35e0)
Documentation
sqlite-doc-3350400.zip (9.73 MiB)	Documentation as a bundle of static HTML files. (sha3: ad45b2358acc34e43c85f5fe8c774e53ac6807e2a996ca374d558f1ae49a4782)
Precompiled Binaries for Android
sqlite-android-3350400.aar (3.12 MiB)	A precompiled Android library containing the core SQLite together with appropriate Java bindings, ready to drop into any Android Studio project. (sha3: 30a840e39920c3f232e8e739669e73cdfa6312c3408782b6522104e1239fadbe)
Precompiled Binaries for Linux
sqlite-tools-linux-x86-3350400.zip (2.06 MiB)	A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff program, and the sqlite3_analyzer program. (sha3: 4f1c553e03a9b9874909e13999e3bac0cf3b70c5aebaecb0ac5f172718ac0b93)
Precompiled Binaries for Mac OS X (x86)
sqlite-tools-osx-x86-3350400.zip (1.42 MiB)	A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff program, and the sqlite3_analyzer program. (sha3: cd5729d0939813a7abcff13227ebec41be258f29d63bd81b863658bb0c4c29a1)
Precompiled Binaries for Windows
sqlite-dll-win32-x86-3350400.zip (538.67 KiB)	32-bit DLL (x86) for SQLite version 3.35.4. (sha3: 22c620d686b0d4393489443cac2b5b550b5c2bf8c0d5b58017d2a66484abef4f)
sqlite-dll-win64-x64-3350400.zip (879.80 KiB)	64-bit DLL (x64) for SQLite version 3.35.4. (sha3: 8373387d25a117593de97b5de61d8c3fd5201ae788cb5d659f429c3543612f74)
sqlite-tools-win32-x86-3350400.zip (1.81 MiB)	A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exe program, and the sqlite3_analyzer.exe program. (sha3: 804c4c83a45c95d657269f792833c2de47deab66bea77d7f129321bf44387c09)
Universal Windows Platform
sqlite-uwp-3350400.vsix (7.81 MiB)	VSIX package for Universal Windows Platform development using Visual Studio 2015. (sha3: b70a2df4ecc2d9e63c16d793c84963fa86ec0a4f28aa759a9b43b83c15652318)
Precompiled Binaries for Windows Phone 8
sqlite-wp80-winrt-3350400.vsix (5.07 MiB)	A complete VSIX package with an extension SDK and all other components needed to use SQLite for application development with Visual Studio 2012 targeting Windows Phone 8.0. (sha3: faabb9e8c9735b4500aea4674cb7a045f5f33d3c66f7247de9b7db1ba5faf4f1)
sqlite-wp81-winrt-3350400.vsix (5.12 MiB)	A complete VSIX package with an extension SDK and all other components needed to use SQLite for application development with Visual Studio 2013 targeting Windows Phone 8.1. (sha3: e8f89255e1d47949eb6f5e08ff7703c1779c7d9d73b5eef82c910f63d9f5fcad)
Precompiled Binaries for Windows Runtime
sqlite-winrt-3350400.vsix (7.70 MiB)	A complete VSIX package with an extension SDK and all other components needed to use SQLite for WinRT application development with Visual Studio 2012. (sha3: f6424a26c4dea970c7cd76b20faf54b837ae76261f93395e2db75da69e17c57b)
sqlite-winrt81-3350400.vsix (7.71 MiB)	A complete VSIX package with an extension SDK and all other components needed to use SQLite for WinRT 8.1 application development with Visual Studio 2013. (sha3: e19e89ef0a366d25c8f7fe39135bc4cb08f975cc9c92e00f4dac5a04ef78062a)
Precompiled Binaries for .NET
System.Data.SQLite	Visit the System.Data.SQLite.org website and especially the download page for source code and binaries of SQLite for .NET.
Alternative Source Code Formats
sqlite-src-3350400.zip (12.22 MiB)	Snapshot of the complete (raw) source tree for SQLite version 3.35.4. See How To Compile SQLite for usage details. (sha3: ea32040cc8c7fe43464a0e7035bd8a478640154721be6f6451a63f99c9227d68)
sqlite-preprocessed-3350400.zip (2.56 MiB)	Preprocessed C sources for SQLite version 3.35.4. (sha3: 3f9e2adcde8b7d2fae5097fede9e6b6c2d37a31ec041d58586378f595db46341)

Build Product Names

Build products are named using one of the following templates:

1. sqlite-product—version.zip
2. sqlite-product—version.tar.gz
3. sqlite-product—os—cpu—version.zip
4. sqlite-product—date.zip

Templates (1) and (2) are used for source-code products. Template (1) is used for generic source-code products and templates (2) is used for source-code products that are generally only useful on unix-like platforms. Template (3) is used for precompiled binaries products. Template (4) is used for unofficial pre-release «snapshots» of source code.

The version is encoded so that filenames sort in order of increasing version number when viewed using «ls». For version 3.X.Y the filename encoding is 3XXYY00. For branch version 3.X.Y.Z, the encoding is 3XXYYZZ.

The date in template (4) is of the form: YYYYMMDDHHMM

Source Code Repositories

The SQLite source code is maintained in three geographically-dispersed self-synchronizing Fossil repositories that are available for anonymous read-only access. Anyone can view the repository contents and download historical versions of individual files or ZIP archives of historical check-ins. You can also clone the entire repository.

See the How To Compile SQLite page for additional information on how to use the raw SQLite source code. Note that a recent version of Tcl is required in order to build from the repository sources. The amalgamation source code files (the «sqlite3.c» and «sqlite3.h» files) build products and are not contained in raw source code tree.

There is a GitHub mirror at

The documentation is maintained in separate Fossil repositories located at: