proggR Posted August 22, 2010 Share Posted August 22, 2010 Hello. I'll actually be using SQLite for this but If I can understand it in MySQL I'm sure I can apply that to SQLite. I am making an app for a phone that will manage time on projects. It will keep track of tasks, clients and projects and how long is spent on each project. I want to also make either a program for OSX or a server side script in PHP that will merge the information from all of the clients into one location. So if I was working on a project with another person, our information about the project (including who its for and the tasks required) would be merged into one master database and all of our sessions would be added as well. I would also like the ability to push tasks/projects/client information from this application to the clients. My problem is I'm trying to figure out how to perform this merge since my project ID for the project could be different than another person's project ID for the project so adding information would have to look at every other piece of information to make sure its the same project. Also, would I make some kind of aggregate table in the master one that would somehow link the client, the project and the client's project ID? Any patterns anyone knows about would be awesome. I haven't done much actual coding on this yet. I've made up my views and make static data for some of the view controllors but most of the logic and all of the models still need to be done because I haven't wanted to rush into doing this wrong and making more work for myself later. Thanks in advance for any help. Quote Link to comment https://forums.phpfreaks.com/topic/211437-merging-databases-into-master-database-and-keeping-child-databases/ Share on other sites More sharing options...
fenway Posted August 22, 2010 Share Posted August 22, 2010 Sorry, I don't follow -- but perhaps this belongs in the app design board.... Quote Link to comment https://forums.phpfreaks.com/topic/211437-merging-databases-into-master-database-and-keeping-child-databases/#findComment-1102437 Share on other sites More sharing options...
Mchl Posted August 22, 2010 Share Posted August 22, 2010 The phrase you need to google search for is 'database replication'. Not sure if SQLite is capable to do it though. Maybe there's some other solution for mobile apps. Definitely app design board, moving there. Quote Link to comment https://forums.phpfreaks.com/topic/211437-merging-databases-into-master-database-and-keeping-child-databases/#findComment-1102444 Share on other sites More sharing options...
proggR Posted August 22, 2010 Author Share Posted August 22, 2010 Thank you for moving the thread. Also thank you for the heads up about the term. Even in the first search its been more helpful than my previous searches. Quote Link to comment https://forums.phpfreaks.com/topic/211437-merging-databases-into-master-database-and-keeping-child-databases/#findComment-1102476 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.