Citus Blog

Articles tagged: access controls

Craig Kerstiens

Raw SQL access for users with row-level-security

Written byBy Craig Kerstiens | April 4, 2018Apr 4, 2018

We talk with a lot of SaaS companies that are encountering issues with their database. The most common issue we discuss relates to performance, either a need to keep scaling or at times just dealing with really intensive data needs of only a few customers and how to handle that.

And then as you continue to scale and capture more data you want to provide more value back to your customers.

At times you might even consider giving raw SQL access to your largest and most important customers. Typically controlling what data you give them, via dashboards and canned reports is ideal–this way you can control performance impact and other risks. But, if you have extra large/important customers that require you to give them raw access to the data… then PostgreSQL and thus Citus has your answer.

Pro-tip: Don’t grant access to *all** of your customers.*

Keep reading
Craig Kerstiens

Raw SQL access for users with row-level-security

Written byBy Craig Kerstiens | March 19, 2018Mar 19, 2018

We talk with a lot of SaaS companies that are encountering issues with their database. The most common issue we discuss relates to performance, either a need to keep scaling or at times just dealing with really intensive data needs of only a few customers and how to handle that.

And then as you continue to scale and capture more data you want to provide more value back to your customers.

At times you might even consider giving raw SQL access to your largest and most important customres. Typically controlling what data you give them, via dashboards and canned reports is ideal–this way you can control performance impact and other risks. But, if you have extra large/important customers that require you to give them raw access to the data… then PostgreSQL and thus Citus has your answer.

Pro-tip: Don’t grant access to *all** of your customers.*

Keep reading

Page 1 of 1