Reading Club

Organize meetings to discuss any book in less than a second
Explore the docs »

Table of Contents

• Table of Contents
• About The Project
  • Built With
• Getting Started
  • Prerequisites
  • Installation
• Notes
• Usage

About The Project

This project uses an OLTP relational database that automates the following business processes:

1. Club administration: (includes associations with other clubs): Reading clubs management, member's maintenance (payment control) and books management
2. Meetings administration: Manage the monthly calendar of reunions, book picking, and moderator's assignation, assistance control and discussions
3. Planning and execution of acted presentations (includes cast), manage the monthly calendar of presentations and actors or presentations ratings

Built With

• Laravel 6
• PostgreSQL 12
• Bootstrap 4
• Vue JS

Getting Started

To get a local copy up and running follow these simple steps.

Prerequisites

1. PHP 7
2. Laravel 6
3. PostgreSQL 12
4. pgAdmin4
5. Node js

Installation

Windows

1. In the project folder run the following commands on cmd

composer install
npm install

2. Create a PostgreSQL user with the following credentials

Username: FrankHesse
Password: metalsonic21

3. Under that user create a database called ReadingClub

4. Run the following commands

php artisan migrate:refresh --seed
php artisan serve

5. In another console run the following command

npm run watch

6. Log in with the following credentials

E-mail: str4ngl3r@aol.com
Password: 123456789

Issues

1. SQLSTATE[08006] [7] FATAL: password authentication failed for user frankhesse

SOLUTION: Go to C:\Program Files\PostgreSQL\12\data, locate the pg_hba.conf file and edit the following lines:

host    all             all             127.0.0.1/32            trust
host    all             all             ::1/128                 trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

This allows replication connections from localhost, the method by default is md5. After making these changes shutdown the server and restart pgAdmin

2. Missing the vendor folder

SOLUTION: Run the following command

composer update

Then, restart pgAdmin and the server.

3. Missing driver

SOLUTION: Check your php.ini file and uncomment the following lines

;extension=pdo_pgsql
;extension=pgsql

4. Migration doesn't work (Class UserTableSeeder not found)

SOLUTION: Run the following command:

composer dump-autoload

Then, try to migrate again

php artisan migrate:refresh -seed

Notes

1. This project has a spanish UI
2. This project includes an ER diagram and a logic design which will be the guide to implement the database

Usage