relational databases are often a good fit for any data that is regular, predictable, and benefits from the ability to flexibly compose information in various formats. Because relational databases work off of a schema, it can be more challenging to alter the structure of data after it is in the system. However, the schema also helps enforce the integrity of the data, making sure values match the expected formats, and that required information is included. Overall, relational databases are a solid choice for many applications because applications often generate well-ordered, structured data

querying language called SQL, or structured query language, was created to access and manipulate data stored with that format

Relational databases: working with tables as a standard solution to organize well-structured data

database schema is a description of the logical structure of a database or the elements it contains. Schemas often include declarations for the structure of individual entries, groups of entries, and the individual attributes that database entries are comprised of. These may also define data types and additional constraints to control the type of data that may be added to the structure

Network databases: mapping more flexible connections with non-hierarchical links

Hierarchical databases: using parent-child relationships to map data into trees

Hierarchical databases are not used much today due to their limited ability to organize most data and because of the overhead of accessing data by traversing the hierarchy

The first flat file databases represented information in regular, machine parse-able structures within files. Data is stored in plain text, which limits the type of content that can be represented within the database itself. Sometimes, a special character or other indicator is chosen to use as a delimiter, or marker for when one field ends and the next begins. For example, a comma is used in CSV (comma-separated values) files, while colons or white-space are used in many data files in Unix-like systems

Some advantages of this format

While flat file databases are simple, they are very limited in the level of complexity they can handle

One of the earliest interactions with a customer is to signal a lack of trust. The bartender is suggesting the customer will leave without paying.

I think many business owners do not consider the subconscious effects on how they manage their business

In another example, there is a plaza near where I work that has a number of eating options but my preferred is a sandwich place at the far end of the building. When I pull in I often look for parking in front, if there is not I might need to go to the opposite end of the plaza to find parking. While walking to the sandwich shop I pass by 3 other places to eat. I almost never make it to the sandwich shop. I always convince myself to try something different before getting to the front door of my go-to lunch spot

the experience his customers have while visiting him was very important to him and it started when they pulled into the parking lot. In his view, they should have front row parking

"Secrecy is the first law of Magic" - from Julia Cameron's Artist's Way.Talking about your project seems to spread your energy in every direction other than towards completion.

Four different tests of 63 people found that those who kept their intentions private were more likely to achieve them

W. Mahler found that if a person announced the solution to a problem, and was acknowledged by others, it was now in the brain as a “social reality”, even if the solution hadn’t actually been achieved

Announcing your plans to others satisfies your self-identity just enough that you’re less motivated to do the hard work needed

Pretty much the same things as the engineering blog, but make sure to skim through the “Issues” section to see if you can find anything else interesting.

What projects/products have they developed recently? And more importantly, what led them to build these things? What business challenges or goals drove the project? What technical challenges drove it?

The list of product(s). Is there anything similar you’ve worked on that you can show you understand the business problems and domain? Anything similar you’ve worked on where you helped make UX and/or feature decisions (where you stepped outside your developer-world bubble?). Anything similar that you had to develop a unique technical solution for? You want to show you can understand the business/product side of things and translate that into technical solutions. List of customers (company’s love to list customer logos!). While on the surface this might not seem that helpful, it can actually provide helpful information. Is there a particular type of customer they have that you have developed solutions for before? (i.e. – government, insurance, etc). Any specific customer you have built products for before? News section. Companies will often talk about new customers, recent acquisitions, and new product developments here. This will give you a sense of where the company is headed and is really useful to bring up in interviews as it shows you have an understanding of the current state of the company.

Things to look for are: What are recent things they’ve worked on or tools they’ve built? What are things they’re working on now? Projects/products/etc What projects/products do they mention that you would be working on? Do they mention any specific technologies you have experience with (not Node/React etc, but for example, performance testing tools -> this suggest they have a lot of traffic and they need to profile their services, something that you would be a good fit for if you have this experience) Anything they explicitly mention they need help with? Sometimes job posting will say things like “We just had a huge increase in users and need to hire another developer to help us re-architect some of our core services”.

At a very high level, it is:

The job search process is a sales process – one in which you are selling your skills and experience

Anki seems more common among software engineers

Engineers are creatures of habit. Make reviewing your flashcard app your first work task (or the train, the toilet right before Candy Crush). Stop StackOverflowing "how do i amend my git commit" five times every month.

Outside of medical students and language learning apps like Duolingo, spaced repetition isn't common. It's not as cool as cramming, but it works. Medical students use it to memorize those awful thousand page textbooks. Duolingo uses it because it's effective

But Why Option 3?

Spaced repetition is a remembering technique that will remind you concepts at spaced intervals to maximize memory retention efficiently

in SM, learning and remembering are blended into one: you read (learn) and review (remember) at the same time. Incremental Reading is essentially “spaced repetition-ing” your reading

Learning = reading and understanding new things Remembering = memorizing what you learned

75 countries already using the technology

However, if you believe that you are indistractable, you empower yourself to respond more healthily to whatever distractions get in your way

identity pact is another way to change your response to distractions. Your self-image has a profound impact on your behavior

price pact puts money on the line. If you stick to your intended behavior, you keep the cash. If you get distracted, you forfeit your funds

effort pact is a kind of precommitment that involves increasing the amount of effort required to do something you don’t want to do

you can take back your smartphone in four steps

The right approach is to ask whether the external trigger is serving you, or whether you are serving it

research shows that ignoring a call or message can be just as distracting as responding to one

After all, the most important people in your life deserve better than the leftover time in your day

Go ahead and scroll through social media, but at allotted times

Turn your values into time

Don’t pick your goals, pick your values

“leaves on a stream” method. Imagine yourself beside a stream, on which leaves gently float by. Place each thought and negative feeling in your mind on one leaf and watch them float away

You can’t control how you feel, but you can learn to control how you react to the way you feel.To start, you can change how you think about the bad feelings that can lead to distraction.

The truth is, we overuse video games, social media, and our cell phones not just for the pleasure they provide, but because they free us from psychological discomfort

The opposite of “distraction” is “traction.” Traction is any action that moves us towards what we really want. Tractions are actions, done with intent.

distractions aren’t necessarily your fault, they are your responsibility

People who frequently consume artificially sweetened drinks biologically look 5-10 years older compared to those who don’t

3 lessons in branding

16 MOOCs offered by the University of Pennsylvania through a company called Coursera. They found that completion rates averaged at around 4 percent.

The UT System invested $5 million in edX and committed to spending another $5 million on course development. It was in good company; Harvard University and the Massachusetts Institute of Technology had each ponied up $30 million to launch the service. Rice University, Texas’ elite private institution, also partnered with edX.

Some of the best and most affordable premium laptops on the market are now shipping with Linux pre-installed. More specifically they’re shipping with Deepin

Segway was $5,000 at launch in 2001, which is a whopping $7,248 in inflation adjusted dollars. Here in 2019, cheap $200 to $300 electric scooters are basically the transformational technology the Segway was supposed to be, aren't they

Did I mention there's a bluetooth connection, and an app, and it is possible to hack the M365 firmware?

There are some challenges with electric scooters, starting with the biggest one: your local government has no idea how to regulate the darn things.

46% of Uber's rides are under 3 miles

What killed the electric scooter back then is the same thing that killed the electric car of year 2000: terrible lead-acid battery technology

it's not that there are new vulnerabilities that have been identified in the implicit flow, just that PKCE offers a more secure alternative that you should use if you have the option

PKCE (which stands for "Proof Key for Code Exchange" and is pronounced "pixie") was originally developed to solve a problem specific to native mobile apps using OAuth 2.0

While this has worked and continues to work for a wide range of web applications, security experts had (and continue to have) concerns that it leaves open some potential attack vectors

click a button that says "Sign in with GitHub." I am then sent to GitHub to sign in and, if this is my first time, grant permissions

If eating more realistic fake meat was about health, the offerings would be far lower in salt content, contain fewer calories and have a bit less dietary fat. None of them do, because the point was never to live up to the marketing of healthier eating. It was to simply act as a smooth replacement for the meat we worried about eating in our day-to-day lives

Most of us don't truly understand how to feed ourselves in a way that doesn’t leave us susceptible to life-threatening illnesses

excessive amount of salt in one's diet has been linked in several different ways to heart disease

Heart disease and cases of type 2 diabetes are on the rise, no matter where you look, and research has suggested that cutting red meat and processed meats (like bologna and other deli meats) might help people facing these conditions

In fact, when you start to compare all of these offerings to their meat-based counterparts, you realize it’s the same story no matter what brands you’re talking about — you might possibly save a few calories or carbs, but you'll probably get way more salt.

By nine to ten years of age, children’s sensitivity to the distinction between sarcasm and verbal irony highlights their impressive understanding of how people’s feelings are affected by others’ speech

these signs will help you prevent burnout before it starts – or work to fix it if you need a way out.

People who feel burned out at work find their home life is more likely to suffer too. This may be because when jobs get more demanding, people put more time and resources into them, often at the expense of their private lives.

57% reported feeling like they need to check in with work – even when they are on vacation

these symptoms suggest that you may be more than stressed:

when the feeling of being completely overwhelmed at work persists, it can spiral into burnout – a growing epidemic with serious consequences for your health and your career.

XMATCH which has a similar signature to XLOOKUP but returns the index of the matching item. XMATCH is both easier to use and more capable than its predecessor MATCH.   XMATCH(lookup_value,lookup_array,[match_mode],[search_mode])

While VLOOKUP was widely used, it has several well-known limitations which XLOOKUP overcomes: 

XLOOKUP(lookup_value,lookup_array,return_array)   lookup_value: What you are looking for lookup_array: Where to find it return_array: What to return

you don’t have to learn alone. In fact, it is the uniqueness of the people with which you learn and the discussions you have together that make what you learn unforgettable

being able to communicate what you’ve learned is one of the main skills that differentiates a good developer from a great one (IMHO).

When facing procrastination, think of process over product. I often procrastinate when I’m overwhelmed by the thought, “Ok, I have to get X done”. Instead, it can be beneficial to think, “Ok, I will spend an hour on X” — which isn’t overwhelming, doesn’t require a long breakdown of tasks, and gets me started (90% of the battle)

Know when to apply a particular concept is as important as knowing how.

Spread it out over many sessions and over many different modes of learning.

test yourself as you’re encountering new material. Recall is a simple example of this mini-testing.

taking a couple minutes to summarize or recall material you are trying to learn

Recently, I found this great application called Highly (you should use this!). They make it really simple to highlight any article that I’m reading on the web using a Chrome extension.

Highlighting or underlining are also techniques that often lead to this illusion of learning. On the other hand, brief notes that summarize keys concepts are much more effective.

First, survey and priming — this involves scanning a book or the syllabus of a course, for example, to get a general idea of the bigger picture. Second, observe an example. Then, do it yourself. And, finally, do it again and again in different contexts.

take breaks, meditate, think about other things, and give yourself plenty of time in both modes.