Presentation
COM-SQL is an SQLite © database manager,
mainly intended for learning this database.
This application can also be useful for designing a new database and to define access requests to
this database.
SQLite © is a database, in public domain, stored in a file.
In addition, the SQL engine of SQLite © is simplified.
SQLite ©, because of its extreme lightness, is used on most smartphones and in many
free applications, like "Mozilla Firefox ©", most of the time to store the parameter
setting of the application, and in non-free software.
SQLite © is the most used database engine in the world.
You can use COM-SQL to:
- learn SQL
- explore the contents or the structure of an SQLite © file
- create your own SQLite © file
Major features
- SQLite © database management
- management of Tables (Fields, Index and Triggers)
- management of the Views (Triggers)
- data views of a table without join
- data views of a table with auto join on linked tables
- form to INSERT, UPDATE and DELETE line in a Table
- enter and execute your SQL requests
- explanation of selection requests
- help creating SELECT queries with JOIN and GROUP BY
- creation of FT4 or FTS5 full-text search table
- running multiple queries in a transaction
- management of table constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE and CHECK
- test the integrity of a database and the validity of foreign keys
- database cleaning and optimization
- Unicode support for data and entity names (tables, views, fields, indexes, triggers and constraints)
- access to all SQLite © PRAGMA functions
- read SQLite © internal tables: sqlite_master and sqlite_sequence
- PRAGMA table_info, PRAGMA index_list and PRAGMA foreign_key_list requests
- creation of fields EAN-8, EAN-13, Email, IBAN, IMEI, ISBN, ISSN, Latitude, Longitude, Payment card number, IPv4 & IPv6 addresses and URL
- administrative identifier fields by country (for example: VAT number, company number, and so on)
- AVG, COUNT, LIKE, MAX, MIN and SUM operation on a field
- creation of table iCal and vCard
- interface in three languages: english, french and spanish
Import/Export
- import and export of SQLite © database files
- import an SQL database file into
- import an iCal file in an iCal table
- import a vCard file in a vCard table
- dump of the databases (structure and/or data) in SQL
- export a table in C#, in CSV, in SQL or in XSD/XML
- export a view in CSV
- Unicode support for import and export
- export in DOT graph description language to obtain a diagram of the database tables
ETL (Extract-Transform-Load)
import a CSV file to a new table
export the results of a query into CSV file
export a table with filter to one or more CSV files
Integration with the Microsoft © webservices
- save/restore databases easily from/to OneDrive ©
- import/export an SQL database file from/to OneDrive ©
Video:
Available on the "Microsoft Store ©":
