Re: How to deal with multi-tenancy using multiple schemas ?

[Lukas Eder]

Hi Cristiano,

What are the problems you're running into?

Thanks,
Lukas

On Mon, Feb 17, 2020 at 6:02 PM Cristiano  wrote:

> Hi Lukas thanks for the info.  I was able to generate my schemas properly.
>
> But I'm having a problem with some column types. In some tables I have
> column using `pg_catalog.point`.
>
> I'm using a non-jdbc postgres driver
> 
> and I'm not sure how to proceed in order to use its provided 
> `io.vertx.pgclient.data.Point`
> type with JOOQ.
>
> Must I create a binding or a converter or other approach ?
>
> thanks
>
> On Monday, February 10, 2020 at 12:35:41 PM UTC-3, Lukas Eder wrote:
>>
>> Hi Cristiano,
>>
>> Please have a look at the runtime schema mapping feature:
>>
>> https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-render-mapping/
>>
>>
>> Thanks,
>> Lukas
>>
>> On Mon, Feb 10, 2020 at 3:35 PM Cristiano  wrote:
>>
>>> I forgot to say that the tenant will be identified by the token being
>>> sent by the web/mobile client app via Rest request.
>>> Also every tenant's schema is planned to be identical.
>>>
>>>
>>>
>>> On Monday, February 10, 2020 at 11:31:32 AM UTC-3, Cristiano wrote:

 Hello all,

 I've started a POC for a new backend application using java+postgresql.
 We would like to experiment to have one common schema and one schema for
 every different customer in the database.

 Have Jooq's a support this kind of approach ?  if yes, could you point
 me to any doc or example ?

 many thanks,

 Cristiano

>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "jOOQ User Group" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to jooq...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/jooq-user/99f88f7c-2bfb-49a2-a375-787e40f5e20a%40googlegroups.com
>>> 
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to jooq-user+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/01913d2b-b8bc-4f6a-8a80-9b4ee1303a5d%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/CAB4ELO489GT49c1qA%2BoVXs90mLSeLNkwHrfHOPPW2L_SeEEpQA%40mail.gmail.com.

Re: How to deal with multi-tenancy using multiple schemas ?

[Cristiano]

Hi Lukas thanks for the info.  I was able to generate my schemas properly.

But I'm having a problem with some column types. In some tables I have 
column using `pg_catalog.point`.

I'm using a non-jdbc postgres driver 

 
and I'm not sure how to proceed in order to use its provided 
`io.vertx.pgclient.data.Point` 
type with JOOQ.  

Must I create a binding or a converter or other approach ? 

thanks

On Monday, February 10, 2020 at 12:35:41 PM UTC-3, Lukas Eder wrote:
>
> Hi Cristiano,
>
> Please have a look at the runtime schema mapping feature:
>
> https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-render-mapping/
>  
>
> Thanks,
> Lukas 
>
> On Mon, Feb 10, 2020 at 3:35 PM Cristiano > 
> wrote:
>
>> I forgot to say that the tenant will be identified by the token being 
>> sent by the web/mobile client app via Rest request. 
>> Also every tenant's schema is planned to be identical.
>>
>>
>>
>> On Monday, February 10, 2020 at 11:31:32 AM UTC-3, Cristiano wrote:
>>>
>>> Hello all,
>>>
>>> I've started a POC for a new backend application using java+postgresql. 
>>> We would like to experiment to have one common schema and one schema for 
>>> every different customer in the database.
>>>
>>> Have Jooq's a support this kind of approach ?  if yes, could you point 
>>> me to any doc or example ?
>>>
>>> many thanks,
>>>
>>> Cristiano
>>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "jOOQ User Group" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to jooq...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/jooq-user/99f88f7c-2bfb-49a2-a375-787e40f5e20a%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/01913d2b-b8bc-4f6a-8a80-9b4ee1303a5d%40googlegroups.com.

Re: How to deal with multi-tenancy using multiple schemas ?

[Lukas Eder]

Hi Cristiano,

Please have a look at the runtime schema mapping feature:
https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-render-mapping/


Thanks,
Lukas

On Mon, Feb 10, 2020 at 3:35 PM Cristiano  wrote:

> I forgot to say that the tenant will be identified by the token being sent
> by the web/mobile client app via Rest request.
> Also every tenant's schema is planned to be identical.
>
>
>
> On Monday, February 10, 2020 at 11:31:32 AM UTC-3, Cristiano wrote:
>>
>> Hello all,
>>
>> I've started a POC for a new backend application using java+postgresql.
>> We would like to experiment to have one common schema and one schema for
>> every different customer in the database.
>>
>> Have Jooq's a support this kind of approach ?  if yes, could you point me
>> to any doc or example ?
>>
>> many thanks,
>>
>> Cristiano
>>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to jooq-user+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/99f88f7c-2bfb-49a2-a375-787e40f5e20a%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/CAB4ELO4Rby%2BFXDqcir-t%3DimZzn-NXWYE%3DCBsCfkEM9QaKC%3Dfeg%40mail.gmail.com.

Re: How to deal with multi-tenancy using multiple schemas ?

[Cristiano]

I forgot to say that the tenant will be identified by the token being sent 
by the web/mobile client app via Rest request. 
Also every tenant's schema is planned to be identical.



On Monday, February 10, 2020 at 11:31:32 AM UTC-3, Cristiano wrote:
>
> Hello all,
>
> I've started a POC for a new backend application using java+postgresql. We 
> would like to experiment to have one common schema and one schema for every 
> different customer in the database.
>
> Have Jooq's a support this kind of approach ?  if yes, could you point me 
> to any doc or example ?
>
> many thanks,
>
> Cristiano
>

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/99f88f7c-2bfb-49a2-a375-787e40f5e20a%40googlegroups.com.