Results of 1 - 10 of about 13 for themselves (0.003 sec.)
- Securing DuckDB 11366
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...tem operations are disabled by configuration Locking Configurations Security-related configuration settings generally lock themselves for safety reasons. For example, while we can disable community extensions using the SET allow_community_extensions = fals...This prevents re-enabling settings that were explicitly disabled. Nevertheless, many configuration settings do not disable themselves, such as the resource constraints. If you allow users to run SQL statements unrestricted on your own hardware, you might w... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- IN Operator 11366
- The IN operator checks containment of the left expression inside the collection on the right hand side (RHS). Supported collections on the RHS are tuples, lists, and maps, as well as subqueries that return a single column. The single-column
...restriction applies only to subqueries; tuples, lists, and maps may themselves contain composite values. IN (val1, val2, ...) (Tuple) The IN operator on a tuple (val1, val2, ...) returns true if the ex... - https://man.mtool.work/duckdb/2.0/sql/expressions/in.html
- GROUP BY Clause 11366
- The GROUP BY clause specifies which grouping columns should be used to perform any aggregations in the SELECT clause. If the GROUP BY clause is specified, the query is always an aggregate query, even if no aggregations are present in the SE
...the grouping columns (i.e., all tuples that belong to the same group) will be combined. The values of the grouping columns themselves are unchanged, and any other columns can be combined using an aggregate function (such as count , sum , avg , etc). GROUP... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/groupby.html
- Securing Extensions 9396
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...db -unsigned in the CLI). It cannot be changed while the database is running. Security-related configuration settings lock themselves , i.e., it is only possible to restrict capabilities in the current process. For example, attempting the following configu... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- WITH Clause 9396
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...Recursive CTEs can reference themselves. Basic CTE Examples Create a CTE called cte and use it in the main query: WITH cte AS (SELECT 42 AS x) SELECT * FROM cte;...is not inlined or executed more than once. Recursive CTEs WITH RECURSIVE allows the definition of CTEs which can refer to themselves. Note that the query must be formulated in a way that ensures termination, otherwise, it may run into an infinite loop. Ex... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Statically Linking Extensions 8745
- This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in
...make Changing the linked set only re-generates the loader, compiles it, and re-links; it does not recompile the extensions themselves. An extension that is built but not statically linked is still available: it is installed from the build's own extension r... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Analyzing a Git Repository 8745
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...'over', 'own', 's', 'same', 'she', 'should', 'so', 'some', 'such', 't', 'than', 'that', 'the', 'their', 'theirs', 'them', 'themselves', 'then', 'there', 'these', 'they', 'this', 'those', 'through', 'to', 'too', 'under', 'until', 'up', 'very', 'was', 'we',... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Subqueries 8745
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...rue Correlated Subqueries All the subqueries presented here so far have been uncorrelated subqueries, where the subqueries themselves are entirely self-contained and can be run without the parent query. There exists a second type of subqueries called corre... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- GROUPING SETS 8076
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...identified by NULL -values returned for the respective column in the grouping. But if the columns used in the grouping can themselves contain actual NULL -values, then it can be challenging to distinguish whether the value in the resultset is a “real” NULL... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- Vector Similarity Search Extension 7425
- 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
...ons for users who are ok with performing brute-force vector similarity searches without having to write out the join logic themselves. In the future these might become targets for index-based optimizations as well. These functions can be used as follows: C... - https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
DuckDB 2.0 Documentation / man.mtool.work