Skip to content

Instantly share code, notes, and snippets.

View jnsprnw's full-sized avatar
🍊
Making smoothies

Jonas jnsprnw

🍊
Making smoothies
View GitHub Profile
@jnsprnw
jnsprnw / strapi-on-uberspace.md
Last active March 2, 2024 13:28
Tutorial on how to install Strapi on Uberspace

Strapi on Uberspace

Some people had problems building Strapi on Uberspace since it will kill your procress when it uses more than 1.5GB of RAM. I had the problem with some versions of Strapi, but the current (4.5) run through without any problems.

⚠️ Notice that you need to run Node version 14 on your Uberspace to run Strapi (uberspace tools version use node 14).

1. Database (Postgres)

I run into problems when running Postgres on Uberspace and using it for Strapi. (Something with pooling) And since I’m no expert in Postgres I decided to switch to Supabase’s free plan. This also saves Uberspace some ressources. If you want to run Postgres on Uberspace, follow this tutorial.

So for Supabase, first create an account and a new database/project. Next, go to Project Settings/Database. You find all the credetials there. Save them for later.

Keybase proof

I hereby claim:

  • I am jnsprnw on github.
  • I am zeto (https://keybase.io/zeto) on keybase.
  • I have a public key ASDtcnkWVKUmI8yGiDTfqwyBhXP_wAc_upm5Zz-OcvYWJAo

To claim this, I am signing this object:

@jnsprnw
jnsprnw / countries-emojis.json
Created July 9, 2022 15:15
JSON file with country ISO 3166-1 alpha-3 and emoji flags
{
"ABW": "🇦🇼",
"AFG": "🇦🇫",
"AGO": "🇦🇴",
"AIA": "🇦🇮",
"ALA": "🇦🇽",
"ALB": "🇦🇱",
"AND": "🇦🇩",
"ARE": "🇦🇪",
"ARG": "🇦🇷",
https://spreadsheets.google.com/feeds/list/ID/od6/public/values?alt=json
/feed/entry/
´´´
@jnsprnw
jnsprnw / NACE REV 2.csv
Created August 1, 2019 13:44
Statistical Classification of Economic Activities in the European Community https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:32006R1893
Section Division Group Class Activity ISICRev. 4
A Agriculture, Forestry And Fishing
01 Crop and animal production, hunting and related service activities
01.1 Growing of non-perennial crops
01.11 Growing of cereals (except rice), leguminous crops and oil seeds 0111
01.12 Growing of rice 0112
01.13 Growing of vegetables and melons, roots and tubers 0113
01.14 Growing of sugar cane 0114
01.15 Growing of tobacco 0115
01.16 Growing of fibre crops 0116

Go to https://www.openstreetmap.org/ and make a right-click on the object and select »object request«. See if it’s an node, way, relation or area and copy the id in the parentheses.

Open https://overpass-turbo.eu/ and type:

Node (Single Point)

(node(265576692);>;);
out skel;
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.