round postgres dependency issues.
>
> On Fri, Dec 30, 2016 at 1:40 PM, Michael Sheaver <mshea...@me.com
> <mailto:mshea...@me.com>> wrote:
> If you want an IDE, Jetbrains, the makers of great IDEs like IntelliJ,
> PyCharm. and AppCode, among others, have recently co
If you want an IDE, Jetbrains, the makers of great IDEs like IntelliJ, PyCharm.
and AppCode, among others, have recently come out with what is arguably the
BEST IDE for DBAs, DataGrip. It runs on most major platforms, and is so good
that I have bitten the bullet and paid the yearly subscription
I would like to echo the sentiment on collation and expand it to character sets
in general. When issues with them come up, they do take an incredible amount of
time and effort to resolve, and are one of my own biggest pain points when
dealing with databases and datasets from other sources. Case
Greetings,
I have two tables that are populated using large datasets from disparate
external systems, and I am trying to match records by customer name between
these two tables. I do not have any authoritative key, such as customerID or
nationalID, by which I can match them up, and I have
truth to the old adage that we must learn from our own mistakes. :)
> On Sep 26, 2016, at 8:46 AM, Michael Sheaver <mshea...@me.com> wrote:
>
> I have done some research after converting my database from MySQL 5.6 to
> PostgreSQL 9.6 (the best move I have ever made), and the
I have done some research after converting my database from MySQL 5.6 to
PostgreSQL 9.6 (the best move I have ever made), and the consensus I found can
be summed up as:
1. Never, neve, never use VARCHAR or even CHAR
2. Always always, always use TEXT
Unless, that is, you have some kind of edge
strategy to implement user requests.
Gitkraken is simply awesome and my go-to GUI for VCS.
An added benefit of this particular toolset is that they work equally well on
Mac and Windows.
Michael Sheaver
mshea...@me.com
> On Sep 3, 2016, at 9:28 AM, Mike Sofen <mso...@runbox.com> wrote:
://stackoverflow.com/questions/38750898/build-or-install-pg-loader-on-windows
<http://stackoverflow.com/questions/38750898/build-or-install-pg-loader-on-windows>
I didn't get a response there, so I do hope someone here might be able to help.
Thanks,
Michael
Michael Sheaver
