Show HN: GizmoSQL – Run DuckDB as a Server with Arrow Flight SQL https://ift.tt/Yrm2jvZ

Show HN: GizmoSQL – Run DuckDB as a Server with Arrow Flight SQL Hi, I'm Philip Moore - the founder of GizmoData, and creator of GizmoSQL - an Apache Arrow Flight SQL Server - with DuckDB (or SQLite) back-end execution engines. GizmoSQL is a composable SQL server with Arrow Flight SQL, DuckDB, and SQLite - with the intention of making it easy to run DuckDB (or SQLite) as a server - usable by multiple people from a client (remote) computer. It also adds security (authentication) and encryption of traffic with TLS. To run GizmoSQL - see the steps in the README.md - where you can see how easy it is to run the server as well as how to connect via ADBC and JDBC from a remote client - such as DBeaver, Python, etc. The easiest way to run GizmoSQL is via Docker - but there are downloads for Linux and macOS for both x86-64 and arm64 platforms (download links in the README). Why?: As you may know, DuckDB and SQLite are embedded systems - they don't enable client connectivity, and they aren't really designed for concurrency. I've built GizmoSQL to work around that - because I believe the DuckDB engine is very powerful, and I feel like a lot of customers overpay and run distributed compute (i.e. Spark) when they don't really need to. Making it easy to have remote connectivity to DuckDB can make it easier to migrate SQL workloads from Spark or other expensive commercial platforms to this engine - with a much simpler architecture/infrastructure. It is my intention to make GizmoSQL a commercial product - licensed for production use by organizations, but free for developers to code with - evaluate, and test. A little bit of backstory: * I built the initial version of this while working for a former employer - it wasn't their core focus, so they open-sourced that early version. After I left there, I forked the product and have improved it substantially - to support concurrency of both reads and writes, improving security, as well as keeping it up to date with the latest versions of Apache Arrow and DuckDB. * This project evolved from a prototype created by the brilliant Tom Drabas. * It feels a little weird trying to make a commercial product based upon DuckDB, but MotherDuck started it :P - and I've contributed (albeit very little) to the DuckDB and Apache Arrow projects in the form of a couple of PRs. I'm really excited about this project - I have run benchmarks of this product against commercial platforms such as Snowflake and Databricks SQL - and it holds its own running the 22-query TPC-H SF1TB benchmark, especially on cost. See the graph at: https://ift.tt/hrPHvEy Getting started: Github README: https://ift.tt/YO5K2RM... DockerHub: https://ift.tt/C4O9FVg GizmoSQL homepage: https://ift.tt/hrPHvEy Phil's Github profile: https://ift.tt/UXayEcJ Thanks for your time and feedback in advance. https://ift.tt/iWcera5 March 21, 2025 at 12:45AM

Show HN: SpongeCake – open-source SDK for OpenAI computer use agents https://ift.tt/v1n2JE5

Show HN: SpongeCake – open-source SDK for OpenAI computer use agents Hey HN! Wanted to quickly put this together after seeing OpenAI launched their new computer use agent We were excited to get our hands on it, but quickly realized there was still quite a bit of set-up required to actually spin up a VM and have the model do things. So we wanted to put together an easy way to deploy these OpenAI computer use VMs in an SDK format and open source it Hopefully this tooling is helpful to other folks building AI agents! Here’s a link to the repo ( https://ift.tt/I3eZGOK ) - please try it out and give us a star. If you have any feedback, add it as a comment to this post! Or if you simply just love spongecake, show support for the delicious treat https://ift.tt/I3eZGOK March 20, 2025 at 10:16PM

Show HN: I made an interactive LLM Tools guide https://ift.tt/NJs43xZ

Show HN: I made an interactive LLM Tools guide So hard to keep up with tooling and MLOps - I put it all in one place and got some tips from an experienced friend on what to use. https://ift.tt/3VCcizg March 20, 2025 at 01:30AM

Show HN: Codemcp – Claude Code for Claude Pro subscribers – ditch API bills https://ift.tt/2LlIKjh

Show HN: Codemcp – Claude Code for Claude Pro subscribers – ditch API bills Hi all! I normally work on the PyTorch project but I've been on baby leave for the past month, so I've been playing around with AI as a user rather than a framework implementor. I really liked the agent experience with Claude Code, but I couldn't really justify spending so many dollars on API costs for random side projects. I already pay for a Claude Pro subscription though, and it turns out you can simulate many of Claude Code's features with an MCP. If you have a Pro subscription, check this out! I think it really captures the Claude Code experience quite well, without forcing you to pay for API tokens. https://ift.tt/S5rjDI6 March 13, 2025 at 11:59PM

Show HN: We built an agentic image editor that preserves the original structure https://ift.tt/FxRYDz4

Show HN: We built an agentic image editor that preserves the original structure Hi everyone, I’ve been experimenting with app where you can edit images in your camera roll simply by tweaking your photo’s metadata (changing location/time) and our agent will contextually regenerate the photo in that place & time in one shot. There's no prompting involved. One of the hardest problems we’ve seen with these ai image editing/creation tools is that they struggle with preserving the subjects of the original image (faces, genders, number of people, bodies, animals, etc), and I think we’ve gotten a step closer to making it feel more realistic. The gallery has some examples that people have been regenerating. https://ift.tt/9JAnIvz Here’s a demo: https://ift.tt/R5M7ldo Feel free to dm me on Twitter: https://twitter.com/sakofchit if you’d like to try out the TestFlight in the meantime Would love to know what y'all think! https://ift.tt/9JAnIvz March 19, 2025 at 11:14PM

Show HN: "Git who" – A new CLI tool for industrial-scale Git blaming https://ift.tt/3A7SIEX

Show HN: "Git who" – A new CLI tool for industrial-scale Git blaming I've always wanted a better way to explore the authorship data embedded in a Git commit log. I'm having fun building a CLI tool to do this. It's a bit like the "Contributors" tab on Github that shows you how many commits each contributor has made but much faster and with many more options. If you get a chance to try it out, please let me know. I'd love to hear feedback and suggestions. Thank you! https://ift.tt/ZWobAKT March 19, 2025 at 01:50AM

Show HN: I Made an Escape Room Themed Prompt Injection Challenge https://ift.tt/CUIJv5l

Show HN: I Made an Escape Room Themed Prompt Injection Challenge We launched an escape room-themed AI Escape Room challenge with prizes of up to $10,000 where you need to convince the escape room supervisor LLM chatbot to give you the key using prompt injection techniques. Hope you like it :) https://ift.tt/oYC5mrL March 19, 2025 at 01:12AM

Show HN: I Created a Fork of Ghost CMS with an AI Editor and Native ECommerce https://ift.tt/7fsi0h6

Show HN: I Created a Fork of Ghost CMS with an AI Editor and Native ECommerce After many months of hard work and innovation, we've built a platform that takes Ghost CMS to the next level. Cartanza integrates native AI-powered content and image creation and native eCommerce functionality directly into the blogging experience. This means you can now: - Generate high-quality blog content and images with AI—no more copy-pasting between tools. - Seamlessly embed eCommerce capabilities, linking products and collections directly into your blog posts. - Manage subscriptions, merchandise, and content marketing all in one place. To see Cartanza in action, check out our demo video on YouTube ( https://youtu.be/CQQDqKjOM-Y ). In the video, I walk you through our platform's key features and show how easy it is to get started with our innovative solution. We're excited to invite bloggers, content creators, and eCommerce enthusiasts to explore Cartanza. Join us as we redefine the blogging experience—where creativity meets commerce, powered by cutting-edge AI. https://cartanza.com/ March 19, 2025 at 12:27AM

Show HN: I made an AI Tutor that teaches through conversation https://ift.tt/3kvM7I5

Show HN: I made an AI Tutor that teaches through conversation https://sproutful.ai/ March 19, 2025 at 12:43AM

Show HN: I Built an iOS app to locate stray animals https://ift.tt/plMvqGB

Show HN: I Built an iOS app to locate stray animals https://ift.tt/Uy83TnR https://ift.tt/UfXJwhm March 18, 2025 at 03:35AM

Show HN: Cascii – A portable ASCII diagram builder written in vanilla JavaScript https://ift.tt/SIt593i

Show HN: Cascii – A portable ASCII diagram builder written in vanilla JavaScript 3 months ago I wanted to draw an ASCII diagram to include in some documentation at work. I found the few tools online to be insufficient, and was suprised there wasn't a more complete tool to get the job done. Since, I've built Cascii from scratch in vanilla Javascript (I'm not an FE dev, it might be obvious...). I hope it works alright. Please check out the live version at https://cascii.app , report problems, make diagrams to improve your code's documentation. Hope you enjoy using it. https://ift.tt/a8ER3uZ March 16, 2025 at 03:32PM

Show HN: OpenTimes – Free travel times between U.S. Census geographies https://ift.tt/XCg7PFS

Show HN: OpenTimes – Free travel times between U.S. Census geographies Hi HN! Today I'm launching OpenTimes, a free database of roughly 150 billion pre-computed, point-to-point travel times between United States Census geographies. In addition to letting you visualize travel isochrones on the homepage, OpenTimes also lets you download massive amounts of travel time data for free and with no limits. The primary goal here is to enable research and fill a gap I noticed in the open-source spatial ecosystem. Researchers (social scientists, economists, etc.) use large travel time matrices to quantify things like access to healthcare, but they often end up paying Google or Esri for the necessary data. By pre-calculating times between commonly-used research geographies (i.e. Census) and then making those times easily accessible via SQL, I hope to make large-scale accessibility research cheaper and simpler. Some technical bits that may be of interest to HN folks: - The entire OpenTimes backend is just static Parquet files on R2. There's no RDBMS or running service. The whole thing costs about $10/month to host and is free to serve. - All travel times were calculated by pre-building the inputs (OSM, OSRM networks) and then distributing the compute over hundreds of GitHub Actions jobs. - The query/SQL layer uses a setup I haven't seen before: a single DuckDB database file with views that point to static Parquet files via HTTP. Finally, the driving times are optimistic since they don't (yet) account for traffic. This is something I hope to work on in the near future. Enjoy! https://opentimes.org March 18, 2025 at 02:10AM

Show HN: A nice website Visual Theme Editor for tailwind/shadcn https://ift.tt/wo3cxYU

Show HN: A nice website Visual Theme Editor for tailwind/shadcn https://tweakcn.com March 17, 2025 at 11:41PM

Show HN: 10 teams are racing to build a pivotal tracker replacement https://ift.tt/srBemOG

Show HN: 10 teams are racing to build a pivotal tracker replacement A lot has changed since the shutdown of pivotal tracker was discussed here. As there were no viable alternatives it seems every month there was a new project popping up. With the last month before the sunsetting approaching, it starts to get exciting who will make it in time, who stays in the race and what the differentiating features of the projects will be. https://bye-tracker.net March 16, 2025 at 07:00PM

Show HN: Nash, I made a standalone note with single HTML file https://ift.tt/VuIAPrC

Show HN: Nash, I made a standalone note with single HTML file Hello HN, I hope it will posted as well. I made a note in single html file. This does not require a separate membership or installation of the software, and if you download and modify an empty file, you can modify and read it at any time, regardless of online or offline. It can be shared through messengers such as Telegram, so it is also suitable to share contents with long articles and images. It is also possible to host and blog because it is static html file content. https://ift.tt/uLDGbYp March 14, 2025 at 07:21AM

Show HN: Kill SaaS with Open Source https://ift.tt/arBPtuY

Show HN: Kill SaaS with Open Source KillSaaS is my answer to subscription software in the AI era. I'm building this because I believe small teams can use modern AI tools to create free alternatives to giants like Figma and DocuSign in weeks, not years. We're creating a platform where developers vote on which SaaS to replace, then build it together as open source. wdyt? https://ift.tt/SFv1kD2 March 16, 2025 at 02:50AM

Show HN: Basic Memory – Build a knowledge graph from Claude conversations https://ift.tt/Zk4T6hI

Show HN: Basic Memory – Build a knowledge graph from Claude conversations Basic Memory is an open-source tool that enables Claude to build and navigate a persistent knowledge graph based on your conversations. It solves the problem of lost context in AI interactions by storing knowledge in standard Markdown files on your computer. I built this because I found myself constantly repeating information to LLMs and wanted a system where my knowledge grew naturally through conversations while maintaining complete control over my data. Demo video: https://ift.tt/Wro260L Key features: - Continue conversations exactly where you left off without repetition - All knowledge stays in local Markdown files you can edit anytime - Works with Claude Desktop via the Model Context Protocol - Seamless integration with Obsidian for visualization and editing - Fully open source (AGPL) The system works by creating structure from simple markdown patterns: - Observations with categories: `- [category] fact #tag` - Relations between documents: `- relation_type [[WikiLink]]` or plain `[[Wikilinks]]` - These patterns emerge naturally during conversations When you chat with Claude, you can simply say "Let's continue our conversation about X" and it will build context from your knowledge base, without needing to upload files every time. GitHub: https://ift.tt/zl2Jh7p Docs: https://ift.tt/ZilP43J Website: https://ift.tt/ivmG9A3 Requires Claude Desktop or other MCP host and Python 3.12+ I'd love feedback from the HN community, particularly from those interested in knowledge management or AI applications. https://ift.tt/zl2Jh7p March 15, 2025 at 11:49PM

Show HN: Web Audio Spring-Mass Synthesis https://ift.tt/0UlPEAy

Show HN: Web Audio Spring-Mass Synthesis Hi, I'm the author of this little Web Audio toy which does physical modeling synthesis using a simple spring-mass system. My current area of research is in sparse, event-based encodings of musical audio ( https://blog.cochlea.xyz/sparse-interpretable-audio-codec-pa... ). I'm very interested in decomposing audio signals into a description of the "system" (e.g., room, instrument, vocal tract, etc.) and a sparse "control signal" which describes how and when energy is injected into that system. This toy was a great way to start learning about physical modeling synthesis, which seems to be the next stop in my research journey. I was also pleasantly surprised at what's possible these days writing custom Audio Worklets! https://blog.cochlea.xyz/string.html March 15, 2025 at 02:57AM

Show HN: Psyllium, a Ruby Gem to make Fibers behave more like Threads https://ift.tt/kZtDHCf

Show HN: Psyllium, a Ruby Gem to make Fibers behave more like Threads Hi everyone! I created this small Ruby Gem to add some convenient methods to the Fiber class to make it easier to use in the same way a Thread object can be used. This was born out of my frustration that the current implementation of the Fiber class makes it difficult to retrieve the final value of a block passed to a Fiber, especially when creating a fiber via the `schedule` class method. I appreciate any feedback anyone has. https://ift.tt/djWysTY March 15, 2025 at 12:09AM

Show HN: OCR Benchmark Focusing on Automation https://ift.tt/UVXqyzC

Show HN: OCR Benchmark Focusing on Automation OCR/Document extraction field has seen lot of action recently with releases like Mixtral OCR, Andrew Ng's agentic document processing etc. Also there are several benchmarks for OCR, however all testing for something slightly different which make good comparison of models very hard. To give an example, some models like mixtral-ocr only try to convert a document to markdown format. You have to use another LLM on top of it to get the final result. Some VLM’s directly give structured information like key fields from documents like invoices, but you have to either add business rules on top of it or use some LLM as a judge kind of system to get sense of which output needs to be manually reviewed or can be taken as correct output. No benchmark attempts to measure the actual rate of automation you can achieve. We have tried to solve this problem with a benchmark that is only applicable for documents/usecases where you are looking for automation and its trying to measure that end to end automation level of different models or systems. We have collected a dataset that represents documents like invoices etc which are applicable in processes where automation is needed vs are more copilot in nature where you would need to chat with document. Also have annotated these documents and published the dataset and repo so it can be extended. Here is writeup: https://ift.tt/HYWFhLM Dataset: https://ift.tt/maULqoy Github: https://ift.tt/UsBieTE Looking for suggestions on how this benchmark can be improved further. https://ift.tt/HYWFhLM March 13, 2025 at 02:19AM