Google is now prioritizing mobile sites to provide better results for mobile devices

best facts apps

We all saw this coming. All the way back in November 2016, Google said it would begin prioritizing websites that have a mobile-friendly, responsive design in favor of traditional desktop online websites. Google is following through on that promise as it’s now implementing this new prioritization method for a “handful of sites.” Quite frankly, the move makes sense given that an ever-increasing amount of people are searching constantly from their phones. Especially when you aren’t at a computer, it’s easier to just pull out the phone that’s in your pocket to search for something.

See also

We’ve all been there, searching for something on Google, when we finally find the information we need, when *gasp*, it’s a desktop site. The change to mobile-first indexing will ensure that this doesn’t happen as often.

Traditionally, Google’s crawling and ranking systems only looked at the standard desktop layout of a website. This is no longer going to be the case.

Google will now use content from mobile sites to create and rank listings, which will allow for more relevant results for mobile users. Google is “evaluating sites independently on their readiness for mobile-first indexing,” and the shift is “closely being monitored by the search team.” If your website is already mobile-friendly, you shouldn’t have to do anything. However, Google does have some guidelines for site owners:

  • Make sure the mobile version of the site also has the important, high-quality content. This includes text, images (with alt-attributes), and videos – in the usual crawlable and indexable formats.
  • Structured data is important for indexing and search features that users love: it should be both on the mobile and desktop version of the site. Ensure URLs within the structured data are updated to the mobile version on the mobile pages.
  • Metadata should be present on both versions of the site. It provides hints about the content on a page for indexing and serving. For example, make sure that titles and meta descriptions are equivalent across both versions of all pages on the site.
  • No changes are necessary for interlinking with separate mobile URLs (m.-dot sites). For sites using separate mobile URLs, keep the existing link rel=canonical and link rel=alternate elements between these versions.
  • Check hreflang links on separate mobile URLs. When using link rel=hreflang elements for internationalization, link between mobile and desktop URLs separately. Your mobile URLs’ hreflang should point to the other language/region versions on other mobile URLs, and similarly link desktop with other desktop URLs using hreflang link elements there.
  • Ensure the servers hosting the site have enough capacity to handle potentially increased crawl rate. This doesn’t affect sites that use responsive web design and dynamic serving, only sites where the mobile version is on a separate host, such as m.example.com.

Thoughts on this change?

Google expands booking features for travelers with price tracking and deals

Google

We are a week and a half away from Christmas, but it’s still not too late to fly away for the holidays — it’ll just cost a pretty penny to do so. If you’re okay with that, Google updated its suite of travel applications and services to feature price tracking and deals.

Starting with Google Flights, the search giant is leveraging its machine learning chops to take a look at historical price data to let you when is the best time to book a flight. Once you let Google Flights know where you want to go, you can choose to have it send you tips like “prices won’t drop further” or “prices are less than normal.” That way, you can be better informed as to whether you should book your flight now or wait a bit longer.

Editor’s Pick

Moving right along, Google’s hotel search results offer similar information. Because you’re dealing with hotels, Google lets you know if rates for a specific room are higher or if the surrounding area is busier due to a local event. That way, you can better plan when to make a hotel room reservation, though you can opt for email alerts whenever prices fluctuate.

Finally, Google’s Trips app now features a “Discounts” section. As the name implies, the section nets you deals for things like tickets, tours, activities, and attractions. Discounts vary based on where you’re located, though the app also leverages Google’s travel-booking features.

Overall, the new features sound very familiar to what services like Kayak and Hopper already offer. The main difference is, since many folks are already deeply immersed in Google’s ecosystem, these are just more reasons why they shouldn’t leave that ecosystem.

The flight and hotel price tracking are currently rolling out worldwide, whereas the Discounts tab inside of the Trips app will be available in English, French, Italian, German, Spanish, and Portuguese.

Elemental Evil: Sessions 5 and 6

It appears I forgot to chronicle the previous session of my D&D home campaign. The last report was from early July, after which we had a summer break, and then resumed mid-August, and then continued yesterday. Both of these sessions were action-centric, with the group clearing out first the abandoned village of Thundertree and then the goblin stronghold of Cragmaw Castle from monsters. A “door-monster-treasure” type of gameplay can be a lot of fun, but the details aren’t always all that interesting in a journal of events. So I will summarize and concentrate on the highlights in this post.

Thundertree is an abandoned village a day’s travel from Neverwinter. The eruption of Mount Hotenow, which caused quite a catastrophe for Neverwinter half a century ago, destroyed the village of Thundertree. Erdan, the druid of the group who is prone to visions and nightmares, dreamed that the eruption of Hotenow was caused by a group of chanting fire cultists, but probably didn’t go as planned, as the cultists were killed in the event. What remained in Thundertree was mostly abandoned houses, with a population of ash zombies and twig blights. The group had gone to Thundertree to meet the druid Reidoth, who was supposed to know the location of Cragmaw Castle. Their “pet goblin” Droop also claimed to be able to find the way from Thundertree to Cragmaw Castle. They met Reidoth, who was able to provide a safe haven in the village, as well as the directions needed.

After clearing out most of the village from monsters, the group came across another group which likewise was engaged in fighting twig blights. That group was wearing blue armor and white robes, beset with feathers. They explained that they were from a club of aerial enthusiasts, and were in Thundertree to try to tame a griffon nesting here, or get eggs from his nest to raise as aerial mounts. The heroes agreed to accompany them to the griffon’s lair in the highest tower of Thundertree. But once there the air cultists tried to becalm the griffon by offering the adventurers up as sacrifice, so the group ended up killing both the cultists and the griffon. They were able to make the link between a symbol the cultists carried and the same symbol they had seen on a letter to Glasstaff in Phandalin.

On the way to Cragmaw Castle the group tried to question Droop for information about the castle. That was somewhat complicated by the fact that Droop could only count to 3, and used “3” as an answer to any question about numbers in which the answer exceeded 2. Not trusting the goblin’s offer to negotiate safe entry into the castle, they knocked him out and attached him to a tree, guarded by the paladin (the player was absent that session). Instead they built a camouflage out of branches and approached the less guarded south side of the castle at night. From there they could see into the banquet hall, but the goblins there didn’t look out the arrow slits. So they managed after a few attempts to unlock the side door. But they didn’t like the idea of advancing with the goblins in the hall behind them, so they decided to attack there.

From there they moved clockwise room by room. That enabled them to eliminate most guards in small groups. However it did move them more towards the entrance of the castle, instead towards the throne room. The toughest fight was against a group of hobgoblins. Popée the sorceress used a web spell on them, but between succeeded saving throws initially and later the web wasn’t all that effective. Then they tried to burn the web, but in 5E that deals only 2d4 damage, and the player rolled double 1s, so the spell wasn’t really a big success. The hobgoblins however had an ability with which they dealt an extra 2d6 damage if next to an ally. And two of them rolled critical hits, which doubles the number of dice on all damage, knocking the druid out of his bear form. After another fight in the central chapel of the castle the group had enough and decided to go back into the woods to take a long rest.

Returning to the castle they found that the bugbear King Grol had obviously noticed that the group had raided his castle and killed most of the goblinoids in there. So King Grol has gathered all the remaining defenders in the chapel, including a priest from the air cult. That ended up being a tough fight, with Theren being knocked down to zero health, but then rescued. The air cultist priest was a real menace, with a dust devil spell that prevented the archers and casters from sniping from the back. But Popée used a scroll of lightning bolt on King Grol and his pet wolf, killing the wolf and seriously damaging the bugbear. Soon after all the bugbears were dead. The priest tried to transform into gaseous form and flee, but didn’t make it out of the arrow slit in one round and concentrated fire killed him before his next round. At this point it had gotten rather late, and we ended the session.

Bridge Constructor Portal is not the Portal game you expected, and that’s just fine

When Bridge Constructor Portal was announced earlier this month, I’d be lying if I said I wasn’t taken aback. After all, I have played the first two Portal games, and while this mobile spin-off incorporates some of the series’ elements, I wouldn’t call it the follow-up that Portal fans have been clamoring for.

Even so, $5 isn’t asking for a lot, and, at least on paper, Bridge Constructor Portal has plenty to offer.

The game tasks players with being able to use metal girders and suspension wires to build bridges. These bridges allow the always-moving vehicles to get across from one side of the level to the other. Because the game employs a realistic physics system, you have to make sure that the bridges you build properly distribute weight. Otherwise, the bridges will collapse under all the stress.

Whereas previous Bridge Constructor games stopped there, however, Bridge Constructor Portal, you guessed it, uses elements of the Portal series to make the levels that much trickier. For example, many levels include sets of portals where you can hurl vehicles, companion cubes, and other objects through. Items like propulsion gel, sentry turrets, and aerial faith plates are also present and accounted for.

With that combination, the more you progress within Bridge Constructor Portal, the more you realize that the levels end up looking like a frenzy of flying vehicles than your typical roadway. Then again, there’s nothing typical about the game, so I suppose it’s fitting.

As with the Portal series, objects sent through portals maintain their momentum, so you will have to think about how to best use them. It’s no surprise, then, that things can get rather complicated, rather quickly, and they do. The unlimited number of dry runs lend to the send of progress, however, and lend to a sense of accomplishment once you finally get past a certain level you might be stuck on.

Also lending to that sense of accomplishment is the way that Bridge Constructor Portal scales the difficulty. Each level allows you to either get by with one vehicle or a convoy of them. The risk is greater with completing levels with a convoy of vehicles, since you have to account for the greater weight and increased chance of collisions, but you get to brag about it to others.

Not that completing levels with one vehicle is a trivial matter — the game’s mind-boggling levels will make you think hard about how best to approach them, so there is no feeling of scraping by if you manage to get one vehicle from one side of the level to the other.

Editor’s Pick

Making that journey a bit more fun is GLaDOS, the dry and sometimes sarcastic AI voiced by Ellen McLain. She is as witty as ever and brought a smile to my face when I heard her voice, only for that smile to go away as I realize that my bridge engineering skills are not as good as I might think they are.

Poor bridge engineering skills aside, I never felt like Bridge Constructor Portal wasn’t fun. Sure, it might not have been the Portal game I was expecting, but it’s great to look at, the music selection is spot-on, and the game itself was fun to play. Making things better, levels beg to be replayed, since there is usually more than one way to complete them.

If you want to catch a glimpse of what’s possible with the Portal series beyond the Portal gun, Bridge Constructor Portal will be available tomorrow, December 20 for $4.99. The game will also be released for the Xbox One, PlayStation 4, and Nintendo Switch in early 2018 for $9.99.

The 7th Continent

I received a parcel yesterday which contained the board game The 7th Continent. I had backed the production of that game on Kickstarter. I don’t often do that, it is only the 5th Kickstarter project I backed. But I am happy to report that with that parcel I am now at 100% success rate, every single Kickstarter project I backed actually delivered. Of course they all delivered late, The 7th Continent had an “expected” delivery in October 2016, and so is nearly a year late. I think a year late is about average of the projects I backed.

Kickstarter claims that only 9% of Kickstarter projects fail to deliver if successfully backed. But curiously they don’t back up that claim with hard data to which they should have access, but rather cite an opinion survey. Other sources claim much higher failure rates. And if you follow games media, stories about Kickstarter failures like this one aren’t all that uncommon. Furthermore as long as the developers deliver *anything*, that isn’t counted as a failure. That doesn’t mean that every delivered product lives up to the hype.

I think that only a very small part of Kickstarter failures are actual scams. I always apply Hanlon’s razor and easily explain failures with incompetence without having to imply malice. Some people are simply good at having bright ideas and marketing those ideas in an enthusiastic way, but are just plain bad at project management. Which both explains many of the total failures as well as the 75% to 84% late delivery rate of Kickstarter.

Of course I don’t back Kickstarter projects that are predictable failures, like people promising a large MMORPG for under $1 million. In general I would also advise to stay away from all Kickstarter projects for computer games: If the project is an actual success, you will be able to buy it later. So I rather back projects like The 7th Continent, which is so niche that it isn’t obvious that one can get the product outside of a Kickstarter campaign. If you want a copy of that board game, you’d actually have to back the Kickstarter for the second print run, it won’t be available in your neighborhood games store. I also sometimes back Kickstarter projects that are basically donations for a good cause, like rebuilding EN World.

In short, as long as you are aware of likelihood of failure, and the near certainty of late delivery, backing a Kickstarter project can be a good idea. Just don’t fall for the hype and get overly enthusiastic. Or you might still be waiting for Star Citizen 3 years later.

Deal: Razer throws in a free Leviathan Mini if you buy the Razer Phone

Available since November, Razer doesn’t appear ready to discount its flagship Razer Phone just yet. What the company is ready to do, however, is throw in one of its Bluetooth speakers for free if you buy its smartphone.

For 48 hours, if you pick up the $700 Razer Phone through the company’s website, you can get its Leviathan Mini Bluetooth speaker for free. Reported by PhoneArena, just make sure to use the promo code PHLVLUP (get it?) at checkout and you won’t pay a dime for the speaker.

I can’t personally attest to the quality of the Leviathan Mini. What I can say, however, is that it originally goes for $180 and was recently discounted to $100 for the holidays. The speaker also sports NFC for quick pairing and is roughly the same size as the popular UE Boom 2, though the Leviathan Mini doesn’t share the latter’s rugged protection. In other words, Razer’s speaker was not built to withstand water, dust, and drops — it’s a speaker meant for the table, not for the outside.

As for the Razer Phone itself, we thought it was a great first effort from Razer. It may not have adopted the near bezel-less design of some of its contemporaries, but the Razer Phone manages to still look unique, thanks to its dark aluminum build and dual speakers that crank out great sound.

Editor’s Pick

Also, we can’t talk about the Razer Phone without talking about its Quad HD display, which is capable of up to a 120 Hz refresh rate. This gives the phone a sense of fluidity and smoothness that only Google’s Pixel 2 and Pixel 2 XL can rival.

The Razer Phone isn’t without its hiccups, however. The display might lend the software a great amount of fluidity, but we found it a bit too dim for our liking. Also, even though our terrible photography experience has improved a bit with software updates, the images still aren’t that great. Finally, even though a dongle is included in the box, you will not find a headphone jack.

With that being said, we would not blame you if you pick up the Razer Phone, so why not do so while getting a Bluetooth speaker for free. You have until the end of tomorrow, December 19 to take advantage of the promotion at the link below.

Get the Razer Phone

A Guide To Better Google Search Techniques

A web search engine is a software system that is designed to search for information on the World Wide Web. The search results are generally presented in a line of results often referred to as search engine results pages (SERPs). The information may be a mix of web pages, images, and other types of files.
The Internet is so full of information that it’s nearly impossible to check its limits. That’s why, search engines were developed to maintain a search-able database of the web’s content. People employ the use of search engines to look up for information on the web.
Google Search, commonly referred to as Google Web Search or simply Google, is a web search engine developed by Google. It is the most-used search engine on the World Wide Web, handling more than three billion searches each day. You type in the query, and the search engine provides you with the search results. In most cases you’re satisfied but sometimes, you’re not. This is where learning the proper techniques to type in your search query comes in handy

Why The Need To Learn Proper Search Techniques?
Everyone including students, researchers, writers, etc. requires information, and they use search engines for that very reason. People spend most of their time continuously looking for the right information because they’re not aware of the proper search techniques. Learning and using good search techniques will help you in the following ways:
  • Better search results
  • Saves your time

How To Use Google.com

Google is a smart and intelligent search engine with many exciting features. But not all the features are rolled out instantly for all versions. Google.com is always first to get feature updates, and then updates are provided in versions specific to different countries such as google.co.uk, google.co.in, or google.sh.
Google’s version for your country might not support all the search techniques described below. That’s why, it’s suggested to use google.com to avail maximum benefits of the search features and techniques.
 Note: Typing google.com automatically redirects you to its version for your country, but you can override this behavior by going to www.google.com/ncr.

Basic Search Techniques

1. Keep It Simple

Keep your search simple and web-friendly. Start by entering one or two words, and gradually adding relevant or important words, if you’re unsatisfied with the results. Less is more for a search engine; meaning the less words you query for, the more results the search engine provides as output.
For example:
Query: [who is the prime minister of India]
Better query: [prime minister of India]

2. Order Of Keywords

Select the right keywords to make your search. Search results completely depend on the given keywords, and if keywords are chosen wisely, then results are more efficient.
Put yourself in the shoes of the author, and think of what words he/she would use to write/describe what you’re trying to find. If you’re looking for a phrase or quote, then keep the order of the words as accurate as possible to get the optimum search results.

3. Skip Unnecessary Parts

Google is smart enough to handle most of your typos, and other things that could just be ignored. That’s why you should skip those things in your query to save time.
You should not worry about the following when writing a search query:
  • Spelling
  • Cases (uppercase or lowercase)
  • Punctuation (dot, question mark, exclamation mark, and more)
  • Special characters (plus, minus, brackets, and more)

4. Social Search

Google is really good at handling searches related to people and social networks. You can search for people and their social profiles using:
+[profile-name]
By adding a ‘+’ before a profile-name, you can search for Google+ profiles and pages.
#[word]
Using the ‘#’ before a word enables you to search for hashtags in Google+, Twitter, and more social networks.
For example: [#privacy]
@[person-name]
You can search for social accounts associated with a person’s name by putting the ‘@’ sign before his/her name.
For example: [@rocky jagtiani]

5. Get Sunrise And Sunset Times

You can use Google to get sunrise and sunset times for many cities of the world. Type your search query in the format of [sunrise place-name] or [sunrise zip-code] to get the sunrise time for the specified location. For sunset times, just substitute the words as per the following style of [sunset place-name] or [sunset zip-code].
For example:
  • [sunrise chembur] 
  • [sunset pune]

Advanced Search techniques

You can use the Google Advanced Search form for a more convenient search

6. Synonym Search:

You can use the synonym search feature to tell Google to even search for synonyms of a specified word in the search query. This is helpful for when you want to search for a word and all its similar words without having to spend time looking for them individually.
Using the tilde symbol (~) before a word tells Google to search for the words and its synonyms too. Type your search query in the format of [~synonymWord otherWords] to search for the word and its synonyms in a single search.

7. Search For Numbers In A Range

You can tell Google to search within a range of numbers, such as dates, prices, and measurements. Using two periods (dots) between two numbers makes Google search within that number range and skip other results.
Using two periods after a number indicates a lower minimum (number..) while putting it before the number indicates a higher maximum (..number). Type your search query in the format of [firstNumber..secondNumber otherWords] to search between a specified lower and upper bounds.

8. Search Using File Types

You can tell Google to search for a specified type of file for your query. Using filetype operators before a type of file tells Google to search only for specified file types and skip other files. Type your search query in the format of [filetype:type otherWords] to search for a specific file type.
For example: [filetype:pdf free java tutorial]

Want to learn Data Analytics?

The #1 Reason the GOP Tax Plan Is an Economic Catastrophe: It Will Send Health Care Costs Through the Roof

The bill is poised to cause real pain and suffering to people who struggle to pay for health care.

Of all the reasons the Republican tax bill will be a mugging of the majority of non-wealthy Americans, one reason stands out above all else—the bill will seriously set back everyone who has struggled to pay for health insurance and medical expenses.

Repealing the Obamacare coverage mandate is likely to prompt insurers to raise premiums by an estimated 10 percent annually into the foreseeable future, according to the nonpartisan Congressional Budget Office. Why? Because as up to 13 million people drop their policies—CBO’s estimate—the remaining policy holders will end up paying more. (Those dropping coverage will revert to pre-Obamacare days of postponing treatments and hoping for the best.)

That’s just the start of the dire news affecting health care costs, as anticipated increases will more than offset any tax break. Not that most Americans were going to see tax cuts anyway—the bottom 50 percent of wage earners will see their after-tax incomes shrink by 2 percent; the middle 40 percent’s after-tax incomes will shrink by 0.6 percent; while the top 10 percent will see their incomes grow by 1.5 percent or more, the New York Times noted Monday.

There’s more bad health care news. The tax bill’s $1.5 trillion cost also preys on seniors, triggering spending cuts of 4 percent annually for Medicare, the federal health program for those 65 and older.

Currently, before Congress has its final votes on the bill, there’s no shortage of physicians who do not accept Medicare, due to  reimbursement rates. The result is people needing to see some physicians have to pay cash up front, if they can, and then fight with supplemental insurance providers to be reimbursed. This downward spiral will only worsen as Congress cuts Medicare.

The GOP bill also trashes preventive health care for the poorest households, a majority of which are single mothers with children. The same budget pressures that trigger automatic cuts for Medicare will also apply to the food and nutritional assistance programs. Additionally, the bill’s authors have swapped in a stingier formula for cost-of-living index increases—the so-called chained CPI. That new metric translates into less assistance, not more, for the needy in coming years.

The punishment of the poor and vulnerable doesn’t stop there. The tax bill’s changes in the earned income tax credit will divert an estimated $19 billion from poor families. The bill’s new requirement that families seeking child tax credit provide a Social Security number will translate into higher taxes for undocumented immigrants, who work and pay taxes but lack that paperwork.

But the bill’s biggest negative impact is that it will take bigger bites from paychecks and savings for health care spending. The bill’s GOP authors will counter that they lowered the threshold for deducting medical expenses from 10 percent of annual income to 7.5 percent. However, like many GOP tax breaks, it can only be claimed after spending the money in the first place—if you have it.

The coming shocks to the health care system have prompted industry experts and insiders to beseech Congress to vote no on the bill this week.

“In the wealthiest country on earth, 40 million people live in poverty,” tweeted Andy Slavitt, who ran the Medicaid and Medicare programs for the Obama administration. “The GOP tax bill would dramatically increase the wealth of the very wealthy & begin a cycle of cuts to poverty & health programs… Uneasy Rs have one last chance.”

“This is a horrid bill,” John Baackes, chief executive of L.A. Care, a public plan covering 2 million mostly poor residents of Los Angeles County, told the L.A. Times. “They haven’t been able to repeal and replace [Obamacare], so they’ll attack it through the budget by looking for ways knock down the money that’s needed to cover people.”

But high-ranking Republicans, like House Speaker Paul Ryan, have told conservative radio that cutting health care programs is their top federal budget priority—with Ryan saying he will be targeting welfare, Medicare and Medicaid (state-run care for those under 65) in 2018.

Meanwhile, neither Ryan nor his Senate counterparts have taken action to continue funding CHIP, the federal health care program that covers 9 million poor children. (On Monday, Alabama announced it was freezing 2018 CHIP enrollment.)

The GOP bill is poised to cause real pain and suffering to people who struggle to pay for health care. 

As Slavitt wrote late Monday, “BREAKING: Trump Administration announced it is ending program to pay differently to improve quality in Medicaid, as happens in Medicare & everywhere else. I’ve run these programs. This is tragic bigotry.”

Yes, more bigotry against the middle class and working poor. Despite GOP campaign trail rhetoric, there’s no tax simplification, fairness, economic growth or fiscal discipline in the Republicans’ tax bill. It transfers money up the ladder to those already making six-figures and into corporate profits. Almost everyone else pays more—starting with their health care (or lack of it).   

 

Related Stories

  • Trump Led American Politics Is Swamped by Epidemic of Unprecedented Lying
  • American Politics Is Swamped by Unprecedented Lies, Lying Politicians and Partisans Blaming Critics
  • Republican Tax Plan Is Only The Start of GOP Effort To Spread Inequality and Economic Anxieties by Shredding Safety Nets

Are You Suffering from Selfitis?

A new study has identified the taking of too many selfies as an actual illness. But how do you know if you’ve got it?

Name: Selfitis.

Age:Three years old.

Appearance: Chin up, lips out, zero attention span.

This sounds like it might be an illness. Correct, it absolutely is. A joint study by Nottingham Trent University and Thiagarajar School of Management has proved it beyond all doubt.

But what is it?A condition that causes people to post too many selfies on the internet.

I mean, that hardly sounds like cholera. But it might be just as dangerous. Did you know that 36 people have genuinely died from taking selfies this year alone? Some fell in rivers and drowned, others were hit by trains. One was trampled by an elephant.

What does that have to do with selfitis? Maybe if these people had spent less time taking selfies and more time looking around for rampaging elephants, they would still be with us.

Now I’m scared. Give it to me straight: do I have selfitis? I’m pleased you asked. The study has developed the Selfitis Behaviour Scale to help diagnose those who think they might suffer from selfitis. All you have to do is assign the following statements with a value between one and five.

OK, shoot. “I feel more popular when I post my selfies on social media.”

Five. “By posting selfies, I expect my friends to appraise me.”

Five. “When I don’t take selfies, I feel detached from my peer group.” “Taking different selfie poses helps increase my social status.” “I use photo-editing tools to enhance my selfie to look better than others.”

Five five five. Oh boy, sounds like you might just be a chronic case.

What does that mean? According to the research, it means that you’re likely to balance low self-confidence with obsessive attention-seeking, and you hope that by compulsively detailing the minutiae of your life online, you will somehow feel like part of a larger group that doesn’t necessarily exist.

Well duh.Yeah, I know, me too.

Is there any treatment available? Not yet, but I suppose we could just put our phones down for a second and experience the real world in the moment. Ha, no, just kidding.

Do say:“I can’t come to work today. As you can see on Instagram, I’m suffering from a nasty bout of selfitis.”

Don’t say: “Finally, proof that anyone who owns a selfie stick is unwell.”

 

Related Stories

  • Uber Stole Trade Secrets, Bribed Foreign Officials and Spied on Rivals, Filing Says
  • Dustin Hoffman Faces Disturbing New Allegations of Sexual Misconduct
  • Trump Is a Master Game-Changer, but Not the Kind You May Think

SQLite Overview with Installation_pRoCess and self-start examples:SQL – Where all to UsE ?

sqlite image


SQLite is embedded relational database management system. It is self-contained, serverless, zero configuration and transactional SQL database engine. SQLite is free to use for any purpose commercial or private. In other words, “SQLite is an open source, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application”.

SQLite is different from other SQL databases because unlike most other SQL databases, SQLite does not have a separate server process. It reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. SQLite was designed by D. Richard Hipp for the purpose of no administration required for operating a program in 2000.

SQLite Features

Following is a list of features which makes SQLite popular among other lightweight databases:

  • SQLite is open-source. License is not required to work with it.
  • SQLite doesn’t require a different server process or system to operate.
  • It facilitates you to work on multiple databases on the same session on the same time.
  • SQLite doesn’t require configuration. No setup or administration required.
  • SQLite is a cross-platform DBMS.
  • The length of the columns is variable and is not fixed. It facilitates you to allocate only the space a field needs.
  • Provide large number of API’s: SQLite provides API for a large range of programming languages.
  • SQLite is written in ANSI-C and provides simple and easy-to-use API.

SQLite Limitations

There are few unsupported features of SQLite which are listed below:-
  • Right Outer Join and Full Outer Join is not Supported.
  • The RENAME TABLE and ADD COLUMN variants of the ALTER TABLE command are supported. The DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT are not supported.
  • FOR EACH ROW triggers are supported but not FOR EACH STATEMENT triggers.
  • VIEWs in SQLite are read-only. You may not execute a DELETE, INSERT, or UPDATE statement on a view.
  • The only access permissions that can be applied are the normal file access permissions of the underlying operating system.

SQLite Installation

SQLite doesn’t require configuration. No setup or administration required. Lets see how to install SQLite on different Systems such as Windows, Linux.

Install SQLite on Windows

Step 1: Go to SQLite official website download page http://www.sqlite.org/download.html And download precompiled binaries from Windows section.
Step 2: Download the sqlite-dll and sqlite-shell zip file. Or sqlite-tools-win32-x86-3170000.zip file.
Step 3: Create a folder C:>sqlite and unzip above two zipped files in this folder, which will give you sqlite3.def, sqlite3.dll and sqlite3.exe files.
Step 4: Add C:>sqlite in your PATH environment variable and finally go to the command prompt and issue sqlite3 command, which should display the following result.
sqlite shell

Install SQLite on Linux

Today, almost all the Linux OS are being shipped with SQLite. So you just issue the following command to check if you already have SQLite installed on your machine.
$sqlite3
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
If you do not see the above result, then it means you do not have SQLite installed on your Linux machine. Follow following Steps
Step 1: Go to SQLite download page and download sqlite-autoconf-*.tar.gz from source code section.
Step 2: Run the following command :
$tar xvfz sqlite-autoconf-3071502.tar.gz
$cd sqlite-autoconf-3071502
$./configure --prefix = /usr/local
$make
$make install
The above command will install SQLite on Linux.

SQLite Commands

SQLite commands are similar to SQL commands. There are three types of SQLite commands:
DDL: Data Definition Language
  • CREATE: Creates a new table, a view of a table, or other object in database.
  • ALTER: It is used to modify an existing database object like a table.
  • DROP: Deletes an entire table, a view of a table or other object in the database.
DML: Data Manipulation Language
  • INSERT: This command is used to create a record.
  • UPDATE: It is used to modify the records.
  • DELETE: It is used to delete records.
DQL: Data Query Language
  • SELECT: This command is used to retrieve certain records from one or more table.

SQLite Create Table Command

In SQLite, CREATE TABLE statement is used to create a new table. While creating the table, we name that table and define its column and data types of each column.
Syntax:
CREATE TABLE database_name.table_name(  
column1 datatype PRIMARY KEY(one or more columns),
column2 datatype,
column3 datatype,
.....
columnN datatype,
);
Example
CREATE TABLE SCTPL(  
ID int PRIMARY KEY not null,
NAME TEXT,
Address TEXT,
);
You can view the tables created in SQLite using .table command and .schema command is used to view the table details.

sqlite create table command

SQLite Insert Query

In SQLite, INSERT INTO statement is used to add new rows of data into a table. After creating the table, this command is used to insert data into the table.
There are two types of basic syntaxes for INSERT INTO statement:
Syntax-1:
INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)    
VALUES (value1, value2, value3,...valueN);
Here, column1, column2, column3,…columnN specifies the name of the columns in the table into which you have to insert data.

You don’t need to specify the columns name in the SQlite query if you are adding values to all the columns in the table. But you should make sure that the order of the values is in the same order of the columns in the table.
Then the syntax will be like this:
Syntax-2:
INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);
Example
Inserting values by first method:
INSERT INTO SCTPL (id, name,address)   
VALUES (101, Suven Consultants,Chembur);



Inserting values by second method:
INSERT INTO SCTPL VALUES (102,Suven Consultants,Thane);



SQLite SELECT Query

In SQLite database, SELECT statement is used to fetch data from a table. When we create a table and insert some data into that, we have to fetch the data whenever we require. That’s why select query is used.
Syntax:
SELECT column1, column2, columnN FROM table_name;
OR
SELECT * FROM table_name;
Example
SELECT * FROM SCTPL;

Do you want to learn Database Programming?