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

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

Import/Export

  • import and export of SQLite © database files
  • import an SQL database file into
  • 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
  • export the results of a query into CSV file

Integration with the Microsoft © webservices

  • save/restore databases easily from/to OneDrive ©
  • import/export an SQL database file from/to OneDrive ©

Video:


Other videos: COM-SQL

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