将数据从 PC 应用程序传输到远程托管数据库
基本上我希望能够将数据从 PC 应用程序传输到远程托管数据库。
我开发了一个wxPython应用程序，用于解析和分析测试数据。
我想更新应用程序，以便它可以将分析的数据传输到在线 MySQL 数据库。
由于它仅供大约十几个人在室内使用，因此不需要非常强大，只需一个简单且有效的解决方案即可。
我在服务器端方面没有太多经验，所以我不太确定这通常是如何完成的，我知道由于安全限制，不可能从应用程序直接连接到数据库。我想我可以使用 ftplib 将数据作为文件上传，然后使用 urllib2 调用 PHP 脚本（将数据插入数据库） >。 这行得通吗？
Basically I want to be able to transfer data from PC application to remotely hosted database.
I have developed a wxPython which application which is used for parsing and analysing test data.
I want to update the application so that it can transfer the analysed data to an online MySQL database.
As it is for just for in house use by about a dozen individuals it doesn't need to be ultra robust, just a simple solution that works.
I dont have much experience on server side stuff so Im not really sure how this would usually be done, I know that directly connecting to the database from the app is not possible due to security restrictions. Im thinking the I could use ftplib to upload the data as files and then call a PHP script (to insert the data in the db)with urllib2.
Will this work?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以访问服务器端吗？如果是这样，您可以启用安全远程 mysql，或添加允许访问的 php 页面。例如，Python可以使用urllib打开“mypage/search.php?name=name&otherdata=otherdata”，并读取结果。这也适用于网络浏览器。
似乎上传文件然后调用脚本来运行会有点低效且不太安全，并且需要访问服务器。为什么不对数据库进行安全的远程访问？
如果有可能设置 Mysql 连接，我会研究一些 Python Mysql 示例：
http://www.kitebird.com/articles/pydbapi.html
首先让它工作在一个小示例脚本中，然后您可以将代码粘贴到您的项目中。
Do you have access server side? If so, you could enable secured remote mysql, or add a php page that allows access. For example, Python could use urllib to open "mypage/search.php?name=name&otherdata=otherdata", and read the result. This would also work in a web browser.
It seems uploading the file and then calling a script to run would be a bit inefficient and less secure, and would require access to the server. Why not have secure remote access for the database?
I'd look into some Python Mysql examples, if there is a possibility of setting up Mysql connections:
http://www.kitebird.com/articles/pydbapi.html
First get it working in a small example script, then you can paste the code into your project.