Creating a fake startup - Session 22: Database design

Let's build a project together!

'Fake Startup' is a new tutoring format in which we work together on a real-world, long-term project.

New here? Don't worry; we are beginner-friendly and always happy to welcome more folks. Join us in Zoom and see for yourself! No need to worry that we are already a few episodes in!

This session

In the next session, we will learn about database designs. We will look at the entities that are part of the Social Plan-it application and create database models for them.

Past sessions

In the past sessions, we made some significant progress!

- In our first session, we brainstormed different startup ideas and finally decided on the general topic area of our fake startup - we will work on a meetup app. We discussed the project's business model and value proposition the week after.
- Next, we created user stories based on current needs and pain points with existing solutions. Finally, we picked user stories for our MVP (minimal viable product) and derived technical requirements from them. We then translated the technical requirements into an initial system design.
- We decided on a tech stack to implement our system architecture. In particular, we dove into the latest changes in the React ecosystem and learned about React's full-stack web frameworks: Next.js and Remix. We also discussed the differences in deploy environments: long-running servers, serverless, and edge deploy.
- After that, we set up a new Remix.run project and configured our programming environment. We also already reviewed best practices for working in a team and created the foundations for our app.
- We learned about design systems and component libraries and pair-programmed on building reusable React components. We also worked on our designs in Figma (user stories -> designs -> tasks).
- We discussed working with images on the web and how to optimize images using a dedicated image hosting service or CDN.
- We pair-programmed the login and signup flow using cookies.