Show HN: thcon, a config-driven theme controller https://bit.ly/48Smuuo

Show HN: thcon, a config-driven theme controller It's not the first CLI tool that switches terminal, editor, and desktop themes, and it certainly won't be the last. This one (mine) focuses more on switching between dark and light variants of a theme than on theme hopping, and is able to support a different set of tools. Notably, KDE Plasma, GNOME Shell user themes, and the macOS global dark mode are all supported, which is pretty unique I guess? https://bit.ly/3Fafmfv October 12, 2023 at 01:42AM

Show HN: Cloudgenda – Membership management platform for social organizations https://bit.ly/3LXcs1w

Show HN: Cloudgenda – Membership management platform for social organizations https://bit.ly/46nUiy7 October 11, 2023 at 10:56PM

Show HN: Netflix for AI-Generated Videos https://bit.ly/3FwBcKp

Show HN: Netflix for AI-Generated Videos https://bit.ly/48GoxSe October 11, 2023 at 12:53PM

Show HN: Dynamic aspect-driven image rendering for web developers https://bit.ly/3PTX2Mo

Show HN: Dynamic aspect-driven image rendering for web developers Hello HN! A few months back I was developing a website and I had to manually (re)crop images a bunch of times to test different image placements and layouts. I thought it would be neat to have a way to generate those images on the fly. Enter.. Ratio Render! ( https://bit.ly/46oeobb ) Ratio Render enables web developers to dynamically render image placeholders on their websites via their aspect ratios. Rather than serving up fixed dimension jpg or png images, Ratio Render serves up SVGs which maintain their aspect ratios while scaling infinitely. Images get embedded via a standard image tag e.g. `` It's built with Typescript & Node, runs powered by AWS Lambda, and deployed via Terraform. I'm actively working on it and there is lots of room for improvement. Any comments, feedback, or suggestions are welcome, especially if you're a web developer! https://bit.ly/46oeobb October 11, 2023 at 11:16AM

Show HN: SQL Window Functions Explained https://bit.ly/46M3FaG

Show HN: SQL Window Functions Explained Window functions are probably the most confusing part of SQL. You might think, "So what? They just added a few extra functions". Not really. "Window functions" is a separate language built into regular SQL. And it's more complicated than anything you know about SELECTs. I've read several dozen articles explaining SQL window functions. They all suffered from one of two problems: (1) Easy read without much practical value, describing 10% of features, or (2) Difficult to comprehend (if I did not know the subject — I would not understand a thing). I wanted people to understand SQL windows better. So I wrote a book on window functions with a hundred pictures and GIFs explaining everything, and fifty-six interactive exercises to turn abstract knowledge into skills. Here it is. https://bit.ly/3tjNt1F October 11, 2023 at 01:25PM

Show HN: Lineage X Snapshot Tooling https://bit.ly/46EK6AI

Show HN: Lineage X Snapshot Tooling Hello everyone, I've been working on this project for several month now and I've just released a Lineage page so I thought I could share it here. Data Drift is a tool to help data teams understand what changed in their data warehouse, and how that led to KPI instability. Here's an example: https://bit.ly/46orNjO... You can "technically" install it by yourself, but tbh our focus are on the features, not the adoption. If you are interested it takes roughly 1 hour to configure (choose the data you want to observe, run a python function, install a Github app, add a configuration file), contact us. The repo: https://bit.ly/46EK7og Roast me https://bit.ly/46qRIHr October 11, 2023 at 10:19AM

Show HN: Neovim Configuration heavily inspired by Emacs and JetBrains https://bit.ly/3Feb72y

Show HN: Neovim Configuration heavily inspired by Emacs and JetBrains Neovim Configuration heavily inspired by Emacs & JetBrains. Based on NvChad https://bit.ly/46GeqLy October 11, 2023 at 06:23AM

Show HN: A lightweight open-source web analytics for webdevs https://bit.ly/3LVc0R6

Show HN: A lightweight open-source web analytics for webdevs I wanted to share something I've been working on recently: Statum, a handy web analytics tool. https://bit.ly/46qxduo The journey began when I found myself frequently needing simple web analytics for my projects. I tried Google Analytics, especially GA4, and realized it was quite complex and, at times, not very accurate, especially when I wanted to view stats for the current day or recent hours. Then I tested a few fancy startup solution but ended up with way too expensive plans the expect me to subscribe (I'm not that rich to pay $99/month for every pet project web analytics). This drove me to think, "Why not create a tool that bridges the gap between these complex/expensive platforms and the real needs of developers like me?" So, I designed Statum to seamlessly parse both Nginx and Apache server logs. It filters all necessary data, including IP, http method, URL, and user agent. What's more, it can categorize these user-agents into mobile users, bots, and others. Besides that...to provide a holistic view, Statum augments local log file statistics with web-based JavaScript analytics, offering even deeper insights, especially into returning visitors. With Statum, you can quickly get a grip on: - The number of visitors and a breakdown between bots and real users. - Identify visitors as unique entities (tied to the browser). - Client-side parameters such as screen resolution, OS, language. - Unique user-agents and much more. I've aimed to make the setup process straightforward (it's just one js line to insert into your website template and update a few paths in .py file to parse logs from the right place). Currently, it does not have UI, I use just a text output from sqlite, the default query to get the number of visitors and return visitors is in gen_stats.sh so you can enhance it depending on what you want to analyze. I'd appreciate any feedback you have on the project. Please keep in mind that this is an initial version and it's not designed for high-traffic websites. https://bit.ly/46qxduo October 10, 2023 at 11:19PM

Show HN: Get Real-Time Updates on DAO Proposals https://bit.ly/45qBih4

Show HN: Get Real-Time Updates on DAO Proposals Hey HN! We built Realtime DAO to give people an easy way to stay updated on DAO proposals. We'll create more Twitter accounts for more options soon. Currently, we have only one for Aavegotchi. Let me know if you have any questions or feedback! https://bit.ly/3ttu5zy October 10, 2023 at 12:50PM

Show HN: Convert the Internet into your own API in seconds using GPT https://bit.ly/3ZNMXVS

Show HN: Convert the Internet into your own API in seconds using GPT Hi! I created a universal data API that uses headless browsers and GPT to extract any data from the web in JSON format. I started this project because I needed some API to do data enrichment to get company data (headcount, investment rounds, etc.). Once I did the first version, I quickly realized that there can be many use cases for such a tool: data enrichment, web scraping, data validation, etc. Thanks! https://bit.ly/3LR6Buo October 10, 2023 at 01:17PM

Show HN: REST Alternative to GraphQL and tRPC https://bit.ly/3tmUTRT

Show HN: REST Alternative to GraphQL and tRPC https://bit.ly/46moEB3 October 10, 2023 at 10:58AM

Show HN: The Water Quality Dashboard: State Compliance over the Years https://bit.ly/48G2mfb

Show HN: The Water Quality Dashboard: State Compliance over the Years https://bit.ly/46EM7Nt October 10, 2023 at 06:40AM

Show HN: Free content optimization tool for SEO https://bit.ly/3PPTHOt

Show HN: Free content optimization tool for SEO https://bit.ly/46qrBR8 October 10, 2023 at 12:01AM

Show HN: A Prettier plugin for formatting imports in Astro files https://bit.ly/3tjKOoG

Show HN: A Prettier plugin for formatting imports in Astro files https://bit.ly/3ZMyae0 October 9, 2023 at 05:27PM

Show HN: I made a Chrome extension to put headlines back into Twitter https://bit.ly/48ZnZav

Show HN: I made a Chrome extension to put headlines back into Twitter https://bit.ly/48IRInN October 10, 2023 at 01:08AM

Show HN: CheckAnyPlate – Free License Plate to VIN Decoder https://bit.ly/3LSF5ww

Show HN: CheckAnyPlate – Free License Plate to VIN Decoder This started as a project to scratch my own itch and has grown from there. Initially I wanted a way to easily see if potential funny license plates were available in a given state, but I've also started using it at car shows when I'm curious which engine or transmission is in a car. It most cases the plate can be matched to a VIN using DMV data, and then some information about the vehicle can be decoded into basic car specs You can also purchase a full vehicle history report which uses data from the NMVTIS and other services to show accident history, previous titles, and salvage issues. The site is built using the Laravel framework and connects to a bunch of APIs like the DOT and NHTSA for Safety and recall information. This is my first time running Laravel on AWS Lambda so let me know how the site feels to you https://bit.ly/3Qari7l October 9, 2023 at 02:17PM

Show HN: Automated data pipeline for your AI apps https://bit.ly/3LUMThs

Show HN: Automated data pipeline for your AI apps We just launched Turbine, it automates the data pipeline for LLM powered apps. It fetches data from your database, creates embeddings from the data, and stores in a vector database for easy semantic search. It also creates a real-time data pipeline to fetch changes and keep the search data fresh. Turbine supports multiple source databases, embedding models and vector databases. It's aimed to be configurable and easy to use at the same time. It's primary use case would be being the data backend for LLM apps—to create a relevant context for each prompt from your data. We are very early and this is our first public launch, we just have tested the product internally. Any and all feedback would be very appreciated. DM or email me at sumit@useturbine.com if you are interested to be a early beta user of Turbine and help us build this product. Thank you! Looking forward to your comments. https://bit.ly/3LOx9MH October 9, 2023 at 01:49PM

Show HN: My First SaaS https://bit.ly/46xShPs

Show HN: My First SaaS Promptly is my first SaaS Project. I built it because I wanted to refine my dev skills and also to have a central place to store my prompts for GPT, Midjourney, and other AI platform and systems. Would love some feedback on the website itself, as well as advice on how I should go about the marketing https://bit.ly/3RRnEk2 October 9, 2023 at 10:53AM

Show HN: I made a all-in-one web app to help me with my freelance admin tasks https://bit.ly/3RLBd4l

Show HN: I made a all-in-one web app to help me with my freelance admin tasks https://bit.ly/48KGqzd October 9, 2023 at 09:50AM

Show HN: I made a one button snake game variant https://bit.ly/45o0yUU

Show HN: I made a one button snake game variant https://bit.ly/45o0zbq October 9, 2023 at 01:50AM