phpLiteAdmin is an open source

Open source

The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...

 tool written in PHP

PHP

PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...

 intended to handle the administration of SQLite

SQLite

SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...

 over the World Wide Web. Its feature set, interface, and overall user experience is comparable to that of phpMyAdmin

PhpMyAdmin

phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and...

 for MySQL

MySQL

MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...

. In the same way that SQLite is a flat file database

Flat file database

A flat file database describes any of various means to encode a database model as a single file .- Overview :...

, phpLiteAdmin is distributed in the form of a single PHP file (currently approx. 100 KiB in size). Its ease of installation, portability, and small size go hand in hand with SQLite.

Features

• Lightweight - consists of a single source file
• Supports SQLite3 with Backward compatibility
  Backward compatibility
  In the context of telecommunications and computing, a device or technology is said to be backward or downward compatible if it can work with input generated by an older device...
  
   for SQLite2
• Add, delete, rename, empty, and drop tables
  Table (database)
  In relational databases and flat file databases, a table is a set of data elements that is organized using a model of vertical columns and horizontal rows. A table has a specified number of columns, but can have any number of rows...
  
  
• Browse, add, edit, and delete rows
  Row (database)
  In the context of a relational database, a row—also called a record or tuple—represents a single, implicitly structured data item in a table. In simple terms, a database table can be thought of as consisting of rows and columns or fields...
  
  
• Add, delete, and edit fields
  Field (computer science)
  In computer science, data that has several parts can be divided into fields. Relational databases arrange data as sets of database records, also called rows. Each record consists of several fields; the fields of all records form the columns....
  
  
• Manage table indexes
• Import and export tables, fields, indexes
  Index (database)
  A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and increased storage space...
  
  , and rows
• Search tool to find rows based on specified field values
• Create and run custom SQL
  SQL
  SQL is a programming language designed for managing data in relational database management systems ....
  
   queries in the free-form query editor
• Secure password-protected interface with login
  Login
  Login is the method whereby a user obtains access to a computer system.Login may also refer to:*Magazines:** LOGiN, published by Enterbrain** ;login:, published by USENIX* Login, Carmarthenshire, an hamlet in Carmarthenshire...
  
   screen
• Specify and manage an unlimited number of databases
• Customize the look and feel with CSS
  CSS
  -Computing:*Cascading Style Sheets, a language used to describe the style of document presentations in web development*Central Structure Store in the PHIGS 3D API*Closed source software, software that is not distributed with source code...
  
  

See also

• Comparison of database tools
  Comparison of database tools
  The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information...
  
  
• SQLite
  SQLite
  SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...
  
  
• phpMyAdmin
  PhpMyAdmin
  phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and...
  
  
• PHP
  PHP
  PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...