Data storage suggestions for Next.js website

[civic patio]

@merry zephyr thanks for the response. I read that PostgreSQL might be better for more complex use cases and might not be ideal for read-only. I was looking at that and MySQL.

[merry zephyr]

arent postgress suport all mysql or mariadb does?

em there also an option to use notion, but I already working for a while on finding how to interact with their api

maybe there are more Content management tools.

you can design generic templates and stamp them, or make each project page individualized

[civic patio]

I need to research more tbh. I’m also looking at headless CMS, I’m not sure if that’s needed for my use-case though.

I don’t have a lot of projects right now but I’d like to set things up to be easily scalable in the long run.

[merry zephyr]

but you would not want to type content straight into web site code?

[civic patio]

I wouldn’t mind that tbh. What would be my options? I thought about just creating a JSON object with the data.

I would probably have to build my own API; is that right?

[merry zephyr]

be aware that plain text can contain links, bold, italic, color etc...
would you cover that in json
also you might consider styling

[civic patio]

I would just use JSON for the content to access it in my project, I’d handle styling separately.

[knotty talon]

why not sqlite with prisma

[merry zephyr]

type MySite = {
cover: Cover;
body: Body;
sidebar: Sidebar;
}

type Cover = {
image: Image;
title: Text;
subtitle: Text;
profileImage: Image;
}

type Body = {
paragraphs: Paragraph[];
slideShow: SlideShow[];
}

type Block = {
type: "paragraph" | "slideshow";
[key: "paragraph" | "slideshow"]: Value;
}

JSON can turn a bit into a decision purgatory

[civic patio]

I actually looked at SQLite briefly, that looks like it may work. What would Prisma be used for?

[civic patio]

I see, I also thought it may be insecure. Do you have any thoughts on that?

[merry zephyr]

security in terms of task becoming to big and hard to acomplish or cyber security?

[civic patio]

I’m mainly referring to cybersecurity. The data isn’t really sensitive but I’d want to avoid bad practices.