Stuff
3 subscribers
198K links
Download Telegram
Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy
8 by Kumzy | 1 comments on Hacker News.
Hello HN! Advanced Alchemy is an optimized companion library for SQLAlchemy, designed to supercharge your database models with powerful tooling for migrations, asynchronous support, lifecycle hook and more. You can find the repository and documentation here: - GitHub Repository: https://ift.tt/6Ev5xVM - Official Documentation : https://ift.tt/U4d5lQk Advanced-Alchemy extends SQLAlchemy with productivity-enhancing features, while keeping full compatibility with the ecosystem you already know. At its core, Advanced-Alchemy offers: - Sync and async repositories, featuring common CRUD and highly optimized bulk operations - Integration with major web frameworks including Litestar, Starlette, FastAPI, Sanic - Custom-built alembic configuration and CLI with optional framework integration - Utility base classes with audit columns, primary keys and utility functions - Built in File Object data type for storing objects: - Unified interface for various storage backends fsspec and obstore - Optional lifecycle event hooks integrated with SQLAlchemy's event system to automatically save and delete files as records are inserted, updated, or deleted. - Optimized JSON types including a custom JSON type for Oracle - Integrated support for UUID6 and UUID7 using uuid-utils - Integrated support for Nano ID using fastnanoid - Pre-configured base classes with audit columns UUID or Big Integer primary keys and a sentinel column. - Synchronous and asynchronous repositories featuring: - Common CRUD operations for SQLAlchemy models - Bulk inserts, updates, upserts, and deletes with dialect-specific enhancements - Integrated counts, pagination, sorting, filtering with LIKE, IN, and dates before and/or after. - Tested support for multiple database backends including: - SQLite via aiosqlite or sqlite - Postgres via asyncpg or psycopg3 (async or sync) - MySQL via asyncmy - Oracle via oracledb (async or sync) (tested on 18c and 23c) - Google Spanner via spanner-sqlalchemy - DuckDB via duckdb_engine - Microsoft SQL Server via pyodbc or aioodbc - CockroachDB via sqlalchemy-cockroachdb (async or sync) The framework is designed to be lightweight yet powerful, with a clean API that makes it easy to integrate into existing projects. You can find a full example using FastAPI there: https://ift.tt/ver0OnI... There are custom datatypes, a service and repository (including optimized bulk operations), and native integration with Flask, FastAPI, Starlette, Litestar and Sanic. Feedback and enhancements are always welcomed! We have an active discord community, so if you don't get a response on an issue or would like to chat directly with the dev team, please reach out. The library: https://ift.tt/6Ev5xVM
The Danglepoise
10 by draazon | 6 comments on Hacker News.
Launch HN: Cua (YC X25) – Open-Source Docker Container for Computer-Use Agents
18 by frabonacci | 1 comments on Hacker News.
Hey HN, we’re Francesco and Alessandro, the creators of c/ua ( https://www.trycua.com ), a Docker‑style container runtime that lets AI agents drive full operating systems in lightweight, isolated VMs. Our entire framework is open‑source ( https://ift.tt/EK8YwL6 ), and today we’re thrilled to have our Launch HN! Check out our demo to see it in action: https://www.youtube.com/watch?v=Ee9qf-13gho , and for more examples - including Tableau, Photoshop, CAD workflows - see the demos in our repo: https://ift.tt/EK8YwL6 . For Computer-Use AI agents to be genuinely useful, they must interact with your system's native applications. But giving full access to your host device is risky. What if the agent's process gets compromised, or the LLM hallucinates and leaks your data? And practically speaking, do you really want to give up control of your entire machine just so the agent can do its job? The idea behind c/ua is simple: let agents operate in a mirror of the user’s system - isolated, secure, and disposable - so users can fire-and-forget complex tasks without needing to dedicate their entire system to the agent. By running in a virtualized environment, agents can carry out their work without interrupting your workflow or risking the integrity of your system. While exploring this idea, I discovered Apple’s Virtualization.Framework and realized it offered fast and lightweight virtualization on Apple Silicon. This led us to build a high-performance virtualization layer and, eventually, a computer-use interface that allows agents to interact with apps just like a human would - without taking over the entire system. As we built this, we decided to open-source the virtualization core as a standalone CLI tool called Lume (Show HN here: https://ift.tt/tD4sE3P ). c/ua builds on top of Lume, providing a full framework for running agent workflows inside secure macOS or Linux VMs, so your system stays free for you to use while the agent works its magic in the background. With Cua you can build an AI agent within a virtual environment to: - navigate and interact with any application's interface; - read screen content and perform keyboard/mouse actions; - switch between applications and self-debug when needed; - operate in a secure sandbox with controlled file access. All of this occurs in a fully isolated environment, ensuring your host system, files, and sensitive data remain completely secure, while you continue using your device without interruption. People are using c/ua to: - Bypass CryptoJS-based encryption and anti-bot measures to interact with modern web apps reliably; - Automate Tableau dashboards and export insights via Claude Desktop; - Drive Photoshop for batch image editing by prompt; - Modify 3D models in Fusion 360 with a CAD Copilot; -Extract data from legacy ERP apps without brittle screen‑scraping scripts. We’re currently working on multi‑VM orchestration for parallel agentic workflows, Windows and Linux VM support, and episodic and long-term memory for CUA Agents. On the open‑source side, c/ua is 100 % free under the MIT license - run it locally with any LLM you like. We’re also gearing up a hosted orchestration service for teams who want zero‑ops setup (early access sign‑ups opening soon). We’d love to hear from you. What desktop or legacy apps do you wish you could automate? Any thoughts, feedback, or horror stories from fragile AI automations are more than welcome!
More Everything Forever
10 by c0rtex | 3 comments on Hacker News.
How ZGC allocates memory for the Java heap
13 by lichtenberger | 1 comments on Hacker News.
AI Horseless Carriages
27 by petekoomen | 3 comments on Hacker News.
The Future of MCPs
15 by tylerg | 10 comments on Hacker News.
Graphics Livecoding in Common Lisp
13 by adityaathalye | 3 comments on Hacker News.
The Really Big One (2015)
6 by Tomte | 2 comments on Hacker News.