Struggling to load Arabic text into MySql 5.6
- Ensure your database, table, and column use uft8mb4 character set.
create database XXXX character set 'utf8mb4' collate 'utf8mb4_unicode_ci'; create table ( ... ) ... character set 'utf8mb4' collate 'utf8mb4_unicode_ci';
- Ensure that the data file you are loading is UTF-8 encoded.
- Run the mysql client with the binary character set.
mysql ... --default-character-set=binary ...
- Load the data with the binary character set.
loading load data local infile 'XXXX.DAT' into table XXXX character set binary ( ... );
Good Terraform and AWS tutorial
The only trouble I had with the examples was that the initial ones assume that you have IP access via the AWS default security group. That might not be the case and so you will need to use the AWS console to allow your machine's public IP address ingress. To do this, go to the AWS Console, then to the EC2 dashboard, then to the Security Groups resource, and in that dialog select the default security group and add an Inbound rule for your public IP address.
Two masters
Patreon's self-inflicted death wound
I like that the Patreon service exists, but am just now discovering what a rip-off it has been for creators. When I give $1 to a creator Patreon takes a 5% cut, which was acceptable (if high), but then Patreon charges the creator for serving the payment. The servicing cost is between between 7-15%. I had no idea that Patreon did not assume the cost of service fees as part of their 5% cut. Now they want to shift the service fee to the patron via a 2.9% fee plus 35 cents on each pledge. My $1 is now going to be $1.38 (ie 100 + 2.9 + 35)! Patreon needs to rethink this change or discover how quickly they will be replaced as an intermediary.
See Funny money, Patreon Style.
Update: Patreon responds We messed up. We’re sorry, and we’re not rolling out the fees change.
Two kinds of noise
Three tweets in 100 square inches of screen space. (Large editorial photos and illustrations do not count as content.)
Which did you read first?
- I swear that no one reads email anymore.
- Anything after the first sentence, nay the first line, is never read.
- Perhaps I should only communicate via bullet points.
The quiet crisis unfolding in software development
4 skills you need to be successful in software development
The article is a half truth. There are 4 skills you need to be successful in software development. Two of these skills are needed to be successful anywhere and they are (1) coherent written & oral communications and (2) working well with others. Any university degree will develop these skills. The other two necessary skills are (3) having broad software development experience (both re/ tasks and teams) and (4) actually knowing the foundations of computer science. A useful programmer can get by for a long time having only skills 1, 2, and 3 but a successful programmer has skill 4. Critical thinking skills alone do not design a successful system nor do they diagnose the root cause of a problem.
I have been developing software programs and software systems for 37 years. I have met lots of very useful software developers in that time. I have met only a handful of successful software developers.
I would never build a team of only useful programmers.
Running out of entropy
You check on how many bytes of entropy are available using
cat /proc/sys/kernel/random/entropy_avail
Our counts are always less than 200. That is not enough. And so my concern is that I have a system that depends on random UUIDs that does not have enough entropy and so, so as not to block, it is using math to get randomness. I don't trust math randomness.
I don't yet have the full picture yet. Hopefully I will soon.
See Check available entropy in Linux.
Update: We have deployed haveged and available entropy is always over 1,000.
Slides for your generic talks
Recently we had the generic TED talk. I think I am going to start collecting the images that seem to be used by all talks. The inaugural image is, without a doubt the most used in more slides than any other, the iceberg.Searching browser history using Google Chrome search engine
chrome://history/?q=%syou can quickly search your browser URL history by typing
Cmd-l h search-text.
Grumble about messaging conversation indistinguishability
$0.43 for Psychotherapist Barbie services
All the wonderful applications and toys that requires an internet service for operation have a very short life. Most application startups don't last two years. That great calendar extension, or small office workflow coordinator, or automatic uploaded video curation you use every day quickly becomes inert. You anxiously wait for their death. The situation for toys is even worse. Almost no toy manufacturer has had to provide service support and maintenance. Once the toy is sold, the only worry a manufacturer had was that of product liability suites. So what are we to expect as we move ever forward into the internet-of-things?
Suppose that Hasbro sells "Psychotherapist Barbie" and she needs to store years of voice recordings and to run complex voice, tone, and sentiment analysis algorithms so as to synthetically voice the appropriate response. How long is Hasbro going to operate this as the number of active customers and maintenance income dwindle?
Hasbro should not run the services. Instead, Hasbro should use the Barbie owner's own Amazon Web Services account to run them on. That is, on behalf of the owner Hasbro will provision the AWS services needed to use Psychotherapist Barbie. Once running, Barbie's owner pays for the services until he or she no longer wants to use the toy. If Barbie's owner prefers Google Cloud Services or Microsoft Azure then Hasbro would provision there instead.
We need manufacturers that sell applications and toys requiring connectivity, storage, and computation for their operation to use the owner's preferred cloud services provider. This is quite easy to do with applications or toys that are used in isolation. For applications or toys that require a network of users then the solution is a little harder as the manufacture would need to implement services that share without centralization and to scale from two users to many, or perhaps millions, of users.
I look forward to the day when I receive my monthly AWS services bill and see listed the applications and toys I use that make my life a little easier and more enjoyable.
PDFs, comments, and Dropbox
When you like commenting you want to have the space needed to comment. I seem to recall that I once forced an author to use double line spacing and an extra wide right margin so that I had room to write. That was great. When Microsoft Word added the comment bubble user-interface I did not think my commenting life could be better. I was wrong. Online collaborative commenting is even better.
Most of my documents are written using Google Docs. Docs has weak formatting and content structuring tools, but it does have great commenting (and version control). I am willing to lose a little structure and style for that. Not all documents come my way via Google Docs, unfortunately. Most of them use Adobe's PDF as authors want structure and style over commenting. Especially, it seems, those working in elementary and secondary education. Sigh.
Today I wanted to read and share my comments on RIDE's "Creating a Shared Understanding of Personalized Learning for Rhode Island," a PDF document. So I looked around the web for tools. There are a fair number, but I was happy to find that Dropbox allows for online collaborative commenting of PDFs. Just add the document to Dropbox and share it. Anyone viewing the document sees the comments and anyone wanting to add comments need only login with Dropbox or Google credentials.
Another online problem solved.
3 times a loser
Liz Gledhill nominated me and Joe Viele seconded the nomination. Since Scott received the necessary 3 winning votes my nomination was never voted on. Meg Healy, Abel Collins, and Bryant Da Cruz appointed Scott Mueller to the vacated seat.
I want to thank Liz and Joe for having the courage to support my positions and this governance rookie. I also want to thank all those people across this country that stood up for what is right over these last weeks as it was their example that inspired me to try again.
Scott was not a good choice. Healy, Collins, and Da Cruz made a politically safe choice and, moreover, a safe Democratic party choice. The ramification of their choice is that the SC is effectively the same SC as we had before the November election. An election that clearly called for change. Roland Benjamin and Alycia Collins will do their best to shift the SC's focus towards, I am guessing, finer budget control and reducing the barriers that obstruct educating all of our children. The other 5 members and the Superintendent will continue as they always have. The brazen submittal to the TC of a school budget that increases spending by double the State mandated limit clearly shows that they are not adequate to the task of their responsibility. Shame on them. And shame on the TC for not listening to SK's voters.
Universal health-care is great for business
I can tell you what would be great for business in the United States -- universal health-care. Those with great ideas for new businesses can take the risk of losing their savings, but not their lives or those their children. Businesses can compete globally unburdened from the financial and moral sole provision of the health of their employees and their families. Businesses can hire the best from across the country because they are not encumbered by the 50 different state health insurance regulations and limitations. Lastly, and most importantly for those with little hands, little minds, and little care for others, billions of dollars of increased shareholder value.
Let a 1000 flowers bloom and 300 million people breathe easier each and every day.
Too much kit
I think what bothers me about these games is that there are too many parts that must be had. To play a dark ages games using the SAGA rules each player must have the faction's "battle board" and their customized dice. To play an ancients game using the Aurelian rules each player needs to have its deck of cards and the unique tokens. These kit are not cheap. For SAGA the rules are $30 and 2 sets of dice are $36 for a total of $66 before playing the first game. For Aurelian the rules are $29 (PDF) and 2 sets of cards are $40 (or, if you print them yourself, $20 in inkjet ink and $10 in sleeves) for a total of $69 (or $59) before playing the first game.
I don't think my aversion is to the cost, our hobby is expensive, but there is ample difference between a high entry cost vs a moderate ongoing cost. Clearly that is where my mind is. I believe that to play a wargame it must be enough to simply have a copy of the rules, figures for both sides, a few rulers, several generic dice, and some generic tokens.
South Kingstown School Committee
I ran for South Kingstown School Committee this past November and so this blog has been quiet as I worked on my campaign. My online campaigning was on Facebook as it gave me the broadest reach into the community and the community an easy way to find me and to keep current. Here is a complete capture, I think/hope, of my postings and comments.
Update: I pulled the better postings into A chronological selection of Andrew Gilmartin’s posting made during his 2016 run for School Committee.
