Find Jobs
Hire Freelancers

Convert single tenant web app into multi-tenant SaaS enviroment

$250-750 USD

Closed
Posted over 8 years ago

$250-750 USD

Paid on delivery
have a standalone,traditional web based app written in php that uses mysql database. My client would like this app converted into a SaaS application as cheaply as possible,using one of the three methods below. Need estimated cost for each of the following methods to see which is cheapest to have implemented for my client. Please see the following three options listed below. Im looking to implement just one of these methods, but would like estimates on all 3 so can discuss with my client : Option 1 – Single database, single code-base Use a single database and store all client data in a single database. You will have to add a field like “clientid” in all your tables and modify all your SQL queries to select the correct “clientid”. If you already have a single tenant app, then heavy modification is required in the code. Option 2 – Multiple database, single code-base Create a separate database for every client. No modification is required to your existing single-tenant codebase. You will only have to modify the configuration file to select a database depending on the client. Option 3 – Multiple database, multiple code-base Create a separate database & duplicate the complete code for every client. No modification required at all. ------ on another note, if there are any other cost effective methods to achieve this same function , please suggest along with price estimate.
Project ID: 8319277

About the project

13 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
13 freelancers are bidding on average $520 USD for this job
User Avatar
Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. see my recent work for the technical expertise along with reviews & feedback on my profile page.
$721 USD in 10 days
5.0 (123 reviews)
8.7
8.7
User Avatar
Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer https://www.freelancer.com/freelancers/Vietnam/all/ https://www.freelancer.com/u/scriptphp87.html I'm expert development with php script Would you like discuss more with me? would you like show me your site to need do? I'm understand clearly your requirement and i'm interested your project I'm ready to do it now Nice to meet you Should you require further assistance, feel free to contact me. Thank you
$263 USD in 10 days
4.6 (187 reviews)
7.6
7.6
User Avatar
Hi, I think the best option you have is the second one: Option 2 – Multiple database, single code-base If so, the developer will just need to code a shared login system (db selection) and all the other stuff can be implemented as normal, also this will be better if you need to provide better support per user and in the case the number of clients increase then you can have the option to create new databases in other servers.- Option 1 will need a lot of edits in the source code and option 3... I didn't finsish reading the option 3. If you have any question just let me know. Greetings!
$250 USD in 3 days
4.9 (79 reviews)
6.3
6.3
User Avatar
Hi Dear!, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks! Mr Khoa
$250 USD in 10 days
4.8 (111 reviews)
6.3
6.3
User Avatar
A proposal has not yet been provided
$526 USD in 10 days
4.8 (13 reviews)
5.9
5.9
User Avatar
hello I would suggest going with method 2 and 3 both. kinda hybrid approach. thanks
$361 USD in 18 days
5.0 (32 reviews)
5.4
5.4
User Avatar
Hello Sir, Greeting for the day, Hope you are doing well We are Group of professional having more than 8 years’ experience in Windows/Linux Server administration , Website Hosting (Cpanel/Plesk) migration, Mail server configuration management ,CISCO Router Switches, Firewall(ASA,PIX,Sonicwall, cyberoam) ,Cloud Computing(AWS/Azure,office365), We provide support for small and medium companies to build their successful online businesses utilizing different platforms like Microsoft (Asp.net, SQL Server, C#, VB.net), LAMP, CMS like DNN, CATALLOK, Magneto, Word Press. We provide solutions focused web professional with comprehensive background orchestrating the design and development of cutting-edge web sites and user experiences that strategically leverage and maximize online presence. Please initiate chat to discuss your requirement in details. Thanks karun
$555 USD in 25 days
4.8 (34 reviews)
5.3
5.3
User Avatar
★★ Cloud computing and product design expert based in the United States - feel free to message me to discuss requirements prior to the project being awarded. ☞ How I Can Help You: There is quite a bit of analysis that needs to go into what decision is truly cheaper. Option 3, to me, shouldn't even be on the table - because that is not truly multi-tenant and you will find yourself managing as many environments as you have users. Shoot me a message and we will discuss what your current situation is and how I can help. There are a lot of factors to consider, not to mention the current size/complexity of the app, when coming up with this answer. ☞ About Me: My name is Tom Griffin, I'm based in the United States, and I have fifteen years of experience in a variety of technology and business roles. You may read more about me on LinkedIn if you search for "Tom Griffin IEEE." ☞ Warranty: All of my work comes with a 30-day warranty in the event something fails to work or experiences issues. ║✭✭✭✭✭✭✭▅▅▅▅▅▅▅▅▅ Tom is based in the United States ║✭✭✭✭✭✭✭▅▅▅▅▅▅▅▅▅ and has worked with major organizations. ║✭✭✭✭✭✭✭▅▅▅▅▅▅▅▅▅ You can read more about him in his profile ║▅▅▅▅▅▅▅▅▅▅▅▅▅▅▅ or by finding him on LinkedIn by searching for ║▅▅▅▅▅▅▅▅▅▅▅▅▅▅▅ "Tom Griffin IEEE." ║▅▅▅▅▅▅▅▅▅▅▅▅▅▅▅
$631 USD in 2 days
5.0 (4 reviews)
3.7
3.7
User Avatar
I will prefer option 3 Thank you
$277 USD in 10 days
5.0 (3 reviews)
2.7
2.7
User Avatar
I have worked with and converted web applications using all three options you provided. Option 1 – Single database, single code-base Add a field like “clientid” in all tables and modify all SQL queries to select the correct “clientid”. This requires the most "upfront" effort but saves in the end. It is easier to maintain, backup and restore a single database. If you make changes or improvements to the code or the database, you only have to do it in a single place and all clients will be up-to-date. Estimate: $700 (Truly an estimate because I have no idea how many source files and SQL statements need to be changed). Option 2 – Multiple database, single code-base Only the database connection string or function needs to be modified. Maintaining several databases - especially with hundreds of clients - can require quite a bit of work. Estimate: $450 Option 3 – Multiple database, multiple code-base Although there may be little code modification upfront, keeping track of hundreds of client code and databases can be a daunting task. An application improvement or database change means rolling changes out to each client individually. The more clients you have, the more effort required to update. Estimate: $200 (Evaluate code and possible change the main database connection routine)
$777 USD in 10 days
0.0 (0 reviews)
3.8
3.8

About the client

Flag of UNITED STATES
annapolis, United States
5.0
4
Payment method verified
Member since Jul 21, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.