IMELGRAT.ME

Resources for Developers

Category

Database

On this page, you will find posts about managing and taking advantage of a database, schemas, tables, queries, reports, views, and other objects. 

 

Left, Right or Cross? Different types of SQL joins explained

Share this article:

When working with databases, SQL joins (Structured Query Language table joins) are used to combine rows from two or more tables, based on a related set of columns between them. In this article, we’ll take a look at the different types… Continue Reading →

Share this article:

Spatial indexes to speed coordinate-based searches

Share this article:

Search operations in databases are usually optimized using indexes as well as careful data modeling. This is also true for coordinate-based databases by using spatial indexes. Optimizing spatial searches is possible with the aid of a great variety of multi-dimensional… Continue Reading →

Share this article:

Composite indexes – When should you use them in MySQL?

Share this article:

What are composite indexes? Database engines (e.g. MySQL, PostgreSQL, etc.) can create composite indexes on table data. That is, indexes on multiple columns at once, instead of indexing a single column. For instance, MySQL allows indexes of up to 16… Continue Reading →

Share this article:

Beyond SQL. Benefits of MongoDB and NoSQL databases

Share this article:

MongoDB (derived from humongous) is a cross-platform, high performance, high availability, and easy scalability document-oriented database. MongoDB is released under a released under a mix of the GNU Affero General Public License and the Apache License. Classified as a NoSQL… Continue Reading →

Share this article:

© 2018 IMELGRAT.ME

Theme by Iván MelgratiTop ↑