ESS, MySQL, views and temporary tables
December 14th, 2009
I am continuing to work on an ESS integration project and one of the biggest issues is speed when dealing with large record sets from MySQL.
Archive
Posts Tagged ‘MySQL’
ESS and Surprised MySQL developers
October 27th, 2009
I had a conference call with a client, one of their biggest customers and the customers’ developers the other day. Both the customer and my client are having new systems written (my client in FileMaker, my client’s customer in MySQL and, i guess, HTML) and they are both keen on integrating stock figures.
SQL Joins
October 21st, 2009
When writing a PHP based site – developers often also have to integrate with a database (otherwise the site tends not to be very exciting!) and a popular technology for this is a flavour of SQL. Rather than go through the basics of database queries using SQL (which if enough people ask me for – I certainly will do in the future) I have decided to write specifically about the mechanics of the JOIN command. The SQL Join command allows us to pull and combine data from two or more tables, where the result can be modified by specifying different data relationships between the tables.
