1 day agoBest practices for storing passwords securely in a databaseThis is the 4th post in a series on MySQL performance. A hacker can also read passwords if you can. Adobe suffered a data breach that affected at least 38 million users in October 2013. Three million encrypted customer credit cards and login credentials for an unknown number of users…Sql7 min read
2 days agoUnderstanding MySQL JoinsThis is the 3rd post in a series on MySQL performance. An SQL query walks into a bar and sees two tables. He walks up to them and asks “Can I join you?” — Source: Unknown The join operation transforms data from a normalized model to a denormalized form that…My SQL5 min read
2 days agoOptimizing MySQL performance by using EXPLAIN — Query Execution PlanThis is the 2nd post in a series on MySQL performance. The previous post discussed the types of indexes and how they help query performance. The MySQL optimizer uses several techniques to optimize SQL lookups based on your tables, columns, and indexes as well as your WHERE clause. It is…My SQL10 min read
5 days agoOptimizing MySQL performance through indexingThis is the 1st post in a series on MySQL performance. An index that makes the query fast is the most basic explanation of an index you have heard of. As an engineer whose expertise is in the application and not MySQL performance, this can be overwhelming. …My SQL10 min read
6 days agoLearn the Interpreter Design PatternThis is the 24th post in a series on design patterns. Interpreter is a behavioral design pattern that defines a grammatical representation for a language and provides an interpreter to deal with this grammar. Interpreter Design Pattern An example of the Interpreter design pattern is the Java compiler, which interprets Java source code…Code3 min read
Jun 16Learn the Memento Design PatternThis is the 23rd post in a series on design patterns. Memento is a behavioral design pattern that lets you save and restore the previous state of an object without revealing the details of its implementation. Consider that you are creating a text editor application. Apart from writing text…Code5 min read
Jun 15Learn the Iterator Design PatternThis is the 22nd post in a series on design patterns. Iterator is a behavioral design pattern that lets you traverse elements of a collection without exposing its underlying representation (list, stack, tree, etc.) Iterator Design Pattern This pattern extracts the traversal behavior of a collection into a separate object called an iterator…Programming3 min read
Jun 14Learn the Visitor Design PatternThis is the 21st post in a series on design patterns. Visitor is a behavioral design pattern that lets you separate algorithms from the objects on which they operate. Suppose you have a canvas that consists of various geometric shapes. You need to export the canvas into XML format now…Code4 min read
Jun 13Learn the State Design PatternThis is the 20th post in a series on design patterns. State is a behavioral design pattern that lets an object alter its behavior when its internal state changes. It appears as if the object changed its class. Imagine that you have a class called Order for ordering Pizzas. The…Code4 min read
Jun 12Learn the Command Design PatternThis is the 19th post in a series on design patterns. Command is a behavioral design pattern that turns a request into a standalone object that contains all information about the request. …Code4 min read
