About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 5 years ago
  • Total downloads: 388
  • Price: Free |
  • Operating system: Win All
  • Publisher: Richard Hipp
See full specifications

windows default iconSQLite3 Publisher's description

A command-line access program for SQLite databases

The SQLite library includes a small command-line utility SQLite3 that will allow you to manually enter and execute SQL commands against an SQLite3 database. This document provides a brief introduction on how to use sqlite3.

To start the SQLite3 program, just type "sqlite3" followed by the name the file that holds the SQLite database. If the file does not exist, a new one is created automatically. The SQLite3 program will then prompt you to enter SQL. Type in SQL statements (terminated by a semicolon), press "Enter" and the SQL will be executed.

What's New in This Release:

В· If a search token (on the right-hand side of the MATCH operator) in FTS4 begins with "^" then that token must be the first in its field of the document.
В· Added options SQLITE_DBSTATUS_CACHE_HIT and SQLITE_DBSTATUS_CACHE_MISS to the sqlite3_db_status() interface.
В· Removed support for SQLITE_ENABLE_STAT2, replacing it with the much more capable SQLITE_ENABLE_STAT3 option.
В· Enhancements to the sqlite3_analyzer utility program, including the --pageinfo and --stats options and support for multiplexed databases.
В· Enhance the sqlite3_data_count() interface so that it can be used to determine if SQLITE_DONE has been seen on the prepared statement.
В· Added the SQLITE_FCNTL_OVERWRITE file-control by which the SQLite core indicates to the VFS that the current transaction will overwrite the entire database file.
В· Increase the default lookaside memory allocator allocation size from 100 to 128 bytes.
В· Enhanced the query planner so that it can factor terms in and out of OR expressions in the ...

System Requirements:

No special requirements.
Program Release Status: Major Update
Program Install Support: Install and Uninstall

SQLite3 Tags:

Click on a tag to find related softwares

Is SQLite3 your software?

Manage your software

Most Popular

windows default icon Apache Tomcat 7.0.41
Apache Tomcat is an open source software implementation of the Java Servlet and JavaServer Pages technologies.... Read more
windows default icon WampServer 2.4
WampServer is a Windows web development environment.
windows default icon PS3 Media Server 1.81.0
PS3 Media Server is a DLNA compliant Upnp Media Server for the PS3, written in Java, with the purpose ... Read more
windows default icon TwonkyMedia Server 7.0.7
TwonkyServer makes it possible for your devices to retrieve your media files from wherever they're stored... Read more
windows default icon AnjLab.SqlProfiler 1.1.1423.75
The express edition of Microsoft SQL Server 2005/2008 is free.

Related Category

» FTP Servers (61)
» Mail Servers (122)
» News Servers (5)
» Web Servers (126)