COM-SQLite
App details
About COM-SQLite
COM-SQLite is a SQLite © management application, essentially intended for learning this database.
This application can also be useful for designing a new database and for defining queries to this database.
You can use COM-SQLite to explore the content or structure of an SQLite © file.
SQLite © is a public domain database stored in a file. Moreover, the SQL engine of SQLite © is simplified. SQLite ©, given its extreme lightness, is used on most smartphones and in many free software, such as “Mozilla Firefox ©”, most of the time to store software settings, and also in non-free software.
SQLite © is also used by “Microsoft Store ©” applications.
SQLite ©’s slogan is “Small. Fast. Reliable". And, logically, SQLite © has become the most widely used database engine in the world.
COM-SQLite is available: in English, Spanish and French.
Key features
-
SQLite database management
-
Management of Tables (Fields, Index and Triggers)
-
Management of the Views (Triggers)
-
Forms to INSERT, UPDATE or DELETE a line in a Table
-
Enter and execute your SQL requests
-
Import and export of SQLite database files
-
Explanation of the SELECT requests
-
Dump of the databases (structure and/or data)
-
Enter and execute several SQL requests in a transaction
-
Export a table in CSV, in SQL or in XSD/XML
-
Export a view in CSV
-
Export the results of a query into CSV file
-
Importing a database file in SQL
-
Support of table constraints : PRIMARY KEY, FOREIGN KEY, CHECK, UNIQUE
-
Unicode support for data and entity names (tables, views, fields, indexes, triggers and constraints) and for import/export
-
Interface customization