TODAYS TECH WORLD

Show HN: Bi-directional sync between Postgres and SQLite 9 by matharmin | 0 comments on Hacker News. Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is designed to be stack-agnostic. If you’d like to see a simple demo, check out the pebbles widget on the landing page here: https://ift.tt/dkC9jZD We wrote about our architecture and design philosophy here: https://ift.tt/vYHFcjd... This covers amongst other things how we designed the system for scal

Show HN: Status on DP – Add Status on Profile Picture Like LinkedIn 3 by bansal10 | 0 comments on Hacker News.

Show HN: Collider – the platform for local LLM debug and inference at warp speed 2 by Ambix | 0 comments on Hacker News. ChatGPT turns one today :) What a day to launch the project I'm tinkering with for more than half a year. Welcome new LLM platform suited both for individual research and scaling AI services in production. GitHub: https://ift.tt/uCIgRah Some superpowers: - Built with performance and scaling in mind thanks Golang and C++ - No more problems with Python dependencies and broken compatibility - Most of modern CPUs are supported: any Intel/AMD x64 platofrms, server and Mac ARM64 - GPUs supported as well: Nvidia CUDA, Apple Metal, OpenCL cards - Split really big models between a number of GPU (warp LLaMA 70B with 2x RTX 3090) - Not bad performance on shy CPU machines, fast as hell inference on monsters with beefy GPUs - Both regular FP16/FP32 models and their quantised versions are supported - 4-bit really rocks! - Popular LLM architectures already there: LLaMA, Star

Show HN: Turn Emoji into Artwork via AI 3 by wonderfuly | 1 comments on Hacker News.

Show HN: I built a fast, accurate translation API for 1/30th the price of Google 5 by nbened | 3 comments on Hacker News. Hey HN, I built an alternative to Google translate that's fast, accurate, and 1/30th the price. 20+ supported languages, not billed until 100k tokens, and already used thousands of times with real language learning users. The landing page has a demo for you to test performance yourself for free with no card required. (Also landing page says 1/13 the price because had to account for all 3 big names, with varying prices each). I built this as a workaround for my language learning startup, and it was perfect at a fraction of the cost. Hopefully it can help other devs in accessibility and language learning apps. Thanks,

Show HN: Dobb·E – towards home robots with an open-source platform 48 by MahiShafiullah | 43 comments on Hacker News. Hi HN! Proud to share our open-source robot platform, Dobb·E, a home robot system that needs just 5 minutes of human teaching to learn new tasks. We've already taken Dobb·E to 10 different homes in New York, taught it 100+ tasks, and we are just getting started! I would love to hear your thoughts about this. Here are some more details, below (or see a Twitter thread with attached media: https://twitter.com/i/status/1729515379892826211 or https://ift.tt/M2EoQhV ): We engineered Dobb·E to maximize efficiency, safety, and user comfort. As a system, it is composed of four parts: a data collection tool, a home dataset, a pretrained vision model, and a policy fine-tuning recipe. We teach our robots with imitation learning, and for data collection, we created the “Stick”, a tool made out of $25 of hardware and an iPhone. Then, using the Stick, we collected a 13 hour dat

Show HN: Instant AI portraits, generate pics of yourself in a few seconds 4 by ftufek | 0 comments on Hacker News.

Show HN: Historical Movie Map 2 by pbring | 0 comments on Hacker News. Hi HN - I love movies, history, and code, so I decided to combine the three together. Enjoy! https://ift.tt/6X4vWiZ

Show HN: Build an open-source computer vision model in seconds using text 4 by nharada | 0 comments on Hacker News. Hello HN! I want to share something me and a few friends have been working on for a while now — Zeroshot, a web tool that builds image classifiers using text-image models and autolabeling. What does this mean in practice? You can put together an image classifier in about 30 seconds that’s faster and more accurate than CLIP, but that you can deploy yourself however you’d like. It’s open source, commercially licensed, and doesn’t require you to pay anyone per API call. Here's a 2 minute video that shows it off: https://www.youtube.com/watch?v=S4R1gtmM-Lo How/why does it work? We believe that with the rise of foundation vision models, computer vision will fundamentally change. These powerful models will let any devs “compile” a model ahead of time with a subset of the foundation model’s characteristics, using only text and a web-tool. The days of teams of MLEs buildin

Show HN: Hacker News Submission Compiler 2 by tanujraghav | 2 comments on Hacker News. Hi! I'm excited to share a website I created that compiles the top 100 submissions on Hacker News on a daily basis. It's simple to use and supports arrow key navigation. Check it out and let me know what you think!

Show HN: Spaceflight News made using Htmx 2 by ngshiheng | 0 comments on Hacker News.

Show HN: Star Time Lapse Videos with a Raspberry Pi Camera and AllSky 4 by johnjones4 | 0 comments on Hacker News.

Show HN: AI Garage Sale – Haggle with AI to buy real products 5 by lanewinfield | 0 comments on Hacker News.

Show HN: I built a domain name marketplace for folks (like me) who hoard domains 7 by thecoppinger | 4 comments on Hacker News. Problem: I (accidentally) hoard domains :') 1. I get excited about a new project 2. I buy a domain 3. I get busy, and the domain collects a thick layer of dust I know I'm not alone in this, either So, I had the idea of creating a simple and casual marketplace for folks like me to list their domains at a fair price with a nice community feel to free up these caged domains It felt like a great project for me to pick up some new skills, so I got to it All up, it took me about a month, and I built the whole thing live on Twitch I've always sat on the design, marketing and front-end side of the fence, so this was my first attempt at making a 'full' web app Here's the stack I used: - SvelteKit ( https://kit.svelte.dev/ ) - Supabase ( https://supabase.com/ ) - Resend ( https://resend.com/ ) - ShadCN Svelte ( https://ift.tt/nVuyG4e ) It was

Show HN: I built a guided Build your own DNS Server challenge 4 by nixylemonbatman | 0 comments on Hacker News. Hey everyone. It's Sherub here, author of the Build your own DNS Server challenge on CodeCrafters. Currently it’s available in Rust, Go, and Python and is free while in beta. https://ift.tt/XNaeKg9 I've kept the challenge accessible but still challenging for an intermediate developer. This challenge, like others from CodeCrafters, is self-paced. You can use any tools you prefer (terminal, editor, etc.) to build the project. At the end of the challenge, you will have created a DNS forwarding server. The server can create and read DNS packets and respond to DNS queries. As you go, you'll learn about the DNS protocol, its format, servers, and A records. All while getting to hone your language skills. Some of the challenges and choices I had to make: * To make the stages easier, I had to break them up, such that each step builds on the previous one. This was especi

Show HN: Upcoming – Explore what's coming next 2 by Aaron_WebL | 0 comments on Hacker News. Get a weekly preview of upcoming movies, TV shows, books, music, games, and events. Add them to your calendar and don't miss out on what's coming this week!

Show HN: Dreamachines.ai 3 by amegahed | 0 comments on Hacker News. AI image generation, management, and sharing platform. Built on top of a cloud OS. Provides a range of mechanisms for sharing. Free, no commercial tier.

Show HN: LockDB now natively supports acting on multiple locks 3 by BrunoBernardino | 0 comments on Hacker News. LockDB is a cross-platform tool you can use to handle process/event locking and avoid race conditions. It is sometimes also known as a semaphore. There are packages for Node.js / Browser / Bun / NPM, Deno, and you can also use it as a CLI. The new LockDB release supports a feature request common for complex locking necessities: The ability to lock, unlock, and check multiple locks. I understand new features aren't _generally_ accepted [1] here, but this one seemed "juicy" enough for it. Feel free to remove the post if I'm wrong, and I apologize in that case! [1]: https://ift.tt/98vUZ2H

Show HN: An open-source notification infrastructure 2 by opensh | 0 comments on Hacker News.

Show HN: pytunes – Free and open-source music streaming service 2 by bernhardfritz92 | 1 comments on Hacker News.

Show HN: git-genie: pre-commit hook that writes commit messages for you 2 by danthelion | 1 comments on Hacker News.

Show HN: I'm selling the ideal AI WebApp boilerplate, which doesn't exist 2 by MaxBalaban | 0 comments on Hacker News.

Show HN: A game to memorize scale degrees on the guitar fretboard 4 by udit99 | 2 comments on Hacker News.

Show HN: I Wrote a Book on PostgreSQL for Rails 9 by andatki | 0 comments on Hacker News. Hi HN. As a backend developer using PostgreSQL and Ruby on Rails for more than 10 years, around 3 years ago, I caught a spark to learn as much as I could about how to operate high performance, scalable, and reliable PostgreSQL databases. As I reflected on my own career path, I realized there are other developers that may want to learn more about this. I saw an opportunity to help show backend developers how they could put advanced, powerful, PostgreSQL features to use, to help build and scale their Rails apps. I've been fortunate to give presentations in both the PostgreSQL and Rails communities over the last couple of years. In that time I've continued to work with these technologies every day. With that said, I'd love for you to check out my new book: "High Performance PostgreSQL for Rails". Currently in ebook/PDF Beta form. While it's only an ebook for now, there

Show HN: Go bindings to SQLite using wazero 2 by ncruces | 0 comments on Hacker News.

Show HN: Play Vectoroids in the browser – a clone of the classic game Asteroids 2 by midzer | 0 comments on Hacker News. src: https://ift.tt/fS3ovIz

Show HN: InsiderXTrade – Yahoo Finance-Influenced Site for SEC Insider Tradings 5 by ddurru | 0 comments on Hacker News.

Show HN: UI Library Creator 4 by kemyd | 0 comments on Hacker News. Hey HN! The "Generative" trend is booming, and UI Library Creator is our original approach to it. In the last three years, we have added 60+ professional UI libraries to Shuffle's catalog (Shuffle = visual editor for web developers). Still, we know we need more than this to satisfy our growing user base! That's why we created the UI Library Creator. In this tool, you can combine elements and styles to create unique UI libraries that work seamlessly with the Shuffle Editor and all its capabilities (drag-and-drop, customizations, live preview, and more). We provide you with UX solutions (components) written in Tailwind CSS and presets so you can quickly combine them to create what you need. You don't need to talk to a "black box" AI with a chat interface. Possible combinations are in gazillions. We aim for original creations, but you have complete control over the final effect. How to u

Show HN: Cyberkitty – an experimental hybrid-GPT+Human long-form fiction editor 2 by jmerz | 0 comments on Hacker News. NOTE: If you're one of the first people to see this, you can also access a running installation at https://cyberkitty.ai It'll run until I hit my GPT-4 budget limit, then stop working. Be warned that it's in single user, so nothing is private! ---- Last week I came down with a fever and decided to run some experiments on whether the new GPT could generate long-form fiction. Around the same time, I saw a HN comment about how technology gains have lead SWEs to work at higher levels of abstraction—and I thought “huh, why not writers?” Anyway so I was locked indoors for a week and a half and I spent it coding an answer that question. Most of the magic sauce here is just in making it feel really snappy and good to edit—making it easy for the human to collaborate with the objectively faster LLM. The underlying prompt engineering is cool, but it’s the feeling

Show HN: Starter kit for hosting static websites on AWS in one click 2 by ipselon | 0 comments on Hacker News. This starter kit offers an optimal solution for hosting static websites on Amazon Web Services (AWS). To deploy your website, simply transfer your website files to the /platform/web-app directory. Following this, execute the command pnpm deploy-platform to initiate the deployment process.

Show HN: GJP-4-GPT, a Gradual JSON Parser for GPT's 2 by explaininjs | 0 comments on Hacker News. Often it's easiest to have an LLM output the results you need in JSON form, but streaming those outputs into an actual viewport is nontrivial. Thus I made this package, a streaming JSON parser that handles all the work of decoding your JSON so you can focus on displaying your UIs.

Show HN: Plantarium – Create 3D Plant Models with Blender-Style Nodes 2 by jimfx | 1 comments on Hacker News. Plantarium is my open source side project that allows you to created procedural 3D plants in your browser using blender style nodes. Recently I added a public gallery so you can share your plant designs and download others. https://ift.tt/ynf2jEL

Show HN: I made a catalog of useful GPTs 2 by dvolkhonskiy | 1 comments on Hacker News.

Show HN: Neum AI – Open-source large-scale RAG framework 5 by picohen | 0 comments on Hacker News. Over the last couple months we have been supporting developers in building large-scale RAG pipelines to process millions of pieces of data. We documented our approach in an HN post ( https://ift.tt/PmqNBga ) a couple weeks ago. Today, we are open sourcing the framework we have developed. The framework focuses on RAG data pipelines and provides scale, reliability, and data synchronization capabilities out of the box. For those newer to RAG, it is a technique to provide context to Large Language Models. It consists of grabbing pieces of information (i.e. pieces of news articles, papers, descriptions, etc.) and incorporating them into prompts to help contextualize the responses. The technique goes one level deeper in finding the right pieces of information to incorporate. The search for relevant information is done through the use of vector embeddings and vector databases. Those pieces of

Show HN: I made a conversational language learning chat UI with gpt4-1106 2 by kylel95 | 0 comments on Hacker News. Hi, I built JoJo, a personal conversational language learning chat interface. video demo here: https://ift.tt/7b4v2NE You can chat casually in both your native and foreign language, translate from your native to foreign language, and get grammar explanations. There is explanation mode when having a conversation which corrects and explains what you type. This can be turned off so you can just chat back and forth in your foreign language. I have a 1395 day streak with duolingo Italian so I wanted to build something to help with conversational practice. There are 15 languages supported to choose from. Any feedback or suggestions is greatly appreciated. Thank you - Kyle

Show HN: Unconventional C library and web app server 2 by jasongilbo | 0 comments on Hacker News. If you want to write web apps in C with mainly server side html, this might be the project for you! I've been using/developing it for a project to sell photos/videos at surf camps. test site: https://ift.tt/ENp9iKy Highlights: * builds to a single AppImage for deployment * all code included that's not a standard linux library * mostly don't have to write html, generated with code There are many things in the currently private project that aren't yet moved to fu due to time.

Show HN: Hotlist, a Tauri powered daily todo list for your Mac menu bar 4 by rikschennink | 1 comments on Hacker News.

Show HN: Signed URLs Gateway – The Missing Infra Piece for Building Modern Apps 4 by GabrielMusat | 1 comments on Hacker News.

Show HN: Serverless VPN App for Android. Unlimited Devices. Unlimited Data 2 by gigapotential | 3 comments on Hacker News. Hello HN, Serverless VPN app for Android is fully open source including desktop apps: https://ift.tt/kcbvrRS Get it on Play Store: https://ift.tt/Rgb1MFj... Feedback about product, pricing, website is most welcome! Thank you, Himanshu

Show HN: cmaps.io – Transform Thoughts into Visual Masterpieces 2 by gxara | 0 comments on Hacker News. Hey! Just launched my new project! It's a tool to rethink the way we study and take notes. Human thinking is inherently associative, not linear. Check it out at https://cmaps.io I would love to get some feedback! Thanks!

Show HN: torbb – Now with Tor, run BrowserBox as a hidden service instantly 2 by keepamovin | 1 comments on Hacker News.

Show HN: "Awesome" Engineering Games (List) 2 by solardev | 0 comments on Hacker News. I've spent way too much time both playing and finding engineering-focused games, and haven't been able to find very detailed or comprehensive lists online. So I made one :) These games are both fun and often quite educational, presenting gamified versions of real-world challenges and professions. There's a lot of different sub-genres of "engineering game", such as: * Factory automation (Factorio, Dyson Sphere Program) * City builders (Cities: Skylines, Anno series) * Route-builders (Mini Motorways, Railway Empire) * Comp sci (TIS-100, Bitburner) All games on the list are very highly reviewed. I've played most (but not all) of them, and provided personal recommendations alongside the reviews. Many of them are also playable on GeForce Now (if you don't have a gaming PC). Please contribute if you know of more, or have any comments/suggestions!

Show HN: YouTube banned adblockers so I built an extension to skip their ads 63 by rKarpinski | 25 comments on Hacker News. Hi HN! Since Youtube no longer allows AdBlockers, I built my own extension to get around their video ads. If there is an ad it temporarily manipulates the video; Mutes the volume, sets speed to 10x, and skips it if there is a button. Chrome Webstore link: https://ift.tt/rAZ4UQI Code: https://ift.tt/AnKr9wh

Show HN: Bemi – data versioning and time travel for PostgreSQL 3 by exAspArk | 1 comments on Hacker News. Hi HN, we’re Evgeny, Arjun, and Donna - the builders of Bemi ( https://bemi.io ). Bemi is an enhancement of your existing transactional database to unlock time travel querying. We enable engineers to track all PostgreSQL state changes. We used to all work together at a startup five years ago, and now have got the gang back together to work on Bemi! Many open-source libraries already track data changes, but they’re not reliable since they don’t track changes made outside ORMs with direct SQL queries. Additionally, they come with runtime performance overhead since they’re making database inserts in callbacks. We’ve also consistently seen hacks that engineers write on top of the libraries to store additional context or make it easier for them to query. There are databases already available for event sourcing, but we take a fundamentally different approach. We don’t want engineers t

Show HN: nbi.ai – Generative Business Intelligence 7 by fromthegut | 1 comments on Hacker News.

Show HN: Turn your kid's drawing into a hardcover storybook (using GPT vision) 2 by abhip | 0 comments on Hacker News. Here's a video demo if you're just curious to see it in action: https://ift.tt/KLXFvoD Feedback welcome.

Show HN: Challenge Your AI Agents/custom GPTs – Can They Survive My Tester? 2 by artas728 | 0 comments on Hacker News. I've pivoted to create AI Agent Tester, a SaaS platform dedicated to testing and validating AI agents from OpenAI, Character.ai, and FlowGPT.com. The platform offers: - Hassle-Free Setup: Get your first simulation up and running in just 5 minutes. - Realistic Simulations: Rigorous user interaction tests to prep your AI agent for real-world scenarios. - Intelligent Scoring: Each response is meticulously evaluated, scoring from 0 to 100(GPT-4 smart enough to evaluate it for you). - Broad Platform Support: Initially rolling out with OpenAI, Character.ai, and FlowGPT.com compatibility. The link: https://ift.tt/8WBbvQj Eager to hear your thoughts and discuss improvements!

Show HN: Beta test Execute Program's interactive "Python for Programmers" course 4 by gary_bernhardt | 0 comments on Hacker News. I'm Gary Bernhardt, founder of Execute Program. Our "Python for Programmers" course is in a free open beta for the next week or so. We don't normally do open betas, but the infrastructure behind this course is new and very complex, so we want to stress test it. https://ift.tt/Lc9vbU7... Today, "Python for Programmers" contains 581 interactive code examples covering the core language. It's aimed at established programmers, not beginners. We don't explain basic language features like `while`, but we do show them briefly and note anything special about how they work in Python. We pay special attention to foot guns. For example, we have an entire lesson about Python's mutable default argument foot gun. This is the first of two courses, with the second coming in 2024. For this course, we drew the line at __

Show HN: I made a really silly personal landing page 2 by mfbx9da4 | 0 comments on Hacker News. Also, yes I am looking for a new role

Show HN: Tiny LLMs – Browser-based private AI models for a wide array of tasks 2 by bilater | 0 comments on Hacker News.

Show HN: Version code, models, & datasets together in GitHub 15 by skadamat | 5 comments on Hacker News. Hi HN! We just launched a GitHub integration that scales your Git repos to handle 100 terabytes of files in a single repo. XetData enables data scientists and machine learning engineers to version code, models, and datasets together. Most teams have glued together clunky workflows using S3, DVC, Git, Git LFS, and other tools and make true reproducibility difficult: https://ift.tt/n4oqxgX We instead embrace and extend Git so end-users don’t need to learn a new tool and a new set of commands. Our implementation is similar to Git LFS, where we take over the .gitattributes file, push pointers to large files in GitHub, and push the raw, large files to us. We have a few distinct features that we’re proud of that improve the user experience: - Our XetData bot comments on your pull requests to provide links to useful dataset views and model diffs. We’re working on rendering these ins

Show HN: AI Receptionist, Speaks 64 Languages 2 by huiwanglomni | 0 comments on Hacker News. If you are looking for a receptionist for your startup, consider using Lomni. Lomni is an AI receptionist that can: * Read your website to answer questions * Upsell your product or service according to your instructions * Send texts and emails to you or the caller, for example: * Send links and confirmation texts to callers * Forward customer feedback to support@startup.com * Connect to any API or webhook, in order to: * Generate leads * Book appointments * Process payments * Integrate with any application * Read from and write to your database * Do all of the above in any language, all day, everyday. * Do all of the above over SMS messaging or a chatbot that you could embed into your website. * Coming very soon: Do all of the above over WhatsApp, Facebook Messenger, and Google’s Business Messages. * Coming very soon: generate actionable insights from conversational data using state-of-the-a

Show HN: Multi-Object Tracking in Python 22 by neer201 | 0 comments on Hacker News. Hello! I've created a small library for tracking, along with a tutorial. I plan to continue developing it. Tracking is an important topic, closely related to object detection. However, I've noticed that it doesn't receive as much attention compared to machine learning approaches. Or, the focus is on filters like the Kalman filter. This tutorial begins with single object tracking and progressively complicates the tasks, introducing various models and a hypothesis tree to solve them.

Show HN: Movis – A Video Editing Library in Python 2 by rezoolab | 0 comments on Hacker News. Originally, this library was created due to my motivation to make videos in Python. Of course, I considered other Python libraries, but I decided to create a new library for video editing because I needed the following features and also for study purposes: - The existence of composition. Especially, the ability to perform advanced video editing by inserting compositions within compositions. - The ability to add animations based on keyframes. - Effects like chroma key and drop shadow. - A caching mechanism to render the same frame quickly. - Various blending modes. These features, despite being standard in proprietary video editing software, were not present in previous Python libraries. Currently, I am using this library to automatically generate videos from raw materials. I would be grateful for any comments, thoughts, or requests.

Show HN: Add auth to Next.js and deploy in 60 seconds – no manual config 9 by dickhardt | 2 comments on Hacker News.

Show HN: Soccer video analysis from your match videos 14 by jfhb-04 | 10 comments on Hacker News. I created a tool to generate awesome soccer video analysis from match videos. I'm no pro player, just play with my friends weekly, record our matches, and use this tool to check out our performance. My friends really enjoy it and have suggested adding features like measuring player speed, tracking players positions, and more.

Show HN: Interactive Demo of a Tag-Based Bookmark Manager 3 by kevinsschmidt | 0 comments on Hacker News.

Show HN: GPT-4-Vision UX audit for your landing page (relaunch) 2 by liorgrossman | 0 comments on Hacker News. Last week, I got seriously fascinated by the new GPT-4 Vision API introduced on OpenAI DevDay, so I decided to build a UX Audit tool with this API. It's pretty simple to use - just go to https://flawless.is and enter your homepage or landing page URL. I'm using the urlbox API to get a screenshot of your page, then I utilize GPT-4V to analyze the screenshot, find potential usability and conversion issues, suggest fixes, and highlight the relevant areas in the screenshot (although the position is sometimes inaccurate). Last week, I launched it on Hacker News ( https://ift.tt/YqQVnsR ), but I wasn't ready for the 20,000 visitors that came next... Unfortunately, GPT-4V has a rate limit of 100 events daily, so almost no one could use the service - EPIC FAIL. To manage demand, I now priced the service at $1.99 (still less than a cup of coffee), which should keep the d

Show HN: Llm.f90 fast, hackable transformer implementation in Fortran 3 by andy99 | 0 comments on Hacker News. I submitted an earlier version of this a few months ago (as llama2.f90). At that time it had a lot of steps to run and was just a toy, now it's easy to run and is a competitive option for llm inference. See the motivation section for discussion and the `Performance` issue for an ongoing discussion about performance.

Show HN: Twogether AI – Multi-Person Photo Generation API 9 by yardenst | 5 comments on Hacker News. Hey everyone, at Magicflow (YC W23) we're helping our customers run AI image generation in production, enabling them to produce high-quality photos at scale. We are launching a scalable API today that makes it possible to create multi-person portrait photos: which means the ability to create real-looking photos of any two persons interacting with each other in some way only by providing a prompt and the person's pose. Generating this kind of photo requires a deep understanding of the AI ecosystem, a knowledge gap many companies face. In order to make the photos look real with high consistency and for a low cost, chaining of many models is required, and an excellent understanding of how to tweak with the various params of each one. We also handle the infrastructure required to generate the photos, which can be a challenge when dealt with alone, especially for companies with a

Show HN: Bitemporal, Binary JSON Database System and Event Store 4 by lichtenberger | 0 comments on Hacker News. I had already posted the project a couple of years ago, and it gained some interest, but a lot of stuff has been done since then, especially regarding performance, a completely new JSON store, a REST API, various internals refactored, an improved JSONiq based query engine allowing updates, implementing set-oriented join optimizations, a now already dated web UI, a new Kotlin based CLI, a Python and TypeScript client to ease the use of Sirix... First prototypes from a precursor stem already from 2005. So, what is it all about? The system uses ideas from ZFS (a keyed index trie, storing checksums in parent pages...) and Git (a persistent index structure that shares unchanged pages between revisions) but appends new tree roots on each commit [1][2]. It is a JSON DBS. The system stores fine granular JSON nodes. Thus, there's almost no limit to the structure and size of an