Implementasi Information Schema Database Pada PostgreSQL untuk Pembuatan Tabel Informasi dengan Menggunakan Python Di PT XYZ
Abstract
Abstract
The rapid development of technology is increasingly affects and facilitates human work. Each year, new technologies emerge by offering the more advanced complex and effective features than similar previous technologies which already exist. Aged technologies is getting no longer adept and began to lose support from their development companies. Nowadays, XYZ Company is migrating its applications, which is built by using Oracle form to Webix and Flask. Due to the large number of forms, the migration process also takes a long time and demand many human resources to be involved. Therefore, the developers need to map the form to see the information about the table which includes column names, constraints, data types, and relationships between each table. Responding to this, XYZ Company created a library that utilizes PostgreSQL database schema information as a table which provides the information. It is expected that the use of schema information to be used as an information table which is able to make it easier for the developers in application making process and fastening the form migration process.
References
[2] E. Tungadi, “Generator Formulir Memanfaatkan MySQL Metadata,” pp. 77–80, 2015.
[3] “PostgreSQL: About.” https://www.postgresql.org/about/ (accessed Nov. 15, 2021).
[4] A. D. Praba, “Aplikasi Rekap Mengajar Berbasis Webiste Dengan Database PostgreSQL,” Indones. J. Netw. Secur., vol. 8, no. 1, pp. 27–31, 2018, [Online]. Available: http://ijns.org/journal/index.php/ijns/article/view/1571.
[5] A. Qushay, A. L. Barra, and E. F. Dharmawan, “‘PostgreSQL’ Database,” pp. 1–18, 2017.
[6] “PostgreSQL: Documentation: 9.1: The Information Schema.” https://www.postgresql.org/docs/9.1/information-schema.html (accessed Oct. 25, 2021).
[7] Syaruddin, “Input Dan Output Pada Bahas Pemograman Pyhton,” Dasar Pemograman Phyt., p. 1, 2018.
[8] “What is Python? Executive Summary | Python.org.” https://www.python.org/doc/essays/blurb/ (accessed Nov. 30, 2021).
[9] “Introduction · Bootstrap v4.6.” https://getbootstrap.com/docs/4.6/getting-started/introduction/ (accessed Feb. 10, 2022).
[10] Romano, Fabrizio. (2018). Learn Python Programming Second Edition. Birmingham: Packt Publising Ltd.
[11] B. Priyatna, A. Lia Hananto, M. Nova, P. Studi Sistem Informasi, and U. Buana Perjuangan Karawang, “Application of UAT (User Acceptance Test) Evaluation Model in Minggon E-Meeting Software Development,” Systematics, vol. 2, no. 3, pp. 110–117, 2020.
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
JATIS oleh http://jurnal.mdp.ac.id/index.php/jatisi disebarluaskan di bawah Lisensi Creative Commons Atribusi-BerbagiSerupa 4.0 Internasional.