Search notes:

Data exchange formats

XML, GML, …
CSV, probably the most common import and export format for spreadsheets and databases.
JSON
GeoJSON
Apache Parquet
Protocol Buffers (protobuf)
YAML (Yaml ain't markup language), a superset of JSON, designed to be human readable and commonly used for configuration files
REBOL (Relative Expression Based Object Language)
RDF (Resource Description Framework)
Hierarchical Data Format
Gellish English (?)
GMT grid file format
INTERLIS
ATOM (a format that was developed as an alternative to RSS)

Challenges with CSV and JSON

CSV and JSON are notably quite prone to data corruption, mainly because these format have almost no notion for data types or domains (such as date and/or time). So, it's easy to insert a text such as hello world into a field that is supposed to store a date.

Scalability, parallel processing

CSV and JSON cannot (easily) be split into partitions that can be processed in parallel.

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758186347, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/Data/exchange/formats/index(60): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Data exchange formats

Challenges with CSV and JSON

Scalability, parallel processing

See also