Re: Multitenent architecture

Hi guys - apologies for jumping into the middle of this, but it touches on precisely one of the topics I'll have to deal with soon. We're standing up a pharmacovigilance / drug safety platform managing ICSRs (HL7 "individual case safety reports" that must be FDA/ICH compliant) and will be dealing w

Re: How to write such a query

Are you looking to arbitrarily update the field in the fifth row, or can the row that needs to be updated be isolated by some add'l attribute? What's the use case? - Jon <https://www.linkedin.com/in/jonstrong/> <https://www.jonathanrstrong.com> *Jonathan Strong* CIO

Re: How to write such a query

of the data in some fashion. - Jon <https://www.linkedin.com/in/jonstrong/> <https://www.jonathanrstrong.com> *Jonathan Strong* CIO / CTO / Consultant *P:* 609-532-1715 *E:* jonathanrstr...@gmail.com *Quora Top Writer <https://www.quora.com/profile/Jonathan-R-Strong>* On Fr

Re: How to write such a query

crucial to understand the model in order to write correctly functioning and reliable code. - Jon <https://www.linkedin.com/in/jonstrong/> <https://www.jonathanrstrong.com> *Jonathan Strong* CIO / CTO / Consultant *P:* 609-532-1715 *E:* jonathanrstr...@gmail.com *Quora Top Writer

Re: How to write such a query

Yes - 100% - Jon <https://www.linkedin.com/in/jonstrong/> <https://www.jonathanrstrong.com> *Jonathan Strong* CIO / CTO / Consultant *P:* 609-532-1715 *E:* jonathanrstr...@gmail.com *Quora Top Writer <https://www.quora.com/profile/Jonathan-R-Strong>* On Fri, Sep 18, 2020

Re: How to write such a query

A pretty good read / intro to the concept of keys in the relational model: https://www.red-gate.com/simple-talk/sql/learn-sql-server/primary-key-primer-for-sql-server/ - Jon <https://www.linkedin.com/in/jonstrong/> <https://www.jonathanrstrong.com> *Jonathan Strong* CIO / CTO / Co

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

ps://www.linkedin.com/in/jonstrong/> <https://www.jonathanrstrong.com> *Jonathan Strong* CIO / CTO / Consultant *P:* 609-532-1715 *E:* jonathanrstr...@gmail.com *Quora Top Writer <https://www.quora.com/profile/Jonathan-R-Strong>* On Tue, Sep 22, 2020 at 10:18 AM Fabio Ugo Venchiarutti &

Re: Rows removed on child table when updating parent partitioned table.

uot;update" on an auto-incrementing serial field is outside intended / supported behavior, and it may well just be that it winds up being handled differently under the covers when the data table and/or associated sequence are partitioned. - Jon <https://www.linkedin.com/in/jonstrong/> <

Re: Rows removed on child table when updating parent partitioned table.

On Thu, Oct 1, 2020 at 2:02 PM David G. Johnston wrote: > The convention on these lists is to inline or bottom-post, please do not > top-post. > > On Thu, Oct 1, 2020 at 10:41 AM Jonathan Strong > wrote: > >> I've been away from coding for several years, but dustin

Re: What's your experience with using Postgres in IoT-contexts?

On Wed, Oct 14, 2020 at 8:49 AM Peter J. Holzer wrote: > On 2020-10-13 06:55:52 +0200, chlor wrote: > > > I want to have long term storage and access to individual telegrams > > > > An IOT is not designed for that. It is used for control or delivery of > > data to a server. > > That's a rather do