Oss

DBeaver, which lets me edit PostgreSQL data in bulk through a GUI while writing almost no SQL, had been invaluable. It is Java based, though, so it is fairly heavy to start up, and I had come to want something a bit lighter for looking at several databases together. That was when I found DBX. It is free, supports many databases, and is said to run lightly. I decided to try building it into my Traefik-fronted Docker environment. [Read More]

When you work with npm / yarn / pnpm a lot, node_modules directories get created one after another, and before you know it they are eating into your disk space. Repositories I tried out, verification projects I left lying around, old clones… hunting down the scattered node_modules one by one and running rm -rf is tedious, so I am noting down that a command called npkill makes tidying up easy. [Read More]

I have written about upgrading Growi before, but this time it is a major upgrade from 4.x to 5.x. Assume that Growi is running on Docker with the configuration below App Version Growi 4.5.19 mongodb 4.4 Note that if you are building it with docker for the first time, you can build it just as the official installation describes, so the work from here on is unnecessary Get 4.x up to the latest version first If you are running it on docker, I think it is better to update 4.x to the latest version as far as you can, based on the official upgrade information below. [Read More]

Restrictions imposed by Twitter 2023/6/30 Because of Twitter's API restrictions and the restriction on viewing without logging in, fetching Twitter posts and so on through nitter is no longer possible Building Nitter with Docker as described below is still possible, but it is of no use unless the restrictions on the Twitter side are lifted Nitter is a Web client for Twitter, and you can view it without having a Twitter account you can view it without logging in to Twitter no ads are inserted you can turn the timeline of a user or keyword you are interested in into RSS This time I build it myself with Docker, but Nitter has an official site and instances, and using those is fine, so there is no need to force yourself to build it [Read More]

I wanted to manage software licences as well as the appliances and assets in my home, so I looked around for a good open source option, found the IT asset management system Snipe-IT, and set it up right away. This is how to install it with Docker Installation and configuration Copy $ git clone https://github.com/snipe/snipe-it.git Edit .env.docker Copy APP_DEBUG=false # please regenerate the APP_KEY value by calling `docker-compose run --rm snipeit bash` and then `php artisan key:generate --show` and then copy paste the value here APP_KEY=base64:3ilviXqB9u6DX1NRcyWGJ+sjySF+H18CPDGb3+IVwMQ= APP_URL=http://localhost:8000 -APP_TIMEZONE='UTC' -APP_LOCALE=en +APP_TIMEZONE='Asia/Tokyo' +APP_LOCALE=ja Port 8000 is used by default, so if you want to change it, change ports in docker-compose.yml [Read More]

TR;DR Assume that Growi is running on docker with the configuration below App Version Growi 4.2.21 mongodb 3.6 There are major changes from Growi 4.3 onwards, so when you upgrade from 4.2 or earlier to 4.3, look through the official articles first And be sure to take a backup before starting the work! Updating mongodb Up to Growi 4.2.x it could also run on mongodb 3.x, but 4.3 requires mongodb 4.4, so mongodb has to be updated I did the work of updating mongodb in the order 3.6->4.0->4.2->4.4 [Read More]

When I updated tt-rss, also known as TinyTinyRSS, to the latest version with git pull, it stopped starting up with the error below PHP UConverter class is missing, it’s provided by the Internationalization (intl) module. The environment it was running in at that point: nginx : 1.16.1 PHP(php-fpm) : 7.3 mysql : 5.5.62 Since it is an error related to Internationalization (intl), I checked the package involved, but it was already installed (php73-php-intl) [Read More]