Question

WEB PROGRAMMING

Answer each question with a paragraph or two.

Do your own work, please

1/ what is a web form , and what does it mean to "sumit" one?

2/ SQLAlchemy is an ORM . What's an ORM , and why is it useful?

3/ In three paragraphs or less , explain the basic concepts behind database migrations.

4/ SQLAlchemy is an ORM . What's an ORM , and why is it useful?

Answer 1

1) Web form - A web form is an HTML form on a web page that lets users to enter their information. Web form can contains multiple fields like user name, address, gender and any other data you wish to collect.

After all the manditory informations are filled then the user needs to submit the information so that this information is, then, sent to a server for processing and then the information will be stored in a database if required.

2) ORM stands for Object Relational Mapping is a mechanism that makes it possible to address, access and manipulate objects without having to consider how those objects relate to their data sources. ORM lets programmers maintain a consistent view of objects over time, even as the sources that deliver them, the sinks that receive them and the applications that access them change.

Usefull :-
a) ORM hides and encapsulates change in the data source itself, so that when data sources or their APIs change, only ORM needs to change to keep up—not the applications that use ORM

b) Hide the SQL away from your logic code. This has the benefit of allowing you to more easily support more database engines

c) Focus on writing the logic, instead of getting all the SQL right

d) ORM software does a transition between those models. For instance, it puts all related records from table B into an attribute of object A. This kind of software makes it easier to use relational databases with object programming languages.

3) Database migration is the migration of data from one kind of database to another kind of database. This usually requires converting the data into a common format that can be output from the old database and input into the new database. Since the new database may be organized differently, it may be necessary to write a program that can process the migrating files.

Database Migrations also know as schema migration are particularly complicated as you have all the challenges of changing your software platform, where some old features are missing, or behave differently and some new features are available and you’d like to take advantage of those. In information technology (IT), migration is the process of moving from the use of one operating environment to another operating environment that is, in most cases, thought to be a better one. Migration can involve upgrading to new hardware, new software or both.

Factors to consider in a data migration project include the amount of downtime required to complete the migration, as well as business risks due to technical compatibility issues, data corruption, application performance problems and data loss

4) Refer point 2