Results of 1 - 10 of about 11 for pick (0.001 sec.)
- Writing JSON 11504
- The contents of tables or the result of queries can be written directly to a JSON file using the COPY statement. For example: CREATE TABLE cities AS FROM (VALUES ('Amsterdam', 1), ('London', 2)) cities(name, id); COPY cities TO 'cities.json
...'POINT(0 1)'::GEOMETRY AS geom, 10 AS my_field) TO 'test.jsonl' (FORMAT GEOJSONL); Optional ID_COLUMN and GEOMETRY_COLUMN pick which columns become the Feature id and geometry. st_asgeojson / st_geomfromgeojson convert a single value. Reading GeoJSO... - https://man.mtool.work/duckdb/2.0/data/json/writing_json.html
- DBine SQL Editor 10953
- DBine is a free, open-source (Apache 2.0) desktop database manager for Windows, macOS, and Linux that works with 130+ databases and cloud services. Besides a SQL editor, it includes notebooks, charts built from query results, and schema com
...ive the connection a name and enter the path to your DuckDB database file in Database file , or click the folder button to pick it. Leave the field empty or enter :memory: to open an in-memory database. Click Test connection to confirm the file can b... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbine.html
- VisuaLeaf SQL Editor 10953
- VisuaLeaf is a cross-platform desktop database client for Windows, macOS, and Linux. Besides a SQL editor, it includes a visual query builder, entity-relationship diagrams, and charts built from query results. VisuaLeaf ships with the DuckD
...DB . Give the connection a name and enter the path to your DuckDB database file in Database File Path , or click Browse to pick it. To create a new database file instead, click New DB . Click Test Connection to confirm the file can be opened, then cl... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/visualeaf.html
- JSON Overview 9335
- DuckDB supports SQL functions that are useful for reading values from existing JSON and creating new JSON data. JSON is supported with the json extension which is shipped with most DuckDB distributions and is auto-loaded on first use. If yo
...B does not support the full JSONPath syntax because SQL is readily available for any further transformations. It's best to pick either the JSONPath or the JSON Pointer syntax and use it in your entire application. Indexing Warning Following PostgreSQ... - https://man.mtool.work/duckdb/2.0/data/json/overview.html
- Android 9335
- DuckDB has experimental support for Android. Please use the latest main branch of DuckDB instead of the stable versions. Building the DuckDB Library Using the Android NDK We provide build instructions for setups using macOS and Android Stud
...io. For other setups, please adjust the steps accordingly. Open Android Studio . Select the Tools menu and pick SDK Manager . Select the SDK Tools tab and tick the NDK (Side by side) option. Click OK to install. Set the Android NDK's... - https://man.mtool.work/duckdb/2.0/dev/building/android.html
- Loops 9335
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...should be used when required. In this manner, when new combinations are added to the preset, old tests will automatically pick up these new combinations. Preset Expansion ⟨compression⟩ none uncompressed rle bitpacking dictionary fsst chimp patas ⟨si... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- marimo Notebooks 8784
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...book from your terminal with marimo edit notebook.py . Create SQL cells in one of three ways: Right-click the + button and pick SQL cell Convert any empty cell to SQL via the cell menu Hit the SQL button at the bottom of your notebook In marimo, SQL... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Securing Quack with a Reverse Proxy 8232
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
.... nginx + Let's Encrypt in production. Caddy + Let's Encrypt in production. The two production setups are interchangeable. Pick whichever fits your operational stack. Local Test Setup with Caddy You can exercise the full HTTPS path on your own machin... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Write User Defined Functions 6614
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...is finalized once register() (or close() ) is called. The simplest functions map directly to a Java functional interface. Pick the overload that matches the number of arguments and, for primitives, their type: withFunction(Supplier) , withFunction(F... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Azure Extension 6614
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...ity, the credential_chain provider uses it with no extra options. If it has several, use the MANAGED_IDENTITY provider and pick one with CLIENT_ID , OBJECT_ID or RESOURCE_ID : CREATE SECRET azure_mi ( TYPE azure, PROVIDER managed_identity, ACCOUNT_NA... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
DuckDB 2.0 Documentation / man.mtool.work