My solution needed to work for both Macs: a pretty old version of macOS 10.13 and the newest macOS 12.5. So, back on track: How did I manage to install MySQL on both machines, and share the database with Dropbox? For the old laptop, I couldn’t use any newer version without issues with the Pillow library, and Python 3.8 for the Mac mini because of the M1 chip and issues with tensorflow.
The last background information which could be important: I needed to use Python 3.7 on my laptop, and Python 3.8 on my Mac mini. If you wonder why I decided to use Dropbox: I already use it to store and share all my photos, using it to share the database was a natural conclusion. I executed this query on my laptop, both with SQLite and MySQL: it took SQLite 4 minutes to get result, but MySQL executes the same query, on the same dataset, in 0.07 seconds. The "breaking" point was, when I tried to get all different camera body types with the query " SELECT camera, count(id) AS count FROM photos GROUP BY camera ORDER BY camera". But as soon as I started to introduce more and more data, and improved the search function leading to more complex queries, SQLite did get slow. SQLite worked well in the beginning and was a nice solution. Therefore, I like to use my Mac mini to import and edit the photos in the photo enhancer application, but mostly use the search function on my laptop. My Mac mini is fast, but my laptop is portable. I have an old MacBook Pro from 2014 with macOS High Sierra, and a Mac mini from 2020 with macOS Monterey. Some background information why I needed to share my database, and why I switched from SQLite to MySQL: When I started with my "photo enhancer" application, I used SQLite, which is already included in Python and extremely easy to share through Dropbox – just put the file in your Dropbox folder and that’s it. I want to share my solution on how you can share your MySQL database using Dropbox.
0 kommentar(er)
