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

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/7Yb1Tyx Getting started: Github README: https://ift.tt/RJLBZ3E... DockerHub: https://ift.tt/ygeYBPs GizmoSQL homepage: https://ift.tt/7Yb1Tyx Phil's Github profile: https://ift.tt/b1rAzoD Thanks for your time and feedback in advance. https://ift.tt/vbU1exo March 21, 2025 at 12:45AM

Show HN: Nicely designed editor for mockups and screenshots https://ift.tt/1uj75Pq

Show HN: Nicely designed editor for mockups and screenshots https://postspark.app March 21, 2025 at 12:14AM

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

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/pXdc59F ) - 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/pXdc59F March 20, 2025 at 10:16PM

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

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/pRfhSMl March 13, 2025 at 11:59PM

Show HN: I built an extension to book Airbnbs directly https://ift.tt/rkvwedz

Show HN: I built an extension to book Airbnbs directly Hi Hackers, My wife and I have been slow traveling around the world for last 3 years, and our top travel hack that has saved us most amount of money is to book directly with Airbnb host. We usually rent for a month so savings in fees are easily ~$300 - $500 on each stay, i.e. about 15-20%. Not every host offers it we respect that, but there are so many hosts out there that would rather have you book directly via their website and we as guests want the same. The problem is these hosts can’t promote or say that on Airbnb. This inspired me to build OpenBnB.org, where I’ve started collecting direct booking websites of hosts. So far, I have around 1,500 hosts representing 150,000 listings – most of them in USA. The idea is to give guests more options to book, and hosts another channel to distribute their listings. The first solution is a browser extension that makes it really easy to find the direct booking website of hosts when you’re browsing Airbnb. It just a one-time easy install with no sign ups. It: 1) highlights all the directly-bookable listings on the search page, 2) lets you search listings only from hosts with direct booking option and then of course 3) gives you the direct booking link on the listing page. What I like about this solution is it doesn’t require guests to go to a different website; they can just browse Airbnb (largest inventory of short-term rentals) as usual and get more options to book when available. Other than savings, I think there is something about the direct relationship with hosts and guests, without any intermediaries. The cool think is I estimate about 20-33% of Airbnbs can be booked directly! That means I’ve only collected around 6 to 9% of all directly-bookable listings around the world. I’ve seen some other chrome extensions do something similar, but none of them highlight these listings nor let you search listings only with hosts that offer direct booking. What do you think? Try it out and let me know if this is useful. I’m also planning to spin up a website that only has listings from these hosts, kind of like a meta-search engine for vacation rental websites. https://ift.tt/rGqe0PO March 20, 2025 at 01:37AM

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

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/7AdIWBh Here’s a demo: https://ift.tt/tgaewYk 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/7AdIWBh March 19, 2025 at 11:14PM

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

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/93JbQpD March 19, 2025 at 01:12AM