Tidbits

VSCODE: You can increase a number in VS Code

• control a increases numbers and you can do it with visual mode

Docker: Pruning - Clean up system

• https://docs.docker.com/config/pruning/

docker system prune

docker system prune --volumes

CF Tunnels

• to get it to work I had to:
• follow guide to step up locally
• then in CF Access migrate
• add connections there

VSCODE & Vim

• make shortcuts in terms of what you do the action #nugget i.e. what comes to mind I want to wrap this

NPM

NPM vars #nugget

• // “build:copy-dist”: “cp -r dist ../dist/$(echo $npm_package_name)“,

JSON Faker has a good example of exporting different versions of js code

• https://github.com/json-schema-faker/json-schema-faker/blob/develop/package.json

Firefox minimap

https://www.stefanjudis.com/a-firefox-only-minimap/

Vim in browser

• https://github.com/philc/vimium

Docker: Backing up Mattermost

docker cp container123:/path/to/example.txt . tar -czvf my_folder.tar.gz ~/my_folder

Sqlite: how to tell what version of sqlite a db is using

file database.sqlite

Linux(Ubuntu) Disable Super P to change monitor setup

• https://askubuntu.com/questions/68463/how-to-disable-global-super-p-shortcut

SQlite: Grab sub select of data to insert

• https://stackoverflow.com/questions/75675/how-to-dump-the-data-of-some-sqlite3-tables

.mode insert <target_table_name>
.out file.sql
select * from MyTable;

Mattermost: Manually install a plugin

https://developers.mattermost.com/integrate/plugins/components/server/hello-world/#install-the-plugin

scp to host docker cp into /mattermost/plugins tar -xvf file.tar.gz done!

Cloudflare: starting a new project

npm create cloudflare@2

Sqlite

• how i move data around
• get list of column names
• modify the ones that need to change like accountId

SELECT GROUP_CONCAT(name) from PRAGMA_TABLE_INFO('lists');

select name, 105 as boardId, meta, '[]' as cardIds, onEntry, 3 as accountId from lists;

• go into sqlite and use .mode insert (docs above)
• take that file and add the appropriate cols used before each insert values
• use that to insert into new database

sqlite path/to/database.db < insert.sql

Fixing Docker services that lost image reference and fix nginx for caprover

docker service ls
docker images
docker service update --image img-captain-remnant srv-captain--remnant
docker service update --image img-captain-remnantapi srv-captain--remnantapi
docker service update captain-nginx --force