Show HN: Build a SQLite satabase from your Reddit data https://news.ycombinator.com/item?id=36062256

Show HN: Build a SQLite satabase from your Reddit data With Reddit's upcoming API changes[0], I got nervous that I'd no longer be able to access the many posts and comments I've left there over the years. Inspired by the Dogsheep projects[1], this CLI lets you immediately pull your most recent 1k comments & 1k posts (the max allowed by the paged API) into a nicely-structured SQLite database. It's perfect for loading into Datasette for nice viewing & full-text search of your content. Taking it a step further, the project's killer feature is the ability to import data from GDPR archives. This allows you to store your full Reddit history (including deleted comments and posts on removed subreddits). I hope you find this tool useful! I'll be around to answer questions and field comments (or feel free to open a GH issue). [0]: https://old.reddit.com/r/reddit/comments/12qwagm/an_update_r... [1]: https://dogsheep.github.io/ https://github.com/xavdid/reddit-user-to-sqlite May 24, 2023 at 11:35AM

Show HN: Gis.chat – a Geospatial Community https://news.ycombinator.com/item?id=36040612

Show HN: Gis.chat – a Geospatial Community Hi folks! I'm excited to show you gis.chat, a geospatial chat platform in both senses: a platform about geospatial topics and a geospatial platform itself, referencing the location of our communities. The setup is fairly simple and reproducible: a plain Zulip instance and a homepage with geospatial search capabilities. It seems almost trivial but it has some very nice features. I guess you should be familiar with Zulips stream/topic model to follow along ( https://zulip.com/help/streams-and-topics ). The core idea is that there are city-specific streams (currently represented by a pin), but there could just as well be streams about points of interest, line geometries (e.g. a river) or polygons (e.g. national park). - Every local stream can have the same topics, e.g. "general", "news", "meetups", "jobs" etc. - With Zulip's search you can either search for a particular topic, e.g. "news" in a local stream or instead in all streams and have some kind of news feed of the community with "topic:news" - Once more communities are added, specific filters could be added, e.g. country-wise or by drawing your own area of interest - Eventually, for the ones who like, users could associate themselves with a local community in their profile or add there main location so one could not only search for the local communities but instead also for individuals There are many nice features in Zulip's pipeline that would foster gis.chat: - Further nesting of streams/topics - Semantic search If for example Zulip would allow for saving coordinates (or better an entire geometry) in the Postgres DB, with the help of PostGIS, Zulip's search could allow for bounding boxes (or custom geometries). Let me know if you have any kind of other ideas or feedback! https://gis.chat May 22, 2023 at 11:24PM

Show HN: Yakread – An RSS reader powered by machine learning https://news.ycombinator.com/item?id=36061427

Show HN: Yakread – An RSS reader powered by machine learning This is a web-based reading app I've been working on since August. The main differentiator is that Yakread uses machine learning to rank the articles in your feed: as you click on articles from a particular RSS/newsletter subscription, other articles from that subscription will tend to be ranked higher in the future (via a bandit algorithm). Yakread also uses ML to recommend articles that other users have read, so your feed will have articles in it even before you sign up and add your own subscriptions. For the recommendations, I'm using the collaborative filtering implementation from Spark MLlib[1]. I model RSS feeds instead of individual articles: when you click an article, that counts as a "point" for that article's RSS feed; at recommendation time, the algorithm first selects an RSS feed to recommend, and then it picks one of the popular/recent articles from that feed. To counter popularity bias, I have a pre-ranking step that probabilistically filters out RSS feeds that have already been recommended a lot. I manually approve all RSS feeds before they're eligible to be recommended. In addition to scrolling through the algorithmic feed, you can read articles chronologically on the subscriptions page, which I sometimes prefer when I have a larger chunk of reading time. There's also a daily digest email that lists new articles from your subscriptions; skimming that is part of my morning routine. I find the whole system gives me a nice balance between algorithmic filtering and manual control. This is the culmination of the past four years I've spent as a full-time bootstrapped founder; Yakread both scratches a personal itch and attempts to fix various deficiencies that my previous businesses have had. In a nutshell, I've come to believe that "discovery is a feature, not a product," which is why Yakread is a full reading app instead of a standalone recommender system like my previous products.[2] From a business perspective, the recommendation algorithm is primarily intended to help onboard new users quickly/easily. More ideologically, I think RSS is ready for a comeback :). [1] https://spark.apache.org/docs/latest/mllib-collaborative-fil... -- I'm using the implicit feedback setting. [2] Show HN for Yakread's immediate predecessor, The Sample: https://news.ycombinator.com/item?id=27664020 . The Sample does bring in $1k or so per month, but long-term retention is too low for me to grow it sustainably. https://yakread.com/ May 24, 2023 at 10:29AM

Show HN: I made a Chrome extension to hide history in ChatGPT https://news.ycombinator.com/item?id=36056404

Show HN: I made a Chrome extension to hide history in ChatGPT https://chrome.google.com/webstore/detail/hide-chatgpt-history/nclfjbhifakabnbohdppoghfdhmlbgak May 24, 2023 at 04:15AM

Show HN: Mental Models for Startup Founders https://news.ycombinator.com/item?id=36054769

Show HN: Mental Models for Startup Founders Hello HN, I launched Wingify/VWO (Visual Website Optimizer) here on HN in 2010. The initial momentum and feedback I got from this place was a key reason I was able to profitably bootstrap the company to roughly ~$30MN ARR. Over the last 2 years, I have been writing a book for startup founders that's informed by my experience with Wingify and many failed attempts before it. It's finally done, so thought of launching it on the same forum where it all started for me :) There are a total of 68 mental models covering various aspects of building a startup: - Choosing markets - Building products - Ecosystems and partners - Thinking about Moats - Approaching marketing - B2B v/s B2C - Hiring & culture Unlike other books, I'm not sharing my story and neither take a very prescriptive approach. Rather, I use mental models to shine light and provide a tractable way of looking at problems an entrepreneur encounters during her startup. I understand that entrepreneurship cannot be systemized, but I'm hoping some of the mental models I share help in clearer thinking and faster decisions. Would love your feedback on the book: https://invertedpassion.com/free-book-mental-models-for-star... If you find it useful, please share it with others in your network. https://invertedpassion.com/free-book-mental-models-for-startup-founders/ May 23, 2023 at 11:27PM

Show HN: Defguard – open-source security army knife (Identity,MFA,VPN,Yubikey) https://news.ycombinator.com/item?id=36056080

Show HN: Defguard – open-source security army knife (Identity,MFA,VPN,Yubikey) https://github.com/DefGuard/defguard May 24, 2023 at 03:27AM

Show HN: Dark Mode for HN https://news.ycombinator.com/item?id=36055506

Show HN: Dark Mode for HN https://chrome.google.com/webstore/detail/hacker-news-dark-mode/jnmbfobflanbemhhphppnjmfhhfdkegd May 24, 2023 at 01:41AM