Laravel Eloquent Select Column as Alias

I like to use select statements to return specific columns. But I was happy to find out that you can alias your columns just like in sql. Which can be make things a breeze, depending on what you are doing. Remember to use the dot syntax to specify a table for joined columns with the … Read more

Postgres Delete Duplicate Rows

This query is to delete duplicate rows on multiple selected columns for Postgres. Just plug in the table_name and columns you want to evaluate duplicates on. This query is the fastest out of several I’ve tried, evaluating and deleting 5 million duplicate rows on 8 columns in about 20 seconds.