Joins are very useful in a lot of ways. If you are here, you most likely know about and use them. Eloquent is very powerful, but it lacks a bit of the "Laravel way" when using joins. This package make ...

Before Donald Trump became US president and the UK left the EU – both arguably the result of a new kind of online politics – a rather nervous-looking Mark Zuckerberg shuffled out onto a Harvard ...

A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...

Elasticsearch is an open-source, distributed JSON-based search and analytics engine built using Apache Lucene to provide fast real-time search functionality. It is a NoSQL data store that is ...

Need help choosing the best Python ORM for your projects? Here's what you need to know about SQLAlchemy, PonyORM, Django ORM, Peewee, SQLObject, and Tortoise ORM. When you want to work with a ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

See how to join two data sets by one or more common columns using base R’s merge function, dplyr join functions, and the speedy data.table package. R has a number of quick, elegant ways to join data ...

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs. SQL Server developers must understand two things: the difference ...