Web Design & Development | IT Consulting
Game Tagg
Game Tagg was a group project where I worked with a team of three people. The purpose of the project was to create a social bookmarking website prototype for videogames. The application uses JSP to send data to and receive data from a Java program that makes and executes SQL statements to interact with a PostgreSQL database. The project was somewhat large for a basic prototype with over 35 pages and 11 database tables. The different pages used to auto redirect such as when clicking on user home and logging in previously it would automatically go back to user home. This functionality was removed because of web host issues, and registration and everything has been changed to be completely open so users can test out everything.
The final result was a fully functional prototype that allowed users to enter items, tag them, update them, and create and update user profiles. For this project we designed a database. To create the database and populate it we used a PostgreSQL script. A java program handled all of the connections and static and dynamic creation of SQL statements. The website also allowed users to search structured data by querying the database for specific tags and to search unstructured information using a Lucene based search engine. A java application handled indexing all items in the database and a search form allowed users to perform free searches on all contents of the database. For this project I was the team leader, designed most of the database, implemented the Lucene search engine, designed most of the layout with CSS and created several SQL statements to interact with the database.
Leave a comment