便携式MySQL数据库 [英] Portable MySQL Database

问题描述

早上好，伙计们，



我目前正在开发一个发票申请表，我的客户可以从数据库中选择产品并输出发票。然后将每个订单发送到准备好的服务器等。



我对这个项目的第一个想法是实时连接到数据库并发送订单通过3G立即获得信息，因为该应用程序将用于Windows平板电脑。



经过一番思考，我想出了另一个（可能更好）的想法，我现在希望程序自动获取MySQL数据库的副本（例如在销售人员去订单之前）并将其存储在本地，然后程序在本地数据库上工作，使应用程序更加快速，高效和防错。



在一天结束时，客户将使用主数据库更新本地数据库。



我对这个解决方案的问题是我不知道如何从MySQL服务器开始实现本地数据库。



任何帮助都会得到认可



谢谢，

Andrew B. org

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

推荐答案

哇那里！你不知道你在这里问的是什么！



获取本地副本是一项微不足道的操作，但是本地数据库的概念不是MySql所知道的 - 你需要在它运行的每台机器上安装一个MySql。



更糟糕的是，你将不得不处理复制，这是它自己很好的厚度本书主题全部都是自己的！问题是，您不能只是将添加记录添加到十个本地数据库中，并希望在将它们返回到基础并将数据填充回主数据库时将它们全部整理出来 - 您必须是非常小心，否则您将丢失数据，或将客户与错误的订单相关联。这当然是可能的，而且效果很好，但它不仅仅是复制并逃跑。



时间做好阅读！从这里开始： http://dev.mysql.com/doc/refman/5.0/en/replication .html [ ^ ]然后通过谷歌分支出来。

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.

MySQL数据库的便携版本就在这里......



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

Portable version of MySQL database is here...

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

在便携式设备中拥有这样的敏感数据并不是一件好事，但实际上是一个坏主意。从简单的安全性到复制和备份，你需要考虑很多事情。



最好的想法是将数据库放在其他一些远程位置（服务器）并具有网络访问权限（最后，在移动设备中使用3G / 4G /等建立一个网络连接，允许您使用标准TCP / IP ipV4 / ipV6连接进行远程连接）。



如果您需要其他类型的应用程序，可以使用一个基于文件的开源便携式数据库： SQLite [ ^ ]。

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[^].

这篇关于便携式MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！