How to Make Websites That Will Require Lots of Your Time and Energy

Re:How to Make Websites That Will Require Lots of Your Time ... by sherburt3 on Monday July 28, 2025 @10:20PM (#44718231)

At least when I see raw sql I know me and the author are on a level playing field. I would rather deal with a directory full of sql statement that get run than some mysterious build tool that generates sql on the fly and thinks its smarter than me.

For example, I'm working on a project right now where I have to do a database migration. The project uses c# entity framework, I made a migration to create a table, realized I forgot a column, deleted the table and tried to start from scratch. For whatever reason, entity framework refuses to let go of the memory of the original table and will create migrations to restore the original table. I hate this so much.

[ Parent | on HN ]

Re:How to Make Websites That Will Require Lots of Your Time ... by krawcu on Tuesday July 29, 2025 @03:01AM (#44720012)

i think you should just create another migration with alter table that adds that column

[ Parent | on HN ]

Re:How to Make Websites That Will Require Lots of Your Time ... by indigo945 on Tuesday July 29, 2025 @03:03AM (#44720022)

You can use EF by writing the migrations yourself ("database first"). Also, whatever problem you have there seems to be easily fixed either by a better understanding of how EF's code generation works, or by more aggressive use of version control.

[ Parent | on HN ]

Re:How to Make Websites That Will Require Lots of Your Time ... by Xss3 on Tuesday July 29, 2025 @05:45AM (#44721229)

Their point is they understand sql and dbs. They shouldnt need to learn EF and all its footguns.

[ Parent | on HN ]