🗺 PostgreSQL Flag Quiz Website

Check out the website here!

This is a web application that serves as a quiz game for identifying flags stored in a PostgreSQL database. Built with -

Node.js, Express, JavaScript, and EJS (Embedded JavaScript)

Note

Windows does not display flag images for emoji. Instead, Windows will show you the country code which looks this: "🇦🇫" :

So as a Windows user, the easiest way to see the flags is simply to use the Mozilla Firefox browser (instead of Chrome). Firefox displays flags just fine!

Table of Contents

• Tech Stack
• Features
• Dependencies
• Getting Started
• Database Schema
• Usage
• Flags
• Cheat Sheet for Country Emojis
• License

Tech stack💻

• Node.js: JavaScript runtime environment for executing JavaScript code server-side.
• Express.js: A web application framework for Node.js used for building web applications and APIs.
• EJS (Embedded JavaScript): Templating engine for generating HTML markup with plain JavaScript.
• PostgreSQL: Open-source relational database system for storing flag data.
• Body-parser: Middleware for parsing incoming request bodies in Express.
• pg (node-postgres): A PostgreSQL client for Node.js used to interact with the PostgreSQL database.
• dotenv: A zero-dependency module that loads environment variables from a .env file into process.env.

Features🚀

• Users can play a quiz game where they are presented with random flags and must input the corresponding country name.
• The application keeps track of the total score, displaying it to the user after each guess.
• Utilizes PostgreSQL as the database backend to store flag data.

Screenshots🖼️

Dependencies🧱

• Express.js: A web application framework for Node.js used for building web applications and APIs.
• Body-parser: Middleware for parsing incoming request bodies in Express.
• pg (node-postgres): A PostgreSQL client for Node.js used to interact with the PostgreSQL database.
• dotenv: A zero-dependency module that loads environment variables from a .env file into process.env.

Getting Started🎯

1. Clone this repository to your local machine.

2. Install dependencies using npm install.

3. Set up a PostgreSQL database and populate it with flag data.

4. Create a .env file in the root directory and add your database credentials:

   DB_USER=your_username
   DB_HOST=your_host
   DB_DATABASE=your_database
   DB_PASSWORD=your_password
   DB_PORT=your_port
   
   

5. Run the application using npm start.

6. Access the application in your web browser at http://localhost:3000 .

Database Schema

The database should contain a table named flags with columns representing flag data, such as name, image_url, etc.

Usage📝

• Visit the homepage (/) to start the quiz game.
• Input the corresponding country name for the presented flag and submit your answer.
• The application will indicate whether your answer is correct and display the total score.
• Continue playing to test your knowledge of flags!

flags📔

Cheat Sheet for Country Emojis📔

	ico	shortcode	ico	shortcode
top	🇦🇨	:ascension_island:	🇦🇩	:andorra:	top
top	🇦🇪	:united_arab_emirates:	🇦🇫	:afghanistan:	top
top	🇦🇬	:antigua_barbuda:	🇦🇮	:anguilla:	top
top	🇦🇱	:albania:	🇦🇲	:armenia:	top
top	🇦🇴	:angola:	🇦🇶	:antarctica:	top
top	🇦🇷	:argentina:	🇦🇸	:american_samoa:	top
top	🇦🇹	:austria:	🇦🇺	:australia:	top
top	🇦🇼	:aruba:	🇦🇽	:aland_islands:	top
top	🇦🇿	:azerbaijan:	🇧🇦	:bosnia_herzegovina:	top
top	🇧🇧	:barbados:	🇧🇩	:bangladesh:	top
top	🇧🇪	:belgium:	🇧🇫	:burkina_faso:	top
top	🇧🇬	:bulgaria:	🇧🇭	:bahrain:	top
top	🇧🇮	:burundi:	🇧🇯	:benin:	top
top	🇧🇱	:st_barthelemy:	🇧🇲	:bermuda:	top
top	🇧🇳	:brunei:	🇧🇴	:bolivia:	top
top	🇧🇶	:caribbean_netherlands:	🇧🇷	:brazil:	top
top	🇧🇸	:bahamas:	🇧🇹	:bhutan:	top
top	🇧🇻	:bouvet_island:	🇧🇼	:botswana:	top
top	🇧🇾	:belarus:	🇧🇿	:belize:	top
top	🇨🇦	:canada:	🇨🇨	:cocos_islands:	top
top	🇨🇩	:congo_kinshasa:	🇨🇫	:central_african_republic:	top
top	🇨🇬	:congo_brazzaville:	🇨🇭	:switzerland:	top
top	🇨🇮	:cote_divoire:	🇨🇰	:cook_islands:	top
top	🇨🇱	:chile:	🇨🇲	:cameroon:	top
top	🇨🇳	:cn:	🇨🇴	:colombia:	top
top	🇨🇵	:clipperton_island:	🇨🇷	:costa_rica:	top
top	🇨🇺	:cuba:	🇨🇻	:cape_verde:	top
top	🇨🇼	:curacao:	🇨🇽	:christmas_island:	top
top	🇨🇾	:cyprus:	🇨🇿	:czech_republic:	top
top	🇩🇪	:de:	🇩🇬	:diego_garcia:	top
top	🇩🇯	:djibouti:	🇩🇰	:denmark:	top
top	🇩🇲	:dominica:	🇩🇴	:dominican_republic:	top
top	🇩🇿	:algeria:	🇪🇦	:ceuta_melilla:	top
top	🇪🇨	:ecuador:	🇪🇪	:estonia:	top
top	🇪🇬	:egypt:	🇪🇭	:western_sahara:	top
top	🇪🇷	:eritrea:	🇪🇸	:es:	top
top	🇪🇹	:ethiopia:	🇪🇺	:eu: :european_union:	top
top	🇫🇮	:finland:	🇫🇯	:fiji:	top
top	🇫🇰	:falkland_islands:	🇫🇲	:micronesia:	top
top	🇫🇴	:faroe_islands:	🇫🇷	:fr:	top
top	🇬🇦	:gabon:	🇬🇧	:gb: :uk:	top
top	🇬🇩	:grenada:	🇬🇪	:georgia:	top
top	🇬🇫	:french_guiana:	🇬🇬	:guernsey:	top
top	🇬🇭	:ghana:	🇬🇮	:gibraltar:	top
top	🇬🇱	:greenland:	🇬🇲	:gambia:	top
top	🇬🇳	:guinea:	🇬🇵	:guadeloupe:	top
top	🇬🇶	:equatorial_guinea:	🇬🇷	:greece:	top
top	🇬🇸	:south_georgia_south_sandwich_islands:	🇬🇹	:guatemala:	top
top	🇬🇺	:guam:	🇬🇼	:guinea_bissau:	top
top	🇬🇾	:guyana:	🇭🇰	:hong_kong:	top
top	🇭🇲	:heard_mcdonald_islands:	🇭🇳	:honduras:	top
top	🇭🇷	:croatia:	🇭🇹	:haiti:	top
top	🇭🇺	:hungary:	🇮🇨	:canary_islands:	top
top	🇮🇩	:indonesia:	🇮🇪	:ireland:	top
top	🇮🇱	:israel:	🇮🇲	:isle_of_man:	top
top	🇮🇳	:india:	🇮🇴	:british_indian_ocean_territory:	top
top	🇮🇶	:iraq:	🇮🇷	:iran:	top
top	🇮🇸	:iceland:	🇮🇹	:it:	top
top	🇯🇪	:jersey:	🇯🇲	:jamaica:	top
top	🇯🇴	:jordan:	🇯🇵	:jp:	top
top	🇰🇪	:kenya:	🇰🇬	:kyrgyzstan:	top
top	🇰🇭	:cambodia:	🇰🇮	:kiribati:	top
top	🇰🇲	:comoros:	🇰🇳	:st_kitts_nevis:	top
top	🇰🇵	:north_korea:	🇰🇷	:kr:	top
top	🇰🇼	:kuwait:	🇰🇾	:cayman_islands:	top
top	🇰🇿	:kazakhstan:	🇱🇦	:laos:	top
top	🇱🇧	:lebanon:	🇱🇨	:st_lucia:	top
top	🇱🇮	:liechtenstein:	🇱🇰	:sri_lanka:	top
top	🇱🇷	:liberia:	🇱🇸	:lesotho:	top
top	🇱🇹	:lithuania:	🇱🇺	:luxembourg:	top
top	🇱🇻	:latvia:	🇱🇾	:libya:	top
top	🇲🇦	:morocco:	🇲🇨	:monaco:	top
top	🇲🇩	:moldova:	🇲🇪	:montenegro:	top
top	🇲🇫	:st_martin:	🇲🇬	:madagascar:	top
top	🇲🇭	:marshall_islands:	🇲🇰	:macedonia:	top
top	🇲🇱	:mali:	🇲🇲	:myanmar:	top
top	🇲🇳	:mongolia:	🇲🇴	:macau:	top
top	🇲🇵	:northern_mariana_islands:	🇲🇶	:martinique:	top
top	🇲🇷	:mauritania:	🇲🇸	:montserrat:	top
top	🇲🇹	:malta:	🇲🇺	:mauritius:	top
top	🇲🇻	:maldives:	🇲🇼	:malawi:	top
top	🇲🇽	:mexico:	🇲🇾	:malaysia:	top
top	🇲🇿	:mozambique:	🇳🇦	:namibia:	top
top	🇳🇨	:new_caledonia:	🇳🇪	:niger:	top
top	🇳🇫	:norfolk_island:	🇳🇬	:nigeria:	top
top	🇳🇮	:nicaragua:	🇳🇱	:netherlands:	top
top	🇳🇴	:norway:	🇳🇵	:nepal:	top
top	🇳🇷	:nauru:	🇳🇺	:niue:	top
top	🇳🇿	:new_zealand:	🇴🇲	:oman:	top
top	🇵🇦	:panama:	🇵🇪	:peru:	top
top	🇵🇫	:french_polynesia:	🇵🇬	:papua_new_guinea:	top
top	🇵🇭	:philippines:	🇵🇰	:pakistan:	top
top	🇵🇱	:poland:	🇵🇲	:st_pierre_miquelon:	top
top	🇵🇳	:pitcairn_islands:	🇵🇷	:puerto_rico:	top
top	🇵🇸	:palestinian_territories:	🇵🇹	:portugal:	top
top	🇵🇼	:palau:	🇵🇾	:paraguay:	top
top	🇶🇦	:qatar:	🇷🇪	:reunion:	top
top	🇷🇴	:romania:	🇷🇸	:serbia:	top
top	🇷🇺	:ru:	🇷🇼	:rwanda:	top
top	🇸🇦	:saudi_arabia:	🇸🇧	:solomon_islands:	top
top	🇸🇨	:seychelles:	🇸🇩	:sudan:	top
top	🇸🇪	:sweden:	🇸🇬	:singapore:	top
top	🇸🇭	:st_helena:	🇸🇮	:slovenia:	top
top	🇸🇯	:svalbard_jan_mayen:	🇸🇰	:slovakia:	top
top	🇸🇱	:sierra_leone:	🇸🇲	:san_marino:	top
top	🇸🇳	:senegal:	🇸🇴	:somalia:	top
top	🇸🇷	:suriname:	🇸🇸	:south_sudan:	top
top	🇸🇹	:sao_tome_principe:	🇸🇻	:el_salvador:	top
top	🇸🇽	:sint_maarten:	🇸🇾	:syria:	top
top	🇸🇿	:swaziland:	🇹🇦	:tristan_da_cunha:	top
top	🇹🇨	:turks_caicos_islands:	🇹🇩	:chad:	top
top	🇹🇫	:french_southern_territories:	🇹🇬	:togo:	top
top	🇹🇭	:thailand:	🇹🇯	:tajikistan:	top
top	🇹🇰	:tokelau:	🇹🇱	:timor_leste:	top
top	🇹🇲	:turkmenistan:	🇹🇳	:tunisia:	top
top	🇹🇴	:tonga:	🇹🇷	:tr:	top
top	🇹🇹	:trinidad_tobago:	🇹🇻	:tuvalu:	top
top	🇹🇼	:taiwan:	🇹🇿	:tanzania:	top
top	🇺🇦	:ukraine:	🇺🇬	:uganda:	top
top	🇺🇲	:us_outlying_islands:	🇺🇳	:united_nations:	top
top	🇺🇸	:us:	🇺🇾	:uruguay:	top
top	🇺🇿	:uzbekistan:	🇻🇦	:vatican_city:	top
top	🇻🇨	:st_vincent_grenadines:	🇻🇪	:venezuela:	top
top	🇻🇬	:british_virgin_islands:	🇻🇮	:us_virgin_islands:	top
top	🇻🇳	:vietnam:	🇻🇺	:vanuatu:	top
top	🇼🇫	:wallis_futuna:	🇼🇸	:samoa:	top
top	🇽🇰	:kosovo:	🇾🇪	:yemen:	top
top	🇾🇹	:mayotte:	🇿🇦	:south_africa:	top
top	🇿🇲	:zambia:	🇿🇼	:zimbabwe:	top

📫 Connect with me😊

Copyright © Shani Bider, 2024

License📄

This project is licensed under the MIT License.