+ 9
Is it necessary to install mysql to save and retrieve sql data on another computer locally?
I have made an java application which utilises SQL database through MYSql . But I want to transfer that exe file to another computer. I want that the data is stored and can be accessed locally on that computer without installing Mysql on that computer through the Java application . Is there any solution to this problem ?
32 odpowiedzi
+ 7
Rugved Modak well I have never used firebase..
But regarding the question I would suggest some cloud server...nut internet seems an issue here so I think user needs DBMS to be installed... 😅
+ 5
No from India
+ 5
Rugved Modak never used sql since 79. It was way too slow for our needs so we tossed it in favor of a custom database code.
+ 5
Oma Falk flew past me😅😂
+ 5
Oma Falk could you explain me in more simpler way?
+ 5
Oma Falk that's amazing solution but the problems to this are -
1. The transfer of data will not be possible if mine computer (c1) is shut down. I have to keep my computer open for approx 10 hrs. That will consume lots of power. However I can 'buy' a cloud server as a solution to this problem but it would be illogical to buy one for only 2 to 3 people.
2. If my computer (c1) shuts down for any reason, client's work will stop completely. And if this happens , he will not spare me😂
3. I don't know how to implement it.😂😂
+ 5
1.u can use a raspberrypi as sever 5v 1A. power consumption. 10$ for zero version
2. let him run. my raspi is a wlan hotspot always running.
3. yes thats hard... as my boss always said: do it anyways.
+ 5
Thanks Oma Falk for the motivation 😂
+ 5
Personally, if installing mysql isn't an option, I'd remove it from your application. Replace each usage of with the equivalent reading/writing of files, after all that is all mysql is doing for you.
Depending on the number and type of commands, you could manage it in days. Back in the day, it took my team of 5 a week to replace all sql in 100k lines of code.
+ 4
Juan Pineda Actually I am creating this application for a client and the data will be stored in his computer . I would have no access to that
+ 4
Juan Pineda Kind of cloud server?
+ 4
If that is applied , then the client will not be able to store data without internet connection and this is not a good case since internet connection may not always work and is often taken down by the government for various reasons . If something important is too be done at that point then it would be a nightmare
+ 4
Same situation like mentioned above😅
+ 4
Rugved Modak Ask from sql users
+ 4
Rugved Modak firebase is used for mobile apps
+ 4
ahhh... ok
Computer 1 (c1)has sql installed
computer 2(c2) has your. exe program
c1 reads sql data and transfers them into a text file and sends the textfile to c2.
.... maybe every hour
the. exe reads the txt file.
+ 4
John Wells yes.. lot to do.
that was a part of my first answer. a (professional) program should be independent of the technic eg for retrieving data. one should be able to change it like a dvd.
The same for representing output. There should be exactly one responsibility with a clear interface.
Well... clever insights have a tendency being always a bit too late😉😉😚
+ 3
Siddharth Golecha
???
please explain
+ 3
how to transfer txt:
ftp, scp, attachment of email.
depends on the location of c1 and c2
+ 3
Rugved Modak sure here are many raspi experts on SL