How much of your job is CRUD?

If you’re a software developer, you know what CRUD means. But do you know how much of your job is actually creating CRUD endpoints, CRUD UX, etc?

In my work with Magic, I have realised that it creates a shitload of code as it is scaffolding a database. In fact, the Sakila database distributed by MySQL generates 15.000 lines of frontend code, and almost 3.000 lines of backend code. Over the last couple of months, I have also optimised it to the extreme, making sure I use base classes and reusable objects as much as possible, to reduce the size of the scaffolded code – Still after insane amounts of optimisations in regards to the size of its result, it still produces 18.000 lines of code in total for a simple 18 tables large database.

Some of these endpoints and grids are probably not needed, and the end solution you want to deliver would probably benefit from having some of these integrated into some parent object form. Still, I am willing to bet with you, you’d have a very hard time creating anything wrapping the Sakila database with a backend and a UX that ends up being smaller than 15.000 lines of code in total.

This implies that a very, very, very large portion of your work as a software developer implies creating simple CRUD endpoints, if you’re a full stack developer of course. Magic does this for free for you, giving you the time you need to focus on the fun stuff. If you’re never creating CRUD things in your work, and you don’t create database driven apps – You arguably don’t need Magic. For everything else, there’s Magic šŸ˜‰

Published by servergardens

Create .Net Core CRUD APIs wrapping your SQL database in seconds