Code Review Videos > Postgres

Relative Dates & Times in PostgreSQL

Recently I have been doing some web scraping in Kotlin, and have now got a regularly updated set of records appearing in my database. An interesting challenge arose when the scraped data was not quite as nice to work with as the web view I was scraping from. With a little front end whizz-bangery, the … Read more

Postgres Standard Deviation [Newbie Guide]

Here’s the problem we are addressing today: you have a set of numerical data returned by your Postgres query. Your numbers look alright, but some very high (or very low) values seem to be throwing things out of whack. What you’d like to do is eliminate the outlying values from your result set, and keep … Read more