Postgres Pro
Downloads
Home   >   mailing lists

Thread: Does postgresq database supports reading data from the same tablefrom many observable simultanousely?

Does postgresq database supports reading data from the same tablefrom many observable simultanousely?

From
hmidi slim
Date:
Hi,
I don't know if is it the suitable place to ask my question but I want to know if a table in a postgres database enable multiple reading actions for mayn rxjs observbles or not.
I create two observables that need to access the same table simultanously to get data, but I found that only one of them receive data.
I'm not sure if the problem may be come from the database or not that's why I asked my question.
Best regards.

Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

From
Andreas Kretschmer
Date:
On 22 December 2017 19:53:03 CET, hmidi slim <hmidi.slim2@gmail.com> wrote:
>Hi,
>I don't know if is it the suitable place to ask my question but I want
>to
>know if a table in a postgres database enable multiple reading actions
>for
>mayn rxjs observbles or not.

Not sure if i understand your question. But for sure PG is able to serve multiple clients at the same time.

Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company

Re: Does postgresq database supports reading data from the same tablefrom many observable simultanousely?

From
Chris Ellis
Date:
Hi

On 22 Dec 2017 6:53 pm, "hmidi slim" <hmidi.slim2@gmail.com> wrote:
Hi,
I don't know if is it the suitable place to ask my question but I want to know if a table in a postgres database enable multiple reading actions for mayn rxjs observbles or not.
I create two observables that need to access the same table simultanously to get data, but I found that only one of them receive data.
I'm not sure if the problem may be come from the database or not that's why I asked my question.
Best regards.

I'm assuming you are accessing PostgreSQL via RX Javascript?

If that is the case, then this question has nothing to do with PostgreSQL and is a question for whatever RXJS implementation you are using.

Regards,
Chris

Re: Does postgresq database supports reading data from the same tablefrom many observable simultanousely?

From
hmidi slim
Date:
But is it possible to make simultanoues select queries from the same connection?

2017-12-22 20:00 GMT+01:00 Andreas Kretschmer <andreas@a-kretschmer.de>:
On 22 December 2017 19:53:03 CET, hmidi slim <hmidi.slim2@gmail.com> wrote:
>Hi,
>I don't know if is it the suitable place to ask my question but I want
>to
>know if a table in a postgres database enable multiple reading actions
>for
>mayn rxjs observbles or not.

Not sure if i understand your question. But for sure PG is able to serve multiple clients at the same time.

Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company

Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

From
James Keener
Date:
Connections are synchronous. You can have multiple connections to the database at a time.

Jim

On December 22, 2017 2:20:03 PM EST, hmidi slim <hmidi.slim2@gmail.com> wrote:
But is it possible to make simultanoues select queries from the same connection?

2017-12-22 20:00 GMT+01:00 Andreas Kretschmer <andreas@a-kretschmer.de>:
On 22 December 2017 19:53:03 CET, hmidi slim <hmidi.slim2@gmail.com> wrote:
>Hi,
>I don't know if is it the suitable place to ask my question but I want
>to
>know if a table in a postgres database enable multiple reading actions
>for
>mayn rxjs observbles or not.

Not sure if i understand your question. But for sure PG is able to serve multiple clients at the same time.

Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company


--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: Does postgresq database supports reading data from the same tablefrom many observable simultanousely?

From
"Joshua D. Drake"
Date:
On 12/22/2017 11:20 AM, hmidi slim wrote:
> But is it possible to make simultanoues select queries from the same 
> connection?

Yes but it will happen serially.


JD

-- 
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
*****     Unless otherwise stated, opinions are my own.   *****