Skip to content

Instantly share code, notes, and snippets.

View eta-orionis's full-sized avatar

eta-orionis

View GitHub Profile
@eta-orionis
eta-orionis / gitea-downgrade-1.23..1.22.sql
Last active July 14, 2026 16:07 — forked from hinrikus/gitea-downgrade-1.23..1.22.sql
Downgrade gitea database (postgresql) from 1.23 to 1.22 revision 310 to 298 for possible migration to forgejo
-- make sure you have a backup
-- tested only with postgresql
alter table issue drop column time_estimate ; -- 311
alter table protected_branch drop column priority; -- 310
drop index "IDX_notification_commit_id", "IDX_notification_issue_id", "IDX_notification_repo_id" , "IDX_notification_source", "IDX_notification_status", "IDX_notification_u_s_uu" , "IDX_notification_updated_by", "IDX_notification_user_id"; -- 309
drop index "IDX_action_r_u_d", "IDX_action_au_r_c_u_d", "IDX_action_c_u", "IDX_action_c_u_d"; -- 308
@eta-orionis
eta-orionis / README.md
Created August 8, 2026 13:42 — forked from XDflight/README.md
Remove cache and old extensions under "~/.vscode-server/" on your Linux server

If you often connect to your Linux server using VSCode, the "~/.vscode-server/" folder (and sometimes the ~/.cache/ folder too) can get very large because VSCode:

  1. Does NOT clean its download cache after installing extensions;
  2. Does NOT delete old extensions after updating them;
  3. Does NOT remove old VSCode servers after installing a new version.

If your server storage space is limited, you might consider cleaning "~/.vscode-server/" (and ~/.cache/) regularly using the bash script I wrote. Simply run the following command:

curl -sL https://gist.githubusercontent.com/XDflight/5f3509eb84fc282b88059c909036f5bc/raw/fe2a3e7dab19160c17efc7025d138f5350964c0f/clean_vscode-server.sh | bash -s