Sync Local SQLite DB w/ Online mySQL DB

---Project Description---

I need a PHP script that securely and quickly syncs the database structure and data of a local SQLite DB with an online mySQL DB. This project is for the online script only.

I have a downloadable software application (known as the 'software' from here on) that creates and manages a local SQLite DB. The software is capable of pulling data from the SQLite DB in any format (XML, SQL etc...) and send it to the server for processing and input into the online mySQL DB.

The local SQLite DB can be modified by the software and the online mySQL database can be modified by another source as well. So they both need to stay in sync with each other.

In addition, there can be multiple local SQLite DB's on various computers since the software can be used on multiple computers.

----Technical Details----


1. The database will consist of 2 - 4 tables. The software will check to see if the database has been created online. If not, it will create the database online based on a table structure provided.

2. Once we know the database is available online the software will ask the database for any new entries. To get new entries, each table has a 'dateCreated' column. The software will ask the online DB for all entries after a specified date (stored within the software).

3. Once the software has the new online entries, it will send the new local entries it has to the online DB. The software will have a column labeled 'modified' that knows whether or not it has synced this column with the online DB. So once it sends the local data to the server, the server needs to let the software know if the data has been successfully entered online. If it has, the software will set the modified column accordingly.

4. For deleting records there will be a table with the following columns;

UUID, tableName, dateDeleted

The server will store the deleted UUID, which table it is from and the date deleted so that the local DB can download this data and delete the appropriate rows. Likewise, the local DB will have the same details that will be synced with the online DB.

5. (once the above is completed) There also needs to be a way for the software to communicate **securely** with the web server to update the table structure if needed. For example, it needs to be able to;

a) add a new column of a specified type (so send the column name and type along with the table it belongs to and the default value. The online version should communicate a success or failure)

b) add data to a specific column

c) possibly other additions

Note: The local sqlite DB's never have to have their structure changed via syncing. Any structure changes will be a one way sync from the local DB to the online DB.

--Data Integrity--

In order to ensure the integrity of the data, we rely on a UUID column instead of an integer primary key. That means that since there are multiple local DB sources, it doesn't matter when the data is added to the online mysql source.

--Error Codes--

Because the server needs to sync with a local software, the server should have standardized error codes that is sent to the software when we have any errors that can then be shown to the user. So instead of using error strings, we simply send a set of standardized error codes depending if something went wrong.

In addition to the error code, there needs to be some kind of log with additional details such as an error in the SQL, etc...


We want to make sure that only communication from the software is processed by the online script. All communication should be sent with a hash that is made up of the data and a secret code that must be validated before any data is processed. In addition, the script should only accept data from a specific HTTP header.

The script should work with both SSL and non SSL connections.

I would also discuss security implementations with the chosen developer to make sure communication comes from the current sources only.

Evner: Database Administration, MySQL, PHP, SQL, XML

Se mere: local sqlite mysql, uuid database sync code, xml to xml online, wrong header, work online as software developer, work available online, web developer local, sql developer online, online work software, online work for php developer, online technical work, online sql developer, mysql software download, mysql db, hash table in data structure, hash table data structure, hash strings, hash in data structure, hash data structure, ensure data security, download mysql developer, create log online, create a log online, code with php online, codes sources

Om arbejdsgiveren:
( 2 bedømmelser ) Thornhill, Canada

Projekt ID: #5985036

19 freelancers are bidding on average $671 for this job


1. Vollks Australian Online Store In these days we are complete re-designing and reimplementing an online store for our Australian client in which we are using X-Cart latest stable release to implement his all require Flere

$695 USD in 15 dage
(91 bedømmelser)

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$515 USD in 15 dage
(77 bedømmelser)

i already have it ready, if u look at [url removed, login to view] which is an android based pos system, it has a local sqlitedb and it syncs to mysql in realtime, ill joust port a version for u in php justc contact me i am all good i Flere

$777 USD in 10 dage
(22 bedømmelser)

A proposal has not yet been provided

$927 USD in 10 dage
(29 bedømmelser)

Hi, I own a small software firm. I have total five employees to work with me. We are a expert in php-mysql and [url removed, login to view] have done a lots of projects on php. your project seems to be easy [url removed, login to view] can do [url removed, login to view] y Flere

$600 USD in 10 dage
(38 bedømmelser)

Dear sir > , Visa Info World Pvt. Ltd. is Indian base company. You can see our work at [url removed, login to view] or in portfolio section. We provide best solution in low cost . So we want to discuss about your requirement. Flere

$684 USD in 10 dage
(18 bedømmelser)

One question: you asked for a php software, that means it is on the web server side and is reading/writing to the MySql DB. You didn't asked for the corresponding client side component reading/writing to the SQLLite DB Flere

$570 USD in 6 dage
(16 bedømmelser)

Hi, I have gone through your requirement and attachment as well.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL Server,Oracle database, I can do your job confidently. But, as per your re Flere

$621 USD in 10 dage
(13 bedømmelser)

Hi there, I'm an Linux expert with a very long professional web hosting experience, see my profile at [url removed, login to view] I have also very long experience in building for a companies scallable XEN/OpenVZ/KVM/AWS Flere

$684 USD in 2 dage
(4 bedømmelser)

My team is really interested in this project as it is exactly within our scope of expertise: We are WEB application design & development experts. Please kindly visit our website [url removed, login to view] to learn more about us and Flere

$1444 USD in 20 dage
(7 bedømmelser)

Hi, I'm ready to do it. Great knowledge on php,mysql. Best Regards

$444 USD in 10 dage
(11 bedømmelser)

Hello, I am able to complete your this project so let me have a chance to make you happy. Thanks, Regards, ATechsWorld

$600 USD in 5 dage
(19 bedømmelser)

Hi, Friend. I have enough experience in Mysql & SQLite programming. I also have deep understanding about PHP. I think I can help you perfectly & asap. If u want, I can make the daemon to performing this tas Flere

$578 USD in 10 dage
(1 bedømmelse)

Hi, My approach to your project is as following. 1) Both SQLite and MySQL will include DATABSE_VERSION column in maybe Config table. 2) Comparing database_version value We can decide whether to update the SQLite data Flere

$700 USD in 10 dage
(2 bedømmelser)

Hi, I have 4 year of experience in Java and database development. For one of my client we had created application to sync oracle with mysql online. That was supporting table data sync, both database export import Flere

$553 USD in 5 dage
(4 bedømmelser)

Sir , I have huge experice in PHP as well as Database , I can provide you long term service . Please give me the chance i will return you quality work Thx!

$750 USD in 10 dage
(1 bedømmelse)

We are '3stechmind' team of dedicated software professionals developing the web projects for our [url removed, login to view] area of expertise is design the web site and implement the functional aspects in software technolgies like ph Flere

$526 USD in 20 dage
(2 bedømmelser)

A proposal has not yet been provided

$555 USD in 10 dage
(0 bedømmelser)

Hi, I'm a professional DataBase Administrator and freelance website developper. I can do your job very efficiently. Before i take your project at the specified price, i need the following informations to be sure i Flere

$700 USD in 10 dage
(0 bedømmelser)

Hi, im expert in data integration tools. I have more than 10 years of experience in databases. I can make your project quickly and efficiently. I have a proccess like you need running in my ovh server. Regards

$555 USD in 3 dage
(0 bedømmelser)