Hi @steel fox. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
#Project with document per pages
sacred fossilBOT
Hey there 👋
For your project where each page's data is stored as a JSON document that users can modify, you have a couple of options depending on your specific needs for performance, scalability, and ease of use.
Option 1: Storing JSON in a Database
Using a JSONB column in a database like PostgreSQL can be a great idea if you need:
- Structured, relational data: If you need to perform complex queries, joins, or transactions, a relational database like Vercel Postgres (https://vercel.com/docs/storage/vercel-postgres) would be beneficial.
- Fast reads and writes: PostgreSQL is optimized for these operations and can handle JSONB data efficiently.
- Serverless SQL: Vercel Postgres offers a serverless SQL solution that integrates well with Vercel Functions.
Option 2: Storing JSON in a Blob Storage
If your primary need is to store large, content-addressable files and you don't need complex querying capabilities, then using a blob storage solution might be more appropriate. Vercel Blob (https://vercel.com/docs/storage/vercel-blob) offers:
- Optimized storage for large files: Ideal for storing images, videos, and other large files.
- Global network: Ensures fast access and delivery of your content.
Recommendation
Given that your data is JSON and users can modify it freely, if you need to perform complex queries or transactions on this data, I would recommend using a JSONB column in a database like Vercel Postgres. However, if your primary concern is simply storing and retrieving large JSON documents without the need for complex queries, Vercel Blob could be a simpler and more cost-effective solution.
For more details, you can explore the following resources:
- Vercel Postgres (https://vercel.com/docs/storage/vercel-postgres)
- Vercel Blob (https://vercel.com/docs/storage/vercel-blob)