Resources for Developers



Composite indexes – When should you use them in MySQL?

Share it!

Share it!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… Continue Reading →

Share it!

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

Share it!

Share it!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… Continue Reading →

Share it!


Theme by Iván MelgratiTop ↑