Feature: Figure out the initial database solution

[ViorelMocanu]

We need to figure out a way to store:

• all the 1635+ links and their metadata:

• the user profile information for login purposes

• the user generated content like comments, likes, etc.

• Databases integrated into Astro, including:

  • Supabase - Astro guide (can be a database, authenticator and store) DOWNSIDE: no clear tutorials / examples.
  • Xata - Xata guide, Astro guide DOWNSIDE: early adoption risk.
  • Firebase - Astro guide - can be used for authentication and data storage

• Edge storage from the host itself:

  • Vercel - Vercel guide, Astro guide, Postgres provider, key value storage, A/B testing edge config, blob file storage DOWNSIDE: no / problematic built-in authentication.

• CMS solutions integrated into Astro, including:

  • DecapCMS - guide - context on Reddit
  • Strapi - Astro guide, Strapi guide, Strapi Tutorial, Dev.to article, generic article DOWNSIDE: external dependency.
  • Storyblok - Astro guide DOWNSIDE: ?.
  • Builder.io - Astro guide, ⭐starter project with SolidJS DOWNSIDE: ?.
  • Sanity - Astro guide, Sanity guide, ⭐starter project with React and Vercel - https://www.builder.io/m/headless-cms DOWNSIDE: ?.
  • Alinea DOWNSIDE: no Astro native integration.
  • Webiny DOWNSIDE: no Astro native integration.
  • CraftCMS DOWNSIDE: no Astro native integration, paid.
  • NetlifyCMS - Example
  • Directus - demo + guide + local setup / cloud + video tutorial

Examples:

• Astro-Supabase-Vercel -> https://astro-supabase-vercel.vercel.app/
• Astro Supabase
• supabase-auth-helpers-astro