July 14, 2014

All Your Database Are Belong to Us

59 minutes

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 Clippert
Why Dynamic Languages are Hard to Maintain

We'll be attending Atlanta Build Guild, Monday July 14th
http://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 obsession
Divinity 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 Xamarin
Word 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 15th
http://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 language
C# 5 Unleashed

Notepad++ Poor Man's T-SQL Formatter
http://notepad-plus-plus.org/
http://architectshack.com/PoorMansTSqlFormatter.ashx

Tips of the Week

Joe's tip - SQL Search
Redgate's SQL Search

Allen's tip - Ctrl + , for Navigate To
http://visualstudiomagazine.com/articles/2014/02/01/6-top-tips-for-visual-studio-2013.aspx

Michael's tip - HTML 5 game creator
https://www.scirra.com/construct2

...more

View all episodes

By Allen Underwood, Michael Outlaw, Joe Zack

4.9

931931 ratings