Dat601 / projects

Transact SQL

design-busting-mistakesI have been cutting my teeth the last couple of weeks of Python’s MySQL API. It has been a lot of fun and now have a reasonably nice couple of OO-scripts that can be used to psuedo-randomly populate our Electric Imp database. By making a direct connection to a MySQL db and using the datatypes class that I defined, it can quickly populate the db with hundreds of rows. It is pretty cool. However, it is still buggy. In particular, there is a whole lot of integrity constraints on the data that need to be built into it.

 

Yesterday, Todd pointed me towards Transact SQL. This looks like it will do everything my Python script does – better! 😦 So it’s out the window with the python and in with T-SQL. I have busted my rump on that Python script as well 😦 But it is ok – it was all about exploring anyway and this just gives me something else to investigate. explore

Thank goodness for an inquisitive mind (and not much of a life :P)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s