huy

9 ms·

1. 31.▲
   OLAP != OLAP Cube(holistics.io)

   4 points by huy 7y ago|1 comments
2. 32.▲
   by huy 7y ago

   Can you elaborate more on what you meAn by “creating clean data models”?
3. 33.▲
   The Rise of SQL-Based Data Modeling(holistics.io)

   192 points by huy 7y ago|125 comments
4. 34.▲
   by huy 7y ago

   Interesting perspective. What do you say to someone who's been using OLAP cube for their entire BI implementation? What would be the transition plan to adopting MPP databases?
5. 35.▲
   The Rise of SQL-Based Data Modeling(holistics.io)

   5 points by huy 7y ago|0 comments
6. 36.▲
   by huy 7y ago

   You might want to check out Holistics.io, allowing your non-technical to explore data without writing SQL. It's an alternative to Looker but more affordable, and more powerful than Metabase.
7. 37.▲
   by huy 7y ago

   Postgres, Pipedrive, Zendesk -> BigQuery, then BI using Holistics.io Holistics handles both ETL, transformation and self-service visualiation (Looker alternative), all in 1 tool.
8. 38.▲
   by huy 7y ago

   It might. But we hope it'll get more popular than Microsoft .NET DBML
9. 39.▲
   by huy 7y ago

   It doesn't yet.
10. 40.▲
    by huy 7y ago

    Yes we do. SQLite is in the roadmap. Although it’s database-agnostic, we do realize that a lot of the use cases is about generating database-specific SQL based on DBML code. So we’re working on introducing dialects to the syntax so that it
11. 41.▲
    by huy 7y ago

    That’s a great idea. We’ll certainly consider it in the near future.
12. 42.▲
    by huy 7y ago

    OP here. Sharing a bit of history on DBML. Originated from dbdiagram.io, a simple tool that we built to help you draw ER diagram by using writing code [1]. We shared that project on HN about a year back. Since then it has been growing organ
13. 43.▲
    Show HN: DBML – simple DSL language to document database schemas(dbml-lang.org)

    57 points by huy 7y ago|16 comments
14. 44.▲
    by huy 7y ago

    Thanks for sharing. I understand the definition, but I'd say that by documenting these market interactions down, we're giving our colleagues a better intuition of the market/industry. Granted it will be some further steps bef
15. 45.▲
    How to transfer tacit knowledge in organization(twitter.com)

    4 points by huy 7y ago|2 comments
16. 46.▲
    Complete, In-Depth Reviews of Google Data Studio(holistics.io)

    1 points by huy 8y ago|0 comments
17. 47.▲
    by huy 8y ago

    Thanks! We actually built this in-house using D3js. Maybe we can look into open sourcing the rendering component.
18. 48.▲
    by huy 8y ago

    Thanks! Can you work around by changing that to a number and try again?
19. 49.▲
    by huy 8y ago

    Thanks for this! Looks like we haven't handled all the custom syntax cases properly. Will sort it out shortly! For now, a workaround is to remove those lambda and it should work!
20. 50.▲
    by huy 8y ago

    It's string-reading, we use PegJS for that :) https://pegjs.org/
21. 51.▲
    by huy 8y ago

    Thanks! This diagram generated by rails-erd is indeed very nice. Something we should definitely look into to improve our visualization. I think both tools serve slightly different purpose. How we're different is that we started by bein
22. 52.▲
    by huy 8y ago

    Thanks for the love! Yes since rails convention is clear-cut and standardized, we can read those implicit conversions in the backend and convert to necessary relationships.
23. 53.▲
    by huy 8y ago

    Thanks! It seems like we haven't catered for more complex table syntax (when you added extra stuff like `force: delele` et al). We'll look into this and fix them. Really appreciate your feedback here!
24. 54.▲
    Show HN: Visualize Your Rails App to ER Diagram Automatically(holistics.io)

    104 points by huy 8y ago|32 comments
25. 55.▲
    by huy 8y ago

    Thanks! We will support DDL of individual SQL databases (postgres, mysql, etc). I.e. you can copy your CREATE TABLE statements here and we will translate them.
26. 56.▲
    by huy 8y ago

    Thanks for the feedback on the showing of relations by default!
27. 57.▲
    by huy 8y ago

    OP here, let me share a bit on the backstory of this. 1 odd month ago, our interns were starting to build this little project, our goal is to integrate into the current product (a cloud-based BI), so our users could easily understand their
28. 58.▲
    Show HN: Draw Database Diagrams Using Code (DSL) – Dbdiagram.io(dbdiagram.io)

    20 points by huy 8y ago|5 comments
29. 59.▲
    by huy 8y ago

    I work for a BI startup (competitor to Domo), so as part of my work, we did our own analysis of Domo product, and also chanced across prospects/customers that are current/ex-Domo users. Domo is very "business users friendly&q
30. 60.▲
    We Built a Job Queue System with PostgreSQL and Ruby (for B2B SaaS Application)(blog.holistics.io)

    12 points by huy 9y ago|0 comments