Portable MySQL Database

Question

0.00/5 (No votes)

See more:

Good morning Guys,

I am currently working on an Invoice Application where my client can select products from a database and output an invoice. Each order is then sent to the server where it will be prepared etc.

My first idea for this project was to connect to the database in real time and send the order information right away via 3G since the application is going to be used on a windows tablet machine.

After some thinking, I came up with another ( possibly better ) idea, I now want the program to automatically grab a copy of the MySQL database ( before the sales man go and take orders for example ) and store it locally, then the program works on the local database making the application much faster, efficient and fault proof.

At the end of the day, the Client will update the local database with the Main database.

My problem about this solution is that I don't know how to start implement the local database from the MySQL Server.

Any help would be Appreciated

Thank You,
Andrew Borg

Posted 12-Jun-12 18:32pm

Andrew_Borg

Add a Solution

3 solutions

Solution 1

Whoa there! You do not know what you are asking here!

Getting a local copy is a trivial operation, but the concept of a "local database" is not something MySql knows about - you would need a MySql installation on each and every machine it is to run on.

Worse, you will then have to deal with Replication which is it's own good thick book subject all on it's own! The problem is that you can't just go "add a record" to ten local databases, and expect them all to be sorted out for you when you return them to base and stuff the data back into the main database - you have to be very careful, or you will lose data, or correlate a customer with the wrong order. It is certainly possible to do, and it works pretty well, but it isn't just "get a copy and run away".

Time to do a good amount of reading! Start here: http://dev.mysql.com/doc/refman/5.0/en/replication.html[^] and then branch out via Google.

Posted 12-Jun-12 19:05pm

OriginalGriff

Solution 3

Having such a sensitive data in the portable device is not a good, but a realy bad idea. You'll have many things to take into account, from simple security to replication and backup.

The best idea would be to have the database in some other remote location (server) and have network access to it (at the end, 3G/4G/etc is used in the mobile device for establishing one network connection that permits you remote connections using standard TCP/IP ipV4/ipV6 connections).

If you need it for other type of application, there's one filebased open source portable database you can use: SQLite[^].

Posted 24-Sep-13 20:37pm

V.Lorz

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 7918016 · Accepted Answer · 2013-09-24T20:12:00

Solution 2

Portable version of MySQL database is here...

http://www.mediafire.com/...Portable.Mysql.5.5.13-Very.Small.rar[^]

Posted 24-Sep-13 20:12pm

Member 7918016