Blog
Why CSV is still king
CSV is the cockroach of data formats. It's simple, tough, and refuses to die. While fancier formats have come and gone, CSV quietly rules the data world. Let's explore how this accidental standard ca...
How to Convert Data Files in PHP with the Konbert API
Konbert is a file conversion service that offers an API to convert files between various formats like CSV, JSON, Avro, or Arrow. In this article, we will learn how to convert files using PHP with the...
How to Convert Data Files in Node.js with the Konbert API
Konbert is a file conversion service that offers an API to convert files between various formats like CSV, JSON, Avro, or Arrow. In this article, we will learn how to use the Konbert API's `/convert`...
Avro vs Arrow: What are the differences?
Avro and Arrow are two popular data formats used in a variety of settings. They both have advantages and disadvantages, and understanding their differences is essential for making informed decisions ...
3 Must Have Skills for Becoming a Successful Data Engineer
Data is becoming increasingly important in the way we do business everywhere, from big digital tech startups to even small town companies. Data drives our decision making, and it's not just importan...
Avro vs JSON: What are the differences?
JSON is a data format that has been around what seems like ages, being used widely as an export format and common exchange format for web APIs everywhere. You might ask yourself, why would I bother u...
The easiest way migrate data from MongoDB to MySQL
**MongoDB** is a NoSQL database that stores data in BSON format, and for that reason, it is not always obvious on how to migrate this data into relational databases like MySQL. The main issue is tha...
Convert JSON to CSV in Python 3 using Pandas
In this tutorial we'll be converting a JSON file to CSV using Python. Let's say we have a JSON file that looks like this: ```json [ { "id": 1, "name": "Albert", "address": { "ci...
Import JSON into Postgres using COPY
Loading data is a very common task when working with databases, and most of the data comes from external data sources, like JSON or CSV files. Fortunately, most databases offer some kind of mechanis...
Convert between CSV, JSON and SQL files in PHP using the Sqlify API
Once you sign up and get an API key, you will get access to our **REST API** which lets you upload and convert files without the need to use our web interface. So before using the API, go ahead and ...