Categories
coding tips

Renaming db_column through django migration.

You have a legacy database in your django application, but created models for it. At first, they were unmanaged, but then you realized that it’d be easier for everyone if django handled the whole database. Now you’re left with a bunch of fields having db_column set and are required to change the field name and also the column name in the database.

Categories
games

Star Wars Battlefront 2 and why I play it

I’ve bought Star Wars Battlefront 2. That’s not all… I’ve pre-ordered it. Did I know about the loot boxes? Yes. Do I care? Yes. So why am I still playing and didn’t get a refund like apparently the whole Reddit did? Because I like the game.

Categories
coding tips

Add unique index to MySQL database

As of version 5.7 MySQL no longer support the keyword IGNORE for ALTER TABLE command, as it was an extension which was badly defined (more information here). Therefore it’s now impossible to use the old query that allowed to delete duplicates by creating a new UNIQUE INDEX and altering the table.

Categories
coding tips

Ignore files in git without editing .gitignore

You work on a repository where the .gitignore file is defined globally and already tracked by git, but you have some files in your local directory that you don’t want to be tracked (logs, or build files, *.pyc etc.) and would like to ignore them (because who doesn’t like git status to show “working tree clean” or the status bar in zsh to be green).