Show HN: It took me 5() months to build a Plausible alternative https://ift.tt/LdzuQjD

Show HN: It took me 5() months to build a Plausible alternative After months of using Google Analytics I realized only about 50% of people accepted my cookie-popup. I had months of incorrect data for my website. I started looking for alternatives and eventually found Plausible, which is great (and open-source). Problem is, I didn't feel like paying 9$ a month to see the amount of visitors on a website i didn't even earn anything on, it was just a hobby project. Eventually I started making my own web analytics. Which actually isn't that hard. It took me about a month of working on my spare time every now and then. Being GDPR compliant basically means to not save any personal identifiers. At first I thought it would be easy since something like a public IP adress can't count as a personal identifier right? I was very wrong. How it works: When a user visited my website I saved the IP and Header for 24 hours. Then if they visited again I checked the combination of IP and Header against the ones saved in my DB. If they were the same I simply added 1 view to my data. If they weren't the same I added 1 unique daily user and 1 view. That's in short how it works. A few weeks later I realized if I had this problem then other would also have it. So I started working on Simplytics.dev. I had to do a lot of new stuff and re-build my code from the ground-up twice. Small things like OAuth was completely new to me and took up a lot of time. But eventually I got here and just launched something that with the knowledge I have today wouldn't even take a third of the time recreating today. It's my first real "Launch" and it feels really good finally creating something AND publishing it. Instead of a montly fee I opted to make it a pay-once service. Right now it's priced at 49$ but I'll see how it works out. If you got any questions on how it works Id love to answer them. November 25, 2024 at 09:05PM

Show HN: Built This in 3 Hours Using Bolt (No React Knowledge) https://ift.tt/qVtibIS

Show HN: Built This in 3 Hours Using Bolt (No React Knowledge) It's blowing my mind that I could build an app from scratch in 3 hours and deploy it with the click of a button - without writing a single line of code myself CacheNotes is a browser-based note-taking app that saves your notes, threads, and AI conversations securely in your browser's local storage 100% free. No login required. You get, - simple, minimal note taking app in your browser - no login required - you can connect your claude api key for the ai integration - visualise notes and twitter threads Check it out! Would love some feedback :) https://ift.tt/b2YNtch November 30, 2024 at 12:39AM

Show HN: I built an extension to contact Airbnb hosts direcly https://ift.tt/rmBCMUg

Show HN: I built an extension to contact Airbnb hosts direcly Hey HN, Over the years, I’ve found myself frustrated with the extra fees Airbnb. While they provide a lot of convenience, the service fees often stack up to a point where they overshadow any potential savings. I started wondering if there was a way to connect directly with property hosts and skip the middleman entirely. That curiosity led me to build getaway.direct, a free Chrome extension that helps travelers save money. It works like this: 1. You browse listings on Airbnb. 2. The extension scans for direct booking links, host websites, or social media profiles where you can reach out to the host directly. 3. It shows those results instantly, so you can compare prices, avoid service fees, and book smarter. The main idea is to provide transparency. A lot of hosts already have their own websites but rely on platforms like Airbnb for visibility. This tool helps surface those direct options, which can often save you 10-20% per booking. I’d love to hear your thoughts: Would something like this be helpful to you? Also, I’m curious to get feedback on ways to improve the tool—whether it’s adding more integrations, improving usability, or something else entirely. Thanks for reading! Let me know what you think. https://ift.tt/KN8l15j November 29, 2024 at 04:48PM

Show HN: A tool for kids to practice arithmetic https://ift.tt/RHVy9u1

Show HN: A tool for kids to practice arithmetic https://ift.tt/HrIGRDu November 29, 2024 at 11:55PM

Show HN: A word guessing game based on text vector embeddings and cos-similarity https://ift.tt/4F3iN6s

Show HN: A word guessing game based on text vector embeddings and cos-similarity Try to find the secret word that computer holds, by guessing and getting feedback in form of how similar your guess to the secret is. The fewer attempts the better. There is also a hint and a give-up button. Thank you, please give it a try ) https://ift.tt/X3B2bfD November 29, 2024 at 04:41AM

Show HN: iOS Theremin Simulator with Hand Tracking (Beta) https://ift.tt/wBTqDsz

Show HN: iOS Theremin Simulator with Hand Tracking (Beta) https://ift.tt/MH4NkmK November 29, 2024 at 12:23AM

Show HN: MyDuck Server – Supercharge MySQL and Postgres Analytics with DuckDB https://ift.tt/37V1yac

Show HN: MyDuck Server – Supercharge MySQL and Postgres Analytics with DuckDB Hello HN! We're excited to announce MyDuck Server, an open-source project that seamlessly integrates the analytical power of DuckDB with your existing MySQL & Postgres databases. *Backstory* Currently, there are no fully satisfactory open-source OLAP solutions for MySQL & Postgres. In the MySQL ecosystem, HeatWave offers close integration, but it's a proprietary, commercial product from Oracle. The Postgres community has seen promising DuckDB-based extensions emerge, including the official pg_duckdb. However, extensions can introduce isolation concerns in mission-critical environments. Consequently, many organizations resort to setting up complex and costly data movement pipelines using tools like Debezium, Flink, or other commercial solutions to replicate data from MySQL & Postgres to OLAP systems (e.g., Snowflake, BigQuery, ClickHouse) or Lakehouses (e.g., Delta Lake + Spark). This approach introduces significant operational overhead and expense. Another emerging strategy is the zero-ETL approach, increasingly advocated by cloud providers. This model simplifies data integration by allowing the cloud provider to manage ETL pipelines, while necessitating reliance on specific cloud ecosystems and services. *Key features* MyDuck Server offers a real-time analytical replica that leverages DuckDB's native columnar storage and processing capabilities. It operates as a separate server, ensuring isolation and minimizing impact on your primary database. Key features include: - Easy Zero-ETL: Built-in real-time replication from MySQL & Postgres with no complex pipelines to manage. It feels like a standard MySQL replica or Postgres standby. With the Docker image, passing a connection string is enough. - MySQL & Postgres Protocol Compatibility: We take this seriously and are working to make this project integrate well with the existing ecosystem around MySQL & Postgres. Currently, it is already possible to connect to MyDuck with standard MySQL & PostgreSQL clients in many programming languages. - HTAP Support: A standard database proxy can be deployed in front of a MySQL/Postgres primary and its MyDuck replica to route write operations to the primary and read operations to the replica. It just works. - DuckDB SQL & Columnar I/O over Postgres Protocol: It's unnecessary to restrict ourselves to MySQL/Postgres's SQL expressiveness and row-oriented data transfer. The Postgres port accepts all DuckDB-valid SQL queries, and you can retrieve query results in columnar format via `COPY (SELECT ...) TO STDOUT (FORMAT parquet/arrow)`. - Standalone Mode: It does not need to be run as a replica. It can also act as a primary server that brings DuckDB into server mode and accepts updates from multiple connections, breaking DuckDB's single-process limitation. *Relevant Previous HN Threads* - pg_duckdb [1] ( https://ift.tt/NUsgpEu ) is the official Postgres extension for DuckDB. It uses DuckDB as an execution engine to accelerate analytical queries by scanning Postgres tables directly. - pg_mooncake [2] ( https://ift.tt/28IdYFM ) is a Postgres extension that adds columnstore tables for PG. It uses pg_duckdb under the hood but stores data in Lakehouse formats (Iceberg & Delta Lake). - BemiDB [3] ( https://ift.tt/le8GF4Z ) is also a DuckDB-based Postgres replica. Unlike us, they focus on storing data in Lakehouse format. We believe MyDuck Server offers a compelling solution for those seeking high-performance analytics on their MySQL & Postgres data without the complexities and costs of traditional approaches. We're eager to hear your feedback and answer any questions you might have. Let me know what you think! [0] https://ift.tt/T9Z1jDu [1] https://ift.tt/aHM3y6Z [2] https://ift.tt/t80M5VD [3] https://ift.tt/3e59bAt https://ift.tt/T9Z1jDu November 28, 2024 at 08:20PM