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).