Results of 1 - 9 of about 9 for serialized (0.003 sec.)
- SQL to/from JSON 14002
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json serialized
...zed statements back to an equivalent SQL string. json_execute_serialized_sql(varchar) Table Execute json serialized statements and return the resulting rows. Only one statement at a time is suppo...d logical query plan of a set of semicolon-separated ( ; ) statements to JSON. If optimize is true , the optimized plan is serialized. json_serialize_sql(varchar, skip_default := boolean, skip_empty := boolean, skip_null := boolean, format := boolean) Scal...ar Serialize a set of semicolon-separated ( ; ) select statements to an equivalent list of json serialized statements. PRAGMA json_execute_serialized_sql(varchar) Pragma Pragma version of the json_execute_serialized_sql function.... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- EXPORT and IMPORT DATABASE Statements 9113
- The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again. Examples Export the database to the target directory target_direc
...rialization: EXPORT DATABASE 'target_directory' (FORMAT csv, DELIMITER '|'); Export to directory target_directory , tables serialized as Parquet: EXPORT DATABASE 'target_directory' (FORMAT parquet); Export to directory target_directory , tables serialized... - https://man.mtool.work/duckdb/2.0/sql/statements/export.html
- Node.js Client (Neo) 8430
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...UNION DuckDBUnionValue UUID DuckDBUUIDValue To retrieve values as JavaScript built-ins or as values that can be losslessly serialized to JSON instead of these specialized objects, use the JS or Json result methods described in Convert Result Data . Convert...see Inspect Data Values below. To retrieve data in a different form, such as JS built-ins or values that can be losslessly serialized to JSON, use the JS or Json forms of the above result data methods. Custom converters can be supplied as well. See the imp...n": [ // { "tag": "name", "value": "Frank" }, // { "tag": "age", "value": 5 } // ] // } Column names and types can also be serialized to JSON: const columnNamesAndTypes = reader.columnNamesAndTypesJson(); // { // "columnNames": [ // "int_array", // "struct... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- marimo Notebooks 8358
- 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
...menu Hit the SQL button at the bottom of your notebook In marimo, SQL cells give the appearance of writing SQL while being serialized as standard Python code using the mo.sql() function, which keeps your notebook as pure Python code without requiring speci... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Indexing 8304
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...changes can further decrease the impact of indexes on DuckDB's available memory. Indexes and Opening Databases Indexes are serialized to disk and deserialized lazily, i.e., when reopening the database. Operations using the index will only load the required... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- PostgreSQL Compatibility 8250
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...space, refer to the “Reclaiming space” page . Strings Since version 1.3.0, DuckDB escapes characters such as ' in strings serialized in nested data structures. PostgreSQL does not do this. For an example, run: SELECT ARRAY['''']; PostgreSQL returns: {'} D... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Reference 8178
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...fer_bytes UBIGINT 268435456 (256 MiB) Server-side per-stream byte budget, at most a quarter of memory_limit . FETCH counts serialized payload bytes, INSERT counts decoded chunk allocations. 0 disables the limit. Server Connections Setting Type Default Desc... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Vector Similarity Search Extension 8124
- The vss extension is an experimental extension for DuckDB that adds indexing support to accelerate vector similarity search queries using DuckDB's new fixed-size ARRAY type. See the announcement blog post and the “What's New in the Vector S
...re no incremental updates to persistent index storage, so every time DuckDB performs a checkpoint the entire index will be serialized to disk and overwrite itself. Similarly, after a restart of the database, the index will be deserialized back into main me... - https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
- Configuration 8052
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...use storage block prefetching. VARCHAR REMOTE_ONLY storage_compatibility_version Sets the DuckDB version for which data is serialized to the DuckDB file during checkpointing. Can differ from the version of the DuckDB instance. VARCHAR latest table_function... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work