Have you ever started working on a piece of software you were really excited to get to working on, only to get to the part where you make the database and thought "Oh brother, not this part again"?
I was recently in the same place and decided to make Database Designer! This is a piece of software aimed at generating Postgres databases as simply as possible! Focused on C#, this includes the database itself, documentation and a group of C# functions made to make development easier!
This records the process of me creating DD in the hopes of helping developers in the future!
So. I ended up making a large amount of code in the format shown below
This would create the SQL file from text. Atop this, the below code
Would create the documentation required for the database. Pretty good!; i've made over 3.5k lines for a database preset sing this! However, this code is the new issue;
I made a function which allows me to create tables much more cleanly, but this means throwing away all the work I already did in favor of the new function. Still, i'm all for progress so this is what i'm doing! I estimate it'll take 2 to 3 days to setup but I do think it's worth it in the long run! When it's all put together i'll give a more formal introduction.