backend
Task:
1. What is the need of User Interface?
✓ The UI is the process of creating the visual interfaces for a software application, web sites, etc.
✓ The frontend UI is used to handle the web page use to clean and easy for everyone.
✓ The responsibilities of UI is typography, colors, styles, branding, spacing, boldness, icons and
images.
✓ The UI developers are decided set animation, layout and etc.
✓ In frontend UI perform in navigation bar, buttons, forms, cards, icons, animations.
✓ In UI developers used the tools of frontend for quick responsive of Bootstrap and styling of
Tailwind CSS.
✓ In backend the UI need of user management work in user register, login, reset password.
✓ The backend the UI helps the admin in view, add, delete or update the records.
2. Which concept is used to fetch the data method?
✓ the data fetching is based on sending a request and getting a response using http methods.
✓ In frontend fetch data using API in javascript.
✓ Example: fetch(‘https://api.example.com’).
✓ Then also used in GraphQL, Axios, and AJAX.
✓ In backend using http requests for fetch the data from API.
✓ Then use database quires use SQL or NoSQL and ORM to fetch the data.
✓ In database use SQL SELECT to fetch the data from tables.
✓ Then use JOIN to fetch related data from multiple tables.
3. Which database is best for offline?
✓ The SQLite is best for mobile and desktop apps it has no server need, very fast.
✓ The Realm is best for mobile apps like IOS and Android it works offline, easy to use, supports
in real-time syn later.
✓ The IndexedDB is best for offline web applications, stores large structured dat based on
javasccript.
✓ The PoucgDB is best for offline and online it work inn browse and Node.js and easy to use
with Javascript.
✓ The TinyDB is best for small python projects it work in offline and easy to use, store data in a
JSON file.
✓ I will show the all type of database does not need internet it works on offline.
4. Why data load in slow and fast of website?
✓ The very fast DB is Redis, Memcached.
✓ Because it has faster than disk and memory storage.
✓ The fast DB is MongoDB and Cassandra.
✓ Because it has built for speed.
✓ The moderate DB is MySQL and PostgreSQL.
✓ Because it has used e commerce and business apps.
✓ The slower DB is SQLite.
✓ Because it has poor queries and used in mobile apps.
5. Performance of DB?
✓ The MySQL, PostgreSQL and MongoDB is high level performance and the platform is E
Commerce like Amazon, Flipkart.
✓ The MySQL, SQLite, Firebase is medium level performance and the platform is
application like School App and CRM System.
✓ The Redis, Firebase, Cassandra is very high level performance and the platform is Real-
Time System like Chat App and Live Score App.
✓ The SQLite is low medium level performance and the platform is offline system like mobile
app.
✓ The BigQuery, Snowflake, Cassandra is high level performance and the platform is
Analytics and big data like reports and dashboards,
