Add readonly option when connecting to database

dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place

28 stars 1 forks source link

Add readonly option when connecting to database #114

Open mikeburgh opened 1 week ago

mikeburgh commented 1 week ago

Discussed in https://github.com/dbcodeio/public/discussions/112

^{Originally posted by **Med-H** November 14, 2024} it would be a good thing to add a readonly option when connecting to databases. It is especially important when accessing production databases

mikeburgh commented 1 week ago

@Med-H I moved this over here.

I was thinking about an option to let you set the "role" of a server.. and then depending on the role some commands would warn you before running.

So for example

Dev: No Warnings
Stage: Warn on DDL changes (Create, delete etc)
Production - Warn on anything that's not a select statement

Maybe a fourth option Critical - That just simply prevents anything that's not a select ?