Find Jobs
Hire Freelancers

Convert single tenant web app into multi-tenant SaaS enviroment

$250-750 USD

Cerrado
Publicado hace más de 8 años

$250-750 USD

Pagado a la entrega
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.
ID del proyecto: 8319277

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
13 freelancers están ofertando un promedio de $520 USD por este trabajo
Avatar del usuario
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 en 10 días
5,0 (123 comentarios)
8,7
8,7
Avatar del usuario
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 en 10 días
4,6 (187 comentarios)
7,6
7,6
Avatar del usuario
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 en 3 días
4,9 (79 comentarios)
6,3
6,3
Avatar del usuario
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 en 10 días
4,8 (111 comentarios)
6,3
6,3
Avatar del usuario
A proposal has not yet been provided
$526 USD en 10 días
4,8 (13 comentarios)
5,9
5,9
Avatar del usuario
hello I would suggest going with method 2 and 3 both. kinda hybrid approach. thanks
$361 USD en 18 días
5,0 (32 comentarios)
5,4
5,4
Avatar del usuario
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 en 25 días
4,8 (34 comentarios)
5,3
5,3
Avatar del usuario
★★ 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 en 2 días
5,0 (4 comentarios)
3,7
3,7
Avatar del usuario
I will prefer option 3 Thank you
$277 USD en 10 días
5,0 (3 comentarios)
2,7
2,7
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
3,8
3,8

Sobre este cliente

Bandera de UNITED STATES
annapolis, United States
5,0
4
Forma de pago verificada
Miembro desde jul 21, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.