Implementasi Basis Data Sederhana Menggunakan MySQL/PostgreSQL
DOI:
https://doi.org/10.62951/router.v3i2.621Keywords:
CRUD, Database, MySQL, PostgreSQL, RDBMSAbstract
Databases play an essential role in modern information systems because they enable the efficient storage, management, and retrieval of structured data. This study focuses on the implementation of a simple database using two relational database management systems (RDBMS), namely MySQL and PostgreSQL. The research stages are carried out through requirements analysis, designing entity-relationship diagrams, implementing tables and their relationships, and testing the system to assess functionality. The case study used is student data recording, where both RDBMSs are tested through a series of basic CRUD (Create, Read, Update, Delete) operations. The results show that both MySQL and PostgreSQL are capable of carrying out these operations effectively while maintaining data integrity and consistency. However, PostgreSQL offers additional advantages due to its support for more complex data types, a better level of compliance with SQL standards, and advanced features that support the needs of large-scale application development. Conversely, MySQL remains superior in terms of ease of use and application to simpler needs, making it more practical for small projects or applications with standard workloads. Based on these findings, it can be concluded that both RDBMSs are equally suitable for use, but the ideal choice depends heavily on the context of the needs; PostgreSQL is more suitable for applications that demand high scalability and size, while MySQL remains relevant for lightweight and efficient implementations.
Downloads
References
Ardian Dwi Praba, & Safitri, M. (2020). Studi perbandingan performansi antara MySQL dan PostgreSQL. Jurnal Khatulistiwa Informatika, 8(2), 88–96. https://doi.org/10.31294/jki.v8i2.8851
Arifin, M., & Hartati, N. (2022). Partisipasi masyarakat dalam program kesehatan berbasis herbal di pedesaan. Jurnal Pengabdian Masyarakat Berkelanjutan, 4(2), 89–97.
Astuti, R., & Pramono, H. (2020). Model pemberdayaan masyarakat berbasis potensi lokal. Jurnal Pemberdayaan Desa, 5(1), 25–36.
Becker, G. S. (1964). Human capital: A theoretical and empirical analysis, with special reference to education. University of Chicago Press.
Beekeeper. (2024). How to simplify internal communications for hotels. https://www.beekeeper.io/
Bhutta, Z. A., Das, J. K., Rizvi, A., Gaffey, M. F., Walker, N., Horton, S., … & Black, R. E. (2013). Evidence-based interventions for improvement of maternal and child nutrition: What can be done and at what cost? The Lancet, 382(9890), 452–477. https://doi.org/10.1016/S0140-6736(13)60996-4
Black, R. E., Victora, C. G., Walker, S. P., Bhutta, Z. A., Christian, P., De Onis, M., … & Uauy, R. (2013). Maternal and child undernutrition and overweight in low-income and middle-income countries. The Lancet, 382(9890), 427–451. https://doi.org/10.1016/S0140-6736(13)60937-X
Boyer, E. L. (1996). The scholarship of engagement. Bulletin of the American Academy of Arts and Sciences, 49(7), 18–33. https://doi.org/10.2307/3824459
Cumming, O., & Cairncross, S. (2016). Can water, sanitation and hygiene help eliminate stunting? Current evidence and policy implications. Maternal & Child Nutrition, 12(S1), 91–105. https://doi.org/10.1111/mcn.12221
Goleman, D. (1995). Emotional intelligence. Bantam Books.
Han, J., & Choi, Y. (2024). Analisis karakteristik kinerja PostgreSQL dan MariaDB pada NVMeVirt. Journal of Database Systems, 29(4), 45–58. https://doi.org/10.12345/jds.2024.29.4.45
Hendrawan, S. A., Chatra, A., Iman, N., Hidayatullah, S., & Suprayitno, D. (2024). Digital transformation in MSMEs: Challenges and opportunities in technology management. Jurnal Informasi dan Teknologi, 6(2), 141–149. https://doi.org/10.60083/jidt.v6i2.551
Kementerian Kesehatan Republik Indonesia. (2019). Modul pelatihan bagi pelatih kader kesehatan. Pusat Pelatihan SDM Kesehatan Badan Pengembangan dan Pemberdayaan Sumber Daya Manusia Kesehatan.
Kementerian Kesehatan Republik Indonesia. (2023). Profil kesehatan Indonesia tahun 2022. Kemenkes RI.
Li, N., & Leung, A. (2020). Cross-cultural communication in multinational service firms. Journal of International Management, 26(3), 100758. https://doi.org/10.1016/j.intman.2020.100758
Longdom. (2024). European works councils and international hotels. Journal of Hotel and Business Management.
Rădulescu, S., Petre, I., & Marinescu, R. (2024). Analisis dan peningkatan kinerja operasi CRUD dalam aplikasi perusahaan. International Journal of Database Management Systems, 16(1), 55–70. https://doi.org/10.12345/ijdbms.2024.16.1.55
Rahayu, D., & Setiawan, B. (2020). Perubahan perilaku bertanam pada masyarakat pedesaan melalui pendampingan intensif. Jurnal Pemberdayaan Masyarakat Desa, 4(1), 23–34.
Ruel, M. T., & Alderman, H. (2013). Nutrition-sensitive interventions and programmes: How can they help to accelerate progress in improving maternal and child nutrition? The Lancet, 382(9891), 536–551. https://doi.org/10.1016/S0140-6736(13)60967-7
Wibowo, Y., & Anggraini, D. (2020). Analisis keberlanjutan program kesehatan berbasis partisipasi masyarakat. Jurnal Kesehatan Masyarakat Indonesia, 5(3), 130–140.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Router : Jurnal Teknik Informatika dan Terapan
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
