A Notepad++ plugin for executing SQL statements in a MS Access database
The first version of the software was created as a part of master thesis that I supervised. The name of the thesis "Creating a Plugin for Source Code Editor Notepad++ that Simplifies SQL Programming in MS Access Databases" (it is in Estonian but with English annotation) (https://digikogu.taltech.ee/et/Item/0...)
The author developed a plugin for Notepad++ source code editor that has two tasks. Firstly, it allows its users to execute SQL statements in MS Access databases (including Data Definition Language statements - CREATE, ALTER, and DROP). Secondly, it checks MS Access SQL statements in terms of 28 different mistakes and gives feedback to the user. The software is open source and published with the MIT license. After that, as a part of a bachelor thesis, additional 12 checks were added to the second version of the plugin.
The shared GitHub repository where the source code as well as the installable files and installation guidelines can be found.
https://github.com/stenarm/NppDB/
Hotel database: https://github.com/erki77/databases/b...
Demonstration SQL statements: https://github.com/erki77/databases/b...
On this page of the site you can watch the video online A Notepad++ plugin for executing SQL statements in a MS Access database with a duration of hours minute second in good quality, which was uploaded by the user Andmebaasid 04 July 2023, share the link with friends and acquaintances, this video has already been watched 365 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
