Session_1_Introduction_To_Databases.sql

CREATE DATABASE food_delivery_db;

------- Three Differences between MySQL & PostgreSQL --------

--  Feature / Use Case       | MySQL                                                                      | PostgreSQL                                                                                                          |
--  ------------------------ | -------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------- |
--    1. Performance Focus   | Optimized for fast read-heavy web applications and simple queries.         | Optimized for complex queries, analytics, and large-scale data processing.                                          |
--    2. Advanced Features   | Simpler feature set, easier for beginners to learn and manage.             | Supports advanced features such as JSONB, window functions, Common Table Expressions (CTEs), and custom data types. |
--    3. Typical Use Cases   | Commonly used for content management systems, blogs, and web applications. | Commonly used for enterprise applications, financial systems, GIS, and data analytics platforms.                    |


-- Popular Users of MySQL are Facebook, WordPress...
-- Popular Users of PostgreSQL are Instagram, Reddit...