Chris Wen's Blog

MySQL FunctionsMySQL provides a wide range of built-in functions that can be used to perform various operations on data. These functions can be categorized into several types, including string functions, numeric functions, date and time functions, and aggregate functions. String FunctionsString functions are used to manipulate and analyze string data. Some common string functions include: CONCAT(): Concatenates two or more strings. COMPARE(): Compares two strings and returns 0 if they are eq...

OverviewMongoDB is a document-oriented NoSQL database that stores data in flexible, JSON-like documents (Wikipedia Contributors 2019). Unlike traditional relational databases, MongoDB does not require a predefined schema, allowing for dynamic and hierarchical data structures. This flexibility makes it particularly suitable for applications that handle diverse and evolving data formats, such as content management systems, real-time analytics platforms, and Internet of Things (IoT) applications...

MySQL Data TypesThis chapter provides a structured overview of MySQL data types, including numeric, string, temporal, and other specialized types. Understanding these types is essential for esigning efficient and reliable database schemas. Numeric TypesInteger TypesMySQL provides several integer types (e.g., TINYINT, INT, BIGINT) to store whole numbers. Historically, these types allowed an optional display width (M). Key points: The display width (M) defines the minimum display width, not t...

MongoDB Basic InformationMongoDB is a popular NoSQL database known for its flexibility, scalability, and ease of use. It stores data in a JSON-like format called BSON (Binary JSON), which allows for dynamic schemas and makes it easy to work with complex data structures. Key Features of MongoDB Document-Oriented Storage: MongoDB stores data in collections of documents, which can have varying structures. This allows for greater flexibility compared to traditional relational databases. Scalabili...

MySQL Basic InformationMySQL is an open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) for managing and manipulating data. It is widely used for web applications, data warehousing, and various other applications due to its reliability, performance, and ease of use. MySQL ArchitectureMySQL follows a client-server architecture, where the MySQL server manages the database and handles client requests. The server consists of several components, inclu...

Understanding Kubernetes Networking: Port-Forward, Envoy Proxy, and IngressKubernetes (K8s) has revolutionized how we deploy, manage, and scale applications. However, understanding how network traffic flows inside and outside the cluster can still be challenging for many developers.In this post, we’ll explore three important concepts in Kubernetes networking — Port-Forward, Envoy Proxy, and Ingress — and understand how they fit together to enable secure and efficient communication in a Kubern...

Installationinstallation Conceptsconcepts