In this blog series, I'm describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, and how this was improved in recent releases. In InnoDB Data Locking - Part 1 "Introduction" I’ve introduced basic concepts required to understand current post: databases, tables, rows (like files on a shared drive, spreadsheets inside a file, and rows inside a spreadsheet) serializability of transactions (ability to explain states observed over time with a convincing story about relative order of parallel operations) timeouts (for misbehaving lock owners, and to resolve deadlocks) reader-writer lock (shared/exclusive access rights) starvation (permanent inflow of readers starving a writer waiting for its turn) queueing (FIFO, or priority) read views (read-only snapshots which allow stale reads concurrent to new writes) granularity of a lock (access right to everything vs.…

Corporate culture permeates throughout an entire organisation. It can be your best advertisement or, if the culture and behavior are not in line with best

Vector resources are a designer’s secret sauce, they’re the special ingredients that help you cook up quality artwork in no time! When you’re working against tight deadlines, being able to select ready-made elements when constructing your designs can be a life saver. It also opens up the possibilities for producing completely new art styles, which […] The post Work Faster and Smarter with this Extensive Vector Elements Collection appeared first on Spoon Graphics.

Unless you've worked with WordPress themes before, it can be difficult to be confident you're making a good choice. There are so many to pick from, that trying to find the best of the bunch can be overwhelming. Here's a two-step process that will lead you to a choice you'll be more than pleased with; […] The post 14 Amazing WordPress Themes to Use in 2017 appeared first on Line25.

Making a complete website wireframe is supposed to be a simple task. But, starting from scratch without a template or quick-start guide can be a nightmare. It takes significant work to make wireframe look beautiful, as well as being optimised for functionality. Especially when you have to create a wireframe to get a client's approval, […]

A concept for a kinetic typography based page transition where background letters come into the foreground and reveal a new content level. The post Kinetic Typography Page Transition appeared first on Codrops.

Like a lot of companies, Johnson & Johnson once relied on a style guide to make sure designers used approved language and components. Style guides can still help brands enhance their UX, but they don't always match the needs of larger companies. Newer technology also makes it possible for smaller enterprises to move from style The post How to go from a style guide to a design system appeared first on Studio by UXPin.

With Service Studio that gives Mac, OutSystems is giving users the same experience that until now was exclusive to PC users as Apple's Mac is slowly gaining market share. The new IDE for Mac also includes new features and capabilities such as new themes for a refreshed and modern look and feel, Dark Mode, and … continue reading The post SD Times news digest: OutSystems releases Service Studio for Mac, Melissa announces Global Green Initiative, Apache weekly update appeared first on SD Times.

Is IT an art or a science? Practitioners seem to be happy leaving questions like these to philosophers. We do like numbers though. Basically, we like to count things. We count users, lines of code, errors, dollars and, one of the coolest things to count, people. We can calculate how many people are needed on … continue reading The post The Fungible Fallacy: Structural impediments to effective project management appeared first on SD Times.

Creating a compelling website ad copy is just the beginning. To create an effective and long-lasting relationship with your prospects, you need to use the right colors. 85% of shoppers place color as a primary reason for why they buy a particular product. Besides, color increases brand recognition by 80%. Before I start discussing the...