... Full-featured SQL implementation with advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions. (Omitted features) A complete database is stored in a single cross-platform disk file. Great for use as an application ... 

5.1. Dependencies  ... Or to get the version of compile-for-windows.md that was valid on 2024-10-18, use a URL like this: "https://sqlite.org/src/doc/20241018/doc/compile-for-windows.md".

 ... Used by:   sql-stmt See also:   lang_vacuum.html window-defn: Used by:   select-core   select-stmt   window-function-invocation References:   expr   frame-spec   ordering ... 

sqlite3_win32_set_directory(), sqlite3_win32_set_directory8(), sqlite3_win32_set_directory16()

These interfaces are available only on Windows. The sqlite3_win32_set_directory interface is used to set the value associated with the sqlite3_temp_directory or sqlite3_data_directory variable, to zValue, depending on the value of the type parameter. The zValue parameter should be NULL to ... 

4. How To Install  ... sqlite3_rsync sample.db mac:sample.db --exe /some/weird/place/sqlite3_rsync The writer of this document has never had any success in getting SSHD to run on Windows. Perhaps he will figure that out and be able to provide instructions ... 

sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()

 ... Function sqlite3_create_window_function() is similar, but allows the user to supply the extra callback functions needed by aggregate window functions. The first parameter is the database connection to which the SQL function is to be added. If an application uses more ... 

 ... math functions ON CONFLICT clause PRAGMA REINDEX RELEASE SAVEPOINT REPLACE RETURNING clause ROLLBACK TRANSACTION SAVEPOINT SELECT UPDATE UPSERT VACUUM window functions WITH clause The routines sqlite3_prepare_v2(), sqlite3_prepare(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_exec(), and sqlite3_get_table() accept an SQL statement list (sql-stmt-list ... 

2.3.3. The Window Function Callbacks Window functions use the same xStep() and xFinal() callbacks that aggregate functions use, plus two others: xValue and xInverse. See the documentation on application-defined window functions for further details.

sqlite3_mutex_alloc(), sqlite3_mutex_free(), sqlite3_mutex_enter(), sqlite3_mutex_try(), sqlite3_mutex_leave()

 ... The SQLITE_MUTEX_PTHREADS and SQLITE_MUTEX_W32 implementations are appropriate for use on Unix and Windows. If SQLite is compiled with the SQLITE_MUTEX_APPDEF preprocessor macro defined (with "-DSQLITE_MUTEX_APPDEF=1"), then no mutex implementation is included with the library. In this case the application ... 

 ... OFFSET UNION, UNION ALL, INTERSECT, and EXCEPT A rich library of standard SQL functions Aggregate functions including DISTINCT aggregates Window functions UPDATE, DELETE, and INSERT (of course) Common table expressions including recursive common table expressions Row values UPSERT An advanced ...