Fossil SCM
Document the need for compiling sqlite3.c with -DSQLITE_ENABLE_DBSTAT_VTAB=1.
Commit
74836bc8ae09edd152d8a9afa50cbd3a979c6d47
Parent
282ae5e4de23ff0…
1 file changed
+6
-4
+6
-4
| --- www/makefile.wiki | ||
| +++ www/makefile.wiki | ||
| @@ -224,20 +224,22 @@ | ||
| 224 | 224 | |
| 225 | 225 | Some files require special C-preprocessor macro definitions. |
| 226 | 226 | When compiling sqlite.c, the following macros are recommended: |
| 227 | 227 | |
| 228 | 228 | * -DSQLITE_OMIT_LOAD_EXTENSION=1 |
| 229 | + * -DSQLITE_ENABLE_DBSTAT_VTAB=1 | |
| 229 | 230 | * -DSQLITE_ENABLE_FTS4=1 |
| 230 | 231 | * -DSQLITE_ENABLE_LOCKING_STYLE=0 |
| 231 | 232 | * -DSQLITE_THREADSAFE=0 |
| 232 | 233 | * -DSQLITE_DEFAULT_FILE_FORMAT=4 |
| 233 | 234 | * -DSQLITE_ENABLE_EXPLAIN_COMMENTS=1 |
| 234 | 235 | |
| 235 | -The first two symbol definitions above are required; the others are merely | |
| 236 | -recommended. Extension loading is omitted as a security measure. FTS4 is | |
| 237 | -needed for the search feature. Fossil is single-threaded so mutexing is | |
| 238 | -disabled in SQLite as a performance enhancement. The | |
| 236 | +The first three symbol definitions above are required; the others are merely | |
| 237 | +recommended. Extension loading is omitted as a security measure. The dbstat | |
| 238 | +virtual table is needed for the [/help?cmd=/repo-tabsize|/repo-tabsize] page. | |
| 239 | +FTS4 is needed for the search feature. Fossil is single-threaded so mutexing | |
| 240 | +is disabled in SQLite as a performance enhancement. The | |
| 239 | 241 | SQLITE_ENABLE_EXPLAIN_COMMENTS option makes the output of "EXPLAIN" queries |
| 240 | 242 | in the "[/help?cmd=sqlite3|fossil sql]" command much more readable. |
| 241 | 243 | |
| 242 | 244 | When compiling the shell.c source file, these macros are required: |
| 243 | 245 | |
| 244 | 246 |
| --- www/makefile.wiki | |
| +++ www/makefile.wiki | |
| @@ -224,20 +224,22 @@ | |
| 224 | |
| 225 | Some files require special C-preprocessor macro definitions. |
| 226 | When compiling sqlite.c, the following macros are recommended: |
| 227 | |
| 228 | * -DSQLITE_OMIT_LOAD_EXTENSION=1 |
| 229 | * -DSQLITE_ENABLE_FTS4=1 |
| 230 | * -DSQLITE_ENABLE_LOCKING_STYLE=0 |
| 231 | * -DSQLITE_THREADSAFE=0 |
| 232 | * -DSQLITE_DEFAULT_FILE_FORMAT=4 |
| 233 | * -DSQLITE_ENABLE_EXPLAIN_COMMENTS=1 |
| 234 | |
| 235 | The first two symbol definitions above are required; the others are merely |
| 236 | recommended. Extension loading is omitted as a security measure. FTS4 is |
| 237 | needed for the search feature. Fossil is single-threaded so mutexing is |
| 238 | disabled in SQLite as a performance enhancement. The |
| 239 | SQLITE_ENABLE_EXPLAIN_COMMENTS option makes the output of "EXPLAIN" queries |
| 240 | in the "[/help?cmd=sqlite3|fossil sql]" command much more readable. |
| 241 | |
| 242 | When compiling the shell.c source file, these macros are required: |
| 243 | |
| 244 |
| --- www/makefile.wiki | |
| +++ www/makefile.wiki | |
| @@ -224,20 +224,22 @@ | |
| 224 | |
| 225 | Some files require special C-preprocessor macro definitions. |
| 226 | When compiling sqlite.c, the following macros are recommended: |
| 227 | |
| 228 | * -DSQLITE_OMIT_LOAD_EXTENSION=1 |
| 229 | * -DSQLITE_ENABLE_DBSTAT_VTAB=1 |
| 230 | * -DSQLITE_ENABLE_FTS4=1 |
| 231 | * -DSQLITE_ENABLE_LOCKING_STYLE=0 |
| 232 | * -DSQLITE_THREADSAFE=0 |
| 233 | * -DSQLITE_DEFAULT_FILE_FORMAT=4 |
| 234 | * -DSQLITE_ENABLE_EXPLAIN_COMMENTS=1 |
| 235 | |
| 236 | The first three symbol definitions above are required; the others are merely |
| 237 | recommended. Extension loading is omitted as a security measure. The dbstat |
| 238 | virtual table is needed for the [/help?cmd=/repo-tabsize|/repo-tabsize] page. |
| 239 | FTS4 is needed for the search feature. Fossil is single-threaded so mutexing |
| 240 | is disabled in SQLite as a performance enhancement. The |
| 241 | SQLITE_ENABLE_EXPLAIN_COMMENTS option makes the output of "EXPLAIN" queries |
| 242 | in the "[/help?cmd=sqlite3|fossil sql]" command much more readable. |
| 243 | |
| 244 | When compiling the shell.c source file, these macros are required: |
| 245 | |
| 246 |