Hwayeonniii

By Alice Park, March 24, 2022 1:17 PM EDT

Link: https://time.com/6159366/covid-19-drug-pharmacies-test-to-treat/

Summary

On March 1, President Biden announced the launch of the "Test to Treat" program; people get tested at a pharmacy, and receive antiviral pills if they're positive. The support for supplies of medications has increased at pharmacies across the US. 

Due to the regulation of the US FDA that pharmacists cannot prescribe Paxlovid & Molnupiravir, only a fraction of pharmacy chains is available to provide a prescription for COVID-19 therapy. In other words, people in areas without a primary care physician should make an appointment or go to an urgent care centre. Its worst scenario is widespread of Covid, doing this whole process for the test and treatment. However, pharmacists argue that they were educated for evaluating patients for potential drug interactions and side effects, so they can prescribe.

Available medication for Covid-19: Remdesivir, Paxlovid, Molnupiravir, Monoclonal Antibodies

• Remdsivir: antiviral, disrupt making copies of SARS-CoV-2 virus, only available in IV form(hospital essential)
• Paxlovid: block SARS-CoV-2 from replicating; can derive kidney problems
• Molnupiravir: block SARS-CoV-2 from replicating, banned to pregnant women
• Monoclonal Antibodies: neutralize any virus floating around by soaking them up

SARS-CoV-2 can easily mutate, and any two of the aforementioned medications cannot be in use together. For Omicron, only Evusheld from AstraZeneca and GlaxoSmithKline's Xevudy are effective.

Now, the access to the treatment is spotty and inequitable since the available clinics are focused around metro areas, not rural areas. 

Some public health experts suggest telehealth can prevent the spread of the virus by cutting out in-person visits entirely. In the best scenario, people get tested themselves at home, get verification for disease via telehealth, get an evaluation by sending their medical history and current statement, get a digital prescription and get delivery of the antiviral. 

Link: https://www.bbc.co.uk/news/business-60925016

Summary

Currently, Russia and the EU are in "a game of chicken" over who would back down first; Russia requires paying for has in roubles, but the EU continues paying in euros. 
The EU countries, especially Germany, brought an "early warning phase" to prepare for a potential supply shock. Its aim is to reduce the dependence on Russian energy. Consumers and industry in German are about to prepare for all scenarios. 
Plus, Russia started demanding payment in roubles for other commodities such as fertiliser, grain, metals and timber. 
In the long term, Mr Rusechas argued that at some point, this situation would force Germany to build more renewable energy production.

What is a Database (DB)?

-       Any collection of related information

• Phone Book
• Shopping list
• Todo List
• Your 5 best friends 
• Facebook’s User Base

-       Databases can be stored in different ways 

• On paper
• In your mind 
• On a computer
• PowerPoint slides
• Comments section

*Computers + Databases > extremely useful

·      computers are great at keeping track of large amounts of information

·      Amazon.com vs shopping list

Database Management System (DBMS)

: a special software program that helps users create and maintain a database

• Makes it easy to manage large amounts of information 
• Handles security 
• Backups
• Importing/exporting data
• Concurrency
• Interacts with software applications: programming languages

Two Types of Databases

1.     Relational Databases: SQL (most popular, organize all the data into a pre-defined table and insert info after that)

-       organize data into one or more tables 

• Each table has columns and rows
• A unique key identifies each row

2.     Non-Relational: noSQL / not just SQL (alike excel spread sheet)

-       Organize data in anything but a traditional table

• Key-value stores: html, JavaScript 
• Documents: JSON, XML, etc
• Graphs
• Flexible Tables

Relational Databases (SQL)

1.     Relational Database Management Systems (RDBMS)

-       help users create and maintain a relational databae 

ex > mySQL, Oracle, PostgreSQL, MariaDB, etc.

2.     Structured Query Language (SQL)

-       Standardized language for interacting with RDBMS 

-       Used to perform C.R.U.D operations, as well as other administrative tasks (user management, security, backup, etc).

-       Used to define tables and structures

-       SQL code used on one RDBMS is not always portable to another without modification 

Non-Relational Databases (noSQL, not just SQL)

            *JSON: html, most popular in noSQL

1.     Non-Relational Database Management Systems (NRDBMS)

-       Help users create and maintain a non-relational database

• MongoDB, DynamoDB, apache Cassandra, firebase, etc

2.     Implementation Specific

-       Any non-relational database falls under this category, so there’s no set language standard

-       Most NRDBMS will implement their own language for performing C.R.U.D and administrative operations on the database.

*cause there’s no language operating non-relational database

Database Queries

: requests made to the database management system for specific information

-       It grabs information I want in a large database via programming language 

-       As the database’s structure become more and more complex, it becomes more difficult to get the specific pieces of information we want 

-       Query is alike a google search; we type specific programming language in query instead of English for a google search. 

Reference  

<iframe width="560" height="315" src="https://www.youtube.com/embed/HXV3zeQKqGY" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

https://www.youtube.com/embed/HXV3zeQKqGY

If you're looking for only a .com website, go to section A of this post, but if you don't matter about the website address, go to section B.

Section A

In short, you must pay for the .com address. You might see loads of ads saying a free web publication, but that service is not for a .com address. I recommend GoDaddy in around 50 pounds (equivalent to 90000 won).

1. This video will help you.

https://youtu.be/kvyWeTXCSKk 

Section B

You have a number of options: Github, Netlify, WordPress, etc.

• Github: https://github.com

Pros:

- one of the biggest community of web developer

- performs very strongly and reliably when compared to other version control systems. 

- easy to contribute to your open source projects.

- systematically manage and keep track of your source code history

Cons: 

- difficult / complicated for beginners

• Netlify: https://www.netlify.com

Pros:

- enables a faster path to much more performant

- easy to handle 

Cons:

- all content changes will be available for users after the build process is completed, unlike real-time alternatives

- cannot implement changes by ourselves

• WordPress: https://wordpress.com

 Pros:

- less expensive

- a wide variety of professional themes

- WordPress sites are mobile-friendly

Cons:

- need lots of plugins for additional features

- slow page speed

- website can go down without notice

Reference 

<iframe width="560" height="315" src="https://www.youtube.com/embed/HXV3zeQKqGY" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

https://www.youtube.com/embed/HXV3zeQKqGY