Coder in Suits

Ivan Chen

5.0 (1)
Technology

Work and Life for Coders in Suits

06/07/2025

CSV and Parquet: A Data Format Comparison

This episode explores **CSV (Comma-Separated Values) files**, a common plain text format for tabular data. * **What is CSV?** A plain text file where values are separated by commas and rows by line breaks. It's **human-readable** and universally viewable in text editors and spreadsheet programs. * **Key Uses:** Widely used for **data import/export** between software, data analysis, migration, backup, reporting, and machine learning datasets. * **Benefits:** Offers **broad compatibility** across applications and languages, is **efficient** due to its lightweight structure, and is simple to create, read, and manually edit. * **Limitations:** Suffers from a **lack of standardization**, leading to inconsistent formatting and user errors like missing data or encoding issues. It also has **security concerns** like CSV Injection and lacks built-in data validation or encryption. For large datasets, CSVs are **inefficient** due to their row-based structure and size limits in programs like Excel. They also lack schema definition, making data type inference challenging. * **CSV vs. Parquet:** * **CSV:** Simple, human-readable, best for **small datasets** or quick manual analysis. * **Parquet:** A **columnar binary format** designed for **large datasets**. It offers significantly **better compression**, **faster query performance** (by only reading relevant columns), and **embeds schema/data types**, ensuring data integrity and efficiency for analytical workloads. Parquet is not human-readable.
10/14/2024

Gitlab vs Github

A comparisom between GitHub and GitLab by NotebookLLM References YouTube Video: Wood, K. (2020, November 2). Git Gitlab vs Github [Video]. YouTube. https://www.youtube.com/watch?v=NzmbGPit8-0 GitLab Forum Post: cmetan. (2023, October 16). GitHub vs GitLab - Why should I choose GitLab?. GitLab Forum. https://forum.gitlab.com/t/github-vs-gitlab-why-should-i-choose-gitlab/98830 YouTube Video: S3CloudHub. (2020, March 29). GitHub vs GitLab | Difference between GitHub and GitLab | Which one is Best? [Video]. YouTube. https://www.youtube.com/watch?v=qN7n9rW85rk Medium Article: Ramesh, C. (2024, May 25). Gitlab vs Github. Medium. https://medium.com/@chanderr/gitlab-vs-github-95a140c6b030 GitHub Resources Webpage: How does GitHub compare to other DevOps tools?. (n.d.). GitHub Resources. https://resources.github.com/devops/github-vs-gitlab/
04/11/2024

How To FInd A Tech Internship in 2024

How To FInd A Tech Internship in 2024

3 Episodes

Work and Life for Coders in Suits

Creator

Ivan Chen
Years Active

2024 - 2025
Episodes

3
Rating

Clean
Show Website

Coder in Suits