(Ruby 2.5.1) Windows Fix – “Cannot Load Such File – Sqlite3/Sqlite3_native (LoadError)”

If you use Windows, you must appreciate that there are several gems which require external libraries in order to be “built” properly.

These external libraries are generally not present on your system and are required to be installed (and referenced) to get them working. This is why the likes of the MYSQL2 and RMagick gems are seen as “difficult” to install.

If you’re using SQLite3, things are slightly different.

This gem has several “builds” which are meant to provide functionality across a number of platforms (Windows included). Whilst this works in earlier versions of Ruby, it doesn’t work for Ruby 2.5.1+ – hence the error you’re seeing…

cannot load such file — sqlite3/sqlite3_native (LoadError)

The error is caused by the installation & attempted usage of the “mingw32” version of the gem. This version of the gem is pre-compiled with the SQLite core files, but has issues when being used with the later versions of Ruby.

The solution is to install the gem for the “ruby” platform (which still works fine in Windows):

gem install sqlite3 –platform=ruby

This will install the “native” version of the gem with all the appropriate files etc – but won’t use any of the platform-specific functionality that comes with the likes of the mingw32 version.

This will work 100% out of the box.

However, there’s another problem. If you use “bundler”, it will often override the native gem installation in favour of a platform-specific one. This means that if you run bundle update / bundle install, it will likely install the sqlite3 gem with mingw32 platform.

In this instance, you need to uninstall *any* references to the latter by using “gem uninstall”. Here’s what typically happens (for us):

bundle update [installs sqlite3]
gem uninstall sqlite3 [shows selection]
remove “mingw32” variant
rails s [should work 100%]

This will get the system working with the gem.

The big problem is that whenever you use the “mingw32” version of the gem, it will have a set of references/calls which are designed specifically to call particular elements of the gem.

In Ruby 2.5.1+ – for whatever reason – these calls are not entirely used to ensure that the system is able to make the most progress, hence the error you’re seeing. To fix this, you need to be able to essentially “force” your system to only use the “ruby” variant of the gem.

The Three WORST Pieces of Advice Given to Presenters (and How Best to Ignore Them)

Ever hear the one about picturing your audience naked to overcome your fear of presenting to them? How about the one about practicing in front of a mirror? Anyone who has ever tried either of those well-meaning tropes knows how futile they are. Deluding ourselves that we can calm fears by laughing at our audience, or that we can convince them of anything by faking authenticity, is worse than a waste of time. It prevents us from using our greatest power as presenters: our true selves. Try ignoring the “worst advice” and substituting powerful communication instead.

Worst Advice:

Memorize Your Presentation

Now this one sounds reasonable enough on the surface. After all, much of our fear about presenting is wrapped up in our fear of looking foolish in front of others. Some of that comes from our fear of drawing a blank when all eyes are on us. If we memorize our presentation, that won’t happen, right? Perhaps, but what will certainly happen is that we’ll be taken out of “the moment” as we put all of our energy and attention on recalling the least significant portion of our presentation: the literal words. Suddenly, we’re not focused on the immediate reaction we’re getting from the audience or on making sure we’re connecting with them. We’re focusing instead on making sure the words keep coming. That sets the bar too low: surviving the presentation until the end isn’t your goal. CONNECTING to your audience is.

Instead: Know Your Presentation

Focus on the essence of what you’re presenting: namely your key messages. This is what’s most important for your audience to understand. If the worst happens and all of your materials and notes disappeared, how would you summarize what you came to say? Put those bigger ideas up front and build your presentation around them. Your audience won’t likely remember all of the supporting details, but they should remember your key points. Worry less about repeating the exact words you intended and more about making sure you’re connecting. If you see heads nodding, react. If you see puzzled looks, don’t just plow through. Stop and make sure you’re not rushing ahead of your audience just to fill space. Slow yourself down and make sure you really see your audience and gauge their reactions. Remember, no one knows what you were supposed to say, so don’t let a pause or different phrasing than you’d planned throw you.

Use a Lot of Bullets

For some reason, lots of presenters think they can take a long, dry presentation and suddenly make it come alive if they can just add enough bullets to the screen. Ever sit through one of those presentations where the bullets don’t in any way indicate an abbreviated point? Heck, they may not even indicate a point! Here’s the thing: TEXT ON A SLIDE IS NOT A VISUAL AID. There is nothing about text that makes it more understandable, or illustrative, than the spoken word, by itself.

Instead: Put the Visual Back in Visual Aid

Are there actual visuals that would help illustrate your points? Can you bring in relevant charts, graphs, photos, illustrations to help your audience “see” your points? If you must use bullets, greatly reduce them and the words you use. Your audience didn’t come to read and they didn’t come to listen to YOU read to them. (Hint: if you use punctuation in your bulleted information, you’re using too many words.)

More is Better

Ever sit through a presentation that’s a product of many hands? More detail, more slides, with the presenter intoning something like… “..and here you can see again… ” or “this is just yet another example of… ” Yes, you want to prove your key points. Data does help you do that. However, information overload may quickly confuse your audience and actually mask your key points.

Relationships: What Can Happen To Someone When Their Partner Denies That They Are Cheating?

When someone is in relationship, they will have the opportunity to grow and to heal any wounds that they may have. This can mean that there will be moments that are deeply fulfilling and moments that are extremely painful pain.

What will play a big part here is how much pain one is carrying. If they have a lot of baggage, they could be used to experiencing more downs than ups in their relationship.

Unaware

However, even if one is carrying a lot of baggage, it doesn’t mean that they will realise this. Instead, they could believe that the other person is causing them to feel the way they do, believing that they are to blame.

If they have this outlook, it is not going to be possible for them to take responsibility for their own pain. The other person could put up with this, thereby causing them to be weighed down by issues that don’t belong to them.

The Defining Factor

What this will show is that they lack self-awareness, with this being the reason why they can’t own their own issues. The reason why the other person goes along with this could be because this is what feels comfortable.

Perhaps they grew up in an environment where their caregiver didn’t take responsibility either, causing them to have a false sense of responsibility and to lack boundaries. This then stops them from standing their ground.

A Battle

The energy that one person uses to blame the other could aid their own development, as opposed to being wasted in this manner. This is then going to be a relationship that will drain both of them.

Before long, one of them could decide that enough is enough and walk away, and this could be the person who doesn’t want to work through their issues. They could soon find someone else and the same thing could happen all over again.

One Problem

Conversely, one could be in a position where one issue is making it hard for them to relax around their partner, and this could cold be something that consumes their attention when they are apart. One may believe that their partner is cheating on them and this could cause them experience a lot of pain.

They could talk to their partner, or they could end up talking to their friends about what is going on for them. If they speak directly to their partner, it might allow them to allay their fears but if they speak to their fiends, it could make things worse.

Another Approach

Alternatively, one could take a step back and reflect on what is taking place internally and externally. This will give them the chance to see if there is anything to what they believe or if they are just overreacting.

During this time, they may find that something from their past has been triggered. Maybe they feel worthless and have a fear of being abandoned, which is why they have come to believe that their partner is straying.

The Past is Present

At the beginning of their life, they may have been neglected by their caregivers, and this would have caused them to believe that they were worthless. The years would then have passed, but they will still fear that they will be left.

Through being egocentric at this age, they would have believed that they were only left since they had no value. In reality, they were left due to the issues that their caregiver/s had; that’s all there is to it.

External Support

What they could then do is to find someone who can assist them, such as a therapist or a healer. Once they have worked though their pain, it will be easier for them to live in the present moment.

Yet, if they were to find that what is taking place within them is not having an effect on how they are perceiving reality, they could believe that it would be a good idea for them to speak to their partner. After talking about this with them, they could find that there is nothing for them to worry about.

Denial

At the same time, one could have clear evidence that something is going on and they could sense that something is not right, but their partner could deny it. If their partner is not willing to admit to what is taking place, they might wonder if the time has come to end the relationship.

On the other hand, they could go along with what their partner says and start to question themselves. As time goes by, they could disconnect from themselves and only pay attention to what comes out of their partner’s mouth.

Out of Touch

One will have allowed their partner to tell them what is or what isn’t taking place, and this will cause them to ignore their own feelings and instincts. Their partner is then going to have a lot of power over them.

Taking this into account, the sooner one gets back in touch with their inner world the better their life will be. The person they are with is not going to have their best interests at heart, so they will probably need to cut their ties with them.

Awareness

If one can relate to this, and they want to change their life, they may need to reach out for external assistance. This is something that can be provided by a therapist or healer, and the support of their friends and family may also be needed.

Prolific writer, author, and coach, Oliver JR Cooper, hails from England. His insightful commentary and analysis covers all aspects of human transformation, including love, partnership, self-love, and inner awareness. With over one thousand seven hundred in-depth articles highlighting human psychology and behaviour, Oliver offers hope along with his sound advice.

How To Select An Efficient Warehousing Service For Your Company

If you are an owner of a business and feels that managing and storing your productions in-house is incurring you a hell amount of money, then its time you decide to outsource your warehousing service to some third-party. A warehousing service is considered praiseworthy if they have a dedicated system that provides you the best storage and depot solutions that will minimize your inventory and logistics expenses.

Here are the determinants of an ideal warehousing service:

The location and space allotted for storage

As a business owner, your first priority is your client’s satisfaction when it comes to timely delivery of your products. A poor location of a warehouse can be a major obstacle in shipping your products to your destination on time. Parallel to this, proper planning while using the space in the warehouse is extremely important. You should select a service where you see stocks are organized efficiently, the old stock has been cleared out and there is no clutter inside the storehouse.

A committed team

The staffs present in the warehouse all the time are responsible for evaluating the warehousing conditions and decide whether it needs any improvements or modifications. They are one who faces the issues that arise daily and hence give a call to the management for the betterment of the service. So whenever you choose a warehouse service please see whether the team involved in the management and storage is a dedicated team with high skills and experience.

Transparencies in the entire process

Before jumping into any decision, you need to know what are the stages and procedures involved in the warehouse service. Yes, this point is important because otherwise you cannot judge the quality of a service and determine if it’s deviating from the usual norms and regulations. With a service provider with a transparent and clear process, it is possible to trust them blindly.

Advanced technology and quality control

The warehouse agencies that maintain the quality standards – ISO 9000 (quality control) and ISO 90001 (quality management) are considered to be the efficient and high standard companies. These play a crucial part to ensure that the anticipated outcomes are due to the utilization of best processes and technology available. A service provider that uses the best software with mobile scanners and high-quality integration with distribution partners is the ideal choice for you.

Warehousing operations are costly and time-consuming, but it is the soul of your business. Poor storage and depot facilities can cause your business to drop down below par. So, why take such risk and wait for such instances to occur? Seek the best warehouse service and skyrocket your business’s profits.

8 Things We Can Actually Learn From Machiavelli’s “The Prince”

1. You can’t please everyone. (The need to avoid contempt and hatred).

Machiavelli constantly noted that it is impossible for a Prince to satisfy both his subjects and his nobles at the same time. The prince would have to sacrifice the needs of one for the other.

Stating clear examples from history, Machiavelli also used the Romans as a case study. He stated that aside from the subjects and nobles, Roman emperors still had soldiers to deal with.

In a modern world view, people wrestle with the notion that they can try to make everyone happy. With some accepting that they would have to displease one in order to please the other, others still hang on to the illusion that they can satisfy everyone. As noted by Machiavelli, trying to please everyone ultimately leads to disaster.

2. Being generous all the time is being stupid all the time. (Generosity and Parsimony)

It’s no rare thing to find fundamentally good people. People who display extraordinary attributes of altruism that surpass even the likes of religious clerics, which is a good thing. But giving away more than you have can be self defeating.

According to Machiavelli, in people’s efforts to become generous, they lose the ability to do so. That simply means that you can only be generous until you lose everything you can be generous with.

He emphasized that the people considered extremely generous in history only did so with what didn’t belong to them in the first place. He cited figures such as Alexander the great, Cyrus and Julius Caesar who were more liberal with what wasn’t their own.

There’s nothing bad in being generous. If you have enough to give, then by all means, do so. But if don’t, do not risk your well-being and that of your family’s for someone else.

It is important to also note that Machiavelli noticed how quickly people can turn on you if you tell them “no”. You become either poor or despised, “seeking to escape poverty”.

3. People cannot be trusted (Cruelty and Compassion)

This is harsh but true. Machiavelli strongly objected to promises made with just words. They could be easily broken.

His words were: “Men are ungrateful, fickle, liars and deceiver. They shun danger and are greedy for profit. While you treat them well, they are yours… But when you are in danger, they turn you away” those words deeply and quite aggressively reflected his views on humanity. But his stance on trust was somewhat accurate.

You should not depend entirely on trust. If you do, be ready to get your heart broken.

4. Education is important (How a prince should organize his militia)

Machiavelli’s idea of education was taking military exercises in the art of war during and after wartime.

He stated how important it is for a prince to know more about war and historical events based on war.

Similarly, in our generation, education is equally important. Knowledge has become more powerful than ever. And what is the best way of acquiring knowledge than education?

You don’t need to know about the art of war, it’s execution and implementation. But learning how to read and write is of equal importance.

5. Always expect the unexpected. (How a prince should organize his militia)

Philopoemen, as cited by Machiavelli, was praised for thinking of war during peacetime. He casually engaged in conversations about military strategy amongst friends.

You have to expect an unexpected change in your life at an unexpected point, one you could not have foreseen. It is always wise to prepare for them.

Setting aside money for an unforeseeable financial problem in the future would be the modern day equivalent to expecting the unexpected. Just like Philopomen.

6. You cannot be all good (and it’s okay). (The things for which men, and especially princes are praised or blamed)

In an era where black is white and white is black and it’s near impossible to tell one from the other, we are often faced with moral ambiguity.

Should I do the “right” thing and hurt someone else in the process? What exactly is the right thing in the first place?. Well Machiavelli says it’s okay. No one is all good.

He enumerated qualities such as faithfulness, courageousness, frivolousness and religiousness. It is laudable for a prince to have them, but due to the “conditions of the world”, princes cannot have those qualities and observe them completely.

Real life is complex and it is not without his drawbacks.

7. Decisiveness and Conviction. (how a prince must win honour)

According to Machiavelli, there’s danger in neutrality and being completely at someone else’s mercy.

Delaying a problem doesn’t actually help you in any way. Indecision equals failure. That’s not ruling out patience completely which is instrumental in solving the problem. But there’s a fine line between patience and delay.

A problem is better solved when confronted.

8. Having a reputation for cruelty is hazardous (The need to avoid contempt and hatred)

Most people do not make it their life’s mission to be known as cruel. They might consider themselves as being strict or forward, but others might see them as bad, wicked and cruel.

Knowingly or not, being cruel is bad in any century. Machiavelli knew this and discuss the topic at length.

A prince, according to him, must always try to avoid being hated and despised by his subjects. Otherwise he risks a rebellion or an uprising.

“Cruelty” is a word that probably comes to mind when discussing Machiavelli and as evidenced in his works about how morality can be altered, it’s not so surprising. But he also noted how cruelty has incited revolutions and brought down empire s. The lesson here is, always try to be kind..