DuckDB - ftsrg/cheat-sheets GitHub Wiki

Build and test the JDBC driver

1. Use the Ninja build system and set BUILD_JDBC=1:

   GEN=ninja BUILD_JDBC=1 make
   

2. Run the tests:

   java -cp ./build/release/tools/jdbc/duckdb_jdbc.jar org.duckdb.test.TestDuckDBJDBC
   

Profiling queries

pragma enable_profiling;

Then, simply run the query. No additional keyword is required.

See also the documentation on runtime profiling.

Building on Windows 7

Use Visual Studio. Building with Cygwin and GCC does not work (at least not out of the box).

Adding an alias (d) on Linux

cd
rm -f duckdb_cli-linux-amd64.zip duckdb
wget https://github.com/duckdb/duckdb/releases/download/v0.5.1/duckdb_cli-linux-amd64.zip
unzip duckdb_cli-linux-amd64.zip
echo "alias d='~/duckdb'" >> ~/.bashrc