YOUR AD GOES HERE

A Notepad++ plugin for executing SQL statements in a MS Access database

Published 04, Jul 2023

Andmebaasid


Description:
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/0ac16423-5434-450d-a961-26fa087f91d4)

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/blob/main/Databases%20and%20SQL/Hotel_database.zip

Demonstration SQL statements: https://github.com/erki77/databases/blob/main/Databases%20and%20SQL/Demo_Notepad%2B%2B_eng.sql

Releted More Videos

  • Sorry!!! Nothing to show

You May Also Like

YOUR AD GOES HERE

YOUR AD GOES HERE