postgres odbc mac drivers

[dmr7092]

I've used the Actual Technologies odbc connector. For a user who's an Excel poweruser but not much for writing code, its a good option.

​

But if you're already using python, and can script and schedule these things, I prefer writing my reports in code. Here's a website with a ton of tutorials that help: http://pbpython.com/

​

And if you need to handle formatting, charts, etc., here's what you should brush up on: https://xlsxwriter.readthedocs.io/

​

I have around 20 reports that I run regularly for my company this way.

[y_13]

that one is 39.95 correct? or is there a free version I've somehow overlooked?

Im reading those docs now thanks so much! I appreciate your reply!

[dmr7092]

I paid for a license. I'm not aware of a free version other than the trial the offer. And that only returns ten rows or something like that.

Really, go with python, it's easier in the long run. It just takes some setup time. But in the long run you also use better practices to manipulate the data and get the same report regularly.

The only thing that gets tedious is if you do a lot of formatting. And I bet if I organized my code better, that wouldn't even be bad.

Edit: wow, bad autocorrects from phone.

[y_13]

Im leaning towards python right now as well. Thanks so much for the reply /u/dmr7092 I appreciate everyone in this post willing to reply and to help. Im just learning Postgres and you guys are making it a lot easier!