This is a baller gist of common useful Postgres queries.
You know you have to query last month’s records all the time (instead of the last 30 days). Here’s how to get those numbers easily with Carbon. We do the extra fancy footwork for the end of the month to avoid simply getting the same last date of the month for the previous month.
If your query is forcing the db to search through millions of rows to fetch data, indexing a table can help improve performance. Here’s how to do it on Postgres. ELI5 Index If you’re actually five you probably haven’t seen Library indexes, but it behaves the same way. Instead of searching through each and every … Read more
If you need to pair down your main js file and want to check what packages are eating up the size, BundlePhobia is a great resource to use. While there are several other tools including CLI tools for discovery, BundlePhobia makes it easy to just search and browse. If you have another way of managing … Read more