{"repo":"starnowski/posmulten","free":true,"listed":false,"github":"https://github.com/starnowski/posmulten","clone":"git clone https://github.com/starnowski/posmulten.git","description":"Posmulten library is an open-source project for the generation of SQL DDL statements that make it easy for implementation of Shared Schema Multi-tenancy strategy via the Row Security Policies in the Postgres database.","language":"Java","stars":25,"topics":["database","multi-tenancy","multi-tenant-applications","multi-tenant-database","postgresql","shared-schema"],"license":"LGPL-2.1","category":"databases-storage","readme_excerpt":"Posmulten Introduction Multi-tenancy Separate database strategy Separate schema strategy Shared schema strategy Implementation requirements How posmulten helps to implement shared schema strategy? Setting RLS policy Function that checks tenant access to a table row Function that checks if the passed identifier is the same as the current tenant identifier Function that returns the current tenant identifier Function that set the current tenant identifier Connecting to Database Adding constraints for foreign key columns Other columns modifications How to start using posmulten Setting maven dependency Building project locally How to start using builder Applying builder changes Dropping builder changes Using posmulten components with database connection Setting default database schema Setting default database user for RLS policy Setting RLS Policy for table Setting RLS Policy for a table with a multi-column primary key Setting RLS Policy for a table without primary key Force RLS Policy for table owner Adding a foreign key constraint Adding a foreign key constraint with a multi-column primary key Setting of type for tenant identifier value Setting the property name that stores tenant identifier value Adding default value for tenant column Skipping adding default value for tenant column for a single table Setting default tenant column name Setting function name that returns the current tenant identifier Setting function name that sets the current tenant identifier Setting function n","default_branch":null,"files":null,"tree":[],"storefront":"/r/starnowski","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/starnowski/posmulten/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}