Activities of "portx-dev"

I would like to make the following two like coupa.

1. Client application
2. Supplier Portal

I have the following issues. ・There is no problem with 1. It is possible with the function of ABP Commercial. ・I don't know how to implement 2. This is because you need to see data from multiple companies.

A specific example of 2 is below. ・Supplier C receives orders from companyA.PortX.cloud and companyB.PortX.cloud ・C logs in to Supplier Portal and sees orders from A and B.

How can Supplier Portal be implemented for such a use case?

ABP Commercial 7.1

thank you. Have you considered MySQL? If so, I would like to know why you excluded MySQL.

thank you. Any idea why Abp chose PostgreSQL?

I have already read the following articles. https://blog.abp.io/abp/Migrating-from-MS-SQL-to-Postgresql We understand that ABP chose PostgreSQL for its price advantage.

I found SQLServer to be very expensive. (I want you to answer intuitively.) Which do you think are the most popular ABP Commercial users, MySQL or PostgreSQL?

We are troubled with DB selection and provider selection. My experience is MySQL + AWS.

I have a few questions there. ・When using ABP Commercial, what are the advantages and disadvantages of SQL server / MySQL / PostgreSQL?

・In terms of ABP Commercial support, are you the best at supporting SQL server out of the three: SQL server / MySQL / PostgreSQL?

・Are most users of ABP Commercial choosing SQL server + Azure?

• ABP Framework version: v7.1

Let's assume that Tenant 1 is treated as a parent tenant, and Tenant 2 and Tenant 3 are child tenants. There is a specification to create roles to be used for Tenant 2 and Tenant 3 on Tenant 1. Is that possible with ABP?

• ABP Framework version:　ABP Commercial 7.1e:

thank you.

Is it possible to write the DB endpoint in this URL? https://docs.abp.io/en/commercial/latest/modules/saas?&_ga=2.31513790.1017473141.1680852494-480170447.1680614778#connection-string

For example, for a company tenant, I want the host to be a.rds.cloud.

Server=a.rds.cloud;Database=a;Trusted_Connection=TrueTrustServerCertificate=True

Thank you very much.

However, it occurs in the future that we want to separate DB instances. As a use case, ・Enterprise companies ・When the number of companies reaches a certain number, we want to split the DB (e.g. 1 DB instance per year)

●Question If we customize ABP Commercial to achieve this, can we get consulting? Also, is the scope of influence of customization quite large?

●workaround Given the current constraints, I would take the following approach ・xxx-2023.portx.cloud → 2023 DB ・xxx-2024.portx.cloud → 2024 DB

Can I choose different DB servers for different tenants?

At https://docs.abp.io/en/abp/latest/Multi-Tenancy#database-architecture, we have found that we can separate the DB for each tenant.

Can I choose different DB servers for different tenants?

Can I achieve the following? https://docs.abp.io/en/commercial/latest/modules/saas#connection-string

• ABP Commercial: v7.1

It is possible to create Entities for all tenants using ABP Suite, but what should I do if I want to create different Entities for each tenant, or if I want to control the Entities that can be used by each tenant? Please let me know if you have any samples.

For example, Entity01 can be used only for tenant 01, and Entity02 and Entity03 can be used only for tenant 02.