Best Practices for File Management in Backend and SQL Projects
Asked by
TechieExplorer42
I'm looking to improve my file management skills, especially concerning file storage for things like profile pictures or even creating simple Google Drive clones. I already have experience with SQL and API requests, but I'm unsure if I should be using my local Windows 11 machine for file storage, since my projects are already running on local pgAdmin4 for PostgreSQL with no cloud integration. Should I keep it local or explore options like Amazon S3 instead? Any advice would be greatly appreciated!
Answers
Using Amazon S3 is a smart move since it creates three copies of your files in different locations, offering better security than just relying on your laptop. If something were to happen to your laptop, you'd risk losing your files entirely. Personally, I found running a server on my local computer to be quite a hassle, so I recommend looking into cloud options for long-term projects.
Reply to this answer
I had a fantastic experience with Google Cloud Buckets! They offer efficient management with low overhead. Plus, new users get $300 in credits to experiment before spending any money. Just a heads-up, their documentation can lag behind on newer features, but it’s still a solid option.
Reply to this answer
If you plan on building complex services, consider using containers for your application. This approach offers OS independence and simplifies both local development and cloud deployment later on. For file storage, check out Minio as an S3 alternative; it's open-source and has a Docker image. The good news is, if you eventually switch to S3, the transition should be minimal—mostly just changing a URL.
Reply to this answer
Starting on your local machine is a great idea! It lets you learn without any upfront costs. Once you get the hang of things, you can transition to the cloud. There are tons of resources online, like YouTube channels or coding websites, that can help you along the way if you'd like.
Reply to this answer
Add your answer
Answers are reviewed before publication.
Related Discussions