Thanks for that insight Tom and I will wander over and have a look at 
EMS when I get a chance.

The AWS server was set up by the other guy who I work with and dBeaver 
is what he was using which made it a no brainer as a starting point 
especially as I had tried pgAdmin 4 for my initial local Postgresql 
implementation and didnt like that one little bit. That said we are not 
wedded to anything in particular right now as the whole project is a 
work in progress. But we are making quite good progress with Python 
Scripts doing good things and Paradox is playing fairly happily with 
things so far.

One aspect that is helping us a lot is the ability of Python Libraries 
to read paradox .db files and also the ability of Python to easily 
interface with API endpoints, get the information we require and then 
simply write from a df to a Postgresql Database. Wow that is simple 
compared to doing it via Paradox. Then of course he can access it and I 
can access it quickly and easily from there.

All a learning process but so far so good.



On 26/02/2020 5:10 PM, Tom Krieg wrote:
> I tried dBeaver and found a few show-stoppers. One is the user
> interface, another is that you can't connect to more than one database
> at a time and so copy between them. And because I'm a security freak I
> won't have Flash player or Java on my system. dBeaver is a pure Java
> application but at least it doesn't install an insecure Java version on
> your PC (as far as I know).
>
> On 23/02/2020 4:53 pm, Robert MacMillan wrote:
>
>> The final thing is that Tom suggests using a EMS Sql Manager. I am
>> using dBeaver. I dont think it really matters which one you use