A Flask-based web app to find the best work-friendly cafes in London.
Easily browse, filter, and manage cafes based on Wi-Fi availability, socket access, seating, and other remote-worker-friendly features.
🚀 Try the app here: https://cafe-and-wifi-is7h.onrender.com
| Home Page | Filter Panel | Add Cafe Form |
|---|---|---|
 |
 |
 |
Screenshots located in the
/assetsfolder.
- ✅ Filter Cafes
- Wi-Fi availability
- 🔌 Power sockets
- 🚻 Toilets
- 📞 Call-friendliness
- 🪑 Number of seats (e.g., 0–10, 10–20, 50+)
- ➕ Add New Cafes
- ❌ Delete Cafes
- 🗺️ Map Integration – View cafes directly on Google Maps
- 📊 Live Count & Smart Filtering
- 🎨 Modern, Responsive UI – Built with Bootstrap 5 and FontAwesome
- 🛢️ Database Flexibility – SQLite locally, PostgreSQL on deployment
| Layer | Technology |
|---|---|
| Backend | Python, Flask |
| Frontend | HTML, CSS (Bootstrap 5), Jinja2, Font Awesome |
| Database | PostgreSQL (via Neon), SQLite |
| ORM | SQLAlchemy |
| Forms | Flask-WTF, WTForms |
| Migrations | Alembic |
| Server | Gunicorn (for production) |
| Env Mgmt | python-dotenv for .env file-based config |
This app supports flexible local and cloud deployment:
- ✅ SQLite for quick local development
- ✅ PostgreSQL via Neon for scalable, production-ready environments
You can configure the database using a .env file:
SECRET_KEY=your-secret-key
DATABASE_URL=postgresql://:@.neon.tech/?sslmode=require
🚀 Serverless PostgreSQL
🔄 Auto-scaling & branching
🔐 Secure SSL connections
🙌 Contribution
Pull requests are welcome! For major changes, please open an issue first to discuss what you'd like to change.