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

Started by hmidi slimover 8 years ago6 messagesgeneral
Jump to latest
#1hmidi slim
hmidi.slim2@gmail.com

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.

#2Andreas Kretschmer
andreas@a-kretschmer.de
In reply to: hmidi slim (#1)
Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

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

#3Chris Ellis
chris.ellis.intrbiz@googlemail.com
In reply to: hmidi slim (#1)
Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

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

Show quoted text
#4hmidi slim
hmidi.slim2@gmail.com
In reply to: Andreas Kretschmer (#2)
Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

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>:

Show quoted text

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

#5James Keener
jim@jimkeener.com
In reply to: hmidi slim (#4)
Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

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.

#6Joshua D. Drake
jd@commandprompt.com
In reply to: hmidi slim (#4)
Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

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. *****