Is it okay if I just use SQLite for the database? I can't imagine that many people using the site so it should be fine right?
>>109777644AFAIK SQLite does not have any concurrency support at all. Use MySQL.
>>109777670Not OP but it can handle like 5k writes per second. That's good enough for a small forum.
>>109777644Nobody is gonna visit your textboard site lil broThis is not 2007
>>109777670Part of the reason why I was wanting to use SQLite is because I'm too stupid to setup my computer to run postgres locally. I hope MySQL actually works for me out of the box. >>109778188That is what I was thinking. I'm not expecting much traffic so I'm wondering if having a server based database is overkill.>>109778198I bet I can get at least 100 peak concurrent posters daily. \m/
>>109777670It lacks write concurrency, not read concurrency.But if it's a low traffic backend like what OP anticipates, it really wouldn't be an issue.Worst case scenario if load and traffic got real heavy, you could just add a backend process that runs an inbound queue and merges multiple write operations into write batches. You could do this with some basic ass string interpolation honestly.
>>109778272>I bet I can get at least 100 peak concurrent posters daily. doubt
>>109778272100 peak posts probablyyeah sqlite is more than enough for this. when you need more just build a tool to query everything and put it into another database. mysql is a piece of shit and mariadb isn't much better. postgresql is the shit. no cap I prefer MSSQL just fine except postgresql seems to have a lot more support on this side of the fence.
>>109778376>>109778382Don't underestimate me damnit!
>>109779044you sound kinda trans sorry I can’t believe you
>>109779045Trust me, I know what I need to do to at least get 100 people posting on my site at a time. I just have to make my textboard unique and make posting fun.
>>109779083Then vibecode it
>>109777644No dude bro man im indian hindu im tech whiz my cousin work for Amazon. Listen to me, you need active-active failover and leader election features. Make new posts go into kafka instance. Then aws lambda take from kafka and write to dynamo db. You have infinite scale because amazon engineers are very talented. Triust me ignore other retards giving bad advice I can charge clients $300 consulting fee for the free advice I give to you.
>>109779091Vibecoding is for when you just want the end result. I want to become a better programmer and to be familiar with my codebase, so I'll wait 2 weeks to a month to put this together. It'll feel good knowing I completed a project for once.
>>109779126You aren't cool for making fun of Indians.
>>109779044Good luck to you bro, I think you can do it
>>109777644Yeah it's fine. It simplifies things a lot. Don't worry about scaling and performance benchmarks and shit for now.I would not use SQLite in prod where I actually need concurrency and the data is critical. For everything else, it's great.>>109778272MySQL is very easy to install and set up on Windows too. Sticking with SQLite for the app for now is good, I just recommend learning MySQL or Postgres at once point down the line because it's useful to know.>>109779159Based, go for it
>>109777644Just start with sqlite and keep changebility high. Put it behind an interface, so the rest of the app does not know or care which db is used. If u see performance issues from db i/o change it later when u actually need lt.
>>109777644I can be your local schizophrenic if you tell me what the site is
>>109781398>>109781421Okay I'll stick with SQLite to start off with>>109781494I'm already the local diagnosed schizophrenic.
>>109777644sqlite is good, i use xampp with sqlite for my local server, it just werks
>>109782907>it just werksThere's literally no release of it with the latest LTS PHP version that has been out for like a year
>>109777644>>109778272>I bet I can get at least 100 peak concurrent posters daily.to oversimplify: it doesn't matter until it does.how much forward looking (or forward compatible) you want to be is up to you - your time/money your choice.
>>109777644try FuzeDBI, it lets you compile with SQlite or Postgres supporthttps://github.com/Liteb0t/FuzeHttp <--- in ./sourceit limits you to using a subset of SQL, but that's all you need.
>>109780944Watch out everyone, we have a virtuous sir over here!
>>109784279counterpoint: nomads.comruns on sqlite
>>109777644what language are you making this with?Anyway, a textboard is like a weekend project, at maximum
>>109777644just store txt files named after the post number in one directory per board
>>109777644She looks deceased and rotting.
>>109785054Javascript using Node.js + Express.js This is probably going to take me 2 weeks because I'm not a good programmer.
>>109785200my condolences
>>109785220I was going to use Go but I really dislike its syntax and the fact that it is a static language. I went with JS because it probably has the most resources for beginners out there.
>>109785256Go is piss easy though, even if I do hate the syntax (the python parts). I'm a cpilled boomer though, so I don't get why anybody would not want static typing.Are you really a beginner if you know specific JS slop frameworks? or did you just ask chatgpt
Anyone have any board suggestions? I'm planning on having a technology board, a random board, and a meta board to start off with.>>109785277I finished the first part of The Odin Project, have probably followed 100s of tutorials over the past decade, and played around with Rails and PHP. I consider myself a beginner because I haven't built anything significant. If you want to know why I "know" these frameworks it is because I'm just watching tutorials on the stuff I want to learn. All I have had ChatGPT do so far is write SQL for me.
>>109785342Fair, but I think'd you'd have the most benefit from learning SQL out of those
>>109785380I just had it flesh out my schema. I am still going to write the queries by hand.
>>109781494The domain is moshr.net
>>109785342The standards are anime/music/whatever
>>109777644sqlite is fine when i was in uni i made an image board and posted the link here didnt have any issues while anons used it for a day or so
>>109788802I think I'm just going to let people make boards.>>109789334Good to hear.
>>109777644Sure it works, nanochan / picochan used it, if you'll have problems it will be your software or your schema, not SQLite.Check online for their code.
