Programming Craftmanship
I'm looking to replace our Magento Ecommerce Server with something "Nice" - Something that is not complicated, not over abstracted, something that is well ... fun to work with. Saleor is an elegant solution. It is an Ecommerce app written in Python and Django…
The Database, Config and Logging are at the core of all application development. Everything starts there. A Database System stores all of the applications data. The storage itself can be anything from a loose collection of files like jpegs, a nosql db like…
Let's standardize how we write SQL. What joy. Rarely, have I seen consistency in how SQL is formatted, and often it is not even considered. Here is the standard I use which makes it easy to read both simple and complex queries. Here is an example: select b.id…
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…
CSV files can be used on the Unix command line like database tables. grep can act as a where-clause, and awk can be used as column selector. However the csv utility from vbin makes it easier. Here it is. $csv -p books.csv id, isbn, name, publicated, type 1…