Show HN: DuckDB Powered SQL Editor https://ift.tt/Fxhom5X

Show HN: DuckDB Powered SQL Editor Hi guys, I made an SQL editor that utilizes the duckDB engine to process your queries. As a result, the speed gains are +25% when compared to using any standard editor that connects through JDBC. I built this because I work on a small data team and we can't justify an OLAP database. Postgres is amazing but, if I try to run any extremely complex queries I get stuck waiting for several minutes to see the result. This makes it hard to iterate and get through any sort of analysis. That's when I got the idea to use duckDB's processing engine rather than the small compute available on my Postgres instance. I didn't enjoy writing SQL in a Python notebook and wanted something like dBeaver that just worked, so I created soarSQL. Try it out and let me know if it has a place in your toolkit! https://soarsql.com April 5, 2025 at 01:40AM

Show HN: I made an online free tool site https://ift.tt/Lcfaw5W

Show HN: I made an online free tool site Hi HN! I've created [UFreeTools]( https://ift.tt/2zfYbdu ), a collection of developer utilities (60+ tools and growing) that's completely free, ad-free, and runs entirely in the browser. No data leaves your device - everything is processed locally. ## Background As a developer, I found myself constantly searching for simple utilities like JSON formatters, UUID generators, and color pickers. Most existing options were cluttered with ads, required sign-ups, or sent data to servers. I wanted clean, fast tools that respected privacy. So I built UFreeTools as a modern SPA using Vue 3 and Vite with: - 100% client-side processing for all tools - Progressive loading with dynamic imports (only load what you use) - Dark/light theme support - Offline capability for most tools - Responsive design that works well on mobile ## Technical Details Some of the more technically interesting implementations: - *JWT Debugger*: Uses WebCrypto API for verification of all common algorithms - *Symmetric Encryption*: Implements AES-GCM/CBC/CTR with PBKDF2 key derivation - *Image Processing*: Uses Web Workers for non-blocking operations on large images ## Lessons Learned The biggest challenges were: 1. *Performance optimization*: Some tools (like image processors) needed careful optimization to handle large files without freezing the UI 2. *Browser API limitations*: Working around browser restrictions for certain crypto operations 3. *Bundle size management*: Keeping the initial load small while supporting 60+ tools ## Future Plans I'm planning to add: - Tool configurations sync via local storage - More specialized tools for developers based on feedback I built it because I needed these tools myself, and I hope others find it useful. I'd love your feedback, especially on UX, tool suggestions, or if you find any bugs! [Try UFreeTools]( https://ift.tt/2zfYbdu ) https://ift.tt/2zfYbdu April 4, 2025 at 11:26PM

Show HN: GitMCP is an automatic MCP server for every GitHub repo https://ift.tt/lD5gycH

Show HN: GitMCP is an automatic MCP server for every GitHub repo https://gitmcp.io/ April 3, 2025 at 11:58PM

Show HN: Monkeys.zip – 3000 Monkeys on Typewriters https://ift.tt/Et4uIfS

Show HN: Monkeys.zip – 3000 Monkeys on Typewriters Hey HN! I posted this on April 1st when it launched, and though it didn't get traction here, it was a minor hit on reddit! Now that we've got a few thousand monkeys under our belt, wanted to give it another shot here! Happy to talk about the technical details of running the site - using supabase/postgres and constantly putting out fires from the traffic. https://monkeys.zip/ April 3, 2025 at 11:36PM

Show HN: Exponent, a collaborative AI programming agent https://ift.tt/hKfDeML

Show HN: Exponent, a collaborative AI programming agent https://ift.tt/Ut5y6WI April 3, 2025 at 12:23AM

Show HN: Bookmarklet to Add TOC to ChatGPT's Chats https://ift.tt/LzrCKVe

Show HN: Bookmarklet to Add TOC to ChatGPT's Chats https://ift.tt/lQBaybY April 2, 2025 at 11:36PM

Improving Safety and Access in the Panhandle: Oak Street Quick-Build Approved by Board

Improving Safety and Access in the Panhandle: Oak Street Quick-Build Approved by Board
By Bobby Lee

We’re working to make your trips across the Panhandle safer – no matter how you get around. The Panhandle is set to receive significant upgrades that aim to make trips safer and more efficient for people walking, biking and driving. Our Board of Directors has approved the Oak Street Quick-Build Project. The Oak Street Quick-Build Project is another example of how we are taking a community-wide approach to improve safety for people walking, biking or driving when they visit or travel through the Panhandle. We’re making this possible by improving crosswalks, adding a separated bike lane and...

Published April 02, 2025 at 05:30AM
https://ift.tt/4CBvtpN