| /* | |
| Countries and dependent territories, 2020 | |
| Data adapted from | |
| http://www.worldometers.info/world-population/population-by-country/ | |
| Does not include rows which had "N.A." values, so some territories are missing. | |
| */ | |
| CREATE TABLE countries( | |
| name TEXT PRIMARY KEY, | |
| population INTEGER, |
| /* | |
| Solar system objects | |
| Adapted from: http://en.wikipedia.org/wiki/List_of_Solar_System_objects_by_size | |
| Collected by: https://www.khanacademy.org/profile/patrick809/programs | |
| */ | |
| CREATE TABLE solar_system_objects( | |
| body TEXT | |
| , mean_radius NUMERIC /* km */ | |
| , mean_radius_rel NUMERIC /* relative to earth */ | |
| , volume NUMERIC /* 10^9 km^3 */ |
| /* Marvel Heroes and Villains | |
| Based on the website http://marvel.wikia.com/Main_Page | |
| with popularity data from http://observationdeck.io9.com/something-i-found-marvel-character-popularity-poll-cb-1568108064 | |
| and power grid data from http://marvel.wikia.com/Power_Grid#Power | |
| Collected by: https://www.khanacademy.org/profile/Mentrasto/ | |
| */ | |
| CREATE TABLE marvels (ID INTEGER PRIMARY KEY, | |
| name TEXT, | |
| popularity INTEGER, |
| /* | |
| Sales from an online furniture store | |
| Collected by: https://www.khanacademy.org/profile/charlesb2000/ | |
| */ | |
| CREATE TABLE sales( | |
| ID INTEGER NOT NULL PRIMARY KEY | |
| , transaction_date TEXT | |
| , product TEXT | |
| , price INTEGER | |
| , payment_type TEXT |
| /* | |
| Earned Badges | |
| This table contains badges earned by a user, including the most recent date achieved, the type, the name, the # of energy points earned, and the activity earned from. | |
| Collected by: https://www.khanacademy.org/profile/chopsor/ | |
| */ | |
| CREATE TABLE badges ( | |
| date TEXT, | |
| badge_type TEXT, | |
| badge_name TEXT, |
| /* | |
| Winston's Donut logs | |
| This table of logs shows how many donuts Winston eats at each year of his life, | |
| plus any particular reason to explain his eating habits. | |
| Collected by: https://www.khanacademy.org/profile/mhogwarts/ | |
| */ | |
| CREATE TABLE winstons_donut_logs ( | |
| id TEXT PRIMARY KEY, | |
| status TEXT, | |
| years_old INTEGER, |
| /* Friendly Card Game Results: | |
| During this past winter, a few friends got together every Wednesday night for a friendly game of cards. On some nights they'd play two games, but never the same game twice on the same night. The usual players were Spunky Sam, Marcimus, Winston, and Hopper. Sometimes, one of the friends couldn't make it, so there were only three players. But sometimes they'd call another friend to fill-in. In every game they played, the one with the hightest score was declared the winner. These are their results: | |
| Created by: https://www.khanacademy.org/profile/brianduckworth | |
| */ | |
| CREATE TABLE card_games(id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| date_played TEXT, | |
| game_name TEXT, | |
| player_name TEXT, | |
| score INTEGER); |
| /* | |
| 1st 3 rounds of the NFL 2015 Draft | |
| Collected by: https://www.khanacademy.org/profile/BobbyandKaren/ | |
| */ | |
| CREATE TABLE picks( | |
| id INTEGER PRIMARY KEY, | |
| pick_number INTEGER, | |
| name TEXT, | |
| college TEXT, |
| /* Source: http://www.boxofficemojo.com/alltime/world/ */ | |
| CREATE TABLE topmovies( | |
| Rank INTEGER, | |
| Title TEXT, | |
| Studio TEXT, | |
| Worldwide REAL, | |
| Domestic REAL, | |
| DomesticPct REAL, | |
| Overseas REAL, | |
| OverseasPct REAL, |
In production, it is recommended to minify any JavaScript code that is included with your application. Minification can help your website load several times faster, especially as the size of your JavaScript source code grows.
Here's one way to set it up:
npm init -y in your project folder (don't skip this step!)npm install terserNow, to minify a file called like_button.js, run in the terminal: