Category: Software

  • PostgreSQL, pgAdmin

    , , ,

    Story about wiped out database or 2 lines of code. Lessons from a Wiped-Out Database: Building a Crypto Portfolio Tracker I’m currently working on a Crypto Portfolio Tracker — a personal project aimed at simplifying how I manage my crypto investments. Previously, I tracked transactions using NextCloud spreadsheets and custom macros to fetch real-time prices.…

  • Docker

    , ,

    Installing Docker on Ubuntu is pretty simple. First step is to setup Docker repository: Second, install the packages: Almost done. But at this point every docker command require sudo privileges. To be able to run without sudo requires add current user to docker group. More about it here. Done! Run test container:

  • Update rClient Rivalz.

    , , , , ,

    Installation process described in previous post Rivalz.AI: rClient CLI. You can use my referral to join for testnet. If you still didn’t update your client rClient you lose your points. Update is pretty straightforward process: Then press ctrl + c to stop the process Paste you EVM address, select drive type, size etc and you’re…

  • Importing Seed Phrase with Custom Derivation Path to Leap Wallet

    , ,

    You should NEVER give your seed phrase or private key to anyone!!! As a user of both Keplr and Leap wallets in the Cosmos Ecosystem, I’ve encountered a common issue when trying to interact with decentralized applications (dApps) that require custom derivation paths. While Keplr supports this feature out-of-the-box, Leap wallet users are left wondering…

  • Rivalz.AI: rClient CLI

    , , , ,

    I’ve decided to participate in RivalzAI testnet and met some challenges on my way to run additional rClient(s).After the announce of rClient CLI I’ve tried to add couple of nodes to farm points. The manual is straightforward but there are some extra steps depending on your system version and software on your machine. 1. Permission…

  • How to download or upload file from VPS

    , ,

    When managing servers sometime it’s needed to move files between remote hosts and local machines. It can be backup files, configs etc. One way it so setup Samba and connect to network storage and share files. Another way is to user CLI command “scp”Download file from remote host: Using ssh key Upload file to remove…

  • ffmpeg. Batch convert files in the folder

    This script allows to convert selected by extension files to any other. For example in particular script selected wav files will be converted to mp3. It will works if modify and paste script to cli. But the better approach is to create file, make it executable and run. All described here you do on your…

  • ffmpeg. Extract images from the video file.

    Lets take a look of the reverse process described in this post. To destructure video file to an array of still images the following needs to be done: ffmpeg uses frame rate from the file so no reason to care about this. For example you need to extract images from specific time: If you need…

  • ffmpeg. Timelapse.

    If you need to gather all your shootings to video file, ffmpeg tool can help to do it in just a seconds. Just navigate to directory with images, change file extension if needed and run the following. Description. Means that filenames are matching the glob pattern, for example img_000*.jpeg Means using as input all the…