buremba

18 ms·

241.
by buremba 7y ago
It sounds to be a PrestoSQL-like solution based on the Postgresql FDW.
242.
by buremba 7y ago
Predicate pushdown is one of the first optimizations implemented in SQL planners and all the OLAP and OLTP solutions that I'm aware of already have this feature in place.
243.
by buremba 7y ago
CTEs solve the problem to some extent only for the data-sources. You often need to have snippets, expression functions, being able to compose multiple expressions, be able to compile SQL queries that are both efficient and readable if you w
244.
by buremba 7y ago
I agree with you, Looker is awesome but it's far from perfect. It does solve most of the problems in a convenient way but as the data modeling gets more and more complex and they're not going to able to iterate the product at that
245.
by buremba 7y ago
RDBMS doesn't work but columnar databases such as BigQuery, Snowflake, and Presto make it work. I agree that web/product analytics data is hard to get it done the right way thus people rely on specialized solutions such as Mixpane
246.
by buremba 7y ago
Correct but the problem with raw SQL is that it's not composable easily. LookML essentially provides that composability on top of SQL.
247.
by buremba 7y ago
The columnar database engines are powerful enough to answer the ad-hoc questions so you often don't need to materialize the summary data somewhere else or use BI tools such as Tableau that fetch the data into their server and let you r
248.
by buremba 7y ago
The main reason is that it took tens of years to build Google Analytics as it is and Google has the advantage to be able to provide more information about the user such as demographic data (gender, age, etc) since they have all the data in-
249.
Recipes: Open-source data models for third party integrations(rakam.io)
2 points by buremba 7y ago|0 comments
250.
by buremba 7y ago
brew install rust
251.
by buremba 7y ago
That's correct but there is also an alternative approach. You can track your user event data into your database using an open-source solution such as Rakam API ( https://github.com/rakam-io/rakam ) or Snowplow ( htt
252.
by buremba 7y ago
Well, your error tracking solution is not simple as a javascript snippet then.
253.
by buremba 7y ago
I see the point but I don't agree with the author. If I'm not mistaken that it took more than two years just to build their product and they're still pivoting in a way that they can monetize their users. I'm not actually
254.
by buremba 7y ago
A user can land your page from multiple referrers (or the same) more than once and some search engines including Google will hide the referrer information so the calculation will be off IMO. The regulations are not strict if you're not
255.
by buremba 7y ago
I tried using Spring with Kotlin last year but it felt verbose as if I'm writing Java so we decided to implement support for Kotlin in our in-house Netty-based server ( https://github.com/buremba/netty-rest ) and us
256.
by buremba 7y ago
People usually get confused when we tell them that we're using Kotlin for our backend APIs. I can't blame them because we attended KotlinConf last year and almost 90% of the audience were using Kotlin on the Android platform. Hope
257.
by buremba 7y ago
Take a look at Google Cloud Shell.
258.
by buremba 7y ago
While I tried to use Lombok in Java 8, it never felt safe. Even if I enabled the integration with the IDE, it magically patches my code under the hood so it wasn't easy for me to catch the bugs introduced by Lombok. > There is littl
259.
by buremba 7y ago
While the cohort tables seems easy to understand, it’s not actually easy to write SQL queries that generates those graphs because of the way SQL works. That’s probably the main reason why most of the companies continue to use the tools such
260.
by buremba 7y ago
I see. We actually develop a BI tool similar to Looker but also want to implement a data catalog feature embedded into it. I'm familiar with Amundsen but I believe that this kind of tool needs to have tight integration with the BI tool
261.
by buremba 7y ago
Since your Looker setup is well-maintained, did you consider adopting the data catalog in Looker, what would be the challenge doing it?
262.
by buremba 7y ago
We use Segment for event tracking, Postgresql for transactional data and a number of spreadsheets and third-party integrations with Stitchdata. Since our data is relatively small, we use PG as a data-warehouse and heavily use DBT for ETL.
263.
by buremba 7y ago
We also developed a product that collects the user event data via SDKs ( https://github.com/rakam-io/rakam ), depending on the data volume the users pick one of the two deployment types. The first one is based on Postgre
264.
by buremba 7y ago
You're right but if the syntax that you're using is not supported in Clickhouse, aggregate and predicate pushdowns won't work and this FDW ( https://github.com/adjust/clickhouse_fdw ) needs to map all the
265.
by buremba 7y ago
If you use Postgresql's query engine on the Clickhouse data, you lose all the benefits of the columnar query engine of Clickhouse so that's not correct.
266.
by buremba 7y ago
We sent an MR to Gitlab 1.5 years ago ( https://gitlab.com/gitlab-org/gitlab-foss/merge_requests/156... ) implementing our open-source analytics tool to their app and letting the system administrators opt-in to
267.
Analyzing Liquor Sales in Iowa Using BigQuery Public Datasets(rakam.io)
1 points by buremba 7y ago|0 comments
268.
by buremba 7y ago
It looks like an alternative to Jsonnet which has schema validation & strict types. IMO, Jsonnet syntax is much simpler, it already has integration with IDEs such as VSCode and Intellij and it has enough traction already. Cue seems like
269.
by buremba 7y ago
I believe that you should set your expectations clearly. 1. Do you want this tool to have advanced analytics features which give you to analyze the user behavior? 2. Who is going to use this tool, marketing or product people? Do you need a
270.
by buremba 7y ago
Would love to see Vue version of it.

More ›