Google Cloud Platform > Cloud SQL > MySQL 2nd Generation Instance
has been created.
The DB in this instance has my Mac and
Microsoft Access (no MacOS version) or
LibreOffice Base (There is a Mac version, but there is some instability, and it is hard to say that the Japanese language forum is fulfilling)
I would like to connect with Japanese & GUI-based applications such as
In particular, I would like to do the following in Japanese & GUI (in short, they might say it's anything).
Therefore, in addition to the two applications listed above,
Please let me know if you have any recommended applications or development environments.
Applications that require tens of thousands of yen a month, and
Even if you buy it out, if it's over 150,000 yen,
Please do not select
I have included Google App Maker in my options, but I'm still starting to use it.
Not to mention understanding the usability, we have not been able to connect to the relevant DB.
However, if you recommend App Maker, please let me know.
(Please let me know if there is anything that doesn't make sense because I'm not familiar with it.)
mysql google-apps-script google-cloud google-app-engine libreoffice
If you want to create a form like MS Access, you may have fewer choices.
Virtualization software such as VMWare and Windows+MS Access may be the most convenient.
(I can eat the CPU, but I think I can operate it seamlessly on my Mac.)
Database management is the same as normal MySQL, so you can manage it through the GUI using MySQL Workbench
or phpMyAdmin
.However, for phpMyAdmin
, you must install it on your Mac and access it remotely.
In addition to Access
and LibreOffice Base
, you can also connect from Excel
. In the case of Excel
, you can easily retrieve data from MySQL by installing the ODBC driver.The Mac version is also charged, but there seems to be an ODBC driver.On the other hand, it is quite difficult to put data into MySQL from Excel
, so I read the Excel
file in Python
and then process it in Python
.This also works on a Mac, but it does not meet the requirements because it is not a GUI. I would be happy if Python
was installed in Excel
, but I don't know what time it will be.
Macs have FileMaker Pro Advanced
software close to Access
.It supports MySQL and there is an evaluation version, so why don't you try it?However, as for business software, Windows is overwhelmingly strong, so I don't think you can expect support like using Access
on Windows.
Also, a PHP web application called LAMP
uses MySQL.For example, the WordPress
that you use to create blogs uses MySQL, and the WordPress
is rich in plugins, so it may be useful for some purposes to create forms.Also, there are many applications in the web system, so if you clarify the purpose a little more, there will be many that can be used.However, it may be difficult if you are used to MS Access
because we will design using HTML and CSS, but the reason why many apps are becoming web these days is that web is easier to make, so I would like to consider it.
I'm sorry to respond to the old thread, but...
FileMaker Pro Advanced, but they don't expect community support.Unfortunately, community support is a must for me...
I would like to add that this is never the case.
There is official support, and there is a community because there are many long-term users.
For example, the following is my community at Discord.
You can also ask questions in the chat room, so please refer to it.
Regarding your initial request, FileMaker Pro can handle the following:
こちらThis is only possible
こちらYou can do this by creating your own scripts.
こちらThis is possible.
こちらThis can be done by re-drawing on FileMaker Pro.
© 2024 OneMinuteCode. All rights reserved.