Top
Best
New

Posted by cpcloud 6 hours ago

Show HN: Micasa – track your house from the terminal(micasa.dev)
micasa is a terminal UI that helps you track home stuff, in a single SQLite file. No cloud, no account, no subscription. Backup with cp.

I built it because I was tired of losing track of everything in notes apps, and "I'll remember that"s. When do I need to clean the dishwasher filter? What's the best quote for a complete overhaul of the backyard. Oops, found some mold behind the trim, need to address that ASAP. That sort of stuff.

Another reason I made micasa was to build a (hopefully useful) low-stakes personal project where the code was written entirely by AI. I still review the code and click the merge button, but 99% of the programming was done with an agent.

Here are some things I think make it worth checking out:

- Vim-style modal UI. Nav mode to browse, edit mode to change. Multicolumn sort, fuzzy-jump to columns, pin-and-filter rows, hide columns you don't need, drill into related records (like quotes for a project). Much of the spirit of the design and some of the actual design choices is and are inspired by VisiData. You should check that out too. - Local LLM chat. Definitely a gimmick, but I am trying preempt "Yeah, but does it AI?"-style conversations. This is an optional feature and you can simply pretend it doesn't exist. All features work without it. - Single-file SQLite-based architecture. Document attachments (manuals, receipts, photos) are stored as BLOBs in the same SQLite database. One file is the whole app state. If you think this won't scale, you're right. It's pretty damn easy to work with though. - Pure Go, zero CGO. Built on Charmbracelet for the TUI and GORM + go-sqlite for the database. Charm makes pretty nice TUIs, and this was my first time using it.

Try it with sample data: go install github.com/cpcloud/micasa/cmd/micasa@latest && micasa --demo

If you're insane you can also run micasa --demo --years 1000 to generate 1000 years worth of demo data. Not sure what house would last that long, but hey, you do you.

346 points | 110 comments
kadrian12 2 minutes ago|
This is quite cool. Makes me philosophical: isn't it odd, that this is like an Excel template? Like a "domain model" template? In this case, presented nicely in a TUI that makes basic CRUD workflows work.

Most SaaS companies are just that: 1) Curated domain model (stored in their cloud db) 2) Some way for users do to almost raw CRUD on the tables 3) Curated high-level domain specific workflows that do n CRUD calls underneath

So many of these SaaS apps could have been a simple Excel / domain model template like Micasa.

But it seems like we haven't "cracked" the perfect UI on top of relational DBs.

Excel: Good: raw CRUD. Bad: too many degrees of freedom + the possibility to edit the domain model itself. That's too much for most users.

TUI: Good: raw CRUD with some guardrails, limited possibility to adjust the domain model / not by accident. Keyboard shortcuts, for professionals. Bad: inaccessible for non-tech end users + hard to build good UX for high-level domain specific workflows.

Full Web UI: Good: accessible for all. Great for high-level domain-specific workflows. Bad: looks and works different every time. Raw CRUD possible, but always a compromise with editable data grid libraries.

gleenn 3 hours ago||
Someone has a sense of humor in the reviews section:

"I’ve been using the demo data for three weeks. I don’t own a house. — Aspiring Homeowner"

kayge 2 hours ago||
I didn't see that review in the 4 shown in that section until I refreshed the page... there are some good ones in there, including a Hacker News shoutout :D
datakazkn 15 minutes ago||
The hallucination-in-analysis problem is real and often undersold. Pattern that works well: use the LLM only to structure already-extracted data (parse fields, normalize formats), then apply deterministic logic for anything numerical. That way the LLM is doing classification/extraction where it's reliable, and you're not trusting it to compute or compare values where it isn't.
fudged71 5 hours ago||
I think/hope the whole "home manager" category is going to take off soon.

On a cost basis, it no longer makes sense--practically--not to use visual/text/audio intelligence to manage such a large asset. We just don't have the user-friendly mass-market interfaces for it just yet.

It's possible to scan every manual, every insurance policy, ingest every local bylaw. It's possible to take a video of your home and transform it into a semantically segmented Gsplat of [nearly] everything you own. It's possible to do sensor fusion of all the outward facing cameras from your home. And obviously agents like OpenClaw can decide what to do with all of this (inventory, security, optimization, etc).

erader 3 hours ago||
I've been working on something like this the last few months specifically around service quote analysis (repairs, construction, hvac, auto, etc.) and it's really cool. I think LLM analysis is the way to go because the amount of complexity is absolutely staggering - just to start the difference in quality and information available on a quote is drastically different between vendors within the SAME vertical. Then to do actual do analysis on local laws, the details of your property (not just photos/videos, but zoning and lot details), vendor analysis, etc.

On top of it all, the most important thing to consider is intent -> An emergency plumbing visit is often very different than a proactive upgrade.

edit: spelling

order-matters 28 minutes ago||
how do you handle the LLM hallucinations in analysis? I like it for data extraction but i never trust it to analyze anything
candiddevmike 4 hours ago|||
We've been building https://homechart.app for years (without GenAI...) and folks just don't realize that home managers exist as an app. They're too used to single purpose solutions, so they don't think to look for more comprehensive options.

There's also the inherit struggle of being everything for everyone with an app like this, and focusing on features 80% of your users want and leaving the other 20% niche features on the backlog upsets people, mostly the power users.

PunchyHamster 19 minutes ago|||
It's just hard sell vs the free of just having a spreadsheet
rocketpastsix 2 hours ago|||
I checked out HomeChart, and boy howdy it feels like its doing way too much.
candiddevmike 1 hour ago||
Thank you for ironically proving my point, I guess. The main value add here is everything is integrated into one app. I always wonder if folks said the same thing when Salesforce or SAP were created.

Anyways we document our reasoning here: https://homechart.app/docs/explanations/architecture/#separa...

relaxing 34 minutes ago||
People say that about Salesforce and SAP now…
embedding-shape 5 hours ago|||
> It's possible to do sensor fusion of all the outward facing cameras from your home

Is that legal though? I'm guessing it the US it might be, given the amount of cameras of public places you can see in various communities, but wonder how common that is. Where I live (Spain) it's not legal to just stick a camera on your house and record public places, you need to put the camera in a way so you're only filming your private property or similar.

matthewfcarlson 2 hours ago||
The US gives you no expectation of privacy in public places and private property is generally do what you want. It gets murkier if your cameras are pointed at other private property (your neighbors).

Not a legal expert just what I’ve heard.

thfuran 1 hour ago||
As I understand it (which probably isn’t well), expectation of privacy on private spaces in the US gets pretty wonky. Like being in plain view on a front lawn wouldn’t have expectation of privacy but being behind a fence would even if the fence doesn’t do a good job of blocking sight lines.
homarp 4 hours ago|||
I call this the "Home Resource Planner"

Bricks are there (Home assistant, Frigate, Pihole,...)

stillforest 1 hour ago|||
[dead]
korse 1 hour ago||
[flagged]
thomascountz 4 hours ago||

   files are stored as BLOBs inside the SQLite database, so cp micasa.db backup.db backs up everything – no sidecar files
SQLite is just so cool. Anyway, this whole project looks amazing. I can't wait to kick tires (and then track when I last changed my tires... wait, can it do that?!)
cpcloud 4 hours ago|
One of my first thoughts after getting a working prototype was: "Doesn't the car battery need to be replaced?"

So, yeah. This would obviously be called micarro.

piskov 4 minutes ago||
Why is the text in cells truncated?

Here it an important th… |

Why?

aeblyve 3 hours ago||
I feel like a lot of these types of apps could just be spreadsheets. Maybe a "smart" spreadsheet like Grist[0] executing Python code. Am I off-base there?

[0] https://github.com/gristlabs/grist-core

deeth_starr_v 28 minutes ago||
I agree. While I really like the idea of being able to query some of this data, it's another system to maintain. I have a system where I use a calendar, physical folder, and notes/folder in the cloud. Call me lazy.
cpcloud 3 hours ago|||
Probably right. My brain is probably stuck in old-man spreadsheet land and I did not explore any new horizons that might have obviated micasa. That said, I also didn't want to invest a bunch of time in developing a domain specific app using spreadsheets as the API, I wanted to invest a bunch of time developing a domain specific app using AI. Might end up being a choice I regret!
aeblyve 3 hours ago||
That's all fair. It is a cool piece of work nonetheless.

For example I am thinking, what if I wanted to hook up my micasa instance to some other arbitrary self-hosted service? If it's an App that means bespoke code, with a spreadsheet stack it is trivial.

iugtmkbdfil834 3 hours ago||
I will say that I am slowly becoming a convert to 'talk to data' approach. Still, it is not without its flaws. At the end of the day, it still requires the user to update stuff and, from experience, this is where I fail and render all those project apps useless..for me specifically.

It sucks, because it sounds like what I really need is for someone to track it for me so that i can just review it if needed.

open592 1 hour ago||
This is awesome, love the sense of humor and just downloaded it and started adding data.

Only small piece of feedback is that I would use `$VISUAL` when opening the editor. When I tried to use `Ctrl+e` it opened nano which I haven't used in ages.

Edit: Oh looks like you use `$EDITOR` - I just didn't have that set. Awesome!

These are the projects which make me love Show HN!

cpcloud 1 hour ago|
Thanks for the feedback!

Did you hit this in the Docs open flow?

micasa will call xdg-open (linux)/open (mac)/cmd (windows) when opening a document, but there's nothing that's explicitly opening a text editor.

solomonb 1 hour ago||
Thank you for the `nix app`!

Being able to launch it with:

     nix run github:cpcloud/micasa     
Is super convenient.

Actually we could go further and serve `micasa` via ssh:

    users.users.micasa = {
      isNormalUser = true;
      shell = pkgs.bashInteractive;
      openssh.authorizedKeys.keys = ...
    };
  
    services.openssh.extraConfig = ''
      Match User micasa
        ForceCommand ${micasaPkg}/bin/micasa
        AllowTcpForwarding no
        X11Forwarding no
    '';
Then we could put this in a nixosModule in your flake.nix. Would you be interested in a PR which does this?

    services.micasa-ssh = {
      enable = true;
      authorizedKeys = [ "ssh-ed25519 AAAA..." ];
      port = 2222;
    };
wolvoleo 5 hours ago|
Thinking of this it would be amazing to have a TUI for home assistant. It's already so good at doing all the nuts and bolts of control and interacting with everything. But its UI is super heavy loaded JavaScript. It doesn't run well on old tablets either for this reason, sadly.
dmd 4 hours ago||
My overall philosophy for (my quite extensive) Home Assistant setup is “amy time a human interacts with the HA UI in any way whatsoever, that is a failure.” I don’t want dashboards, I don’t want a user interface at ALL other than for setting up new automation. The point of HA for me is the house should feel like the correct things happen by magic (and should be essentially unobtrusive and natural).
wolvoleo 4 hours ago|||
Oh that's not my philosophy at all. I don't like too much automation because I'm very fussy as to what I want at one moment. It all depends on my mood which home assistant doesn't know. Sometimes when I enter a room I want the lights on, other times I don't, stuff like that. Like when the curtains are open and I'm walking around half naked. And sometimes I just like the dark and sometimes I need bright lights. Sometimes I need heat and sometimes sitting in 16 degrees (C) is totally fine. Yeah I'm weird I know :)

Also I'm really chaotic in terms of schedule. My mood and behaviour changes by the day.

I use it more as a monitoring and control tool.

Not saying your way is bad, it's more as HA is intended. But I'm just saying it won't work for me.

enobrev 1 hour ago|||
I'm similarly unpredictable in my home. Add to that the others in my house, and it's impossible to even guess what everyone's intentions are at any given time.

Sometimes I daydream about a "solo mode" where the timings on lights are tighter and my music can follow me around the house when I'm up at night and nobody else is. But most times I'm trying to find the get-out-of-way averages that keep everyone happy.

Some things work great: Automated lights everywhere. Automated dimming of lights at night or sunset or whatever. Notifications when the laundry is done, or the cat litter is ready to be changed, or someone is at the door, or the garage door has been left open - all great. What music to play in what room at any time? Always changes. When to "dim all the lights" because Plex started a movie? But my son is building Legos in the dining room, and my wife is knitting and needs the couch light on. Sometimes I want it, but not every time.

For those things having a single button press is still a huge win over opening multiple apps and getting the right things set the right way for each participant.

cyberge99 2 hours ago|||
Same. My environment molds to my comfort, not the other way around.
cpcloud 4 hours ago|||
I've honestly never explored HA. Is there a world where HA obviates micasa. That seems like a win, at least in terms of not having yet another piece of software duplicating an existing thing.
sublinear 5 hours ago|||
There's a CLI [1], LLM API [2], and REST API [3].

[1]: https://github.com/home-assistant-ecosystem/home-assistant-c...

[2]: https://developers.home-assistant.io/docs/core/llm/

[3]: https://developers.home-assistant.io/docs/api/rest/

jefurii 5 hours ago||
I would love to have a TUI for Home Assistant!
More comments...