Showing posts with label POSTGRES. Show all posts
Showing posts with label POSTGRES. Show all posts

Wednesday, 28 April 2021

Working With Time Series Using SQL by Michael Grogan via @kdnuggets

This article is an overview of using SQL to manipulate time-series data.

This is nice and clear. Times are ok if you have enough of the right data and you really understand what you are doing. Pay particular attention to timezones and daylight saving. Also, consider the physical location of the data and what time that system or server is set up to be. 

Monday, 16 March 2020

The Most Useful ML Tools 2020 by @ian_xxiao via @TDataScience

5 sets of tools every lazy full-stack data scientist should use

This is a great list of tools and should give you a list of tools to try. Give Ian some applause on Medium and a follow.

Friday, 5 August 2016

Why Uber Engineering Switched from Postgres to MySQL by Evan Klitzke via @UberEng

Uber Engineering explains the technical reasoning behind its switch in database technologies, from Postgres to MySQL.

I loved this explanation and the level of detail behind it.