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).
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!
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).
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.
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
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
