Skip to content

Instantly share code, notes, and snippets.

View jnsprnw's full-sized avatar
🍊
Making smoothies

Jonas jnsprnw

🍊
Making smoothies
48 followers · 50 following
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.

@jnsprnw
jnsprnw / keybase.md
Created November 11, 2022 08:01

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": "🇦🇷",
@jnsprnw
jnsprnw / Google Sheets JSON.md
Created February 12, 2020 15:34 
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
@jnsprnw
jnsprnw / Extracting objects by ID in OpenStreetMap.md
Created April 17, 2019 04:20

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;
@jnsprnw
jnsprnw / Dhaka Metro Line 6.geojson
Last active April 17, 2019 07:51
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jnsprnw
jnsprnw / Dhaka Metro Line 6.geojson
Created April 16, 2019 06:42
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jnsprnw
jnsprnw / extensions.md
Last active March 18, 2019 09:26
Firefox Extensions for Privacy and Convenience
@jnsprnw
jnsprnw / Kennedy Elliott links.md
Last active October 20, 2018 14:55
Kennedy Elliott’s links from her talk at the Information+ conference 2018