# A5:SQL Mk-2

| Item      | Description                                                                         |
| --------- | ----------------------------------------------------------------------------------- |
| Software  | A5:SQL Mk-2 Version 2.21.0 release candidate 3                                                          |
| Author    | masakazu matsubara                                                                  |
| Target OS | x64 edition: Microsoft Windows Vista SP3 or Windows 7 or later, Microsoft Windows Server 2008 R2 or later<br>x86 edition: Microsoft Windows XP or later, Microsoft Windows Server 2003 or later<br>** x64 version can not be connected to 32 bit OLE DB, ODBC.<br>** x86 version can not connect to 64bit OLE DB, ODBC. |
| Category  | Business/Database related software                                                  |
| Contact   | Please access the URL below and send an email to the email address on the top page. |
| Website   | https://a5m2.mmatsubara.com/                                                        |

## Outline
A5:SQL Mk-2 is a free SQL development environment & ER diagram development tool developed to support database development that is complicated.  
It is developed with the goal of being highly functional and lightweight and easy to understand its usage.  
In addition to executing SQL and editing tables, it has various functions such as obtaining SQL execution plans and creating ER diagrams.  

## File Contents
The archive file contains the following files.

| File Name                 | Description                                                                                                                  |
| ------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| A5M2.exe                  | A5:SQL Mk-2 execution file.                                                                                                  |
| A5M2.ENU                  | English Language resource.                                                                                                   |
| A5M2.drc                  | Delphi resource string file (Files required when creating your own language resources using Better Translation Manager etc.) |
| a5er_specification.enu.md | ER Diagram File Format (English)                                                                                             |
| a5er_specification.jpn.md | ER Diagram File Format (Japanese)                                                                                            |
| build_info.txt            | compiler version information.                                                                                                |
| concrt140.dll             | Microsoft Concurrency Runtime Library                                                                                        |
| history.txt               | change history.                                                                                                              |
| libbson-1.0.dll           | libbson library.                                                                                                             |
| libmongoc-1.0.dll         | MongoDB library.                                                                                                             |
| license.txt               | License regulation.                                                                                                          |
| license_en.txt            | License regulation.                                                                                                          |
| msvc140.dll               | Microsoft C Runtime Library.                                                                                                 |
| picture.zip               | ZIP file that summarizes the image files used for the icons of each button etc.                                              |
| readme.md                 | readme (japanese).                                                                                                           |
| readme_en.md              | this file.                                                                                                                   |
| sqlite3.dll               | SQLite library.                                                                                                              |
| TileServerList.txt        | Map Tile server settings.                                                                                                    |
| vcruntime140.dll          | Microsoft® C Runtime Library                                                                                                 |
| VirusCheck.txt            | Check result file of each file in anti-virus software.                                                                       |
| WebView2Loader.dll        | WebView2 Component (Show maps on Chromium based Edge)                                                                        |
| sampledb\\*               | Sample database(Microsoft Access, ER Diagram)                                                                                |
| sample\\*                 | Sample script.                                                                                                               |
| scripts\\*                | Script file.                                                                                                                 |
| geom_js\\*                | leaflet, WKX                                                                                                                 |

## Required Software
None.

## Install
### ZIP File edition
Installation work is not necessary.  
You can use it by expanding the archive file and starting A5M2.exe.  
To use it in portable mode (described later), create "Portable" folder in the same folder as A5M2.exe before executing.  

### Microsoft Store edition
Install from the [Microsoft Store](https://apps.microsoft.com/store/detail/a5sql-mk2-x64/9NSBB9XTJW86?hl=en-us&gl=us).


## Upgrade
### ZIP File edition
You can use it by unpacking the archive file and launching A5M2.exe like installation.  
Please unpack the archive file to a folder different from the old version.  

### Microsoft Store edition
Upgrade from the Microsoft Store.  

## Uninstall
### X64 version or x64 version (read only version)
Delete the folder where the archive file was expanded.  
Delete registry `\\HKEY_CURRENT_USER\Software\mmatsubara\a5m2(x64)`.  
Delete directory (`%APPDATA%` is an environment variable) represented by `%APPDATA%\a5m2(x64)`  
(Deleting the directory registry is not mandatory)  
After that, delete the folder with A5M2.exe.  

### X86 version or x86 version (read only version)
Delete the folder where the archive file was expanded.  
Delete registry `\\HKEY_CURRENT_USER\Software\mmatsubara\a5m2(x86)`.  
Delete directory (`%APPDATA%` is an environment variable) represented by `%APPDATA%\a5m2(x86)`  
(Deleting the directory registry is not mandatory)  
After that, delete the folder with A5M2.exe.  

### When using in portable mode
Delete the folder with A5M2.exe.

**If you are not in portable mode and have ever activated in normal mode at least once, X86 version, x86 version (read only version) or x64 version, x64 version (read only version) Please follow the uninstallation procedure.**

### Microsoft Store edition
Right-click A5: SQL Mk-2 icon in Start menu and select "Uninstall".

## How to use
When registering for the first time, the database registration screen will be displayed. Register the database to use from there.  
When that is done, you can connect to each database from the tree on the left and access the table view synonym and the stored procedure.  
You can test SQL statements by choosing Create New from the SQL menu. You can execute select statements and other DML statements (Insert, Update, Delete) in this window. DDL statements can also be executed with the syntax provided by the connection destination RDBMS.  

Rough function list
- Connection to various databases (You can connect directly to Oracle, PostgreSQL, MySQL, SQLite)
- SQL input completion function (also analyzes common table expressions and subqueries)
- Create and edit SQL with GUI
- Show SQL Execution plan
- Format SQL
- Continuous execution of SQL delimited by ";" (semicolon) or "/" (slash) or "GO" at the beginning of the line
- Multiple result sets are output to Excel collectively
- Execute SQL twice to output differences to Excel (also possible to compare multiple result sets)
- Execution of SQL with parameters
- Filtering of tables and query result sets (narrowing down)
- A pseudo-life specifying a column name, a result set title, etc. in a query comment Function to embed decree
- Table editor that can be output to Excel
- Display property of table (additional RDBMS information)
- Show table source
- Export/Import of table contents
- Insert a large amount of test dummy data into the table
- Create ER diagram
- Create ER diagram from database
- Create DDL of database from ER diagram
- Script language
- Function to generate SQL statements from natural sentences using AI (external service)
- Function to correct SQL statements that result in errors caused by AI (external service)
- SQL performance tuning function using AI (external service)

*The AI disabled version cannot use functions related to AI (external services).

For details, please refer to the following site.
https://a5m2.mmatsubara.com/

## Portable mode
By creating a "Portable" folder in the same folder as A5M2.exe in advance, it is possible to operate in "portable mode" where all settings and temporary files / SQL log files are placed in the "Portable" folder I can do it.
With this, you can place A5:SQL Mk-2 on a USB memory etc, and you can share settings on each PC.

Portable mode has the following features.
- Do not write to the registry
- Do not create temporary files other than "Portable" folder
- All settings, temporary files, and SQL log files are encrypted with AES (256 bit)
- Start password can be set
- File association is not possible

In the portable mode, as described above, all settings, temporary files, and SQL log files are encrypted with AES (key length: 256 bits). Therefore, if you set up the startup password, even if you lose the USB memory with A5:SQL Mk-2 in the unlikely event, you can set the DB setting information, temporarily saved SQL · ER diagram · script, It is possible to minimize the possibility of logged log files being leaked.

Of course, you can also use the portable mode for not writing to the registry without entering into the USB memory etc.

Microsoft Store Edition is not available in portable mode.

## Startup parameter
You can open the file by passing it as an argument at startup.
Besides that, you can process the following parameters.

- `/Workspace <WorkspaceName[:Portable]>`
  Start with the specified workspace.
  When using a portable mode workspace, add ":Portable" after the workspace name.
- `/Connect <DBName>`
  Connect to the specified database.
- `/ConnectAs <UserName>/<Password>@<DBName>`
  Connect to the specified database with the specified user name and password.
- `/AddDB <DBName>=<ConnectionString>`
  Register the database.
  If the database of `<DBName>` is already registered, an error will occur.
  You can register multiple databases by describing multiple `/AddDB` parameters.
- `/SetDB <DBName>=<ConnectionString>`
  Register the database.
  If the database of `<DBName>` is already registered, it will be overwritten.
  You can register multiple databases by describing multiple `/SetDB` parameters.
- `/DelDB <DBName>`
  Unregister the database.
- `/DelAllDB`
  Unregister all databases.
- `/RestoreSession`
  Restore the state at the time of the last exit.
  If not specified, it follows the check state of "Restore file state at the time of last exit at startup".
- `/NoRestoreSession`
  Do not restore the state at the time of the last exit.
  If not specified, it follows the check state of "Restore file state at the time of last exit at startup".
- `/Exit`
  Exit A5M2.exe. It must be specified after other startup parameters.
  Specify when you want to process only the startup parameters.

## About used program components
In A5:SQL Mk-2 we use the following program parts (component and library). I am thankful to the authors from the bottom of my heart.
- ActiveQueryBuilder Ver 1.17
  - Active Database Software
  - Commercial License
- DCPcrypt 2017-12-16(r16)
  - https://sourceforge.net/projects/dcpcrypt/
  - Copyright © 1999-2009 David Barton
  - Brought to you by: lomo74
  - MIT License
    - https://a5m2.mmatsubara.com/open_source_license/DCPcrypt/MIT_license.txt
    - https://opensource.org/licenses/mit-license.php
- DMonkey Version: 0.3.9.1
  - Project DMonkey
  - Proprietary license
- Excel4Delphi
  - https://github.com/m-matsubara/Excel4Delphi
  - forked from https://github.com/rareMaxim/Excel4Delphi
  - forked from https://github.com/Konctantin/Excel4Delphi
  - forked from https://github.com/Avemey/zexmlss
  - zlib License
- GDI+ API, GDI+ Class, GDI+ Util
  - http://www.progdigy.com
  - Mozilla Public License Version 1.1
  - source : https://github.com/m-matsubara/GDIPlus_Delphi
- github-markdown-css
  - Copyright (c) Sindre Sorhus <sindresorhus@gmail.com> (https://sindresorhus.com)
  - https://github.com/sindresorhus/github-markdown-css
  - MIT License
- highlight.js
  - Copyright (c) 2006, Ivan Sagalaev.
  - https://highlightjs.org/
  - BSD-3-Clause license
- leaflet 1.7.1
  - © 2010–2021 Vladimir Agafonkin. Maps © OpenStreetMap contributors.
  - https://leafletjs.com/
  - BSD-2-Clause
- marked.js
  - Copyright (c) 2011-2022, Christopher Jeffrey. (MIT License)
  - https://github.com/markedjs/marked
  - MIT license
- MongoDB C Client library (DLL)
  - https://github.com/mongodb/mongo-c-driver
  - Apache License : https://www.apache.org/licenses/LICENSE-2.0
- range-regex
  - https://github.com/voronind/range-regex
  - Copyright (c) 2013, Dmitry Voronin
  - BSD-2-Clause License
  - Convert the above code (Python) for Delphi and use it
    - https://github.com/m-matsubara/range-regex-pas
- SecureBridge Ver 11.0.1
  - Devart
  - Commercial License
- SQLite3.dll version 3.50.4
  - D. Richard Hipp
  - Public domain
- SynEdit
  - https://github.com/m-matsubara/SynEdit
    - forked from https://github.com/pyscripter/SynEdit
    - forked from https://github.com/TurboPack/SynEdit
    - original https://github.com/SynEdit/SynEdit
  - Mozilla Public License Version 1.1
  - About brunch
    - x64 version uses mm_develop branch of m-matsubara/SynEdit
    - x86 version uses mm_develop_gdi branch of m-matsubara/SynEdit
- TCtrlGrid Components Ver 2.10
  - ＳＵＮ
- UniDAC Ver 11.0.0
  - Devart
  - Commercial License
- WKX
  - Copyright (c) 2013 Christian Schwarz
  - https://github.com/cschwarz/wkx
  - MIT License
    - https://a5m2.mmatsubara.com/open_source_license/DCPcrypt/MIT_license.txt
    - https://opensource.org/licenses/mit-license.php
- Fontname Combobox(&Listbox) Version 1.2.1
  - CQN11335 加藤太朗(Taro Kato)
