Forem: Lyner Lim

MariaDB - can log in via the command line but not through app like TablePlus

Lyner Lim — Tue, 04 Mar 2025 08:54:48 +0000

For MariaDB older than 10.4

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NewPassword');
FLUSH PRIVILEGES;

then

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NewPassword');
FLUSH PRIVILEGES;

Python - datetime as filename

Lyner Lim — Tue, 04 Mar 2025 07:40:58 +0000

filename = f'{datetime.now():%Y-%m-%d-%H%M}'

with open(f'{filename}.txt', 'w') as file:
    file.write('hello')

Tweepy - Twitter Data Scraping in 2025

Lyner Lim — Tue, 04 Mar 2025 06:37:48 +0000

Note that to select Read and write in App permissions under User authentication settings.

client = tweepy.Client(
    bearer_token=BREARER,
    consumer_key=API_KEY,
    consumer_secret=API_KEY_SECRET,
    access_token=ACCESS_TOKEN,
    access_token_secret=ACCESS_TOKEN_SECRET,
    return_type = dict,
    wait_on_rate_limit = True
)

response = client.search_recent_tweets(
    "artifical intelligence OR machine learning lang:en",
    max_results = 10,
    tweet_fields = ['author_id','created_at','text']
)

Git - RPC failed; HTTP 400 curl 22 The requested URL returned error: 400

Lyner Lim — Wed, 06 Nov 2024 06:46:10 +0000

In my case, this error occurred because I attempted to push a file size of 30MB. We resolved this issue by increasing Git’s HTTP buffer size to accommodate larger pushes. Say we set the size to 150mb, using the following command:

git config --global http.postBuffer 150000000

git config --global --get http.postBuffer

After entering these two lines, our push should work successfully.

Ubuntu - Enter sudo Password in a Single Command

Lyner Lim — Sat, 26 Oct 2024 02:15:09 +0000

If you’re using the terminal on Linux or Mac, echo <password> | sudo -S <command>.

If you’re doing this programmatically, for example in Python, os.system(f'echo {password} | sudo -S {command}').

Troubleshooting: curl/wget Fetching HTML Instead of Files

Lyner Lim — Sat, 26 Oct 2024 01:40:20 +0000

Have you ever tried to download a file using curl or wget, only to end up with an HTML page instead? It’s likely that the URL isn’t pointing directly to the file. Let’s use downloading a file from GitHub as an example.

If you just click on the file like this link (https://github.com/docker/docker-install/blob/master/install.sh), right click to inspect and you will see it is in html.

What we should do is click on the Raw to get this link (https://raw.githubusercontent.com/docker/docker-install/refs/heads/master/install.sh).

Now, wget https://raw.githubusercontent.com/docker/docker-install/refs/heads/master/install.sh or curl -O https://raw.githubusercontent.com/docker/docker-install/refs/heads/master/install.sh will download the install.sh file to your local directory.