ywelsch / duckdb-prql Goto Github PK
View Code? Open in Web Editor NEWPRQL as a DuckDB extension
License: MIT License
PRQL as a DuckDB extension
License: MIT License
Heya! Thanks for sharing this extension. I've noticed that it'll fail when installing with duckdb v0.10.0 (released last week):
$ duckdb -unsigned
v0.10.0 20b1486d11
Enter ".help" for usage hints.
D SET custom_extension_repository='http://welsch.lu/duckdb/prql/latest';
D FORCE INSTALL prql;
Error: HTTP Error: Failed to download extension "prql" at URL "http://welsch.lu/duckdb/prql/latest/v0.10.0/osx_amd64/prql.duckdb_extension.gz"
Candidate extensions: "parquet", "sqlite", "sqlite3", "sqlite_scanner"
D
presumably because it hasn't been built for v0.10.0, as the extension repo only contains tarballs up to v0.9.2.
One workaround is to grab the duckdb v0.9.2 binary from the releases page and use that -- and the installation instructions work flawlessly โจ
Would it be possible to add 0.10.0 to the artifacts that are built? Are they built automatically, so that I can open a PR of some sort to help with this...? ๐ค
Hi,
I wanted to give a try to prql in duckdb on a Windows-10 laptop (duckdb-0.8.1).
I couldn't install it. Here are the steps:
> duckdb -unsigned
v0.8.1 6536a77232
Enter ".help" for usage hints.
D SET custom_extension_repository='welsch.lu/duckdb/prql/latest';
D FORCE INSTALL prql;
Error: HTTP Error: Failed to download extension "prql" at URL "http://welsch.lu/duckdb/prql/latest/v0.8.1/windows_amd64/prql.duckdb_extension.gz"
Candidate extensions: "parquet", "sqlite", "sqlite3", "sqlite_scanner"
D
Should it be possible as of now ? prql cli compiler works on Windows...
Very nice work, would it be possible to create a WASM extension to use it in duckdb-wasm?
duckdb(24577,0x16ffd3000) malloc: Heap corruption detected, free list is damaged at 0x600003aacec0
*** Incorrect guard value: 78611779014145
duckdb(24577,0x16ffd3000) malloc: *** set a breakpoint in malloc_error_break to debug
and
zsh: segmentation fault duckdb --unsigned
when running the demo example.
version = v0.9.2 3c695d7ba9
OS = Darwin Kernel Version 23.0.0: Fri Sep 15 14:41:43 PDT 2023; root:xnu-10002.1.13~1/RELEASE_ARM64_T6000 arm64
I was trying to build the extension so that I can use it in a Lambda function (see https://github.com/tobilg/duckdb-nodejs-layer/blob/main/Dockerfile.prql). Once I try to load in, I get the following error:
"IO Error: Extension \"/opt/nodejs/node_modules/duckdb/extensions/prql.duckdb_extension\" could not be loaded: /opt/nodejs/node_modules/duckdb/extensions/prql.duckdb_extension: undefined symbol: _ZTIN6duckdb9ExceptionE"
Not sure how I can get more info on this error though. It's compiled for the latest master branch of DuckDB. Thanks for any hint!
installing via the repository doesn't work as it looks like the /v0.9.2/linux_amd64_gcc4
doesn't exist in the repository.
D SET custom_extension_repository='http://welsch.lu/duckdb/prql/latest';
D install prql;
Error: HTTP Error: Failed to download extension "prql" at URL "http://welsch.lu/duckdb/prql/latest/v0.9.2/linux_amd64_gcc4/prql.duckdb_extension.gz"
Candidate extensions: "parquet", "sqlite", "sqlite3", "sqlite_scanner"
Copying the file from the remote repository to /home/me/.duckdb/extensions/v0.9.2/linux_amd64_gcc4/
then loading it cuases a segmentation fault.
Building it locally and running it with the version of duck the build process makes results in this result when issuing the PRQL statement from the README.
free(): invalid next size (fast)
Aborted (core dumped)
``
I was trying to do a custom compilation for the prql extension, but I'm seeing the following error during the build:
#8 1039.2 [ 62%] Building CXX object extension/prql/CMakeFiles/prql_extension.dir/src/prql_extension.cpp.o
#8 1039.3 /tmp/from-git/duckdb-prql/src/prql_extension.cpp:12:12: fatal error: libprql_lib.h: No such file or directory
#8 1039.3 #include "libprql_lib.h"
#8 1039.3 ^~~~~~~~~~~~~~~
#8 1039.3 compilation terminated.
#8 1039.3 gmake[3]: *** [extension/prql/CMakeFiles/prql_extension.dir/src/prql_extension.cpp.o] Error 1
Could you give me a hint on how to fix this? Thanks in advance @ywelsch!
Hi,
great work!
Is it somehow possible to create a View from an prql-Query?
Thanks,
Jannis
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.