Description
COM-SQL 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-SQL 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-SQL is available: in English, Spanish and French.
-
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 your 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
-
Import an SQL database file
-
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
-
Database cleaning and optimization
-
Interface customization
-
Creation of fields EAN-8, EAN-13, Email, Latitude, Longitude and URL
-
Export in DOT graph description language to obtain a diagram of the database tables
-
Creation of table iCal and vCard