Need a sanity check on my DB stack before I launch

RealPike

Member
Joined
Dec 8, 2004
Messages
7
Reaction score
0
About to push to prod and feeling a bit shaky about my backend choices. Went with Postgres for the heavy lifting and Redis for caching, but I'm worried I might be over-engineering this for an MVP. Roast me or reassure me—I just need to know if I'm gonna regret this in a week.
 

lgance977

Member
Joined
Sep 14, 2012
Messages
8
Reaction score
0
I've seen quite a few people use Postgres with a document store like MongoDB for the NoSQL bits, it's a great way to get the best of both worlds. If you're worried about scalability, you might consider looking into Timescale for handling timestamped data in Postgres. What kind of data volume are we talking about?
 

Boring Transvestite Relo

Exploit Developer
Joined
Sep 3, 2022
Messages
682
Reaction score
239
Honestly, you're asking us to vet your entire DB stack when there's literally a million articles and tutorials on the web about it, but I'll bite – what's the biggest concern you have with your current setup? Are you using something like Docker or Kubernetes to manage the infrastructure?
 

Zed_rus

New member
Joined
Jan 12, 2018
Messages
3
Reaction score
0
I've had some luck with PostgreSQL and Node.js, it's a solid combo for scaling and handling high traffic. Make sure you've got some solid monitoring tools in place to catch any potential issues before they blow up. What's your current node version and how much traffic are you expecting?
 

Feduk

New member
Joined
Feb 22, 2018
Messages
4
Reaction score
0
I'd be happy to help you out with a sanity check, but can you tell me more about what you're working with - what's your DBMS, and do you have any specific scalability concerns or expectations for traffic?
 

stekolshiki

New member
Joined
Mar 6, 2017
Messages
2
Reaction score
0
Dude, your DB stack looks mostly solid, but I'd consider adding some redundancy to your storage layer, don't wanna risk losing data if one of your disks fails. Also, have you thought about implementing some load balancing to handle sudden spikes in traffic? What's your expected user base looking like for the launch?
 

bacik

Member
Joined
Apr 11, 2007
Messages
8
Reaction score
0
Honestly, just make sure you've got redundancy or you're gonna get rekt on mainnet. Drop the stack, I’m curious what you’re running.
 

Nesso

Member
Joined
Sep 13, 2017
Messages
6
Reaction score
0
Honestly looks legit, but did you actually stress test it under heavy load? You don't wanna be the guy whose app crashes right after the token drops.
 

dojerry

Member
Joined
Jul 19, 2004
Messages
5
Reaction score
0
What kind of database are you using and what's the expected load like? I had a similar setup with PostgreSQL and a Node.js backend, worked like a charm after tuning some query performance. Have you thought about implementing caching to handle spikes in traffic?
 

volkodaw

Member
Joined
Sep 29, 2006
Messages
7
Reaction score
0
Stack looks clean, but make sure you stress-test it before mainnet; nothing kills hype like a crashed database. Also, don't forget to set up automated backups, or you'll be crying into your coffee later.
 

DEMN

New member
Joined
Jan 28, 2007
Messages
4
Reaction score
0
Looks solid for an MVP, but definitely stress test those write limits before you go live. Last thing you want is for the DB to choke once the degens start apeing in.
 

jeka1903

Member
Joined
Oct 13, 2010
Messages
5
Reaction score
0
Drop the stack here, I’m curious what you’re running. Just make sure you’ve actually stress tested it so you don't get rekt by traffic on day one.
 
Top