Page 2 - Gary's Blog

How to find all indicators and country codes while using imf api

2023-08-08 213 记录 Leave a Comment

When following the imf api service to query data, you have to specify the indicators. You must have viewed this 2 posts: How to Use the API (Python and R) IMF API (Python) But both of them do not explain how to get full list of indicators as well as the country code. Get full list of imf indicators We have to a…

What is OpenAI Function Calling and How to Use it?

2023-06-17 142 记录 ChatGPT, OpenAI 1 Comment

Simply put, OpenAI / ChatGPT function calling can identify the intent and entities in a sentence through a language model. For example, when the user asks "I want to recharge my phone100 USD". The model should recognize the intent recharge and it's 2 entities recharge amont: 100 currency:USD Back to O…

A script to test MySQL port is running

2023-05-03 85 记录 MySQL Leave a Comment

#!/bin/bash ip="<MySQL HOST>" port="<MySQL PORT>" output_file="<Log File Path>" while : do nc -zv "$ip" "$port" > /dev/null datetime=$(date +"%Y-%m-%d %H:%M:%S") if [ $? -eq 0 ]; then echo "$datetime: Port $port is open on $ip…

From PHP to Python In 10 Minutes

2023-04-11 121 记录 PHP, Python Leave a Comment

PHP and Python are both high-level, interpreted programming languages with a variety of applications, but they have some significant differences in terms of syntax, design philosophy, and use cases. Here's a detailed comparison of the two languages: 1. Purpose and Use Cases PHP: Created by Rasmus Lerdorf in 199…

How to compress mp4 in one command with ffmpeg

2023-03-28 78 记录 ffmpeg, mp4 Leave a Comment

With ffmpeg, we can create a free video compresser on our local machine. First, create a shell function on you .bashrc or .zshrc: function mp4-compress() { filename=$(basename -- "$1") extension="${filename##*.}" name="${filename%.*}" ffmpeg -i "$1" -vcodec libx265 -crf 2…

How to transfer data between different mongodb instance?

2023-03-25 63 记录 MongoDB Leave a Comment

Here is the python code to transfer data between different mongo instance: def transfer(source_collection, dest_collection, batch_size: int): offset = 0 total = source_collection.count_documents({}) total_inserted = 0 while True: documents = source_collection.find().skip(offset).limit(batch_size) data = list(do…

How to config logging output to file and stdio/console with basicConfig() in one line?

2023-03-22 99 记录 Python Leave a Comment

import logging logging.basicConfig(format='[%(asctime)s] [%(levelname)s] %(message)s', datefmt='%Y-%d-%m %I:%M:%S', level=logging.DEBUG, handlers=[logging.FileHandler('app.log'), logging.StreamHandler()])

Linux multiple threads download from file with wget

2023-03-20 377 记录 Linux, wget Leave a Comment

Assume we have a file that have all the urls to download. sed 's|^|https://data.commoncrawl.org/|' wet.paths | xargs -n 1 -P 15 wget --timeout=1800 --retry-connrefused --waitretry=10 -nc &

KeyCloak vs Authelia

2023-02-15 2.6k 记录 Authelia, Keycloak Leave a Comment

Category Detailed KeyCloak Authelia Star Github 14,776 15,346 Technical Language Java Go Database for dev H2 (file and memory) SQLite Database MariaDB, MSSQL, MySQL,Oracle, PostgreSQL MySQL, PostgreSQL Cache for dev local Memory Cache Infinispan Redis Redis Sentinel Connections Protocols OpenID Connect, OAuth …

Special Character and Symbol Names on Keyboard

2023-02-03 75 记录 Leave a Comment

~: tilde `: push, open quote, left quote, grave, back quote !: bang, exclamation @: at #: hash, sharp $: dolor %: percent ^: caret, circumflex &: and *: star, asterisk (: left parenthesis ): right parentthesis -: dash, hyphen, minus _: underscore +: plus =: equal {: curly bracket, open brace }: curly brack…