Metabase deployed on Oracle Cloud Free Tier. using wallet Connect to free Oracle Autonomous Database

    It is difficult to find a free stock financial data interface now. Extracting financial data from Yahoo Finance may be the easiest method in the free solution. Since yahoo Finance canceled API support, you can only write your own crawler or use a third-party library, but yahoo occasionally Page changes and regional restrictions also cause great trouble for crawling data.

    This article introduces the yahoo_financials_stmt package I recently submitted to get stock financial data Project address：https://github.com/luckfu/yahoo_financials_stmt

Usage：

I have an old mac pro in my office. The operating system is big sur. It uses wifi to connect to the internal network and Bluetooth to connect to the external network of the mobile phone. Unfortunately, I recently upgraded Monterey and the Bluetooth network connection disappeared.Bluetooth PAN is missing

macOS big sur，bluetooth connection to mobile phone network

The last article mentioned that Oracle Cloud’s free and popular 4c24g VM.Standard.A1.Flex model is difficult to apply, but in actual use, there are still many traps in the Oracle Cloud free package. The following are some common situations:

Free hosting is over quota, free storage is over quota, oc priority to stop the resource is this A1.Flex vps 。

Flex.A1 The optional operating system is only oracle linux v7 or v8 , if you like ubuntu…😭

When the operating system is broken, unlike general cloud service consoles that can restore the image, you can only reapply

Using a container as a virtual machine is not in line with the original intention of container application deployment, but in view of the above problems, docker is used to create a container instead of a virtual machine in this article. Everything is operated in the virtual machine. When the system disaster is unrecoverable, just delete container and Create the container again.

Oracle cloud open registered account can apply for 4c24g free cloud server, database and other services, 1c1g x86 server is easier to apply, but the popular 4c24g Ampere A1 type of host under normal circumstances can not apply through the web, currently popular on the Internet Cybersquatting methods are nothing more than two modes：

• Browser plug-ins or scripts or button wizards. The problem with this method is that the console is timed out. It is also easy to be judged by the server as illegal operations. Accounts are disabled. It is obviously not suitable for operations that require stable operation for several days.
• Call the oci command script, this is the safest mode, because oci is officially provided by oracle, the principle is to use the oci command to directly apply for an instance, for example：

oci compute instance launch ....

However, according to my Hong Kong host test, this can only be refreshed every 20 seconds at most, because the complete process of the oci command execution：

• 1、start to connect to oracle cloud
• 2、Verify user legitimacy
• 3、Excuting an command
• 4、exit

Steps 1, 2, and 4 waste a lot of time in the loop. In this article, we use python to call the oci api , omit multiple verification , and execute the create instance command in loop. The refresh speed can reach 3 seconds/time. When the instance creation is successful, return ,Automatic withdrawal.