PHPnews.io

Overview for 'remysharp'


The mythical code review [blog]

Written by Remy Sharp / Original link on Mar. 24, 2021

For anyone who's worked in a development team (that involves code) and more than a single individual then the idea of a code review is going to have floated past your bow at some point or another. I've been doing code reviews since the early 2000s. It's taken me some twenty years to finally articul…


Marbles2 - 23-Mar 2021 [devlog/marbles2]

Written by Remy Sharp / Original link on Mar. 23, 2021

It's been a while since posting any progress on this project, but I've been working away quietly. What's nice about Marbles is that because the game is so familiar to me, it let's me spend time experimenting in areas that are typically out of reach. The bulk of the work I've done over the last few…




Postgres CSV import with JSON [til/data]

Written by Remy Sharp / Original link on Mar. 9, 2021

The problem: CSV files generally quoted using " and delimited using , - both of which feature heavily in JSON strings. So importing a CSV with JSON doesn't fly. One solution (it took me hours and hours to solve) is to use an alternative byte for quote and delimiter. For example, quote using \x1 and…