Show HN: I wrote a free eBook about many lesser-known/secret database tricks https://bit.ly/3ulKbbs

Show HN: I wrote a free eBook about many lesser-known/secret database tricks https://bit.ly/3UpUR3C December 2, 2022 at 06:43PM

Show HN: A Visual UI to Hacker News https://bit.ly/3XUotJp

Show HN: A Visual UI to Hacker News https://bit.ly/3ujFFu9 December 2, 2022 at 02:14PM

Show HN: Mini Christmas Trees with addressable LEDs and RP2040-based controller https://bit.ly/3UsxvdE

Show HN: Mini Christmas Trees with addressable LEDs and RP2040-based controller Hello HN, these Mini Trees have a custom circuit board with WS2812 addressable LEDs on one side and a controller using an RP2040 microcontroller on the other, all inside a CNC'd Foamex PVC case. They stand around 23cm (9") tall. The firmware is written in MicroPython, which can be modified or replaced. Power is provided via USB-C, which is also used for programming. There is also a web-based animation sequencer to create lighting sequences in time to arbitrary audio, examples of which are on the linked page. This is similar to xLights ( https://bit.ly/3UrQW68 ), but much less powerful, and we hope to release firmware to interface directly with xLights soon. My colleague and I started kicking the idea for these around after making some custom circuit boards for another project, and thought we'd have a go at making smaller versions of some much larger exhibits we had made using 12 volt WS1812 bullet pixels. I hope you enjoy them, Merry Christmas! https://bit.ly/3UnriiZ December 2, 2022 at 01:20PM

Show HN: SecretKeeper – The Secure, Free iOS Password Manager https://bit.ly/3ukRbp8

Show HN: SecretKeeper – The Secure, Free iOS Password Manager Hi all! I was very disappointed that my favorite password managers for iOS went to a subscription-only model, so I decided to take matters into my own hands. SecretKeeper is a FREE password manager for iOS, allowing you to safely store all of your passwords, banking information, etc. behind a single master password (or Touch ID/Face ID). All of your data is encrypted on-device, and is NEVER shared with a third-party. With SecretKeeper, you can easily auto-fill passwords in Safari, too! I'm still making enhancement to it, so don't hesitate to make suggestions if there are features you'd like to see! https://bit.ly/3B813Gv December 2, 2022 at 02:21PM

Show HN: I made a Google Chrome extension automatically with ChatGPT https://bit.ly/3FnDGeN

Show HN: I made a Google Chrome extension automatically with ChatGPT https://bit.ly/3FkkU7N December 2, 2022 at 09:55AM

Show HN: Solving Advent of Code with ChatGPT https://bit.ly/3H1JhbG

Show HN: Solving Advent of Code with ChatGPT https://bit.ly/3W0858v December 1, 2022 at 05:16PM

Show HN: Data Breach Source Detector https://bit.ly/3ueB6kH

Show HN: Data Breach Source Detector https://bit.ly/3AZXQsE December 1, 2022 at 12:46PM

Show HN: Semantic Question Answering as a Service https://bit.ly/3GYBewf

Show HN: Semantic Question Answering as a Service Since managing the Large Language Models in production might be challenging, we've made a short demo to present how to use Cohere co.embed API and Qdrant Cloud to create a semantic QA system. This is based on bi-encoder architecture, and can be easily adopted to a different use case, like semantic search in any domain. https://bit.ly/3VJvomA December 1, 2022 at 02:11PM

Show HN: Natural Language Processing Demystified (full release/no sign-up req'd) https://bit.ly/3gOeNiT

Show HN: Natural Language Processing Demystified (full release/no sign-up req'd) Link: https://bit.ly/3wq49E3 Hi HN: After a year of work, I've published my free NLP course. The course helps anyone who knows Python and a bit of math go from the basics to today's mainstream models and frameworks. I strive to balance theory and practice, so every module consists of detailed explanations and slides along with a Colab notebook putting the ideas into practice (in most modules). The notebooks cover how to accomplish everyday NLP tasks including extracting key information, document search, text similarity, text classification, finding topics in documents, summarization, translation, generating text, and question answering. The course is divided into two parts. In part one, we cover text preprocessing, how to turn text into numbers, and multiple ways to classify and search text using "classical" approaches. And along the way, we'll pick up valuable bits on how to use tools such as spaCy and scikit-learn. In part two, we dive into deep learning for NLP. We start with neural network fundamentals and go through embeddings and sequence models until we arrive at transformers and the mainstream models of today. No registration required: https://bit.ly/3wq49E3 December 1, 2022 at 01:00PM

Show HN: I made a 2D shoot 'em up game with Go, using Entity Component System https://bit.ly/3XO6pjV

Show HN: I made a 2D shoot 'em up game with Go, using Entity Component System https://bit.ly/3XKF3eD December 1, 2022 at 12:29PM

Show HN: We have built a benchmark platform for graph databases https://bit.ly/3BnzZDx

Show HN: We have built a benchmark platform for graph databases https://bit.ly/3ESeqf5 December 1, 2022 at 09:34AM

Show HN: Notion Standup – Get daily reports on your tasks on Notion https://bit.ly/3ukW6Gp

Show HN: Notion Standup – Get daily reports on your tasks on Notion Notion Standup helps you to receive daily standup reports on email and other channels for your and your team's current and overdue tasks on Notion. Stay updated always with daily reports through email, Slack, Discord, Webhook, Zapier, and Telegram. https://bit.ly/3XOQZMg December 1, 2022 at 02:40AM

Show HN: Basement – a GraphQL API for on-chain Ethereum data https://bit.ly/3H6DmlA

Show HN: Basement – a GraphQL API for on-chain Ethereum data If we want better web3 experiences, developers need better tools. RPC nodes are really good at executing transactions, however they are notoriously cumbersome to set up, and reading large chunks of data is not very efficient: To show a list of transactions and receipts, nodes have to re-execute smart contract code on entire blocks. For every read call. Not great at scale. Which is why everyone is building ETLs to move data from the chain into their own database. This GraphQL API is our first step in allowing developers to spend more time on building product, rather than ETL infrastructure. https://bit.ly/3AWrPS4 November 30, 2022 at 11:55AM

Show HN: I built my own minimal PHP framework https://bit.ly/3GSdPN8

Show HN: I built my own minimal PHP framework This is a simple PHP framework I built myself from scratch with minimal dependencies from composer. It has Autowiring DI and some simple routing provided by the Slim router. The code: https://bit.ly/3gNN81u November 30, 2022 at 08:51AM

Show HN: Amazon Seller sent me a postcard asking me to leave a 5-star review https://bit.ly/3VE3DvL

Show HN: Amazon Seller sent me a postcard asking me to leave a 5-star review Wanted to jump in and throw this here since this is about the first time I've been reached out to by an Amazon seller by mail, directly asking me to leave a 5-star review in exchange for a $20 gift card. With an already struggling E-commerce market, it's quite strange to see the lengths sellers are going to, to buy 5-star reviews from buyers. I am considering reporting this to Amazon, however wanted to run this by you guys and hear similar stories from you! Here is the card I received: https://bit.ly/3FfrxZk https://bit.ly/3FfrxZk November 30, 2022 at 02:37AM

Show HN: SinglePage – Quickly and anonymously publish a page to the web https://bit.ly/3FbiUim

Show HN: SinglePage – Quickly and anonymously publish a page to the web Creating a basic webpage has become way too complicated and expensive. Often there are those times when you just want to share your thoughts with the world but don't want the overhead and complexities that come with maintaining a website. Sometimes, you have an interesting thought piece, an education article, or just a quick and simple bio page that doesn't need the heavy hand of a WordPress blog or Medium post. That's where Single Page comes in. Publish a single page instantly to the web with no fuss. I was laid off three weeks ago from Twitter and I decided to work through a couple of my projects and this was one of them. I've tried blogs over the years, Medium didn't feel right but yet I wanted to quickly post pages online and couldn't find an easy way to do it. So I created it. Feedback appreciated! https://bit.ly/3FcgW0V November 29, 2022 at 09:14PM

Show HN: A userscript that adds archive URLs below the paywalled HN submissions https://bit.ly/3GXrvGD

Show HN: A userscript that adds archive URLs below the paywalled HN submissions This userscript adds archive URLs to the metadata section of HN submissions without breaking the immersion. Here are 2 screenshots: https://bit.ly/3idPhUm GreasyFork: https://bit.ly/3OPWEhi... Source code: https://bit.ly/3GWGrEV Now let me overexplain. -Why?- I never liked paywalled articles. I understand where they come from, but I don't like where we cross our paths. This is why I don't use major news aggregators anymore. Instead, I spend my "catching-up-with-the-world-time" on Hacker News. However, Hacker News (HN) also has its fair-share of paywalled articles. ( Around 11.6% according to my short-lived, half-assed attempt at measuring it. See my super old data https://bit.ly/3OMKANy I tell the story below.) -First try- Around a year ago, when I ran the above experiment, my goal wasn't to run that experiment. It was during my self-teaching & career-changing process, I decided to build a React HN clone. To make it stand-out from the bunch, I added a paywall feature. It would detect paywalled articles and would add an archive URL into the metadata. The issue with archiving is unless someone archived the link before on the {archiving-project} then the link is most likely not archived. So me sending people to those projects meant nothing. It kinda meant something for me from an ideological standpoint but I assume you are not me. This rubbed me the wrong way. I decided to build a backend (See https://bit.ly/3GXowOC ) that would scan the links and automatically to detect paywalls close to real-time and submit paywalled ones to archive.is for archival. I used Nodejs, Firebase, and React. I was -still am- really proud because I believed it was doing public good in terms of digital preservation. Only 1 person needed to run this script to benefit everyone. As an extra, I was curious on how many paywalled articles were being shared, by whom, at what time. So I also created some analytics functionality to gather the data. And later created a UI to present it. HN-Paywall-Archiver was great but I stopped running the backend at some point. Because at that point couldn't find a way to continuously run my backend code on some platform for cheap or didn't try hard enough. P.S. Recently I've been thinking of remaking this version with Cloudflare Workers. -Hacker News Paywall Archiver Userscript- After almost a year, I got into userscripts. Super great super awesome concept. People seem to hate javascript unless it is presented as a userscript. So I decided to get my hands dirty to create a simple solution that solves the paywall issue on HN without breaking any hearts. My solution is not perfect as it had to be simple. But here's the rundown. Pros: - Does not beg for attention. - Simple code, simple concept. - Unintentionally, indicates which submissions are paywalled without you interacting with anything. - Not-yet-archived archive links can make you feel like you are contributing to the society after you click on the "archive this URL" button on project page. - Uses HN html defaults, so I hope it plays well with the HN skins/plugins/userscripts you use. Cons: - It doesn't automatically archive the links. - It uses clone of a static list of paywalled websites sourced from a popular Chrome extension. ( https://bit.ly/3VATNLg... ) So changing the paywall list is slow and manual. - No guarantees of archived links actually having the archive readily available for reading. Though there are currently 3 projects added, so it should be enough for most links. So, there you go. I hope you enjoy it. It can break occasionally due to changes in news.ycombinator code, if you let me know on Twitter, I can fix it ASAP. Otherwise you have to wait until I notice that the script is broken, which can take quite a while as I browse HN on mobile. https://bit.ly/3GWGrEV November 30, 2022 at 12:08AM

Show HN: A utility to reduce TypeScript errors over time https://bit.ly/3u6fQ0F

Show HN: A utility to reduce TypeScript errors over time https://bit.ly/3gKW73n November 29, 2022 at 05:04PM

Show HN: Python library for embedding large graphs (Written in Rust) https://bit.ly/3EEJa2U

Show HN: Python library for embedding large graphs (Written in Rust) https://bit.ly/3ETqexQ November 29, 2022 at 07:20AM

Show HN: Compare GPT DaVinci-002 and 003 summaries of current top HN stories https://bit.ly/3VxewPY

Show HN: Compare GPT DaVinci-002 and 003 summaries of current top HN stories Based on quick extensions to the open source telegram summarization bot I posted a few days ago ( https://bit.ly/3Uai4GC ), you can see for yourself how davinci 002 and 003 compare on the current top HN stories for the same prompt and temperature (0.2). Items that don't have summaries are usually due to a failure to access meaningful url content. https://bit.ly/3VxQZ1p November 29, 2022 at 02:41AM