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...
Sur cette page du site, vous pouvez voir la vidéo en ligne A Notepad++ plugin for executing SQL statements in a MS Access database durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Andmebaasid 04 juillet 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 365 fois et il a aimé 1 téléspectateurs. Bon visionnage!
