I'm working at a commercial real estate company with around 600 properties and nearly 1,000 tenants. I've been tasked with developing an asset management tracker that will take our raw property and tenancy data, and display live information about upcoming lease events, like expirations, breaks, rent reviews, and vacancies for the next few years. Asset managers need to log in, view events specific to their properties, and input data such as status, expected completion date, expected rent, and whether tenants are staying or leaving. An editable table view would make this easier. The goal is to keep everyone informed about the business's current situation, upcoming risks, and for performance tracking.
I'm looking for it to have the following features:
- Live data pulled from internal databases that updates as tasks are completed and new ones arise.
- Each asset manager needs to log in and only see their assigned properties.
- Ability to export Excel reports, such as upcoming rent reviews for the next couple of years with management inputs.
- A version history to track changes made by asset managers.
I've got some familiarity with Python and R, but no professional coding experience. I've read that I might need PostgreSQL for the backend and React for the front end. Do I need to host this on a server? This is all quite new for me, and I'm seeking advice on its feasibility, the best approach to take, and whether this is too much for me to tackle. I also prefer to keep costs low where possible, knowing some expenses are inevitable, like server costs.
2 Answers
It's great that you're taking on this project, but honestly, without more coding experience, you might find it tough to implement something secure and efficient on your own. Consider teaming up with a professional developer, especially for something that will be handling sensitive data.
If you're looking for a quicker start, you could try using Airtable or other no-code platforms, which might be more suitable for your level right now. Just ensure you’re okay with their limitations in flexibility and complexity. Good luck!
You can absolutely build a web app like this, but it seems like a big undertaking for someone without a lot of programming experience. I suggest deciding whether you want this as a web app or something that can run natively on devices.
Using a framework like React for the frontend is a solid choice, and PostgreSQL is a good option for your database. Just remember, you'll need to set up a backend API to handle communications between your frontend and the database securely. Services like Firebase or Supabase can simplify some of that too! You'll also need to think about hosting your app and database. If it seems overwhelming, working with a developer can save you a lot of headaches!
Related Questions
Cloudflare Origin SSL Certificate Setup Guide
How To Effectively Monetize A Site With Ads