IMELGRAT.ME

Resources for Developers

Tag

mysql

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:

Bulk Upload custom posts to WordPress

Share this article:

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 →

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:

Date formatting: How to Detect and convert date formats in PHP

Share this article:

MySQL and Date Formatting MySQL database engines support  a number of different date and time column formats. These can be summarized as follows: DATE – Stores a date value in the form YYYY-MM-DD. For example 2008-10-23. DATETIME – Stores a… Continue Reading →

Share this article:

Info-FICH: Faculty Information Integrated System

Share this article:

This project’s main goal is to create a Faculty integrated information system and was put forward to fulfill the Faculty’s information requirements (either specific, aggregated or statistical data). The system takes data from external databases currently and provide a growing… Continue Reading →

Share this article:

CSV exports of a MySQL or PostgreSQL query with a simple PHP class

Share this article:

CSV Exports of SQL queries CSV (comma-separated values) is the most widely supported format for transferring tabular data. That’s why CSV Exports are very common in web applications. This simple PHP class will help you get started with CSV export…. Continue Reading →

Share this article:

IAMBackup – Database Backup and Restore PHP package

Share this article:

A solid database backup strategy provides an essential safeguard for protecting critical data stored in your databases. To minimize the risk of catastrophic data loss, you should back up your databases to preserve changes performed on your data on a… Continue Reading →

Share this article:

© 2018 IMELGRAT.ME

Theme by Iván MelgratiTop ↑