COM-SQL COM-SQL v3.4 Help

 

 

Presentation

COM-SQL is a SQLite database manager. SQLite is a database, in public domain, stored in a file. In addition, SQL engine of SQLite is simplified. SQLite is used in many free application, like "Mozilla Firefox”, most of the time to store the parameter setting of the application.

You can use COM-SQL to:

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

SQLite is also managed by "Windows Store” applications.

COM-CRM is bilingual: French and English.

Note: SQLite is a light database and relatively limited, if you have more important needs turn to database servers!

Note: For more information on SQLite, please visit the website: www.sqlite.org.

 

Advertising

 

Minimal configuration required

Operating System

Windows 10

Display

800 x 480 pixels

RAM memory

1 Gb

Disk space necessary to the installation

10 Mb

Required

Internet connection

 

 

Installation

It is necessary to install COM-SQL from the "Windows Store" and to follow the instructions on the screen.

 

To uninstall the program, in the "Windows 10" main menu, right-click on the app icon, a menu appears, it is necessary to click on the uninstall button.
Warning: In the event of uninstallation, all the application databases will be lost.

 

 

Files association

The application COM-SQL can be associated with the "*.db" and "*.sqlite" files types, it is possible, while clicking on a file of this type, to open the application automatically and to import the file in it.

 

 

Run the application

To run the application, click on "COM-SQL" icon, in the main menu of "Windows 10".

Then the principal window of the application appears on the home page. This page presents a dashboard with a drop-down list of all your databases. You can select a database and have information on the number of tables in this database. The application has a principal menu at the top of the page.

 

 

Main menu

The main menu comprises the following items

¤ " Files "

¤ " Manage "

¤ " Setting "

¤ " Help "

 

 

" Files " menu

 

This menu comprises the following items:

¤ " New database file "

¤ " Delete this file "

¤ " Database dump to SQL "

¤ " Import a file "

¤ " Export this database "

 

 

" Files / New database file "

This option gives access to a form which allows to enter the name of the database file to be created.

Note: You cannot use a file name which was already be used.

 

 

" Files / Delete this file "

This option allows to delete the database file selected on the homepage.

Note: The deletion of the file is definitive. If you do not wish to lose your data, you can make a backup copy via the menu "Export this database" (see further).

 

 

" Manage / Database dump to SQL "

This functionality allows to realize the extraction of the database to SQL format (the technical term is "Dump"). The SQL commands are copied in a "*.sql" file. The choice should be made between the extraction of the structure of the table (CREATE commands), the data (INSERT commands) or the structure and the data.

Note: If the database is large, this may take several minutes.

 

 

" Manage / Import a file "

This option ask you to select a "SQLITE 3" file having for extension *.db, *.db3, *.sqlite or *.sqlite3. The selected file will be copied in an internal folder of the COM-SQL application. You will be able then to select it in the home page of COM-SQL and to manage its structure and its data.

Note: As indicated the selected file is recopied by COM-SQL. The file that you indicated will not be thus by not be affected by the possible modifications which you will realize in his structure or its data.

 

 

" Manage / Export this database "

This option allows to recopy the selected database in the folder which you wish.

Note: As indicated the selected database is recopied by COM-SQL. The database managed by COM-SQL thus neither will be modified, nor removed.

 

 

" Manage " menu

 

This menu comprises the following items:

¤ " SQL requester "

¤ " SQL transaction "

¤ " Tables "

¤ " Views "

 

 

" Manage / SQL requester "

This option allows to enter SQL requests which will be executed on the current database. The queries can be of any type, as much selection requests (SELECT) that action requests (ALTER, CREATE, DELETE, DROP, INSERT, UPDATE, and so on).

Note: It should run only one query at a time.

Note: In the event of selection, table result is displayed under the request.

Note: For selection requests (SELECT) on tables containing many records, the application displays only the first 20 records. And it recommends to use the LIMIT and OFFSET directives to reduce the size of the displayed result and speed up processing.

Note: A history of the requests is constituted and it is accessible via a drop-down list placed above the field containing the request.

 

 

" Manage / SQL transaction "

This option lets you enter multiple SQL queries that will be run in a transaction.

Note: Following the principles of SQL transactions, if a query of the transaction fails, the entire transaction is canceled however if all the requests of the transaction are successful, the transaction is committed.

 

 

" Manage / Tables "

This option allows to manage the tables of the selected database. The tables are presented in a drop-down list, each line comprising the name and the number of fields of the table.

This menu comprises the following items:

¤ " Create a table "

¤ " Edit this table "

¤ " Delete this table "

¤ " Manage / Fields "

¤ " Manage / Indexes "

¤ " Manage / Triggers "

¤ " Manage / Data "

¤ " Manage / Export table to CSV "

¤ " Manage / Export table to SQL "

 

 

" Manage / Tables / Create a table "

This option allows to create a new table via a form requiring the name of the new table.

Note: You cannot use a name of table already used.

Note: By default, the table is created with a field named rowid which is of type INTEGER and which is a primary key with auto-increment. If this field is not appropriate to you it is possible to delete it a posteriori. You can also use a SQL request such as  CREATE TABLE in the menu "Manage / SQL requester" (see higher).

 

 

" Manage / Tables / Edit this table "

This option allows to rename an existing table.

Note: You cannot use a name of table already used.

 

 

" Manage / Tables / Delete this table "

This option allows to delete an existing table.

Note: The suppression is definitive, all the records of this table will be definitively lost.

 

 

" Manage / Tables / Manage / Fields "

This option allows to manage the fields of the selected table.

This menu comprises the following items:

¤ " Create a field "

¤ " Edit this field "

¤ " Delete this field "

 

 

" Manage / Tables / Manage / Fields / Create a field "

This option allows to create a field in the selected table. You must specify: the name of the field, the type of the field, possibly the length of the field, if the value NULL is accepted, if it is a primary key, if it is auto-increment, if there is a default value and if it is a foreign key (by selecting the table and the pointed field).

Notes: The length of the field must be indicated for types CHAR, VARCHAR and NVARCHAR.
In the case of a field of the CHAR, TEXT, VARCHAR or NVARCHAR type, the default value must be surrounded by two single quotes.

Note: If you to try to create a NOT NULL field, without providing a default value, the error message "Cannot add a NOT NULL  column with default value NULL!" appears.
A solution to avoid this problem is to create a NULL field, then to modify it in NOT NULL, via the modification form of the field.

 

 

" Manage / Tables / Manage / Fields / Edit this field "

This option allows to modify a field of the selected table. The form is identical to that of creation but it is not possible to modify the type and the length of the field.

Notes: In the case of a field of the CHAR, TEXT, VARCHAR or NVARCHAR type, the default value must be surrounded by two single quotes. A priori, the modification of the field should not affect the data stored for this field.

 

 

" Manage / Tables / Manage / Fields / Delete this field "

This option allows to delete a field of the selected table.

Note: The deletion of this field is definitive, all the data of this field will be lost.

 

 

" Manage / Tables / Manage / Indexes "

This menu comprises the following items:

¤ " Create un index "

¤ " Edit this index "

¤ " Delete this index "

 

 

" Manage / Tables / Manage / Indexes / Create un index "

This option allows to create an index for the selected table. A form allows to indicate the name of the index, the unicity and fields of the index with the possible value of sorting (ASC or DESC) and the possible compare value (BINARY or NOCASE).

 

 

" Manage / Tables / Manage / Indexes / Edit this index "

This option allows to modify the selected index. The form of modification is identical to that of creation.

 

 

" Manage / Tables / Manage / Indexes / Delete this index "

This option allows to delete the selected index.

Note: The deletion of this index is definitive.

 

 

" Manage / Tables / Manage / Triggers "

This menu comprises the following items:

¤ " Create a trigger "

¤ " Delete this trigger "

 

 

" Manage / Tables / Manage / Triggers / Create a trigger "

This option allows to create a trigger for the selected table. A form allows to indicate the name of the trigger, the event (WHEN), the action (ACTION), if the action is for each row (FOR EACH ROW) and the SQL request to execute.

 

 

" Manage / Tables / Manage / Triggers / Delete this trigger "

This option allows to delete the selected trigger.

Note: The deletion of this trigger is definitive.

 

 

" Manage / Tables / Manage / Data "

This option allows to display the list of the data, for all the fields, of the table, in a data-grid.

Note: The SQL request executed is of the following type: SELECT * FROM table LIMIT 20 OFSSET n. A pagination system allows to explore the whole table without penalizing performance.

This menu comprises the following items:

¤ " Insert "

¤ " Update "

¤ " Delete "

 

 

" Manage / Tables / Manage / Data / Insert "

This option allows to insert a line in the selected table (thanks to the SQL command: INSERT).

 

 

" Manage / Tables / Manage / Data / Update "

This option allows, after selection of a line in the data-grid, to update the corresponding line (thanks to the SQL command: UPDATE).

 

 

" Manage / Tables / Manage / Data / Delete "

This option allows, after selection of a line in the data-grid, to delete this line (thanks to the SQL command: DELETE).

 

 

" Manage / Tables / Manage / Export table to CSV "

This option allows to export a table to CSV.

 

 

" Manage / Tables / Manage / Export table to SQL "

This option allows to export a table (structure, data or both) to SQL.

 

 

" Manage / Views "

This menu comprises the following items:

¤ " Create a view "

¤ " Edit this view "

¤ " Delete this view "

¤ " Manage / Triggers "

¤ " Manage / Data "

 

 

" Manage / Views / Create a view "

This option allows to create a view. A form asks to indicate the name of the view and the SQL code of selection.

Note: You cannot use a name of view already used.

 

 

" Manage / Views / Edit this view "

This option allows to modify a view. The form is identical to that of creation.

Note: You cannot use a name of view already used.

 

 

" Manage / Views / Delete this view "

This option allows to delete a view.

Note: The deletion of the view is definitive.

 

 

" Manage / Views / Manage / Triggers "

This menu comprises the following items:

¤ " Create a trigger "

¤ " Delete this trigger "

 

 

" Manage / Views / Manage / Triggers / Create a trigger "

This option allows to create a trigger for the selected table. A form allows to indicate the name of the trigger, the event (WHEN who can be only INSTEAD OF for a view), the action (ACTION), if the action is for each row (FOR EACH ROW) and the SQL request to execute.

 

 

" Manage / Views / Manage / Triggers / Delete this trigger "

This option allows to delete the selected trigger.

Note: The deletion of this trigger is definitive.

 

 

" Manage / Views / Manage / Data "

This option allows to display the list of the data, of the view, in a data-grid.

Note: The SQL request executed is of the following type: SELECT * FROM view LIMIT 20 OFSSET n. A pagination system allows to explore the whole view without penalizing performance.

 

 

" Setting " menu

This menu comprises the following item:

¤ " Language "

 

 

" Setting / Language "

This option gives access to a page which allows to change the language of the user interface (English or French).

 

 

" Help " menu

This menu comprises the following item:

¤ " Report a bug "

 

 

Report a bug

The menu "Help / Report a bug" allows you to announce a bug found in the application. Your default email application is started for sending an e-mail to us.

Note: Before announcing a bug, we invite you to read this documentation with attention, to see whether your problem is not a simple error of use.

 

 

COM-SQL - COM-ADD