Berryhub.app (@berryecosystem) header
Berryhub.app (@berryecosystem) profile picture

I am deeply passionate about pushing the boundaries of modern technology.

Vietnam
Joined January 2014
Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)Photo by Berryhub.app (@berryecosystem)
The most dangerous database bugs don't crash with a stack trace. They return status 200 OK, while quietly mutating the wrong schema. Recently, @RenXLog noted a sharp insight on building robust database clients: "A useful Postgres fixture would be two schemas with the same table name but different columns. It catches clients that quietly lose the schema qualifier." This exact observation exposed a silent risk across many DB tools. In Postgres & SQL Server, unqualified queries resolve to the default search path (`search_path = "$user", public` or `dbo`). When a client introspects `tenant_alpha.items` but forgets the prefix: ❌ Intended: SELECT * FROM "tenant_alpha"."items"; ⚠️ Executed: SELECT * FROM "items"; The database silently serves or updates records in `public.items` with zero errors! Today, we're releasing BerryDB v1.0.8 with a comprehensive architectural fix: 1️⃣ Multi-Schema "Acid Test" Fixtures: Docker-based CI testing with two separate schemas (`berry_s1`, `berry_s2`) sharing table name `items` but completely disjoint columns. If any qualifier drops, CI instantly catches it. 2️⃣ Principle N1 (Single Execution Path): Every SELECT, INSERT, UPDATE, DELETE, and TRUNCATE must pass through Swift's dialect quote resolver (`SQLDialect.qualifiedName`). Bare unquoted names are structurally impossible. 3️⃣ Namespace-Aware Foreign Key Introspection: Joined `pg_namespace` on `confrelid`, ensuring foreign key clicks navigate to the exact intended entity across schemas. 4️⃣ Adaptive Schema-First Tree View: macOS sidebar adapts automatically: hierarchical `Connection > Schema > Tables` for Postgres/MSSQL, flat for SQLite/MySQL. Built with Swift 6 strict concurrency and AppKit virtualization. A huge thank you to @RenXLog for pushing open-source DB tooling forward! 🫐 Are you running tricky database topologies (complex RLS, partitioning, custom types)? We invite you to challenge BerryDB. 📦 Download DMG: download-db.berryhub.app/Ber… 🐙 GitHub (Apache 2.0): github.com/berry-apps/berryd… #PostgreSQL #macOS #Swift #Database #OpenSource
39
BerryDB is now open source. A native macOS database client written in Swift 6 and AppKit. No Electron, no JVM, no bundled browser. One app for Postgres, MySQL, SQLite, SQL Server, Redis, MongoDB, DynamoDB, Elasticsearch and Qdrant. The SQL copilot reads your real schema and your real slow-query stats before it says anything. It writes the plan into a new tab and stops there. Nothing runs against your database until you press Run. Apache 2.0 — github.com/berry-apps/berryd…
4
1
77
Help wanted, and these are real gaps: • ClickHouse and DuckDB drivers — nine ship, these two are planned • more languages — it ships English and Vietnamese • re-enable Postgres and MySQL in the conformance matrix • bug reports from schemas we've never seen Issues are labelled.
1
52
Credentials go to the Apple Keychain, never a plist. SSH tunnelling is built in, and the key passphrase travels through SSH_ASKPASS — never the command line, where every process on the machine can read it. TLS on every driver that supports it.
8
The SQL copilot reads your real schema and your real slow-query stats before it says anything. It writes the plan into a new tab and stops there. Nothing runs against your database until you press Run.
10
Every number we publish is one we measured, with the script that ships in the repo: • 0.85s cold start to first window • 1,000,000 rows streamed for ~5.5MB peak — the same as 200,000 • 77MB app, no runtime dependencies Don't take our word for it: scripts/measure-performance.sh
30
Stop building video workflows from scratch. 🛑 Just write your wildest idea ➔ AI Agent auto-generates the node pipeline ➔ Render in seconds. ⚡️ 📝 Prompt: "A colorful parrot getting a ridiculous haircut at a barbershop" 🎬 Result: A 3s video generated instantly. From crazy idea to finished video before your coffee gets cold. ☕️ Try it today 👇 [berryhub.app] #AIVideo #GenerativeAI #AIWorkflow #ContentCreation #AItools #berrydb #berryreel #berryshot @thsottiaux
42
Built an open-source database management tool: db.berryhub.app 🚀 It’s still a work in progress with plenty of features to improve, and I’d love to get feedback from the developer community! What features or UI improvements would you like to see in a modern DB client? #OpenSource #Database #DevTools #PostgreSQL #SQL
45
🚀 Meet BerryDB – The modern, AI-powered database client built for fast workflows. Stop context switching. Query, analyze, and manage your databases with built-in intelligence. ⚡ What makes BerryDB different:✦ Universal Support: PostgreSQL, MySQL, SQLite, MongoDB, Redis, Elasticsearch, Qdrant & DynamoDB ✦ AI Assistant: Instant schema insights, AI queries & workload analysis ✦ Graph Explorer: Visualize table relationships & blast radius before running migrations ✦ Secure by Design: Native SSH tunneling & TLS support ✦ Sleek macOS-native dark UI Simplify your database workflow today 👇 🔗 db.berryhub.app/docs.html #Database #PostgreSQL #MySQL #DataEngineering #DevTools #Tech #BuildInPublic #AI
39
Optimizing database used to be such a hassle back in the day, but now AI handles it all—from risk analysis to optimization planning in a snap. Whether it's at the DB level or tweaking prompts at the application layer, AI has it covered. For the pros rocking Mac M-series chips, life is even easier: leverage Apple Intelligence without spending a single dime 😜 db.berryhub.app #berrydb
1
1
76
Database optimization used to be pure pain. Now AI does the entire job in seconds. Risk analysis → finds unused indexes → builds the optimization plan. Done. Mac M-series users get it completely free with Apple Intelligence. This is wild: db.berryhub.app #berrydb #AI #DatabaseOptimization #AppleIntelligence #MacOS
1
11
1/ I wanted a fast, native, open-source screenshot utility for macOS that respects user privacy and doesn't charge monthly subscriptions. So we built BerryShot 🍓 👇 #swiftUI notex.work/berryshot github.com/berry-apps/berrys…
33
Xem trang trưng bày của nhà sáng tạo này trên TikTok Shop vt.tiktok.com/ZS9hysDgNQdQ5-…
32
Discover great free apps and get rewarded with gift cards! m.freemyapps.com/share/twitt… via @freemyapps