Results of 1 - 10 of about 13 for Besides (0.001 sec.)
- DBine SQL Editor 12299
- 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
... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbine.html
- VisuaLeaf SQL Editor 12299
- 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
... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/visualeaf.html
- Comparisons 10381
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...ng, consider creating a macro with the typeof function or implementing a user-defined function . BETWEEN and IS [NOT] NULL Besides the standard comparison operators there are also the BETWEEN and IS (NOT) NULL operators. These behave much like operators... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- Troubleshooting 9079
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...ash. To avoid this, it's recommended to import numpy.core.multiarray before starting up threads. Many Threads per Database Besides its worker threads, each database starts a pool of asynchronous I/O threads : by default four times the number of CPU core... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- Result Verification 9079
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...--- 42 84 10 20 # value-wise query II SELECT 42, 84 UNION ALL SELECT 10, 20; ---- 42 84 10 20 Hashes and Outputting Values Besides direct result verification, the sqllogic test suite also has the option of using MD5 hashes for value comparisons. A test... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Installing Extensions 8445
- To install core DuckDB extensions, use the INSTALL command. For example: INSTALL httpfs; This installs the extension from the default repository ( core ). Extension Repositories By default, DuckDB extensions are installed from a single repo
...re set of extensions. These extensions live in the default core repository, which points to http://extensions.duckdb.org . Besides the core repository, DuckDB also supports installing extensions from other repositories. For example, the core_nightly rep... - https://man.mtool.work/duckdb/2.0/extensions/installing_extensions.html
- Python API 7794
- Installation To use the DuckDB Python client, visit the Python installation page . The latest stable version of the DuckDB Python client is 2.0.0. Installation The DuckDB Python API can be installed using pip : pip install duckdb . Please s
...nary, where configuration options can be specified. For example: import duckdb con = duckdb.connect(config={"threads": 1}) Besides its worker threads, each database starts a pool of asynchronous I/O threads : by default four times the number of CPU core... - https://man.mtool.work/duckdb/2.0/clients/python/overview.html
- ODBC Extension 7794
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...erformance API, odbc_query uses multiple API calls per-row and performs UCS-2 to UTF-8 conversion for every VARCHAR value. Besides that, query processing is strictly single-threaded. When submitting issues related only to performance please check the pe... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- CSV Auto Detection 7794
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...arate step using the sniff_csv(filename) function, which returns the detected CSV properties as a table with a single row. Besides the commonly used sample_size parameter, which configures the number of rows sampled, sniff_csv accepts the same named par... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Loading JSON 7794
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...ine_delimited . read_ndjson_auto(filename) Alias for read_json with parameter format set to newline_delimited . Parameters Besides the maximum_object_size , format , ignore_errors and compression , these functions have additional parameters: Name Descri... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
DuckDB 2.0 Documentation / man.mtool.work