Elliot Chance

I'm a data nerd and TDD enthusiast living in Sydney, Australia. I love exploring new technologies and working on modern ways to solve age old problems

  1. Comparing GEDCOM Files

  2. Calculating the Timezone From the Latitude/Longitude in SQL

  3. Using the Correct Versions in Your Package Manager

  4. Sorting Git Tags in Semantic (Natural) Order

  5. Colored Output from SQLite3

  6. Better Code Highlighting in Postach.io

  7. ETL on Billions of Rows in Redshift

  8. Comparing Floating Point Numbers in C/C++

  9. PHP serialize() and unserialize() Implemented In Go

  10. Building a Date Dimension Table in Redshift

  11. Redshift Does Not Support generate_series()

  12. Fixing Duplicate Class Errors with Locally Symlinked Vendor in PHPStorm

  13. Assertions in PHP

  14. Converting C to Go

  15. Removing Duplicate Data in Redshift

  16. Fixing Zeroed Dates in MySQL in a Large Database

  17. Implementing Repeatable Read and Serializable Transaction Isolation

  18. Making the World A Better Place with CAT Tools

  19. Farewell 2016, Hello 2017!

  20. Code Coloring in Postach.io