Wuhibeselassie Nigatu

Juno is a mobile-first PostgreSQL client for iOS and Android, built with Flutter. It lets you browse schemas, filter and page through tables, and run SQL with syntax highlighting and schema-aware autocomplete, all from a phone.

I designed and built the app end to end. Read-only mode is enforced server-side via default_transaction_read_only, so writes hidden inside CTEs are rejected by the engine rather than by a regex, and passwords live only in the OS keychain/keystore, never in the local database or logs. The table browser does server-side filtering, sorting, and 200-row paging; the SQL editor adds a composable snippet toolbar above the keyboard, cancellable queries, and a results grid with JSON pretty-printing.

Since mobile OSes kill idle sockets, every resume pings and silently reconnects, and driver errors are mapped to typed, human-readable messages. Every database call goes through an abstract adapter and package:postgres is imported in exactly one directory, so adding MySQL or SQLite later means a new adapter rather than a UI rewrite. Releases are cut from a version tag and ship as signed APKs via GitHub Actions.

CRWN Clothing is an eCommerce demo storefront built with React 18 and TypeScript, bundled with Vite and deployed on Vercel. It presents a directory of clothing categories, lets you browse the products in each collection, and adds items to a cart that tracks quantities and a running total. Authentication is handled by Firebase Auth, covering sign-up and sign-in, and the product collections and user profile records live in Cloud Firestore rather than being hard-coded on the front end.

I built the project end to end: the component architecture and client-side routing with React Router, the shared cart and user state, the Firebase and Firestore integration, and the styling, which is written in SCSS with shared variables and per-component partials for a responsive layout. The codebase is fully typed and kept consistent with ESLint and Prettier, and deploys straight from the repository. It is a portfolio build, so it focuses on front-end architecture, the authentication flow, and data modeling rather than payment processing.