I've built a library website where I've uploaded lots of details about physical books, including their locations and borrowing requests. Now, I'm stuck on how to give each user their own personal database and homepage to track the books they've borrowed and other personal info. Any advice on how to set this up?
1 Answer
You definitely don't want to set up a separate database for each user; that would be super inefficient! Instead, you should create a single database with a user table and a separate table for books. When a user logs in, you can query the database for all entries associated with their user ID, which will help you display the relevant books for them.
Which programming language would be best for implementing this?