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. Calculating the Timezone From the Latitude/Longitude in SQL

  2. Using the Correct Versions in Your Package Manager

  3. Sorting Git Tags in Semantic (Natural) Order

  4. Colored Output from SQLite3

  5. Better Code Highlighting in Postach.io

  6. ETL on Billions of Rows in Redshift

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

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

  9. Building a Date Dimension Table in Redshift

  10. Redshift Does Not Support generate_series()

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

  12. Assertions in PHP

  13. Converting C to Go

  14. Removing Duplicate Data in Redshift

  15. Fixing Zeroed Dates in MySQL in a Large Database

  16. Implementing Repeatable Read and Serializable Transaction Isolation

  17. Making the World A Better Place with CAT Tools

  18. Farewell 2016, Hello 2017!

  19. Code Coloring in Postach.io

  20. SQL Transaction Isolation Levels Explained