/plushcap/analysis/neon/neon-export-to-csv-json-and-xlsx-from-the-neon-console

Export to CSV, JSON and XLSX from the Neon console

What's this blog post about?

The text discusses the implementation of CSV, JSON, and XLSX exporting capabilities from Neon's SQL Editor console. It highlights the challenges faced during the development process, such as ensuring precision in big or precise numbers for CSV and JSON downloads, and dealing with Excel's XML format and column references. The author also introduces two new npm packages: littlezipper, a Zip library that works across modern browsers, Node, and Deno; and xlsxtable, an Excel worksheet-writing library that depends on littlezipper.

Company
Neon

Date published
May 16, 2024

Author(s)
George MacKerron

Word count
1337

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.