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

Show HN: A website to practice for job interviews https://ift.tt/RsmrjJE

Show HN: A website to practice for job interviews A little backstory- When I first arrived in Canada as an international student, I met a guy who created a product called InterviewPal. I was fascinated and eager to use it, but soon discovered it was exclusive to University of Alberta students. This made me frustrated so I decided to take on the challenge of building a better alternative- something more accessible and affordable. After I announced Zilta’s waitlist on LinkedIn, Aryan blocked me, which bummed me out for a bit. But it only fueled my drive to create something much better than his overpriced product. My goal was to offer a solution that students and recent grads could actually afford and benefit from. And that’s how Zilta came into existance. I also wanted to give indie hacking a shot and took this endeavor so you can say I hit two birds with one stone haha --- Zilta was launched in June but I wasn't able to work on it extensively because of the workload from college and a part-time job I do. Now that the semester is approaching its end, I'm getting more time for it. Frankly speaking, I don't really know where to take this product to. Right now I am a little confused if I should focuss on marketing and getting more users to try it out and then add more features to it or the opposite. On the other hand, I've also listed this startup to sell for a few bucks because marketing is so hard. What I want deep down? I want this product to grow to 1-2K MRR and then sell it. The problem? I am not sure if I'm heading in the right direction. I'd like you all to give it a try and roast this product. I'm open to receving constructive critism and any advice that can help me succeed in this journey. Should I work on marketing, adding more features or selling this? https://www.zilta.io/ November 27, 2024 at 11:54PM

Show HN: AutoPiP – Safari extension for automatic Picture-in-Picture mode https://ift.tt/HkqzdeZ

Show HN: AutoPiP – Safari extension for automatic Picture-in-Picture mode AutoPiP is a Safari extension that automatically enables Picture-in-Picture mode when switching tabs and disables it when returning to the video tab. No clicks needed - just seamless multitasking while watching videos. Key features: • Automatic PiP activation when switching tabs • Smart detection for active videos only • Seamless disable on tab return • Zero configuration needed GitHub: https://ift.tt/DbeXdEC https://ift.tt/DbeXdEC November 27, 2024 at 04:06PM

Show HN: AI Project Manager for Slack with Natural Language Superpowers https://ift.tt/fMaDw5v

Show HN: AI Project Manager for Slack with Natural Language Superpowers https://ift.tt/1tr2yDd November 27, 2024 at 07:33AM