Welcome Canadian Viewers


First time Canada has topped my stats on daily views... Welcome Canadians!

Comments

Post a Comment

Popular posts from this blog

Development : Python, MySQL and Protocol Buffers Build

Today I've come to a totally virgin installation upon a server, this was for a work group I've got to head up whom are looking at pushing MySQL with Python.  And things initially went wrong... I stipulated they had to use Python3 and thought everything else would be fine for them to install with Pip3, so... sudo apt-get update sudo apt-get upgrade sudo apt-get install python3 sudo apt-get install python3-pip sudo apt-get install mysql-server Everything looked fine, their user could install packages through Pip3 and they had Flask and a few other things and were flying.  I used the mysql client on the command like to test I could add a few items and also ran... sudo mysql_secure_installation To do the basic hardening of the database, so everything was fine... Right?....RIGHT?!?! No, not exactly....  "I can't get mysql.connector" .... Came the cry. And they were right, it reported a myriad of build issues and could not install.  I took a look... NIGHTMARE! It appear...
Read more

Development : The Cathedral & The Bazaar

Recently I had to explain to a none-developer how we had been working on a project, that is to say he and I.  I explained that our common boss worked very much in terms of the Cathedral, everything is big, grand, old, with set sources for supplies and almost dogmatic adherence to their ways of working.  Whilst he and I had been working, with extraordinary success, in a much more agile manner, in the manner of the Bazaar. Anyone could bring items to us, he could filter some queries, I could filter some others, between us we then worked in an Agile manner to achieve a result. I myself ran the development, and I pushed builds, lots of builds, releasing at least twice daily.  Any problem was picked up, worked on, solved and the next build had it, leaving a train of progressively better builds step by step, until we sit today with a fully functional system and we await input from multiple other sources. The main source for things we are awaiting is the Cathedral, we have ...
Read more

Development : No Great Shakes at SQL

I was just handed a technical test, this was for a job interview, and I was a little... well I'll say surprised, but then shocked, by the reply, lets take a look... I was handed these SQL statements, in several questions, and then told to summarise what I should see on any output of the various instructions.... create table customers (id INTEGER PRIMARY KEY, name Text, age INTEGER, weight REAL); insert into customers values(73, "Brian", 42, 33); insert into customers values(1, "Helen", 12, 12.5); select * from customers; SELECT name, CASE WHEN age > 18 THEN "adult" ELSE "minor" END "type" FROM customers; create table orders (id INTEGER PRIMARY KEY, customer_id INTEGER, desc TEXT); insert into orders values (0, 73, "Apples"); insert into orders values (1, 73, "Oranges"); insert into orders values (2, 1, "Bananas"); select * from orders; SELECT customers.name, orders.desc FROM customers JOIN orders ON ...
Read more