LightBnB is a simple application clone to AirBnB.
Users sign up for an account where they can create a new listing to rent out their homes to people on vacation. Account holders can search for properties available for rent using the Search feature, which pulls data from the database. Account holders can also view any existing properties they own and have listed for rent as well as view past and current reservations.
The purpose of this project was to design a database using server-side JavaScript to display the information from queries to web pages. It offered practice working with simple and complex SQL queries, relational databases and ERD (entity relationship diagram) design to integrate the database with a Node backend, using PostgreSQL and node-postgres (Node PG).
View past and current reservations
ERD showing each table's relationship to one another
1_queries
contains some SQL queries to retrieve data from the PostgreSQL databaseLightBnB_WebApp
contains HTML, CSS, and JavaScript (client and server side) code as well as database code to render the contents for the appdocs
contains screenshots of the appmigrations
containssql
files to create the tables needed for the databaseseeds
containssql
files to populate each of the database's tables with data
- Create a new repository using this repository as a template.
- Clone your repository onto your local device.
- Install dependencies using the
npm install
command. - Start the web server using the
npm run local
command. The app will be served at http://localhost:3000/. - Go to http://localhost:3000/ in your browser (preferably Chrome).
bcrypt: ^3.0.6
- (If you receive an error after starting the server, uninstall bcrypt and install it again using a higher version e.g. version
5.1.0
)
- (If you receive an error after starting the server, uninstall bcrypt and install it again using a higher version e.g. version
body-parser: ^1.19.0
cookie-session: ^1.3.3
express: ^4.17.1
nodemon: ^1.19.1
pg: ^8.7.3