After spending a bit of time with Neon’s SQL Editor making d and friends work, there were a couple of other things I wanted to bring to it, both related to the query results. The first was a simple expand-to-window control for the results pane, to get a better and less cramped look at query result tables and […]

Materialize

Bobby Iliev

DevOps

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

Neon's SQL Editor now supports exporting query results to CSV, JSON, and XLSX formats directly from the interface, eliminating the need for additional tools or steps. This feature allows for better data visualization and simplifies subsequent data handling tasks, particularly for Excel users. The update includes client-side JavaScript handling for these formats and introduces new npm packages, 'littlezipper' for zip file creation and 'xlsxtable' for Excel worksheet creation.

Export to CSV, JSON and XLSX from the Neon console