Title Details: | |
Databases and Python |
|
Authors: |
Perakis, Konstantinos Dasygenis, Minas |
Reviewer: |
Avouris, Nikolaos |
Description: | |
Abstract: |
In this chapter, we will describe how Python can be used to access external databases. Databases are an integral component of every information system, as well as many applications. They provide an organized way of storing and retrieving data. Since several applications are implemented in Python, there is often a need to access such an external database (e.g., MySQL) from Python for the retrieval and processing of values and vectors. This book would not be complete without presenting the Python libraries that serve this purpose. Initially, a brief description of the SQL (Structured Query Language) for database access will be given, followed by the description of how to access MySQL, SQLite, PostgreSQL. A significant element of the chapter is the presentation of techniques to achieve better security by preventing SQL code injections (SQL injection) and ensuring the integrity, availability and confidentiality of accesses.
|
Linguistic Editors: |
Kagiadaki, Sofia |
Graphic Editors: |
Kagiadaki, Sofia |
Type: |
Chapter |
Creation Date: | 15-05-2024 |
Item Details: | |
License: |
Attribution - NonCommercial - ShareAlike 4.0 International (CC BY-NC-SA 4.0) |
Handle | http://hdl.handle.net/11419/13363 |
Bibliographic Reference: | Perakis, K., & Dasygenis, M. (2024). Databases and Python [Chapter]. In Perakis, K., & Dasygenis, M. 2024. Python Toolbox [Undergraduate textbook]. Kallipos, Open Academic Editions. https://hdl.handle.net/11419/13363 |
Language: |
Greek |
Is Part of: |
Python Toolbox |
Publication Origin: |
Kallipos, Open Academic Editions |