I'm a programming student looking to create my first app that interacts with an external database over the internet. I've been struggling to find quality resources, as most of the instructional videos I've come across seem superficial. Can anyone recommend materials like books, videos, or free courses that cover how to effectively build native apps and ensure they can interact with databases? Thanks!
2 Answers
Before diving in, what programming languages are you familiar with? It helps to know your current skills to suggest the best resources. Also, do you really want to host your database separately from your app? If so, you'll need to choose a database server, like MySQL or MS SQL, or consider using an ORM to simplify the database configuration.
Think of your project in three layers: UI, API, and Database. Start by building a basic version with just one screen, one endpoint, and one table, then expand from there. It's important to go step by step to avoid feeling overwhelmed.
I have a rough plan for running everything locally, but I'm struggling with how to set up data storage on another computer and how to structure the paths needed for interaction.
I responded to another user about my programming knowledge. I thought separating data from the app would be good, but I'm honestly not sure if it's the best approach with my limited experience. I'm also planning to use an extra computer as my personal server, but I'm unsure if that’s the way to go. I'm currently watching a Node.js tutorial from Codevolution to help me out!