I'm not sure why there is a database at all, if you want messages to just appear and not stick around you could do this over websockets and never need to touch a database

I'm brand new to full stack so I have no idea what I'm doing. Kind of figuring it out as I go along. Decided to start with short polling since I was having trouble getting websockets working and just wanted to get a v1.0 out in the wild.

Switching over to websockets eventually is 100% on my mind, but I have a near infinite amount of work to do on all fronts so we'll see when I have time!

Good on you. Learning about DB structure is far more important than websockets when starting out full-stack. You’d need to run your own websocket server anyway or pay through the nose for a service like Pusher (or stay on the free tier and not learn a single thing about either).

You choose well! Nice job, keep at it :)

I agree absolutely - just want to add that learning when not to use a db, which db to use when you need one, and which network protocols to use for an application, is also important

Not sure what your backend is, but websockets are pretty straightforward with socket.io! Happy to help get you up to speed - don't hesitate to reach out (@maxverse on twitter, email in profile)

Great job figuring things out as you go, and I love the experience. Keep up the good work!

Congrats for the little project, pls opensource the db!

Most of my requests are failing with

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://api.ventspace.life/api/v1/ventpost. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing).

Me too :( Seems to be broken now!

Looks like it caps off at 2,000, and we're currently at 130K+ messages

what does this mean?

The API returns at most 2000 messages at a time (this might have changed since I last tried), and last I looked the message IDs were around 130K, meaning that's how messages there have been.

I wonder what the most common word will be? I'd guess between "covid" and "Maddie"

over the last ~20hrs, the most common words and their frequencies are "the": 12263, "i": 12212, "fuck": 9015, "you": 8940. with stopwords removed, these become "fuck": 9015, "guess": 4084, "nums": 4062, "cunny": 3728. out of interest "maddie": 857, "covid": 231

I wondered too

Who is Maddie?

A guy was on talking about his ex-gf Maddie, and then it carried on.

I think Maddie McCann, she was a young girl who disappeared in Portugal sometime a few years ago. She's been in the news recently I believe.

Oooof I was assuming it was a different Maddie. But yes that's the most famous Maddie in the UK. Might be a coincidence though. It feels like it was over ten years the Maddie you're thinking of disappeared while on holiday

(Edit: looked it up) Maddie McCann disappeared in may 2007