COM-SQL

COM-SQL

Microsoft Store ©
  • Home page
  • Tables management
  • Manage fields of a table
  • Views management
  • Data management of a table
  • Display data of a table with data of linked tables
  • SQL requests
  • SQL transaction
  • Interface customization

Presentation

COM-SQL is an SQLite © database manager.
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.

You can use COM-SQL to:

  • learn SQL
  • explore the contents or the structure of an SQLite © file
  • create your own SQLite © file

Main 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 the selection requests
  • 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
  • creation of fields Email, Latitude, Longitude and URL
  • AVG, 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 CSV, in SQL or in XSD/XML
  • export a view in CSV
  • Unicode support for import and export

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 ©":

Get it from Microsoft ©

Our other applications

COM-ADD also offers you the following applications:

COM-CRM Pro

C.R.M. solution for small structures

COM-DOC

Document management solution for small structures

COM-MAP Top

Mapping application for professionals

COM-SCAN

Optical Character Recognition and barcode application