| /sqlite-3.40.0/ |
| H A D | sqlite_cfg.h.in | 3 /* Define to 1 if you have the <dlfcn.h> header file. */
6 /* Define to 1 if you have the `fdatasync' function. */
9 /* Define to 1 if you have the `gmtime_r' function. */
12 /* Define to 1 if the system has the type `int16_t'. */
15 /* Define to 1 if the system has the type `int32_t'. */
21 /* Define to 1 if the system has the type `int8_t'. */
30 /* Define to 1 if you have the `isnan' function. */
48 /* Define to 1 if you have the `pread' function. */
115 /* Define to the full name of this package. */
124 /* Define to the home page for this package. */
[all …]
|
| H A D | configure.ac | 11 # located relative to this directory.
120 # if not, then we fall back to plain tclsh.
155 AC_MSG_NOTICE(Version set to $VERSION)
158 AC_MSG_NOTICE(Release set to $RELEASE)
199 # Do we want to support release
595 # Do we want to support math functions
609 # Do we want to support JSON functions
653 AC_MSG_CHECKING([whether to support FTS3])
662 AC_MSG_CHECKING([whether to support FTS4])
672 AC_MSG_CHECKING([whether to support FTS5])
[all …]
|
| H A D | README.md | 25 verify its integrity, there are hints on how to do that in the
30 If you do not want to use Fossil, you can download tarballs or ZIP
50 If you do want to use Fossil to check out the source tree,
64 update to the latest version using:
69 Or type "fossil ui" to get a web-based user interface.
73 First create a directory in which to place
83 cd bld ;# Change to the build directory
159 fill it with all the source files needed to build SQLite, both
187 opcode-number to opcode-name that is used for EXPLAIN output.
233 (helping to understand how SQLite works include the
[all …]
|
| /sqlite-3.40.0/src/ |
| H A D | sqlite.h.in | 626 ** refers to.
745 ** to NULL.
891 ** pointed to is set to the new limit.
1004 ** to a pointer to the top-level VFS.)^
1142 ** to block for up to M milliseconds before failing when attempting to
1642 ** changes to SQLite in order to tune SQLite to the specific needs of
2742 ** it is trying to promote to a reserved lock and
3110 ** not want the user to be able to make arbitrary changes to the
3800 ** is safe to pass to routines like:
5071 ** need to be added to the string.</li>
[all …]
|
| /sqlite-3.40.0/test/ |
| H A D | fts2c.test | 55 be more than willing to stay.');
99 or me to participate.
342 to someone on my team. I know it will take some time for the new names to
409 Assistant to Kevin Presto
511 These are the documents that Peter promised to give to you for Mark Frevert.
512 He has now handed them to him in person but asked me to transmit them
619 I haven''t talked to many of you via email recently but I do want to give you
685 If you need to know their power desk to map their ID to their gas books, those desks are as follows:
762 We also need to continue to explore a JEA buy-out.
1004 11:15....talk to you');
[all …]
|
| H A D | fts1c.test | 55 be more than willing to stay.');
99 or me to participate.
342 to someone on my team. I know it will take some time for the new names to
409 Assistant to Kevin Presto
511 These are the documents that Peter promised to give to you for Mark Frevert.
512 He has now handed them to him in person but asked me to transmit them
619 I haven''t talked to many of you via email recently but I do want to give you
685 If you need to know their power desk to map their ID to their gas books, those desks are as follows:
762 We also need to continue to explore a JEA buy-out.
1004 11:15....talk to you');
[all …]
|
| H A D | fts3ac.test | 55 be more than willing to stay.');
99 or me to participate.
342 to someone on my team. I know it will take some time for the new names to
409 Assistant to Kevin Presto
511 These are the documents that Peter promised to give to you for Mark Frevert.
512 He has now handed them to him in person but asked me to transmit them
619 I haven''t talked to many of you via email recently but I do want to give you
685 If you need to know their power desk to map their ID to their gas books, those desks are as follows:
730 …to your request, attached are the Schedule to the ISDA Master Agreement, together with Paragraph 1…
762 We also need to continue to explore a JEA buy-out.
[all …]
|
| H A D | io.test | 14 # more database pages than it has to, stuff like that).
92 # to be added to the root page of abc. 4 pages in total
114 # to the b-tree used to store table abc. It should only be necessary to
115 # write to 3 pages to do this: the change-counter, the root-page and
137 # 2) The journal file (to sync the page data),
235 } {1 {unable to open database file}}
271 } {1 {unable to open database file}}
392 # File size might be 1 due to the hack to work around ticket #3260.
439 # 2) The journal file (to sync the page data),
618 # cache size to become too small to hold the entire db in memory.
[all …]
|
| H A D | corruptD.test | 3 # The author disclaims copyright to this source code. In place of
29 # This test file attempts to verify that SQLite does not read past the
32 # that contains an offset to some other structure within the same page
33 # is set to too large a value. A database page contains the following
36 # 1. The page header field that contains the offset to the first
40 # list (the offset to the next free block).
57 # strategically corrupted database files to attempt to provoke such buffer
62 # (or similar) in order to verify that no overreads occur.
66 # Test cases corruptD-1.* are white-box tests. They attempt to corrupt
70 # Offset variables 1, 2, 3 and 4 are all checked to make sure they
[all …]
|
| /sqlite-3.40.0/autoconf/ |
| H A D | INSTALL | 39 If you need to do unusual things to compile the package, please try
40 to figure out how `configure' could check whether to do them, and mail
59 2. Type `make' to compile the package.
164 The most portable way to affect installation locations is to pass the
168 having to reconfigure or recompile.
199 Some packages pay attention to `--enable-FEATURE' options to
223 order to use an ANSI C compiler:
237 to try
275 need to know the machine type.
289 If you want to set default values for `configure' scripts to share,
[all …]
|
| /sqlite-3.40.0/ext/wasm/jaccwabyt/ |
| H A D | jaccwabyt.md | 75 experiment to determine whether it would be feasible to implement,
157 3. [Feed (2) to the function generated by (1)](#step-3) to create JS
309 aware of when we need to deal with pointers and pointers-to-pointers
342 is used to try to map that pointer to a struct instance. If a match
390 heap memory. The correct way to free up that memory is to use the
543 is transfered to the caller, who must eventually pass it to the
647 member. If its signature is `s` then it is assumed to refer to a
684 assign it to the given member, and add the new string to this
753 pointer to an object, this function can be used to type-safely
868 extended to tag specific members as serializable and how to
[all …]
|
| /sqlite-3.40.0/ext/fts3/ |
| H A D | README.content | 4 Normally, in order to create a full-text index on a dataset, the FTS4
9 designed to extend FTS4 to support the creation of full-text indexes where:
41 table. Attempting to do so is an error.
44 an error to attempt to retrieve the value of any table column other than
54 -- other than docid are required to evaluate them.
60 Errors related to attempting to retrieve column values other than docid
108 -- to return.
134 to predict. The FTS index may be left containing entries corresponding to the
140 some users may wish to use database triggers to keep the full-text index
141 up to date with respect to the set of documents stored in the content table.
[all …]
|
| H A D | README.tokenizers | 4 When creating a new full-text table, FTS3 allows the user to select
5 the text tokenizer implementation to be used when indexing text
13 The built-in tokenizers (valid values to pass as <tokenizer name>) are
17 arguments to pass to the selected tokenizer implementation. The
23 FTS3 allows users to provide custom tokenizer implementations. The
27 Registering a new FTS3 tokenizer is similar to registering a new
28 virtual table module with SQLite. The user passes a pointer to a
29 structure containing pointers to various callback functions that
34 FTS3 does not expose a C-function that users call to register new
36 be encoded as an SQL blob value and passed to FTS3 through the SQL
[all …]
|
| /sqlite-3.40.0/tool/ |
| H A D | build-all-msvc.bat | 55 REM when set ^(to anything^), they are:
186 ECHO Could not change directory to "%ROOT%".
341 REM it to something else later on.
349 REM it to something else later on.
357 REM it to something else later on.
365 REM it to something else later on.
651 ECHO Failed to copy "%DLL_FILE_NAME%" to "%BINARYDIRECTORY%\%%B\%%D\".
662 ECHO Failed to copy "%LIB_FILE_NAME%" to "%BINARYDIRECTORY%\%%B\%%D\".
676 ECHO Failed to copy "%DLL_PDB_FILE_NAME%" to "%BINARYDIRECTORY%\%%B\%%D\".
721 ECHO Failed to copy "%EXE_FILE_NAME%" to "%BINARYDIRECTORY%\%%B\%%D\".
[all …]
|
| /sqlite-3.40.0/doc/ |
| H A D | vdbesort-memory.md | 13 Assuming SQLITE_CONFIG_SMALL_MALLOC is not set, keys passed to the sorter are
14 added to an in-memory buffer. This buffer is grown using sqlite3Realloc() as
17 then this buffer is allowed to grow up to 2MB in size.
19 Once the buffer has grown to its threshold, keys are sorted and written to
22 the temp file, the buffer is reused to accumulate the next batch of keys.
25 to sort and flush once it is full, and a new buffer allocated to allow the
26 main thread to continue to accumulate keys. Buffers are reused once they
36 with a single database connection, to which it holds a pointer.
40 This case is similar to the above, except that instead of accumulating
43 List elements are freed as they are flushed to disk, either by the main
[all …]
|
| H A D | trusted-schema.md | 6 structures that cause code to run when some other application opens and
8 definition with a view. Or the attacker might add triggers to tables
39 the application takes deliberate steps to change the risk level.
42 will be updated to recommend applications turn TRUSTED\_SCHEMA to off.
59 We do not want an attacker to be able to add these kinds of things to
69 over to "Direct-Only" behavior using a single pragma.
82 turning TRUSTED\_SCHEMA on and off. It defaults to ON.
85 TRUSTED\_SCHEMA setting to be off.
90 calls to sqlite3\_db\_config().
99 5. New options to sqlite3\_vtab\_config():
[all …]
|
| H A D | vfs-shm.txt | 13 states. Each connection to a wal-index file must be in one of
24 These roughly correspond to the 5 states of a rollback lock except
42 WRITE - It is OK to append to the wal-index file and to adjust
43 the header to indicate the new "last valid frame".
45 PENDING - Waiting on all READ locks to clear so that a
51 other than to zero the last valid frame field in the
54 RECOVER - Held during wal-index recovery. Used to prevent a
65 a single state equivalent to READ, meaning that a writer could
81 The original database is the file named in the 2nd parameter to
104 those locking states in response to READ and CHECKPOINT requests,
[all …]
|
| H A D | wal-lock.md | 3 On some Unix-like systems, SQLite may be configured to use POSIX blocking locks
10 need to continuously poll the database lock, and (b) using blocking locks
15 to the \*-shm file nevery use blocking locks.
19 that lock multiple databases simultaneously to do so. In most cases the OS will
25 database clients changes from zero to one. In this case, a client is
26 considered to connect to the database when it first reads data from it.
31 returns SQLITE\_BUSY to the user. With blocking locks configured, the second
40 lock is required briefly as part of opening the transaction (to check that a
49 lock to do so if any of the following are true:
58 to a write-transaction. In that case a non-blocking lock is used.
[all …]
|
| H A D | pager-invariants.txt | 1 *** Throughout this document, a page is deemed to have been synced
6 *** Definition: A page of the database file is said to be "overwriteable" if
32 (3) Writes to the database file are an integer multiple of the page size
33 in length and are aligned to a page boundary.
39 (5) All writes to the database file are synced prior to the rollback journal
43 are synced prior to the master journal being deleted.
46 are said to be "logically equivalent" if they give the same answer to
52 of the unsynced changes to a rollback journal are removed and the
54 equivalent to the database file at the beginning of the transaction.
57 is called to restore the database file to the same size it was at
[all …]
|
| /sqlite-3.40.0/ext/async/ |
| H A D | README.txt | 9 Normally, when SQLite writes to a database file, it waits until the write
11 Since writing to the file-system is usually very slow compared with CPU
13 contains an extension that causes SQLite to perform all write requests
16 allows SQLite to return control to the caller quickly even when writing to
36 to occur. The write seems to happen very quickly, though in reality
57 written directly to disk, but is placed in the "write-queue" to be
63 the vfs reader the xWrite() appears to have already completed.
99 in the write-queue have been flushed to disk. This means
132 in sqlite3async.h to initialize and configure the module.
143 3. Use the normal SQLite API to read and write to databases via
[all …]
|
| /sqlite-3.40.0/ext/wasm/api/ |
| H A D | README.md | 4 `sqlite3-wasm.c`. This collection of files is used to build a
17 to be loaded as JS Workers.
30 of the WASM environment, to facilitate plugging it in to arbitrary
36 more portable to arbitrary WASM toolchains. This API is
39 to support this tree but is standalone and maintained together
48 Invokes functionality exposed by the previous two files to
50 these pieces related to the `sqlite3.capi.wasm` object.
62 A Worker-thread-based API which uses OO API #1 to provide an
79 Origin-Private FileSystem (OPFS) as a storage layer to provide
88 they add callback functions to be called during its
[all …]
|
| /sqlite-3.40.0/ext/expert/ |
| H A D | README.md | 3 This folder contains code for a simple system to propose useful indexes
6 1. The user database schema is copied to a temporary database.
12 1. The information gathered in step 2 is used to create candidate
16 1. A subset of the data in the user database is used to generate statistics
21 of the indexes created in step 3, they are recommended to the user.
36 1. Optionally, the **sqlite3\_expert\_config()** API may be used to
40 1. **sqlite3\_expert\_analyze()** is called to run the analysis.
42 1. One or more calls are made to **sqlite3\_expert\_report()** to extract
45 1. **sqlite3\_expert\_destroy()** is called to free all resources.
47 Refer to comments in sqlite3expert.h for further details.
[all …]
|
| /sqlite-3.40.0/ext/fts2/ |
| H A D | README.tokenizers | 4 When creating a new full-text table, FTS2 allows the user to select
5 the text tokenizer implementation to be used when indexing text
13 The built-in tokenizers (valid values to pass as <tokenizer name>) are
17 arguments to pass to the selected tokenizer implementation. The
23 FTS2 allows users to provide custom tokenizer implementations. The
27 Registering a new FTS2 tokenizer is similar to registering a new
28 virtual table module with SQLite. The user passes a pointer to a
29 structure containing pointers to various callback functions that
34 FTS2 does not expose a C-function that users call to register new
36 be encoded as an SQL blob value and passed to FTS2 through the SQL
[all …]
|
| /sqlite-3.40.0/ext/userauth/ |
| H A D | user-auth.txt | 4 The ext/userauth/sqlite3userauth.h header file is available to
5 applications to define the interface.
7 When using the SQLite amalgamation, it is sufficient to append
23 const char *zUsername, /* Username to be added */
31 const char *zUsername, /* Username to change */
39 const char *zUsername /* Username to remove */
47 database being opened requires authentication, then attempts to read
83 to create a new user. When called on a no-authentication-required
108 to delete a user. The currently logged-in user cannot be deleted,
113 The sqlite3_user_change() interface can be used to change a users
[all …]
|
| /sqlite-3.40.0/autoconf/tea/tclconfig/ |
| H A D | tcl.m4 | 1014 # Try to determine the proper flags to pass to the compiler
1025 # LDFLAGS - Flags to pass to the compiler when linking object
1028 # LD_SEARCH_FLAGS-Flags to pass to ld, such as "-R /usr/local/tcl/lib",
1037 # SHLIB_CFLAGS - Flags to pass to cc when compiling the components
1138 # default to '{$LIBS}' and set to "" on per-platform necessary basis
1860 # We need to specify -static-libgcc or we need to
2070 # Determine which interface to use to talk to the serial port.
3010 # $exec_prefix will be set to the values given to Tcl when it was
3131 # MAKE_LIB - Command to execute to build the Tcl library;
3365 # We want to ensure these are substituted so as not to require
[all …]
|