Innovative Data Solutions

Tag Archive: MySQL

To celebrate our 12th Birthday, we’ve launched our new brand and website..

image-6

We’ve just taken the covers off a completely redesigned website of our own. The new Linear Blue site is based on a design by prestigious branding and design company, CaB Studios.

Synchronizing large data sets between FileMaker and MySQL

Recently we have been working on a system that requires a large amount of data to be synchronized to MySQL (for driving a web interface) from FileMaker. After a few initial tests of methods for achieving this we found that the speed of the transfer was un-acceptable due to the large amount of data being…

ESS, MySQL, views and temporary tables

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.

ESS and Surprised MySQL developers

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

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 –…