|Subject:||Re: ODBC to an Amazon WS Postgressql db.
|Date:||Wed, 26 Feb 2020 23:05:55 +1100
|From:||Robert MacMillan <email@example.com>
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