Hacker News new | ask | show | jobs
by sandGorgon 2635 days ago
this is super cool and i would pay for this. Bigquery is a cheap alternative to a lot of the mobile analytics tools.

Quick point however - why do you need a new database ? You can use a table inside bigquery itself. It seriously reduces the dependencies required.
1 comments
akalitenya 2635 days ago
Mprove creates permanent derived tables in BigQuery if the user wants it.

But you can't use BigQuery for OLTP.

link
sandGorgon 2634 days ago
No - I'm talking about MySQL being needed as a dependency.

https://github.com/mprove-io/mprove/blob/master/deploy/docke...

Can you not use biquery database itself. Create tables for your internal use instead of MySQL ?

link
akalitenya 2634 days ago
The MySQL image specified in the docker-compose file you mentioned. It is used for the internal data of the Mprove application (users, projects, members, etc.). Each user action in the web client (angular) can initiate several queries to this database through an backend request. Delays here are crucial. network latency - so you need to keep the database as close as possible to your server side, read / write delays - for queries such as finding a user / setting a username / creating a member, etc.
link
sandGorgon 2634 days ago
Hmm..I would prefer to not have it. In production, managing database persistence is very hard. Especially when you go down the kubernetes road.

I would take higher latency, but avoid pulling in a whole database infrastructure.

Plus a huge number of us use postgresql..so that becomes another set of a mess. I would strongly urge you to do this on the same bigquery database that you would connect to anyways.

link
akalitenya 2632 days ago
Bigquery exists only in Google Cloud. This is a columnar database like Redshift. It is not designed for fast processing small queries that are necessary to support the operation of any application. Its main feature is that it can scale the execution of heavy analytical queries between 10,000 nodes transparently for the end user. Users have no control over Bigquery instances. This is super cost effective cloud analytical database as a service to be used as centralized data warehouse for company of any size.
link