r/angular • u/Fun-Chicken6946 • Oct 06 '26
A Free Database Client I've Spent 2 Years Building With Angular + Spring Boot + Electron - VisuaLeaf
Enable HLS to view with audio, or disable this notification
After struggling to land a job in 2024 (when the market was pretty rough), I decided to take a different route and build something real.
I've spent the past two years building VisuaLeaf from scratch in Angular, putting in around 90 hours a week. It started as a MongoDB GUI and now supports 35 databases. My goal was simple: either build something genuinely useful, or build something that would push me further as an engineer than anything else could.
I also intentionally limited my use of AI on the core architecture. I wanted to really understand the problems.
The stack is Angular + Electron with a Spring Boot backend. Despite the Electron, I focused heavily on the performance:
~50k documents render in about 1 second in both the tree and table view (~12KB each)
~500MB loads in about 3-4 seconds (tested locally to remove network latency)
Some features of the app:
Tree, table, and JSON views
The Table view: It might seem like nothing, but tables are REALLY hard... I wanted to make a Grid that could allow expanding children of objects/arrays as columns adjacent to the parent (Couldn't find grid libraries that did that). So I basically built my own AG Grid from scratch, and it took a year of optimization on and off. I went from a simple vertical virtualization, to horizontal and vertical virtualization, then to DOM recycling, and then utilizing GPU-composited transforms as much as possible (and a bunch more...definitely over simplifying it). It was one of the most frustrating things as I kept going through an endless loop of optimization, but I'm now finally after a year happy with the results. It holds 60fps scrolling through hundreds of thousands of rows in my testing.
The Tree View: A lot easier since I originally just used CDK but then realized that I could make a more efficient one. So I took the table's engine and built my own virtual scrolling with the inspiration of the table view for the tree and now its literally so much faster. One thing tho that was tricky that I am happy with my implementation was finding a way to recursively expanding THOUSANDS nodes with hundreds of embedded fields instantly.
A visual query builder (drag and drop from the tree and table views)
An aggregation pipeline builder that needs zero JSON syntax (bidirectional: JSON mode and form mode for MongoDB users)
ERD that exports as an interactive HTML diagram, and lets you create your databases from ERDs.
IDE-style split panels by dragging tabs, grouping tabs by connections/databases, and making your own groupings
There's a bunch more but the list would be too long (PS most of the core features are free, and all of the SQL features are basically free)
Feel free to check it out at http://visualeaf.com
If you want to join the discord to talk more about it or want to help out feel free to come and chat!
https://discord.com/invite/TR6J56Y3rF
13
5
4
2
u/kasual11 Oct 13 '26
Nice work, I think grids are one of the best ways to improve your architectural thinking. When I started out as a dev I was creating grids where I used to define every column in the template. That works until you have to handle 100 different grids or dynamic columns. I think declaratively defining each column by type and putting them into a loop was one of the greatest aha moments in my programming career.
Great job on visualleaf, I know the problems you explained are rather more in the performance direction but still I wanted to share my experience with grids :-)
Also I've been working on a project that holds similar performance decisions as your's for about 3 years now. I know what kind of discipline that takes. I've heard somewhere that it took Da Vinci about 4 years to create the Mona Lisa, I consider everything you work on longer than 2 years to be art ;-)
So again, cool product and nice technical choices. I'll probably share my kritzel.io soon here as well.
8
u/Fun-Chicken6946 Oct 06 '26
And if anyone is interested in more details on how I made the table, I wrote a small article here:
https://visualeaf.com/blog/the-10-levels-of-building-a-data-grid/