Show HN: Open-source private home security camera system (end-to-end encryption) https://ift.tt/kls8fcZ

Show HN: Open-source private home security camera system (end-to-end encryption) I needed a security camera inside my house, one that would send motion notifications to my smartphone and would allow me to livestream remotely. However, I could not find one that I could trust due to privacy concerns. Many of them upload the plaintext of videos to their servers and none is fully open-source as far as I know. Therefore, I decided to use my spare time to build one from scratch. Called Privastead (as in Private Homestead), it uses OpenMLS for end-to-end encryption (between the camera local hub and the smartphone) and is mostly implemented in Rust (except for part of the Android app that is implemented in Kotlin). The system is functional now and I've been using it in my own house for the past couple of weeks. Based on some of the discussions I've seen online, it seems like there are other users who are also concerned with the privacy implications of home security cameras. Therefore, I decided to open source my solution for everyone to use. If you need a privacy-preserving home security camera, please give it a try and provide feedback. Note that trying out the system requires you to have a supported IP camera, a local machine connected to the IP camera, a server, and an Android smartphone. I have put together detailed instructions on setting up the system, which I hope makes it easier for others to get the system up and running. In addition, consider contributing to the project. The prototype currently has a lot of limitations: mainly that it has only been tested with one IP camera, only allows the use of one camera, and only supports Android. I'll continue to improve the prototype as time permits, but progress will be much faster if there are other contributors as well. https://ift.tt/D1PeLbS December 1, 2024 at 03:43AM

Show HN: Jinbase – Multi-model transactional embedded database https://ift.tt/Lu8or3n

Show HN: Jinbase – Multi-model transactional embedded database Hi HN ! Alex here. I'm excited to show you Jinbase ( https://ift.tt/C7ufK5c ), my multi-model transactional embedded database. Almost a year ago, I introduced Paradict [1], my take on multi-format streaming serialization. Given its readability, the Paradict text format appears de facto as an interesting data format for config files. But using Paradict to manage config files would end up cluttering its programming interface and making it confusing for users who still have choices of alternative libraries (TOML, INI File, etc.) dedicated to config files. So I used Paradict as a dependency for KvF (Key-value file format) [2], a new project of mine that focuses on config files with sections. With its compact binary format, I thought Paradict would be an efficient dependency for a new project that would rely on I/O functions (such as Open, Read, Write, Seek, Tell and Close) to implement a minimalistic yet reliable persistence solution. But that was before I learned that "files are hard" [3]. SQLite with its transactions, BLOB data type and incremental I/O for BLOBs seemed like the right giant to stand on for my new project. Jinbase started small as a key-value store and ended up as a multi-model embedded database that pushes the boundaries of what we usually do with SQLite. The first transition to the second data model (the depot) happened when I realized that the key-value store was not well suited for cases where a unique identifier is supposed to be automatically generated for each new record, saving the user the burden of providing an identifier that could accidentally be subject to a collision and thus overwrite an existing record. After that, I implemented a search capability that accepts UID ranges for the depot store, timespans (records are automatically timestamped) for both the depot and key-value stores and GLOB patterns and number ranges for string and integer keys in the key-value store. The queue and stack data models emerged as solutions for use cases where records must be consumed in a specific order. A typical record would be retrieved and deleted from the database in a single transaction unit. Since SQLite is used as the storage engine, Jinbase supports the relational model de facto. For convenience, all tables related to Jinbase internals are prefixed with "jinbase_", making Jinbase a useful tool for opening legacy SQLite files to add new data models that will safely coexist with the ad hoc relational model. All four main data models (key-value, depot, queue, stack) support Paradict-compatible data types, such as dictionaries, strings, binary data, integers, datetimes, etc. Under the hood, when the user initiates a write operation, Jinbase serializes (except for binary data), chunks, and stores the data iteratively. A record can be accessed not only in bulk, but also with two levels of partial access granularity: the byte-level and the field-level. While SQLite's incremental I/O for BLOBs is designed to target an individual BLOB column in a row, Jinbase extends this so that for each record, incremental reads cover all chunks as if they were a single unified BLOB. For dictionary records only, Jinbase automatically creates and maintains a lightweight index consisting of pointers to root fields, which then allows extracting from an arbitrary record the contents of a field automatically deserialized before being returned. The most obvious use cases for Jinbase are storing user preferences, persisting session data before exit, order-based processing of data streams, exposing data for other processes, upgrading legacy SQLite files with new data models and bespoke data persistence solutions. Jinbase is written in Python, is available on PyPI and you can play with the examples on the README. Let me know what you think about this project. [1] https://ift.tt/HOV8l6o [2] https://ift.tt/Ak274Ry [3] https://ift.tt/wWygnlF https://ift.tt/C7ufK5c November 30, 2024 at 01:55AM

Show HN: wazero compiler ported to 4 new OSes https://ift.tt/FVEnMIJ

Show HN: wazero compiler ported to 4 new OSes Release 1.8.2 of wazero, the zero dependency WebAssembly runtime for Go, brings the amd64 compiler to 4 new OSes: NetBSD, DragonFly BSD, illumos and Solaris. The compiler also supports Linux, FreeBSD, macOS and Windows, on amd64 and arm64. This didn't require any changes to the compiler, just enabling it after setting up tests to validate that it already worked. Now the HN hook: noticeably absent is OpenBSD, which I failed to get working, even after taking W^X into account (we already had that for arm64 on macOS). If you wanna help, please drop us a note! https://ift.tt/WJm54a7 December 1, 2024 at 12:18AM

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

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/dIOQnAk

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/aJND8yd November 30, 2024 at 12:39AM

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

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/QkTnS7J November 29, 2024 at 04:48PM

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

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

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

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/7XnUHiw November 29, 2024 at 04:41AM

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

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/fLxCcPo ) 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/c91elHs ) 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/0E3dokJ ) 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/l6Tzgs3 [1] https://ift.tt/hzNxAOI [2] https://ift.tt/jHAcwIe [3] https://ift.tt/DLmPj9Z https://ift.tt/l6Tzgs3 November 28, 2024 at 08:20PM

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

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: AirPrint Bridge: Enable AirPrint for Non-AirPrint Printers on macOS https://ift.tt/C5qMKSV

Show HN: AirPrint Bridge: Enable AirPrint for Non-AirPrint Printers on macOS Lightweight, open-source, and fully automated, AirPrint Bridge uses macOS's built-in tools to bridge the gap without relying on external software. Perfect for reviving your trusty old printer! https://ift.tt/mDbn6gI November 27, 2024 at 11:41PM

Show HN: Yoyo is a Livewire/Htmx alternative for vanilla php https://ift.tt/9WXhbLQ

Show HN: Yoyo is a Livewire/Htmx alternative for vanilla php https://ift.tt/08i6AJs November 27, 2024 at 08:43AM

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

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

Show HN: I created a lightweight JavaScript library to visualize JSON as a graph https://ift.tt/4NuURab

Show HN: I created a lightweight JavaScript library to visualize JSON as a graph https://ift.tt/4dQqZXS November 27, 2024 at 04:11AM

Show HN: Clean Your Mac with a Script https://ift.tt/SarbI54

Show HN: Clean Your Mac with a Script I wanted to clean old temporary files and caches from my macOS with a script instead of using a shady paid app, so I created a simple script for that. Pull requests are very welcome for other unused files to clean up storage space! https://ift.tt/ynaSpAs November 27, 2024 at 03:19AM

Show HN: Table of Elements – Your strategic advantage in project management https://ift.tt/xg4mZ32

Show HN: Table of Elements – Your strategic advantage in project management https://ift.tt/pm06xTy November 26, 2024 at 08:17AM

Show HN: I made a tool for voice cloning https://ift.tt/hS3eDoO

Show HN: I made a tool for voice cloning https://anyvoice.app November 26, 2024 at 01:30AM

Show HN: WeSQL – An Innovative MySQL That Stores All Data on S3 https://ift.tt/WbjhHIy

Show HN: WeSQL – An Innovative MySQL That Stores All Data on S3 https://ift.tt/OorvAwT November 25, 2024 at 11:39PM

Show HN: QuackHouse, Database in the browser, using WASM and DuckDB https://ift.tt/wC2eitM

Show HN: QuackHouse, Database in the browser, using WASM and DuckDB I'm building a privacy focused analytics tool, using WebAssembly and DuckDB. You can upload your files (CSV, JSON and Parquet), and interact with them as where they a SQL Server. Your data never leaves your computer, however I do track page views and visitors using Plausible. The next steps are to add forecasting and segmentation, as well as some data visualisation capabilities. I would love to hear your opinion. All code for the repo is available here: https://ift.tt/3o70znb https://ift.tt/curMqw9 November 25, 2024 at 02:42AM

Show HN: My weekend project to end Go/TypeScript boilerplate hell https://ift.tt/0oiYq2a

Show HN: My weekend project to end Go/TypeScript boilerplate hell https://ift.tt/6qhyIX3 November 24, 2024 at 03:24PM