To generate an SSL private key for use with MySQL/MariaDB and PDO:
openssl genrsa -out client-key.pem 4096
Category Archives: Programming
NetBeans red line
There is a feature of NetBeans where it puts a red line as the right margin in the code editor. By default this margin is at 80 characters but I prefer it at 99 characters. To change the setting in NetBeans see Tools -> Options -> Editor -> Formatting -> All Languages -> Tabs And Indents -> Right Margin. For example:
Everything you need (and don’t need) to know about PHP’s type system
I read Everything you need (and don’t need) to know about PHP’s type system, it was interesting. My favourite quote was at the end:
“I believe php’s type system is incredibly rich and carries many innovative and legacy features and they all make much sense when you look at the history of the language development.”
Axiomatic CSS and Lobotomized Owls
Today I learned about the “Lobotomized Owl” CSS selector over on Axiomatic CSS and Lobotomized Owls.
Things I Wish I’d Known About CSS
Today I read Things I Wish I’d Known About CSS. Good read about how some fundamental CSS things work.
Ten modern layouts in one line of CSS
Today I read Ten modern layouts in one line of CSS about advanced contemporary CSS features.
Lighthouse
I might be a little behind the times here but I learned about Lighthouse today. It’s from Google, which is regrettable, but I might check it out some time.
Programming Quotes
I came across these Programming Quotes over on cat-v.org today. Their Bumper-Sticker Computer Science is also good.
My favourite was “You can’t trust code that you did not totally create yourself.” — Ken Thompson
The End of OS X
Today I read The End of OS X. I particularly liked the bit about the Unix philosophy:
- Make each program do one thing well. To do a new job, build afresh rather than complicate old programs by adding new “features”.
- Expect the output of every program to become the input to another, as yet unknown, program. Don’t clutter output with extraneous information. Avoid stringently columnar or binary input formats. Don’t insist on interactive input.
- Design and build software, even operating systems, to be tried early, ideally within weeks. Don’t hesitate to throw away the clumsy parts and rebuild them.
- Use tools in preference to unskilled help to lighten a programming task, even if you have to detour to build the tools and expect to throw some of them out after you’ve finished using them.
MySQL Table Locking Issues
Today reading about MySQL Table Locking Issues. Of particular interest were the HIGH_PRIORITY and SQL_BUFFER_RESULT SELECT Statement options.