Search notes:

jq: @csv

@csv formats each incoming arrays as CSV record, thus, it processes a series of arrays, not an array of arrays.

Note the -r (raw output) option in the following example:

$ echo '
  [42, "Hello world"]
  [99, "Ninety nine"]
' |
  jq -r @csv
42,"Hello world"
99,"Ninety nine"

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...', 1788499616, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/JavaScript/JSON/tools/jq/at/csv(46): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

jq: @csv

See also