ywelsch/duckdb-prql

PRQL as a DuckDB extension

duckdb-prql's Issues

no build artifact for duckdb v0.10.0

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...? 🤔

Installation on Windows ?

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...

WASM extension

Very nice work, would it be possible to create a WASM extension to use it in duckdb-wasm?

malloc: Heap corruption detected and segfault when running demo example

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

Error when using extension in a Lambda function

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!

Can't install from repository, cant build from source.

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)
``

Error when compiling extension

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!

Create View from prql

Hi,

great work!

Is it somehow possible to create a View from an prql-Query?

Thanks,

Jannis