I have a maximum of 100 concurrent connections. What offering is best for me?
I teach and have a few hundred students - prob a max of 100 will connect to my database (v small, 1000 records). What plan is ideal for me?
3 Replies
flat-fuchsia•2w ago
I think the free plan will be good for you for now! I'd expect the usage pattern to be very spiky, so scale-to-zero will stretch those 50 CU a long way. If ever you have them working in groups, the free tier now offers 20 projects, each with 50 CU, which should be more than enough. If you ever run out of compute, let me know here, and I'll get something going 🙂
yappiest-sapphireOP•5d ago
Is there a way to use an api to automatically set up a role/user and apply a password and retrieve it back to a website.
I want to make it easy for a new students to connect without me having to go in and create their account for them.
flat-fuchsia•5d ago
You could create a group role
student with whatever permissions you want then programmatically create a login role firstname_lastname for each student and grant student to each of them. This also allows you to grant more permissions a per student basis.
A simple python script that takes in all the student names, generates a strong random password per student, creates/alters the firstname_lastname role with that password, grants the student group role, and outputs a CSV or JSON with their password would work great.