I’ve recently found something relatively interesting that you can do in a bash terminal. I recently sent out an email talking about how to implement git completion’s wonderful self to work on macs. Part of that endeavor meant diving into the way that the terminal displays its information to you on your prompt. Some of the things [...]
18
Nov
MySQL – I Am a Dummy
Today I learned about an interesting command-line option for MySQL: $ mysql –i-am-a-dummy This is an alias for –safe-updates, which imposes three restrictions: Any UPDATE or DELETE that does not have a WHERE or LIMIT is rejected. Any SELECT without a LIMIT will be automatically limited to 1,000 rows in the result. Any join that would [...]
04
Jul
PostgreSQL Cheat Sheet
PostgreSQL is one of our favorite database engines for a variety of reasons. Here is our cheat sheet to help you get online and get around Postgres with minimal effort. Database Access Security Database security is handled primarily in two place, from the system service level via a file called pg_hba.conf and within the database [...]
Talk To Me...
Enter your email below to sign up for the monthly Store Locator Plus newsletter. Click the Facebook icon to get almost-daily updates on what I'm working on now. The RSS feed icon will bring my bi-weekly blog posts to your feed reader.
