innovative data solutions
+44 (0)845 521 0015

Database Topics

» Database Design
» Rapid Application Development
» Data Across Multiple Sites
» Technologies
» Support
» Training
» Agile Development
» Data Manipulation
» Software Communication
» Image Management
» Rapid Prototyping
» Security
» Data Protection Act

Technologies

FileMaker and MySQL

At Linear Blue, we predominantly work with two key database technologies, FileMaker and MySQL. We believe in using the right tool for the right job.

FileMaker gives us a platform on which to design and develop desktop based solutions that can cover everything from marketing management through to Sales Order Processing and Customer Relationship Management. FileMaker is an ideal platform for this type of solutions for many reasons, not least of all because it allows for rapid interface development and scalability.

FileMaker Development

• Cross platform: Windows and Macintosh OS X
  
  
• Scalability: Single user to 999 concurrent users, per server.
  
  
• Capacity: A single file can store up to 8 Terabytes of data, with 125 files per server.
  
  
• Connectivity: With full support for XML, XSLT, PHP, SQL/ODBC, JDBC, in conjunction with all standard data formats i.e.: csv and Excel
  
  
• Direct SQL integration: Microsoft SQL, Oracle and MySQL
  
  
• Industry Compliance: Ms Windows XP and Vista - Ms Server 2003/2008 certified
  
  
• Industry Compliance: Macintosh OS X and OS X Server - 10.4 and 10.5 certified
  
  
• Remote Access: Certified for Citrix and Ms Terminal Service compliance.
  
  
• Integration with Microsoft Office support
  
  

For more information, please visit the FileMaker web site.

MySQL Development

When designing web sites with interactive content, we need to build a database behind the scenes to store the content or for somewhere to store orders on an e-commerce solution. For this we use MySQL, an industry standard SQL database engine. MySQL gives us a powerful database back-end, with seamless links (through PHP) to our websites. MySQL is now the most popular database engine used on the web worldwide. This is, in part, due to its power, flexibility and ease of web integration; along with its low cost of ownership (free in some cases) and compatibility with ISP hosting sites. Some of the key features of MySQL are -

• It can support large doatabases of 50 million rows or more.
  
  
• Libraries for accessing MySQL databases are available in all major programming languages with language-specific APIs (allowing for smooth integration with web languages.)
  
  
• Fast performance combined with high reliability allows maximum uptime for your solution.
  
  
• No licensing costs, meaning cost effective deployment of solutions.
  
  
• Large and established community meaning that systems and processes have been refined and honed to make them as efficent and robust as possible.