DEV Community: Pau

Introduction to Markup Languages

Pau — Mon, 28 Oct 2024 14:08:11 +0000

Markup Languages

Index

Introduction
XML
JSON
Markdown
Tips For Beginners

Introduction

Programming languages are formal systems composed of a set of rules and symbols that allow programmers to write instructions for computers to execute specific tasks. While programming languages handle complex operations, markup languages are designed mainly for structuring and presenting data.

XML

The Extensible Markup Language (XML) allows for defining and storing data in a structured format. XML is widely used for data exchange between systems and configuration files.

Sample Code: <name>John</name>

More Info: XML

Example:

<europe>
    <countries>
        <continent>Europe</continent>
        <content>
            <country>
                <name>Spain</name>
                <birth_rate>7.2 per 1000 inhabitants</birth_rate>
            </country>
            <country>
                <name>Italy</name>
                <birth_rate>6.8 per 1000 inhabitants</birth_rate>
            </country>
            <country>
                <name>France</name>
                <birth_rate>11 per 1000 inhabitants</birth_rate>
            </country>
            <country>
                <name>Portugal</name>
                <birth_rate>7.7 per 1000 inhabitants</birth_rate>
            </country>
        </content>
    </countries>
</europe>

JSON

The JSON (JavaScript Object Notation) format is a lightweight data format commonly used as an alternative to XML. JSON is popular for data transfer between web servers and applications because of its simplicity and ease of use with JavaScript.

Sample Code: { "name": "John" }

More Info: JSON

Example:

{
  "Class": {
    "Students": [
      {
        "FirstName": "John",
        "LastName": "Doe",
        "Country": "USA",
        "Address": "123 Elm St",
        "Phone": 1234567890
      },
      {
        "FirstName": "Mario",
        "LastName": "Rossi",
        "Country": "Italy",
        "Address": "Piazza del Popolo 10",
        "Phone": 987654321
      }
    ]
  }
}

Markdown

Markdown is a lightweight markup language primarily used for formatting plain text. It enables easy creation of headings, lists, links, and other text formats with minimal syntax.

Sample Code: **Hello, world**

More Info: MarkDown

Example:

# Class

## Students

### Student
- **First Name:** John
- **Last Name:** Doe
- **Country:** USA
- **Address:** 123 Elm St
- **Phone:** 1234567890

### Student
- **First Name:** Mario
- **Last Name:** Rossi
- **Country:** Italy
- **Address:** Piazza del Popolo 10
- **Phone:** 987654321

Tips for Beginners

Start Simple
- Begin with small examples to practice and build confidence.
- Try to work with basic structures, adding complexity gradually.
Use Online Validators
- Validators help catch errors in XML and JSON before use.
- Example: JSONLint for JSON and W3C Validator for XML.
Understand Formatting Differences
- Remember: XML and JSON are for data structuring, while Markdown is for text formatting.
- Keep examples distinct to prevent confusion.
Practice on Real Data
- Try using actual data in XML, JSON, or Markdown structures.
- This makes learning more practical and relatable.
Experiment with Different Markup Elements
- Test headings, lists, and links in Markdown.
- In XML and JSON, practice creating nested structures like objects or tags.

Introduction to DBMS

Pau — Sun, 27 Oct 2024 16:59:53 +0000

Database Management Systems (DBMS)

Author: Pau López Núñez

1. DBMS Market Share in 2024

MySQL: Continues to be a market leader with a 23.94% share MySQL Datanyze.
Microsoft SQL Server: Holds second place with a 13.44% share and is popular in enterprise environments that use Microsoft infrastructure Microsoft SQL Server Datanyze.
PostgreSQL: Has gained popularity recently with an 8.25% share, known for its robustness and standards compliance PostgreSQL Datanyze.
Oracle Database: Although historically dominant, it has been surpassed in popularity by others like PostgreSQL and MySQL, remaining strong in the enterprise segment Oracle Database Datanyze.
SQLite: While it has a smaller share, it is commonly used in mobile and lightweight applications SQLite Datanyze.

2. License (Paid or Free)

MySQL: Offers both a free open-source version and a paid commercial version through Oracle MySQL Products.
SQL Server: Microsoft offers free options (SQL Server Express) as well as paid versions SQL Server Downloads.
PostgreSQL: Completely free and open source PostgreSQL About.
Oracle: A commercial system, though limited free versions are available for developers Free Oracle Databases.
SQLite: Entirely free and open source SQLite About.

3. Compatible Platforms

MySQL: Available for Windows, macOS, and Linux MySQL Installation.
SQL Server: Primarily for Windows, with support for Linux in recent versions SQL Server Overview.
PostgreSQL: Compatible with Windows, macOS, Linux, and other Unix-based systems PostgreSQL Installation.
Oracle: Runs on multiple platforms, primarily Linux, Unix, and Windows Oracle Database Free.
SQLite: Operates on nearly any platform, including mobile and embedded systems SQLite Platforms.

4. Stored Procedures / Programming

All these systems (MySQL, SQL Server, PostgreSQL, Oracle, and SQLite) support stored procedures and allow programming through SQL and other languages, depending on the implementation.

5. Transaction Support

MySQL: Supports transactions, but requires the InnoDB storage engine for full support MySQL Transactions.
SQL Server: Supports transactions SQL Server Transactions.
PostgreSQL: Provides robust transaction support PostgreSQL Transactions.
Oracle: Advanced transaction support Oracle Transactions.
SQLite: Supports transactions, though with limitations compared to more robust systems SQLite Transactions.

6. DBMS Comparative Table

Features	MySQL	SQL Server	PostgreSQL	Oracle	SQLite
Market Share (2024)	23.94%	13.44%	8.25%	N/A	N/A
License	Free / Paid	Free / Paid	Free	Paid (limited free)	Free
Supported Platforms	Windows, macOS, Linux	Windows, Linux	Windows, macOS, Linux	Linux, Windows	All platforms
Stored Procedures	Yes	Yes	Yes	Yes	Yes
Transaction Support	Yes (with InnoDB)	Yes	Yes	Yes	Yes

7. Personal Choice of DBMS

PostgreSQL

Cost: Completely free and open source, offering economic flexibility without costs tied to usage.
Flexibility: Highly adaptable for a range of environments, from small applications to large enterprise systems.
Intuitive Interface: PostgreSQL offers a variety of intuitive graphical management tools, such as pgAdmin, one of the most popular interfaces for managing PostgreSQL databases.
Fewer Restrictions: Compared to commercial systems, PostgreSQL imposes fewer constraints, allowing for scalability without additional costs, unlike solutions like Oracle or SQL Server, which have more restrictive licensing.

Note: As this is a personal opinion, it is subjective and based on a critical comparison of various DBMS options.

8. References

MySQL: https://www.mysql.com/
Microsoft SQL Server: https://learn.microsoft.com/en-us/sql/sql-server/
PostgreSQL: https://www.postgresql.org/
Oracle: https://www.oracle.com/
SQLite: https://www.sqlite.org/
LearnSQL: https://learnsql.com/
Datanyze: https://www.datanyze.com/
Red9: https://red9.com/

Introduction to IDEs

Pau — Sat, 26 Oct 2024 23:05:25 +0000

Integrated Development Environments

Author: Pau López Núñez

Visual Studio Code
Eclipse
IntelliJ IDEA
Comparison of IDEs

Visual Studio Code

IDE Installation

Download VS Code from the official Visual Studio Code page.
Select your operating system and follow the installation instructions.

Recommended Extensions

Java Extension Pack: Includes support for Java.
Debugger for Java: Enables Java code debugging.
Prettier: Helps with automatic code formatting.

Basic Configuration

Indentation: Go to File > Preferences > Settings, search for "Tab Size," and adjust according to your preferences.
Project Folder: Use File > Open Folder to select the project folder.

Run Code

Open the .java file.
Click on the play icon in the top-right corner or use the Run > Run Without Debugging menu.

Create Executable .jar

Install the "Java Extensions" extension.
Use commands like jar cfm FileName.jar MANIFEST.MF -C bin or create the JAR directly from the extension.

Eclipse

IDE Installation

Download Eclipse from the official Eclipse page.
Follow the installer instructions.

Recommended Plugins

Maven Integration: Integration for projects with Maven.
Eclipse Git Team Provider: Supports Git integration.

Basic Configuration

Indentation: Go to Window > Preferences > Java > Code Style > Formatter.
Project Folder: Select File > New > Java Project and choose the directory.

Run Code

Right-click on the .java file.
Select Run As > Java Application.

Create Executable .jar

Select the project from File > Export.
Choose Java > Runnable JAR file and save the .jar file.

IntelliJ IDEA

IDE Installation

Download IntelliJ IDEA from its official page.
Select either the Community or Ultimate version and follow the installation instructions.

Recommended Plugins

Kotlin: Adds support for Kotlin projects.
Git: Facilitates Git integration for version control.

Basic Configuration

Indentation: Configure it from File > Settings > Code Style.
Project Folder: Use File > New > Project to create or import an existing project.

Run Code

Right-click on the .java file.
Select the Run option.

Create Executable .jar

Go to File > Project Structure > Artifacts.
Add a .jar, select the main class, and use Build > Build Artifacts.

Comparison of IDEs

Installation Experience

Visual Studio Code: Quick and easy installation; useful for lightweight projects with easy configuration through extensions.
Eclipse: Robust but with a less intuitive interface. Ideal for large projects with advanced support like Maven.
IntelliJ IDEA: Easy to install and configure, with advanced autocompletion and efficient Java project management.

Cloud IDE: Codenvy

Codenvy is an online IDE for Java with Git integration and deployment options. It does not require installation and is accessible from any browser, facilitating remote work and collaboration.

Comparison between Local and Cloud IDEs

Advantages of Local IDEs: Allows for advanced customization, better performance offline, and plugin support.
Advantages of Cloud IDEs: No installation needed, accessible from multiple devices, ideal for team collaboration.

Conclusion

Using an IDE optimizes the workflow in software development, with integrated features that streamline development, debugging, and dependency management, significantly increasing productivity.

Full Research (in spanish)

DEV Community: Pau

Introduction to Markup Languages

Markup Languages

Index

Introduction

XML

JSON

Markdown

Tips for Beginners

Introduction to DBMS

Database Management Systems (DBMS)

1. DBMS Market Share in 2024

2. License (Paid or Free)

3. Compatible Platforms

4. Stored Procedures / Programming

5. Transaction Support

6. DBMS Comparative Table

7. Personal Choice of DBMS

8. References

Introduction to IDEs

Integrated Development Environments

Table of Contents

Visual Studio Code

IDE Installation

Recommended Extensions

Basic Configuration

Run Code

Create Executable .jar

Eclipse

IDE Installation

Recommended Plugins

Basic Configuration

Run Code

Create Executable .jar

IntelliJ IDEA

IDE Installation

Recommended Plugins

Basic Configuration

Run Code

Create Executable .jar

Comparison of IDEs

Installation Experience

Cloud IDE: Codenvy

Comparison between Local and Cloud IDEs

Conclusion