Rietta
Rietta: Web Apps Where Security Matters
You are reading The Rietta Blog, a publication about the web since 2005.

SQL Converter 2 for Excel Website Update

From My Company’s Homepage:
Rietta is proud to announce that we have updated the website for SQL Converter for Excel at www.sqlconverter.com. Next year is the 10th anniversary of the initial public release of the program.
I originally wrote the Excel add-in that converts Excel files to MySQL while a student at Georgia Tech as a Visual Basic macro. Over the last nine (9) years it has been used by hundreds of customers in many industries, including by many small businesses, several publicly traded companies, government agencies, and educational institutions.

The current version is still a macro that works fine with Microsoft Excel for Windows, but it is time to build a solution that works for more platforms, including my personally preferred Mac OS X and Linux systems. To this end, we are currently working on a web-based service to provide cloud-based spreadsheet to database conversions.  However, the first step towards deploying the new service is migrating the current infrastructure to Ruby on Rails.

The original sqlconverter.com website was written in PHP and hosted on a typical shared Linux server environment, but the new one is entirely in Ruby on Rails 3.1. We setup the routing such that the old URL structure was maintained for search engine optimization (SEO) purposes. We also implemented canonical links to avoid duplicate content penalties due to the pages being accessed through more than one path. One of these days I should write a bit more about the tricks employed.

If you routinely work with spreadsheets provided by customers or team members and need to get that data into a MySQL database for your projects, please check SQL Converter out.  Also please feel free to let me know if you have any questions about it!

About Frank Rietta

Frank Rietta's photo

Frank Rietta is specialized in working with startups, new Internet businesses, and in developing with the Ruby on Rails platform to build scalable businesses. He is a computer scientist with a Masters in Information Security from the College of Computing at the Georgia Institute of Technology. He teaches about security topics and is a contributor to the security chapter of the 7th edition of the "Fundamentals of Database Systems" textbook published by Addison-Wesley.