Saki Blogs

The chicks are doing very well - some of them are a few days younger than others and not quite as bold. Hence only the one photo of Daysie with one of her 4.   Maysie has the slightly older 5 and they are rapidly becoming more of a handful for… more »

  and they talk about "a dog's life".... more »

Now that we finally have the breeding chooks that I've wanted, we're launching into breeding season.  Excess roosters notwithstanding... so far we have 6 hatched (5 surviving chicks) under one surrogate mother, and 4 hatched chicks, 2 eggs remaining und… more »

We've now come a long way since our first steps at creating our online bookshop database. Now we need to start to think about how to sell the books and store details about the sales.  This is the time we need to start understanding database transactions… more »

And got pushy, and a little bit bitey when you're slow with the food buckets - but these pigs are absolutely hilarious and the best entertainment.  (Even better now that they are too big to jump through the little chook sized hatch into the chook house… more »

In our last episode we learned how to modify data and table definitions.  This will come in handy as we look at building in referential integrity constraints into our database.  To begin we will need the database definition resulting from last episode's… more »

In our last episode we covered sorting, searching and grouping. We found out that using the COUNT(*) can be problematic when we have unexpected NULL data. Now we look at how to resolve data issues by updating the data, and perhaps even the table schem… more »

In our last episode we were able to select some information from our bookshop database, this time we look at putting this into some semblence of order.  To fully investigate this topic we need a few more entries in our database, so rather than detail th… more »

In our last episode we started building up our online bookshop database, with tables for publishers, authors, formats and books.  At the moment we only have one book in there, so before we go too far, lets add a few more: INSERT INTO `book` VALUES ( N… more »

In our last episode we found out how to connect to a MySQL server.  This time we learn how to lay out a database and start creating it. For this, and following episodes, we will be looking at creating a database to support an online bookshop. Creating… more »