All Your Database Are Belong to Us

Coding Blocks

Part one of our two part database podcast starts with choosing the RDBMS (Relational Database Management System) and what to do when you run into deficiencies in that particular database system.

First and foremost, what's with the title?! Are these guys grammatically challenged? If that was your first thought, then you should check out this link:http://en.wikipedia.org/wiki/All_your_base_are_belong_to_us

Others who have been around a little while (longer than us three 21 year olds), we hope you got a kick out of the title.

Podcast News

• Article on creating a database schema for a product catalog:http://www.codingblocks.net/programming/database-schema-for-multiple-types-of-products/
• Article from Eric ClippertWhy Dynamic Languages are Hard to Maintain
• We'll be attending Atlanta Build Guild, Monday July 14thhttp://atlanta.buildguild.org
• MVC vs Webforms question from @brocbeat https://twitter.com/brocbeat/status/486221052108742656
• We always keep detailed show notes @RajSoTweet
• Joe's latest gaming obsessionDivinity Original Sin
• Steam Streaming
• Discussion about our experience with the Xamarin Meetup we attended a couple weeks ago
• Hosted by Bluetube, Inc. - excellent content
• Roger Peters @smartyp - excellent presentation of how he took an app from Java on Android and ported it to Windows and iOS with XamarinWord Search Little Books (search in your preferred app store)Matchingo (search in your preferred app store)
• Bluetube Inc will be hosting their first Xamarin meetup in Cincinnati, OH this Tuesday, July 15thhttp://blog.bluetubeinteractive.com/2014/06/inaugural-cincinnati-xamarin-mobile-net-users-group-meetup-july-15th.html
• We have 14 ... COUNT EM...14 FIVE STAR REVIEWS in iTunes!!! While we're thrilled, more would make us even happier! Please do leave us a review in iTunes here:http://www.codingblocks.net/itunes
• Special thanks to PJR_ATL and a3electroniks for our most recent iTunes reviews. We really do appreciate them.

Topics

• How much should a developer know about databases in general?
• How do you pick a database when you're starting a project?
• MySQL
• PostgreSQL
• http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
• Microsoft SQL Server
• Oracle
• DB2
• No SQL databases
• Do you hack solutions to deal with the deficiencies of the particular database system you chose?
• Trees and hierarchies in various RDBMS engines
• Joe Celko's SQL Trees and Hierarchies book
• Nested Set Model on Wikipedia

Resources

• Need to know your IP Address?WtfIsMyIp.com
• Excellent book on understanding all the intricate details of C# 5 the languageC# 5 Unleashed
• Notepad++ Poor Man's T-SQL Formatterhttp://notepad-plus-plus.org/http://architectshack.com/PoorMansTSqlFormatter.ashx

Tips of the Week

• Joe's tip - SQL SearchRedgate's SQL Search
• Allen's tip - Ctrl + , for Navigate Tohttp://visualstudiomagazine.com/articles/2014/02/01/6-top-tips-for-visual-studio-2013.aspx
• Michael's tip - HTML 5 game creatorhttps://www.scirra.com/construct2