Show HN: Ask recurring questions and get aggregated answers in your email https://ift.tt/2U2LcTo

Show HN: Ask recurring questions and get aggregated answers in your email https://keyory.com March 13, 2020 at 08:44PM

Launch HN: Ophelia (YC W20) – At-home recovery for opioid addiction https://ift.tt/2w3bs80

Launch HN: Ophelia (YC W20) – At-home recovery for opioid addiction Hi HN, My name is Zack, and I'm the founder of Ophelia. We help people quit opioids without going to rehab. We offer online doctor's visits, medication for withdrawal and cravings, and long-term support for recovery. There’s a treatment for opioid addiction that works, and it’s low-cost, discreet, and convenient. It’s called medication-assisted treatment (or MAT), it reduces mortality by more than 5x [1], and it resembles treatment for anxiety or depression: medication and therapy. Yet 80% of the 3 million Americans addicted to opioids are not getting it. You can read more about MAT at [2] [3] [4]. I decided to work on this problem after my girlfriend died of an overdose last year. She wanted to quit, but she was afraid of losing her job and her privacy, and she found it easier to get this medication from a drug dealer than a doctor or rehab. The rest of the story is too sad to articulate, and I don’t want this post to be about her. It’s about all of the people just like her, struggling to get help today. This is why I started Ophelia: to lower the barriers to proven, lifesaving treatment. Most Americans struggling with opioids have jobs, families, and privacy concerns that make rehab an impossible option. They want to quit , but they’re afraid of withdrawal, and the medication that helps is too hard to get: doctors need a special waiver to prescribe it, which only 5% of them have [5], so most people are buying it on the black market. Yet, drug dealers aren’t doctors, and the statistics support it: every 11 minutes, another American dies of an opioid overdose – now the #1 cause of death for Americans under 50. As it turns out, rehab is not just unnecessary: the data shows it rarely works anyway [6] [7]. Without medication, 90% of people relapse in the first 3 months: yet, 2/3rds of rehabs don’t offer medication, and most don’t even employ doctors! Thus: 80% of people avoid getting help, and the rest succumb to pseudoscience that does nothing to address their problem. Ophelia’s mission is to replace drug dealers with doctors, without any loss of privacy or convenience. We make MAT discreet, convenient, and affordable for anyone who needs help but can’t or won’t go to rehab. Our medical directors are two of the best addiction specialists in the world (Dr. Adam Bisaga and Dr. Arthur Robin Williams, both Columbia Professors and NIH-funded research scientists), and we’re now treating patients in Philadelphia and New York, through a combined in-person and telemedicine approach. There's a problem, though: we're restricted by regulations from letting people know that this treatment is available. Both Facebook and Google require a third-party certification before allowing us to use their platforms, and many sites like Reddit don't allow any advertising for addiction treatment at all. We would love your help figuring out how to get past this bottleneck. The other big problem is the stigma around addiction, which stops most people from sharing success stories about MAT, so its efficacy is underappreciated. If you know anyone who is personally struggling with this issue, please make sure they know about MAT. It can literally save their life. If you have thoughts about how we can solve these problems, I would be grateful for your help: any ideas to increase awareness of MAT or just personal stories that can help us better understand the needs of our patients. Thank you, HN. Your time and support mean a lot. Zack Gray, Ophelia Founder & CEO P.S. You can reach me at zack@meetophelia.com [1] Effects of medication-assisted treatment among opioid users https://ift.tt/3cYMIP9 [2] Medication-Assisted Treatment (MAT) https://ift.tt/2mIy4mW [3] Information about Medication-Assisted Treatment (MAT) https://ift.tt/39RI2Zh... [4] We have a solution for the opioid epidemic. It’s dramatically underused. https://ift.tt/33gvh7Z... [5] America’s Healthcare System is Making the Opioid Crisis Worse https://ift.tt/2U2Blgl... [6] Lapse and relapse following inpatient treatment of opiate dependence. https://ift.tt/2dpGs6j [7] Does Rehab Work as a Treatment for Alcoholism and Other Addictions? https://ift.tt/2QrVklJ March 13, 2020 at 08:23PM

Show HN: Covid-19 Deathrate https://ift.tt/3aQxWba

Show HN: Covid-19 Deathrate https://ift.tt/3aLgp4e I had a recent conversation with a startup who needed a developer, they asked me to write some code to prove I can code. NOTE: I hate writing toy CRUD things... so... Recent Coronavirus news was on my mind so I thought I would add a fun little project to the mix. So here it is. This website is a little tool so you can make guesses as to the possible death-rate of Covid-19 is assuming you contract the illness of course. The problem is, the numbers you need to actually make these calculations don't exist so it's all very hypothetical. But I wanted to show that things are hypothetical at this stage. I am not sure how I will improve it moving forward but I have a few ideas. I'm more interested in what some of you guys think! March 13, 2020 at 06:53PM

Show HN: Eat the News – A text extraction playground for global RSS feeds https://ift.tt/39P9Ptq

Show HN: Eat the News – A text extraction playground for global RSS feeds https://ift.tt/2QcB890 March 13, 2020 at 05:13PM

Show HN: I made a chat roulette for remote workers https://ift.tt/38PEghQ

Show HN: I made a chat roulette for remote workers https://ift.tt/2IMaGPv March 13, 2020 at 05:01PM

Launch HN: Castodia (YC W20) – Populate Google Sheets from databases https://ift.tt/2U0FKAk

Launch HN: Castodia (YC W20) – Populate Google Sheets from databases Hey HN, we’re Jimmy and Ayazhan, founders of Castodia (https://ift.tt/3d1Dr95). We help pull data from databases directly into Google Sheets. It’s basically a live database connector for Google Sheets that allows for data refreshes. Before we started working on this, we were working on an idea around data pipelines. It didn’t take off so we had to pivot mid-batch. We had less than 1 month to do user interviews, build our product, get it approved, and launch it. To start with, we knew we wanted to stay in the data space. We spent the first week talking to over 30 people at different companies. In those conversations, we noticed that sales, marketing, and operations teams constantly need to ask developers to help them export data from the database and often have to submit follow-on data requests because they forgot to add a dimension needed for analysis (they often do this by submitting Jira tickets). This is an inefficient yet surprisingly common thing at companies today. Perhaps even more surprising is that data scientists at big companies like Facebook, who have invested heavily in data infrastructure and analytics tools, often use spreadsheets as a step in their data analysis workflow. While they can pull data for analysis themselves, they too export data into CSV and then open it in a spreadsheet. This means that their data doesn’t update automatically and the process has to be repeated each time. At first, we were considering building our own BI tool to solve this problem. However, during our conversations we noticed that people feel new-tool fatigue, especially when their companies rotate through different tools that are used for the same purpose. For instance, we’ve heard of companies going from Tableau to Looker and back to Tableau. Or from Kibana to Sisense to Looker. Sometimes it feels like companies are paying a lot of money for tools that people aren’t really using just because it’s the thing everybody “needs to have”. Each one comes with its own structure, data modeling and steep learning curve. It's overwhelming. At some point people just realize that whatever tool they learn will likely change once a new VP gets hired and wants to do things in a new way. In anticipation of that, they default to the one tool they know how to use and likely won’t be replaced soon. Spreadsheets also happen to be an elegant solution for simple calculations, quick pivots, and high level data exploration. They are elegant in a way that no $50k a year enterprise visualization tool can be - not because they can’t do those things, but because people don’t know how to do it quickly with them. It’s also hard to change workflows for people who live in spreadsheets. Spreadsheets are a pretty good for ad-hoc analysis and summaries that are used for presentations and reports. So instead of another BI tool, we built a Google Sheets add-on that connects to a database and lets them search through tables, filter/order the data, and then load it into Sheets directly. In the future, we’ll let them schedule data refreshes for any saved query, so all their calculations and pivot tables update with the latest data from the database. We’ve built our first integration with Postgres and testing a MySQL, MongoDB, and public dataset connector. We plan to add integrations to more data sources, including data warehouses such as Snowflake and BigQuery. We implemented it to only get read-access to the database and we don’t store connection credentials or replicate data in our database. We are focused on data analysis at the moment, but a few customers have requested features to also write into database (write access to the database). Not sure yet how to do this safely with spreadsheets or whether we should at all. We’ve heard suggestions such as database write roll-backs or some intermediate data queue that can be approved by table owners. Other challenges include: (1) building data connectors because many data sources spits out data differently, which means we have to parse it differently to make it accessible from a uniform interface. (2) We make connections to databases and perform all queries using AWS lambda functions (thank you serverless!) Some queries are taking minutes to execute, but AWS drops connection after 29 seconds. (3) It is hard and, as HN often points out, risky to build a product that depends on Google. We're also running into Google Sheets' row limitations - still figuring out a way to work around this for large databases. We’ve been bouncing ideas around building a back-end to perform heavy computations while only displaying a sampled subset of data in the spreadsheet. We think it's worth it to plunge ahead despite all these issues, though, because having a spreadsheet interface to their data is very much what our users want. We plan to charge users a monthly fee for use of our product and we'll have a HN discount on our basic plan. We’d love to hear about your data analysis workflows, the tools you use to do this, any problems you’ve had getting data for analysis, and of course, your thoughts and experiences on this use of spreadsheets! Questions and specific integration requests are also welcome, and if you would like to be beta users, feel free to email us at founders@castodia.com. March 13, 2020 at 03:36PM

Show HN: Photile – create photo collages from your Instagram photos easily https://ift.tt/3aYhcit

Show HN: Photile – create photo collages from your Instagram photos easily https://photile.co/ March 13, 2020 at 01:07PM

Show HN: Iam-SSH-agent, SSH-agent for AWS IAM entities without raw key access https://ift.tt/2wWxeKE

Show HN: Iam-SSH-agent, SSH-agent for AWS IAM entities without raw key access https://ift.tt/2Wb33ds March 13, 2020 at 02:29AM

Show HN: Counters – GUI for those who don't do GUI https://ift.tt/2WaqtzO

Show HN: Counters – GUI for those who don't do GUI https://ift.tt/39Nuq15 March 13, 2020 at 08:23AM

Show HN: Mimetype – Golang library for file type identification https://ift.tt/2TVfQxK

Show HN: Mimetype – Golang library for file type identification https://ift.tt/2LXFNeH March 13, 2020 at 07:35AM