Hello, the SQL workbench is awesome. May I know which technique is required to build the UI and BE? And how to get started for a new programmer? Thanks.
Very very nice tool you built there. Congrats!
Is there any possibility to ".open" a local duckdb file instead of working in ":memory:" ?
Very nice tool. I am missing, however, a mention of whether the data is processed exclusively in the local browser or if some data is shared with the server. If so, which data is shared with the server and how it is used. A privacy statement/data protection policy, basically.
I would also love to be able to run this locally in my machine using a light http server, if possible.
This article and Workbench are mind-blowing. Super impressed.
May you open source your duckdb playground, it's so fascinating that I'm curious to build my own customized version :)
Hi Tobias, I am an SQL beginner and wanted to use this to examine CSVs I work with - looks to be a great interface and works fine with the example files. But using CSVs on my laptop give errors for various CSVs including a copy of the aws_services.csv
ERROR Parser Error: syntax error at or near \2024. LINE 1: SELECT * FROM 2024-02-06 feed full.csv LIMIT 10. ^
or ERROR IO Error: No files found that match the pattern \aws_services.csv)
It seems to recognise the file ok as it generates columns correctly on the Tables view - but trying to query the table gives various errors
Am I doing something wrong? Using:Chrome, Windows10
Michael Booth
DataBooth: Data-driven solutions for business
Really nice work!! Apologies if this is described elsewhere - can you connect to a local (or e.g. S3 hosted) version of a DuckDB database (i.e. .duckdb) file? Or only CSV, Parquet, JSON etc?