Re: Drill-downs and OLAP type data - Mailing list pgsql-general

From Ondrej Ivanič
Subject Re: Drill-downs and OLAP type data
Date
Msg-id CAM6mie+R-FQF9D5drjDFkD_eHrcxEeO=a_H6Ci4asRk8xMATbQ@mail.gmail.com
Whole thread Raw
In response to Re: Drill-downs and OLAP type data  (Anthony Presley <anthony@resolution.com>)
Responses Re: Drill-downs and OLAP type data  (Anthony Presley <anthony@resolution.com>)
List pgsql-general
Hi,

> The *problem* with Greenplum is that it's ultra-expensive once you leave the
> CE version - and you're not supposed to be using the CE version for
> commercial usage last I read the license.  Has that changed?

Not sure. I haven't seen something like that in the license. After POC
we bought HW and license from EMC

> The last pricing I saw was around $16k per CPU (it may have been per core?).
>  At that point, you're now in the realm of SQL Server Analysis and DB2 SPSS.

Yeah, it is not cheap but it is "drop in" replacement for Postgres and
we can connect to it from PHP without any issues. (PHP PDO + ODBC
doesn't work very well)

>
> Our problem is pairing
> up a web based GUI to a database we love using.  Doesn't seem possible,
> because the user-friendly OLAP / data analysis / dashboard tools are all
> expecting functionality that PG doesn't have.

Could you please name few of them? I'm looking for something like
Tableau but web based (without .Net) and hackable (our DB is partially
encrypted)

> It sounds like, we're either choosing a different DB to work with the pretty
> GUI tools, or writing a GUI tool to work with PG.

I think you are right here.

--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)

pgsql-general by date:

Previous
From: Bob Hatfield
Date:
Subject: Re: pg 8.3 replication causing corruption
Next
From: Simon Riggs
Date:
Subject: Re: pg 8.3 replication causing corruption