I am familiar with the most popular database flavours on the internet (MSSQL and mySQL) and have done some work with PostgreSQL, Access and Oracle.
There’s something quite retro about SQL which I find appealing. I alwasy try to organize code so that most of the data manipulation is done in SQL in stored procedures, and SQL calls are minimized.
Projects
- The Communicator Data Extraction project involved fetching registration data from a remote third party API and storing it in a local database for the data analysis team to work with.
- The Motorola Interim DB was a database solution we designed to help Motorola centralize their global user registration data, which was currently scattered amongst a variety of data providers, with an API to allow a variety of interested parties to obtain the data.
- The database behind myCokeMusic was huge, and required judicious indexing.
- In all the other projects databases were used to hold user registrations, highscore tables, or site content.
