Write standalone program to use MYSQL database

I have a MYSQL database hosted on website
I want to create a standalone program to run on windows PC that will use the MYSQL database to display appropriate data
The standalone program must be able to run external programs that are on PC that the database refers to
Any suggestions on the approach, language etc would be welcome.
LVL 1
AIGSNetwork AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
You would need to provide more detailed info on what resources on the PC the application shou,d be able to call on?
Do you have visual studio that you will be creating the application? You would need to get the MySQL odbc driver.......
1
John TsioumprisSoftware & Systems EngineerCommented:
The easiest and fastest way for such kind of operations is Ms Access...here is a small demo of a project i am working right now (very early stage)
The data come from my VPS server located over the Internet so you are seeing a data retrieval of 1000 rows with 25 columns and then the transfer to Excel Spreadsheet...
0
AIGSNetwork AdministratorAuthor Commented:
John - I was using MS Access 2010, when we had the data in Access stored on our server, worked well.
Since we changed over to MySQL keeping the data on our website host and after setting up ODBC connection for the same access front-end, I can see the tables and run queries, but using treeview to display the data in a form is not working. It seems the recordset that is created loads too slow  and causes form to freeze! - aigs
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

nociSoftware EngineerCommented:
The problem with some tools is that they don't only run select remotely but select all and then filter afterwards.
Which will make it slow.

Did you try to use mysqlworkbench to access the remote database?
(If the database is accross the internet, are you using a TLS(ssl) secured link?)
If the database is remote, it might be far better to create an API that runs on top of the database and access that API from your workstations.
This will create an extra layer of security in that the database can only be changed according to the rules set in the API.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
The problem is that lot of people believe that by switching BE to MySQL...is like a magic pill...well it isn't..it requires considerable homework.
Probably it would be better if you create a Gig...
0
AIGSNetwork AdministratorAuthor Commented:
I have a database which I want to use on externally hosted website and I also need to use it on out internal network. At the end of the day it doesn't really matter if it is in MYSQL or MS Access.
The current front-end (forms) to use the database is in MS Access (in the past this has worked fine when data and forms have both been on the internal network).
As the external website is written in php, I thought I could use MYSQL on external website and use MS Access front-end on internal network (which would link to MYSQL database) - it does work but very slow and causes some issues in retrieving the data.
So, would I be better in having the data in MS Access on internal network and connect to it with php from external website using PDO ODBC to be able to view data on website?
I only want to have one master database but be able to access it from external website and also our internal network - I don't want to have to copy data from one to the other when changes occur.
Am I barking up the wrong tree or is this feasible?
0
John TsioumprisSoftware & Systems EngineerCommented:
Well probably you didn't saw my demo ...lets take it again....if you use MySQL as Access its going to be slow...dead slow....if you have a lot of records you would probably "see" timeouts ..and the whole process...is slow...
On the other hand if you use MySQL as MySQL then you will have a database solution that works globally speedy and efficiently...a quick and dirty example right now....fetching 1000 rows and 90 columns on my VPS (1 core Intel® Xeon® E5-2650L v4, 1Gb Ram...over Wifi from accross the street router  (not on the same room) over ADSL ...ping around 2-3 ms...or more ..:)   ) ...time less than 10 seconds....(keep in mind i haven't designed the database)
0
AIGSNetwork AdministratorAuthor Commented:
In the end - after more research I found using dbOpenSnapshot & dbReadOnly with dbOpenRecordSet solved the issues for siaplaying data in a TreeView.
0
John TsioumprisSoftware & Systems EngineerCommented:
Well....this my 2 cents
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.