The Unix operating system is the most powerful development tool. It doesn't matter if you're working with a LAMP/LEMP stack, Java, NodeJS, or SQL or any other coding language, Unix allows you to develop code and computer systems more efficiently. Developed in…
Good Data makes life easy; If we model all our the business logic in the database then the application layer is trivial. Case in point: I'm implementing a User Access Module. First I define a list of Access terms: Things like dashboard (allow view dashboard)…
If you don't diff before you commit you don't know what you're committing. When programming anything even remotely interesting, we're making changes all the time. Change, change, change. Phase 1, phase 2, experiment 1, experiment 2, etc. And we're using…
Where is everything? Where do files go in Unix? There are no bonafide rules. But we're free to invent some. So here are mine. The Heap /data - Everything starts off in this subdirectory. Consider it the Heap from which all other areas are carved out of. We're…
It is far better to have an excellent Database Design and a crappy Application Layer, than an excellent Application Layer with a crappy Database design. Why is that? Simply put, you can always skim your Application code off the top and write a new one. But you…
Somewhere someone started the tradition of capitalizing keywords in SQL. Its like shouting all the unimportant parts of the code and making what's important harder to read. SELECT b.id as book_id, a.name as author, b.pub_date as publication_date FORM books b…