OPAC System — Online Public Access Catalog

6DIPROGLANG Final Project | Holy Angel University | S.Y. 2025-2026

Built with Ruby + Sinatra + MySQL

---

Group Members

• Evangelista, Vince — Backend Developer
• Mallari, John S. — Documentation
• Oliveros, Michael Francis Noel M. — Database Administrator
• Pineda, Sophia Keziah G. — Project Lead / QA
• Sarmiento, Maria Anne Joy — Frontend Developer

---

Requirements

• Ruby 3.x with DevKit — https://rubyinstaller.org
• XAMPP — https://www.apachefriends.org

---

Setup

1. Install gems

gem install sinatra
gem install webrick
gem install mysql2 -- --with-mysql-lib="C:/Ruby34-x64/msys64/ucrt64/lib" --with-mysql-include="C:/Ruby34-x64/msys64/ucrt64/include/mariadb"

2. Start XAMPP — run both MySQL and Apache

3. Import the database

• Go to http://localhost/phpmyadmin
• Create a database named opac_db
• Import opac_db.sql from the project folder

4. Run the program

ruby opac_main.rb

5. Open in browser

http://localhost:4567

---

Admin Login

Password: admin123

---

Troubleshooting

MySQL won't start

• Open services.msc, stop any conflicting MySQL/MariaDB service, then retry.

Access denied error

• Make sure MySQL is running in XAMPP before running the program.

mysql2 install fails

• Make sure Ruby was installed with DevKit and ridk install was completed.

Books not showing — Import opac_db.sql in phpMyAdmin first.