Lukket

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----

--Syncing--

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...

--Security--

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.

Færdigheder: Database Administration, MySQL, PHP, SQL, XML

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

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

Projekt-ID: #5985036

19 freelancere byder i gennemsnit $671 for dette job

buraqtech

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 Mere

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

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)
6.6
qtorixsystems

i already have it ready, if u look at stickpos.com 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 Mere

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

A proposal has not yet been provided

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

Hi, I own a small software firm. I have total five employees to work with me. We are a expert in php-mysql and sqlite.We have done a lots of projects on php. your project seems to be easy one.We can do it.If y Mere

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

Dear sir > , Visa Info World Pvt. Ltd. is Indian base company. You can see our work at www.visainfoworld.com or in portfolio section. We provide best solution in low cost . So we want to discuss about your requirement. Mere

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

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 Mere

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

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 Mere

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

Hi there, I'm an Linux expert with a very long professional web hosting experience, see my profile at http://lnkd.in/b5W3zSM. I have also very long experience in building for a companies scallable XEN/OpenVZ/KVM/AWS Mere

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

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 phamtech.net to learn more about us and Mere

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

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

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

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)
3.6
KingOfPhoenix

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 Mere

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

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 Mere

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

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 Mere

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

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)
1.4
ppandare

We are '3stechmind' team of dedicated software professionals developing the web projects for our clients.Our area of expertise is design the web site and implement the functional aspects in software technolgies like ph Mere

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

A proposal has not yet been provided

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

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 Mere

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

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)
0.0