Resources for Developers



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:

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:


Theme by Iván MelgratiTop ↑