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

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 →

Bulk Upload custom posts to WordPress

WordPress is a flexible CMS and allows to manage a large number of posts that doesn’t limit users to regular “posts” and “pages” types of content through the use of custom posts. WordPress also has built-in post import tools using… Continue Reading →

Spatial indexes to speed coordinate-based searches

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 →

Composite indexes – When should you use them in MySQL?

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 →

Beyond SQL. Benefits of MongoDB and NoSQL databases

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 →

© 2017 IMELGRAT.ME — Powered by WordPress

Theme by Iván MelgratiUp ↑