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 →
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 →
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 →
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 →
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 Melgrati — Up ↑