what does this PR do?

live templates loading from appwrite

you can test here:https://code-in-the-dark-editor-git-feat-templates-seborans-projects.vercel.app/compete

How does it work?

Set an appwrite collection with every attributes implementingTemplateInformations interface:

interfaceTemplateInformations{eventName:string;referenceImage:string;instructions:string;injectCode?:string;showPreview:boolean;demoMode:boolean;}

CreatedfetchTemplates.ts which plugs to appwrite in server side.

Long pooling using SWR.

page previews are hosted in an appwrite bucket to keep them hidden.

I don't think we should move the other images and logos because we it makes relative URLs simpler

New env variables

You need to set 4 new environments variables:

APPWRITE_PROJECT_ID=""APPWRITE_DATABASE_ID=""APPWRITE_COLLECTION_ID=""APPWRITE_READ_TOKEN=""

Some ideas and questions

• long pooling with SWR works fine, but I wonder if won't make huge requests spikes...
  Thinking about this point, at the very worst we would have 8 participants long pooling every 2 seconds during 5 minutes, which would amount to 1200 requests, don't think it would make a huge impact
• I refactored page.tsx to make it server side only because it looked cool, but now we're long pooling I wonder if it's useful
• it's a bit cumbersome to change an entry
• I don't think setting a timestamp is a good idea. we should manually change timings because we never know when a competition will start for real or if everybody is ready.
• sorry forpnpm-lock.yml changes 🙈