I have been using Google Analytics frequently and have become impressed with the level of detail their features offer. The graph is one of my favourite tools, which helps to detect a trend with the data. The advanced segments feature is impressive, allowing you to select up to four segments, such as, new visitors, paid search traffic or non-paid search traffic, which filters through to the graph.
As the latest person to join Linear Blue I should probably introduce myself to everyone and make a start on my first blog entry here.
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.
It would be rude not to introduce myself and start blogging! I will start by telling you a little bit about myself first.
Automated server based scripts for Importing or Exporting are a great way of moving time consuming jobs away from users. Whether it is exporting a report from a complex find or generating records overnight to save the users time during the day, there are two very important things to remember.
The first thing you will want to do is download the FPDF class files from http://www.fpdf.org/ – this site is also an excellent resource for the FPDF class, if you get stuck then a look through the manual or frequently asked questions will help out no end.
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.
I have been doing quite a bit of work with smart pens recently so I thought I would drop in a quick primer on the technology.
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.
Script triggers are your best friend and worst enemy. They are great when they trigger as required but not always so good when you don’t want the scripts to run.
