Show HN: Growing Wine Grapes in My Parents’ Basement https://www.hefvin.com/ September 30, 2020 at 03:31PM
via Blogger https://ift.tt/3n85dW7
via Blogger https://ift.tt/3irpeDT
(https://ift.tt/36qp6BZhttps://whatsmusic.de/frankien-interview-creating-the-singer-songwriter-genre-standing-against-racism-and-a-memorable-open-mic-episode/
Show HN: Growing Wine Grapes in My Parents’ Basement https://www.hefvin.com/ September 30, 2020 at 03:31PM
via Blogger https://ift.tt/3n85dW7
via Blogger https://ift.tt/3irpeDT
(https://ift.tt/36qp6BZShow HN: Growing Wine Grapes in My Parents’ Basement https://www.hefvin.com/ September 30, 2020 at 03:31PM
via Blogger https://ift.tt/3n85dW7
(https://ift.tt/36lcjANShow HN: Telegram bot to get new HN stories by keywords https://ift.tt/3n7yNLJ September 30, 2020 at 10:00AM
via Blogger https://ift.tt/3l19QQe
(https://ift.tt/3jiMHIxLaunch HN: Narrator (YC S19) – a data modeling platform built on a single table Hi HN, We’re Ahmed, Cedric, Matt, and Mike from Narrator ( https://www.narrator.ai ). We’ve built a data platform that transforms all data in a data warehouse into a single 11-column data model and provides tools for analysts to quickly build any table for BI, reporting, and analysis on top of that model. Narrator initially grew out of our experience building a data platform for a team of 40 analysts and data scientists. The data warehouse, modeled as a star schema, grew to over 700 data models from 3000+ raw production tables. Every time we wanted to make a change or build a new analysis, it took forever as we had to deal with managing the complexity of these 700 different models. With all these layers of dependencies and stakeholders constantly demanding more data, we ended up making lots of mistakes (i.e. dashboard metrics not matching). These mistakes led to loss of trust and soon our stakeholders were off buying tools (Heap, Mixpanel, Amplitude, Wave Analytics, etc…) to do their own analysis. With a star schema (also core to recently IPO-ed Snowflake), you build the tables you need for reporting and BI on top of fact tables (what you want to measure, i.e. leads, sales…) and dimension tables (how you want to slice your data, i.e. gender, company, contract size…). Using this approach, the amount of fact and dimension tables grow in size and complexity in relation to the number of questions / datasets / metrics that need to be answered by the business. Over time the rate of new questions increases rapidly and data teams spend more time updating models and debugging mismatched numbers than answering data questions. What if instead of using the hundreds of fact and dimension tables in a star schema, we could use one table with all your customer data modeled as a collection of core customer actions (each a single source of truth), and combine them together to assemble any table at the moment the data analyst needs that table? Numbers would always match (single source of truth), any new question could be answered immediately without waiting on data engineering to build new fact and dimension tables (assembled when the data analyst needs it), and investigating issues would be easy (no nested dependencies of fact and dimension tables that depend on other tables). After several iterations, Narrator was born. Narrator uses a single 11-column table called the Activity Stream to represent all the data in your data warehouse. It’s built from sql transformations that transform a set of raw production tables (for example, Zendesk data) into activities (ticket opened, ticket closed, etc). Each row of the Activity Stream has a customer, a timestamp, an activity name, a unique identifier, and a bit of metadata describing it. Creating any table from this single model made up of activities that don’t obviously relate to each other is hard to imagine. Unlike star schema, we don’t use foreign keys (the direct relationships in relational databases that connect objects, like employee.company_id → company.id) because they don’t always exist when you’re dealing with data in multiple systems. Instead each activity has a customer identifier which we use, along with time, to automatically join within the single table to generate datasets. As an example, imagine you were investigating a single customer who called support. Did they visit the web site before that call? You’d look at that customer’s first web visit, and see if that person called before their next web visit. Now imagine finding all customers who behaved this way per month — you’d have to take a drastically different approach with your current data tools. Narrator, by contrast, always joins data in terms of behavior. The same approach you take to investigate a single customer applies to all of them. For the above example you’d ask Narrator’s Dataset tool to show all users who visited the website and called before the next visit, grouped by month. We started as a consultancy to build out the approach and prove that this was possible. We supported eight companies per Narrator data analyst, and now we’re excited for more data folks to get their hands on it so y’all can experience the same benefits. We’d love to hear any feedback or answer any questions about our approach. We’ve been using it ourselves in production for three years, but only launched it to the public last week. We’ll answer any comments on this thread and can also set up a video chat for anyone who wants to go more in-depth. September 30, 2020 at 09:30AM
via Blogger https://ift.tt/3cHgpEA
(https://ift.tt/33eEIqkShow HN: A simple SSH CA service with only 150 lines of Python code https://ift.tt/2Sc8UvV September 30, 2020 at 07:54AM
via Blogger https://ift.tt/2GgpFUd
(https://ift.tt/34fT7BVShow HN: Parenthing – a parenting companion for parents with children aged 3 – 9 https://ift.tt/34ecRWj September 30, 2020 at 06:26AM
via Blogger https://ift.tt/2EPLw4k
(https://ift.tt/2SdiLBzShow HN: Buku – browser-independent private portable bookmark manager https://ift.tt/2RKNVkm September 30, 2020 at 06:18AM
via Blogger https://ift.tt/3l0csO5
via Blogger https://ift.tt/347ciha
(https://ift.tt/34f6KB5Show HN: Ruby One-Liners Cookbook https://ift.tt/2Sa7Usd September 30, 2020 at 04:57AM
via Blogger https://ift.tt/3jcw15k
via Blogger https://ift.tt/3cK4ANI
(https://ift.tt/33lNhjjShow HN: A simple log-based, transactional, embedded relational database in Java https://ift.tt/2Gk685c September 30, 2020 at 07:45AM
via Blogger https://ift.tt/3ii3cDt
(https://ift.tt/3jhCKLfShow HN: Buku – browser-independent private portable bookmark manager https://ift.tt/2RKNVkm September 30, 2020 at 06:18AM
via Blogger https://ift.tt/3l0csO5
(https://ift.tt/3l1DYe4Show HN: Ruby One-Liners Cookbook https://ift.tt/2Sa7Usd September 30, 2020 at 04:57AM
via Blogger https://ift.tt/3jcw15k
(https://ift.tt/3l0v5kXShow HN: Live dashboard of every email Trump and Biden are sending https://ift.tt/33epHot September 29, 2020 at 07:25PM
via Blogger https://ift.tt/2GqD8Zh
via Blogger https://ift.tt/3l0BpsG
(https://ift.tt/36pvCJrShow HN: Live dashboard of every email Trump and Biden are sending https://ift.tt/33epHot September 29, 2020 at 07:25PM
via Blogger https://ift.tt/2GqD8Zh
(https://ift.tt/36flp21Show HN: ML News – Like HN, but for Machine Learning http://mln.dev September 29, 2020 at 02:15AM
via Blogger https://ift.tt/2SfxhZr
via Blogger https://ift.tt/3jf2GHw
(https://ift.tt/33fJEeFShow HN: Elsa is a minimal, fast and secure runtime for JavaScript written in Go https://ift.tt/3hQxZa4 September 29, 2020 at 05:05AM
via Blogger https://ift.tt/36iVDtQ
(https://ift.tt/34dzGcKShow HN: Go library for loading Python’s data serialized with pickle https://ift.tt/37o4eK1 September 29, 2020 at 03:35AM
via Blogger https://ift.tt/30dSSpG
(https://ift.tt/34o9pc7Show HN: A progress bar that plays lofi music while waiting https://ift.tt/36392WQ September 28, 2020 at 10:35PM
via Blogger https://ift.tt/2Sah3AQ
via Blogger https://ift.tt/341Mym8
(https://ift.tt/3n47mCcShow HN: ML News – Like HN, but for Machine Learning http://mln.dev September 29, 2020 at 02:15AM
via Blogger https://ift.tt/2SfxhZr
(https://ift.tt/349lUb9Show HN: A progress bar that plays lofi music while waiting https://ift.tt/36392WQ September 28, 2020 at 10:35PM
via Blogger https://ift.tt/2Sah3AQ
(https://ift.tt/34bmgOmShow HN: Keywords2lyrics – Automatic Songwriting from Keywords https://ift.tt/3kZV3oV September 28, 2020 at 03:20PM
via Blogger https://ift.tt/2S7apLP
via Blogger https://ift.tt/2HJ6MtL
(https://ift.tt/3cHXObeShow HN: lit-request – 852 bytes fetch API based Javascript microlibrary https://ift.tt/2HE3Q1n September 28, 2020 at 08:22AM
via Blogger https://ift.tt/36mOWqm
via Blogger https://ift.tt/3jhH516
(https://ift.tt/3mU6bVYShow HN: Keywords2lyrics – Automatic Songwriting from Keywords https://ift.tt/3kZV3oV September 28, 2020 at 03:20PM
via Blogger https://ift.tt/2S7apLP
(https://ift.tt/3mZndlvShow HN: lit-request – 852 bytes fetch API based Javascript microlibrary https://ift.tt/2HE3Q1n September 28, 2020 at 08:22AM
via Blogger https://ift.tt/36mOWqm
(https://ift.tt/3l0lESvShow HN: Remote Oil Tank Monitoring Solution http://myoilguage.com/ September 27, 2020 at 03:34PM
via Blogger https://ift.tt/3mXMcpv
via Blogger https://ift.tt/338K2eC
(https://ift.tt/2EJaXEGShow HN: Remote Oil Tank Monitoring Solution http://myoilguage.com/ September 27, 2020 at 03:34PM
via Blogger https://ift.tt/3mXMcpv
(https://ift.tt/3kXKX83Show HN: Fast Variant data type for Go https://ift.tt/30gzg4q September 27, 2020 at 04:56PM
via Blogger https://ift.tt/3mRxhgB
via Blogger https://ift.tt/2S5wDOs
(https://ift.tt/3cDZ8vZShow HN: File2DB, Upload CSV/JSON/Excel to a (PostgreSQL/MySQL/) Database https://ift.tt/3kRWANz September 27, 2020 at 11:36AM
via Blogger https://ift.tt/3cFvuXk
via Blogger https://ift.tt/3kU23n2
(https://ift.tt/33XWjSkShow HN: Fast Variant data type for Go https://ift.tt/30gzg4q September 27, 2020 at 04:56PM
via Blogger https://ift.tt/3mRxhgB
(https://ift.tt/3j9rCQtShow HN: File2DB, Upload CSV/JSON/Excel to a (PostgreSQL/MySQL/) Database https://ift.tt/3kRWANz September 27, 2020 at 11:36AM
via Blogger https://ift.tt/3cFvuXk
(https://ift.tt/368ZCchShow HN: Submit your startup to 38 communities https://ift.tt/303EoZg September 26, 2020 at 11:55PM
via Blogger https://ift.tt/3cyF0vf
via Blogger https://ift.tt/30d4LMO
(https://ift.tt/34jdbU7Show HN: iPhone app that may prevent you from frequent social media checking https://ift.tt/3jG8AC9 September 27, 2020 at 04:29AM
via Blogger https://ift.tt/369s6Te
(https://ift.tt/30cEqhwShow HN: Timebox – Timer Script for Windows/Linux/macOS to Practice Timeboxing https://ift.tt/1O905xI September 27, 2020 at 03:21AM
via Blogger https://ift.tt/3jm0XAp
(https://ift.tt/2ECh25CShow HN: Build AWS ECS external deployments graphically https://ift.tt/36civLy September 26, 2020 at 11:13PM
via Blogger https://ift.tt/3i1KMGM
via Blogger https://ift.tt/3i3eYkJ
(https://ift.tt/2EBkY6DShow HN: Wisefin API – Turn messy bank transactions into beautiful data https://wisefin.ai?hn September 26, 2020 at 10:00PM
via Blogger https://ift.tt/307lIrR
via Blogger https://ift.tt/3i3eY4d
(https://ift.tt/2S3VLFiShow HN: DevUtils.app – Developer Utilities for macOS This is a project I’ve been working on since the start of Covid-19. I built an app so that I don’t have to put data into online tools like JWT debugger, JSON formatter, URL decoder, etc… https://devutils.app The app works entirely offline and is open-source. I’m selling the pre-built version of the app to earn some revenue for my time. If you want to try the app but can’t afford the price or don’t have XCode to build the app, drop me an email (my profile), I’ll be happy to provide you a free build. I would love to hear all the feedback/suggestions. Thanks! September 26, 2020 at 09:47PM
via Blogger https://ift.tt/2G2x9du
via Blogger https://ift.tt/3i55JjZ
(https://ift.tt/346xLa3Show HN: Port2 – Expose local port to the internet, macOS App https://ift.tt/3i6lirT September 26, 2020 at 08:00PM
via Blogger https://ift.tt/3cAX5IZ
via Blogger https://ift.tt/2G7000j
(https://ift.tt/3j81PbnShow HN: Submit your startup to 38 communities https://ift.tt/303EoZg September 26, 2020 at 11:55PM
via Blogger https://ift.tt/3cyF0vf
(https://ift.tt/2GbwlCLShow HN: Build AWS ECS external deployments graphically https://ift.tt/36civLy September 26, 2020 at 11:13PM
via Blogger https://ift.tt/3i1KMGM
(https://ift.tt/334Cw4sShow HN: Wisefin API – Turn messy bank transactions into beautiful data https://wisefin.ai?hn September 26, 2020 at 10:00PM
via Blogger https://ift.tt/307lIrR
(https://ift.tt/2G27vp6Show HN: DevUtils.app – Developer Utilities for macOS This is a project I’ve been working on since the start of Covid-19. I built an app so that I don’t have to put data into online tools like JWT debugger, JSON formatter, URL decoder, etc… https://devutils.app The app works entirely offline and is open-source. I’m selling the pre-built version of the app to earn some revenue for my time. If you want to try the app but can’t afford the price or don’t have XCode to build the app, drop me an email (my profile), I’ll be happy to provide you a free build. I would love to hear all the feedback/suggestions. Thanks! September 26, 2020 at 09:47PM
via Blogger https://ift.tt/2G2x9du
(https://ift.tt/3jlecRTShow HN: Port2 – Expose local port to the internet, macOS App https://ift.tt/3i6lirT September 26, 2020 at 08:00PM
via Blogger https://ift.tt/3cAX5IZ
(https://ift.tt/30bQaASShow HN: Teach yourself to code with real-world projects https://codedamn.com September 26, 2020 at 07:53AM
via Blogger https://ift.tt/3mWaWys
(https://ift.tt/2S1irG3Show HN: “Embeddable Fields” in GraphQL https://ift.tt/3i67v4y September 26, 2020 at 07:16AM
via Blogger https://ift.tt/3mTe5z1
(https://ift.tt/2EAK5GKShow HN: Wyre, a hardware definition language that compiles to Verilog https://ift.tt/3mVYiiM September 26, 2020 at 06:55AM
via Blogger https://ift.tt/3cDayzZ
(https://ift.tt/369UcObShow HN: Airlane Beta – a better LinkedIn for your Twitter https://ift.tt/30a4nOW September 26, 2020 at 06:33AM
via Blogger https://ift.tt/3j9wx4e
(https://ift.tt/3334Q7iShow HN: BulletWeek GTD app packed with features https://bulletweek.app September 25, 2020 at 09:58PM
via Blogger https://ift.tt/3348kq5
(https://ift.tt/3kVXokNShow HN: Rentify – Create an online rental store https://rentify.store September 26, 2020 at 03:36AM
via Blogger https://ift.tt/3i70uAk
via Blogger https://ift.tt/3i6N3Ak
(https://ift.tt/367pLIsShow HN: I’m building an open-source catalog of cloud infrastructures https://ift.tt/3jj2eIt September 26, 2020 at 03:02AM
via Blogger https://ift.tt/2S7vyoZ
via Blogger https://ift.tt/3cwTE62
(https://ift.tt/3mW7aVxShow HN: Rentify – Create an online rental store https://rentify.store September 26, 2020 at 03:36AM
via Blogger https://ift.tt/3i70uAk
(https://ift.tt/2HzmHutShow HN: I’m building an open-source catalog of cloud infrastructures https://ift.tt/3jj2eIt September 26, 2020 at 03:02AM
via Blogger https://ift.tt/2S7vyoZ
(https://ift.tt/2RZlbDE