[tenaciousDaniel]

Nice! The space is pretty ripe for disruption because basically all of the tools are pretty old-school. Here are the things I really wanted:

1. Create dynamic schemas. Some of our clients had their own dimensions that they cared about.

2. Pick the level of integration. Imagine having an out-of-the-box integration available, but then offering fully customizable solutions for one-off scenarios.

Really it comes down to those two things, which basically means "flexibility". Like I said, we spent months evaluating products, and while we found several companies claim to offer the above, no one actually did.

[tenaciousDaniel]

One thing I did not like about CubeJS (not sure if they've changed this), is that their integration is its own standalone server. Like, if you have an existing server, it didn't seem possible to just integrate it into what you already have. That was kind of a bummer, but it wasn't a deal breaker.

[igorlukanin]

Long time ago, it was possible to built Cube into a Node.js app. However, the team decided to deprecate it: https://github.com/cube-js/cube.js/blob/master/DEPRECATION.m...

The motivation is diverse but one of the reasons is that a Cube app should be scaled differently from a client-facing app. Noone probably wants their app to hang when Cube serves a ton of requests or refreshes cached data (and vice versa). That’s why it’s recommended to run Cube as microservices. I hope it’s not a big deal since a lot of cloud platforms provide container environments.

Also, just recently, we’ve launched Cube Cloud which provides serverless experience for Cube apps and has a free tier: https://cube.dev/cloud/

[seektable]

Have you evaluated PivotData Microservice (https://www.nrecosite.com/pivotdata_service.aspx) too? It supports dynamic schemas and beyond just API it comes with sample report builders (for end-users) and built-in pivot tables.

[pklee]

What do you mean by dynamic scheams ?

[igorlukanin]

Hey! Igor from the Cube team here. Coincidentally, in a few days, we’re having a workshop on multitenancy where we’ll cover dynamic schemas: https://cube.dev/events/multitenancy. We’ll show how to customize schemas using pure JavaScript.

[mason55]

Do you have recordings or transcripts of the workshops? Multitenancy is huge for us and I’d love to see what CubeJS is offering now but I can’t make the workshop

[peiback]

we will, yes! here's our last workshop's recording, for pre-aggregations: https://www.youtube.com/watch?v=1_BP3B_wbec