This project, focused on backend to understand the role of databases is developed by us servers as a comprehensive guide to the vibrant clubbing scene in Madrid. It offers detailed insights into various clubs, events, and nightlife experiences in the city, making it an essential resource for party-goers and nightlife enthusiasts.
- 🎉 Detailed information on popular clubs in Madrid.
- 📅 Event listings and schedules for major nightlife events.
- 📍 Interactive mapping of club locations and events.
- 📝 User reviews and ratings for clubs and events.
The project leverages web scraping and database management to gather and present information:
- Web Scraping: Extracts data from club websites to compile comprehensive club listings.
- Database Management: Organizes and stores club and event data for easy retrieval and analysis.
- User Review System: Allows users to post reviews and ratings, providing valuable insights into each club's experience.
The project is open to future enhancements to enrich the user experience:
- Mobile App Integration: Develop a mobile application for easier access and real-time updates.
- Social Features: Implement social networking features to connect club-goers and share experiences.
- Advanced Filtering Options: Provide more detailed search and filter options for users to find clubs and events that match their preferences.
- Live Event Updates: Integrate live updates for events, including ticket availability and special announcements.
- Python: For web scraping and backend development.
- Django: A high-level Python web framework for rapid development.
- MongoDB: A NoSQL database for storing and managing club and event data.
- Djongo: A connector for using Django with MongoDB.
- Python
- pip
- virtualenv
- MongoDB
- BeautifulSoup (Web-Scraping)
-
Install MongoDB:
- Follow the instructions on the MongoDB website to install MongoDB on your system.
-
Install pymongo and Djongo:
pip install pymongo
pip install Django djongo
- Install Virtual Environment:
pip install virtualenv
virtualenv venv
Windows
venv\Scripts\activate
MacOS
source venv/bin/activate
- Install Required Packages:
pip install wheel
pip install django
pip install django
pip install mysqlclient
pip install beautifulsoup4
- Create Database Tables:
python manage.py makemigrations
python manage.py migrate
- Run the Server:
python manage.py runserver
Now, you should be able to access the application at http://localhost:8000
.
This will initiate the web scraping process and populate the database with the latest clubbing information.
Clubs_Scraping/
├── images/
└── project/
├── clubbing/
│ ├── pycache/
│ ├── migrations/
│ ├── admin.py
│ ├── apps.py
│ ├── models.py
│ ├── routers.py
│ ├── tests.py
│ └── views.py
└── project/
├── pycache/
├── asgi.py
├── settings.py
├── urls.py
├── wsgi.py
├── events.py
├── manage.py
├── mapping.py
├── queryMongo.py
├── venv/
│ ├── kapital.py
│ └── MongoReview.py
├── README.md
├── scrapingMadrid.py
├── scrapingNightlife.py
└── segovia.sql
This section includes images for our project.
You can use this link to download the scraped data and run the files - https://drive.google.com/drive/folders/1MpWk-N62uHAvmvDLA5dpkdQN38Eu_epm?usp=sharing
https://www.esmadrid.com/en/madrid-nightlife
Contributions are welcome! If you have suggestions or find a bug, please open an issue or submit a pull request.
Dive into the heart of Madrid's nightlife with this comprehensive guide. Discover the best clubs, events, and experiences the city has to offer! 🎶🌆