How to Set Up a Local Database System for a Non-Profit Organization?

0
2
Asked By CuriousCoder77 On

Hey everyone! I'm a high school student volunteering with a non-profit and I've been tasked with creating an internal management system. The non-profit needs to manage inventory, handle scheduling, and facilitate client check-ins. Since they deal with sensitive data, they want everything to be self-hosted on a local server, avoiding any reliance on the cloud. I'm also looking for a system that's flexible enough to integrate a local AI model later down the line. As I'm new to system design, I'm seeking advice on what technology stack (frontend, backend, database) would be best for a beginner, focusing on security, ease of self-hosting, and maintenance. Any guidance would be greatly appreciated!

2 Answers

Answered By DatabaseDude55 On

What you're looking to build is essentially an ERP system. Instead of developing one from scratch, consider exploring the many off-the-shelf ERP solutions available. They cover a wide range of functionalities and could save you a ton of time and effort.

CuriousCoder77 -

What is an ERP? I searched but it seems like a more holistic approach rather than just data management? Any specific "off-the-shelf" options you recommend?

Answered By TechSavvy123 On

For your tech stack, I recommend using a containerized approach with a React frontend, a Go backend, and PostgreSQL for your database. This combination is pretty robust, and you'll find plenty of resources to help you get started. Also, for security, looking into STIGS (Security Technical Implementation Guides) might be beneficial.

CuriousCoder77 -

THANKS for your reply!!! I'll look them up right now.

Related Questions

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.