IMELGRAT.ME

Resources for Developers

Tag

postgresql

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 →

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

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 →

© 2017 IMELGRAT.ME — Powered by WordPress

Theme by Iván MelgratiUp ↑