Agree with this, though I've mostly been using Gemini CLI. Some of the simplest things, like applying a small diff, take many minutes as it loses track of the current file state and takes minutes to figure it out or fail entirely.
I use markdown files in vs code. Supports folding of sections, combined with a few keyword/char patterns that I highlight different colors. Also get code highlighting in properly labeled code sections.
Well, pretty much everyone is less valuable than they think!
I've bootstrapped and sold two startups, first time with 5 (!) equal cofounders and second time with 3. I've learned a lot along the way, obviously some of that through mistakes of my own. Have my cofounders been perfect? Heck no -- one lacks the same level of drive, the other is less trustworthy (always multiple irons in the fire kinda guy). But we all have strengths, are all generally better off together, and have the combined skill set to run super lean. Even if you think you can do some things better alone, you can never do it all, and that grind will take quite a toll.
Related: over the years the topic of going into business with some of my best friends has come up, and I always say I would never do that. Running a fast-moving, high stakes business with multiple founders involves a lot of tough conversations and occasional relationship strain. My business partners are business partners first, friends second, and I think that's important to consider if you really value a friendship.
I just went through this process and ended up getting the HP Omnibook Ultra Flip with a core 7 258v, running Ubuntu 24.10. Performance is excellent, battery life is the best I've ever had on an Intel running Linux. If you truly need more RAM than 32 GB it won't be an option though.
The air or an mb pro seems so nice until I remember the sting of dealing with the dev environment and docker on a Mac compared to Linux. No amount of battery life or marginal jump in performance (which gets lost through needed virtualization) will make up for that for me.
It does seem quite nice. Is the pen input decent?
If the build quality is OK the pricing is quite good, in France with 32Go/1To is 650€ cheaper than an equivalent MacBook Air.
I have not looked for a proper CPU comparison but I don't that it matters that much for a device of this type, and as you said, with Apple Silicon you lose a lot of the performance once you venture away from optimized software (which is still quite restrictive).
Considering the (relative) failure of the ARM push for Windows PCs I doubt ARM is going anywhere in the consumer market (that probably means it will stay niche in the server market as well but we'll see).
You are doing a lot of the work a semantic layer would do for you. I wonder if you would have better luck having the LLM talk to a semantic layer instead of directly to the database.
There are a number of semantic layer tools out there these days. Each has their own unique approach, but essentially it's a meta layer on top of your database that can be used to do things like form queries or provide a consolidated API to your data (which may be in multiple databases).
Some comments on this thread mention popular semantic layer tools like cube.dev. I also made an open source one that I use regularly, though it's currently in I-hope-to-put-more-time-into-this-someday mode. Been busy with an acquisition this year.
Not OP, but a naive guess is it would mean that you'd have your schema defined in an ORM (for example, Prisma). The advantage here is that the LLM gets context on both the schema and how the schema is used throughout the application.
I use Weaviate and let the model create GraphQL queries to take advantage of both the semantic and data layer. Not sure how efficient it is but it's worked for me
Happy to see them announce the new AMD chips in the 13", but the prices are a little nuts compared to what you can get elsewhere.
I bet the desktop is interesting, but first I was in a 30m waiting room to access their website (what?!?) and then the button to pre order the desktop is broken. Ouch.
The constant struggle is the lagging support for the best hardware. Unless you want to buy a machine from a dedicated Linux shop (framework, System76, tuxedo), you are taking a risk buying anything remotely new without a lot of research into the hardware and hunting for posts about people who have had success. Those dedicated Linux shops are usually at least a generation behind too. It doesn't help that architectures are evolving rapidly in response to Apple's chips (not a bad thing long term).
Just bought an HP omnibook flip with an Intel 258v. From what I've read I expect most things to work, or work soon with kernel updates. All applications I care about work well. Would be nice to see OpenAI make a desktop app for Linux, or some other open source equivalent.
Congrats on the launch. I made a tool that has some similar objectives but doesn't present as SQL itself like Trilogy seems to. I'll take a deeper look at Trilogy soon, always interested to see the variety of approaches to this.
Had some more time to drill into this and we've ended up with a very similar approach to a lot of the metadata definition and resolution - I'd love to chat sometime about how you've solved some of the common problems (table selection w/ multiple sources, the constraint vs output projection, aggregation level, etc, etc)
Oh wow yeah, a lot of parallels - thanks for sharing, I'll take a deeper dive in a bit. I think there's a lot of demand and a lot of space for different solutions; Trilogy definitely aspires to hew closer to standard SQL. (I actually really like SQL for the most part!)
I have nothing against SQL of course. The simplified approach of a UI built on top of zillion or tools like it really enables a whole next level of productivity for business users that are never going to learn SQL, but also need more query flexibility than just "dashboards" without having to wait on a BI team for answers -- I die inside a little bit every time I hear of a company doing this. And as you have noted, I also think text-to-semantic-layer is an interesting approach for involving AI/NLP.
I've been pulled away from this project for some time due to an acquisition at my day job but hoping to get back into it soon!
Also full agreement! In an optimistic view, the SQL layer (at a slightly higher level) unifies the top level accessibility tools (NLP, drag/drop chart result builders, etc) with the more tech-familiar level of analysts/engineers, and provides progressive disclosure as you go down the stack and a path to promote the adhoc/SQL level work up to reporting easily.
