SQLite

All files named ”ext/misc/fileio.c”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for ext/misc/fileio.c

2025-05-13
16:58
First cut at enhancing the fsdir virtual table so that it works with unicode characters on Windows. file: [34993b8105] check-in: [c9e04dadfd] user: drh branch: trunk, size: 31194
2025-01-03
11:22
Avoid using Int32x32To64() with a 64-bit argument in fileio.c - this level of micro-optimization is not really necessary there. file: [07cf3109ec] check-in: [1291b013a8] user: dan branch: trunk, size: 30319
2024-09-25
15:26
Have the zipfile and fileio extensions use sqlite3_stdio.c when it is available - such as when those extensions are preloaded into the CLI. file: [e6b34db4df] check-in: [74bbb2b2b4] user: drh branch: cli-stdlib, size: 30332
2024-09-20
17:41
Fix comment typo in the fileio.c extension. No changes to code. file: [001179b297] check-in: [bf2c5b368a] user: drh branch: trunk, size: 30060
2024-05-06
20:21
When extracting links from sqlar archives, clobber any existing file or link, and do not call utimes() to set the timestamp - it looks through the link and operates on the target. file: [916638042f] check-in: [2bf8c3f99a] user: dan branch: trunk, size: 30061
2023-12-03
19:32
Partial hand-merge of shell.c.in (not buildable) file: [d668e98676] check-in: [62e90c9ba8] user: larrybr branch: cli_extension_wip, size: 29797
2023-10-06
12:51
Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. file: [d88e60f635] check-in: [f3b3d712d6] user: drh branch: trunk, size: 29797
2023-05-09
21:20
Made to build (again). file: [37f19acaf2] check-in: [3eb194957c] user: larrybr branch: cli_extension, size: 29749
2022-07-22
20:24
Add experimental 'xShadowName2' method for virtual table modules. file: [a96bd8bb76] check-in: [57beb700c0] user: mistachkin branch: xShadowName2, size: 29799
2021-12-16
17:35
New defenses against OOM and corrupt database problems in the CLI. file: [4e7f7cd30d] check-in: [5c9fd7fde1] user: drh branch: trunk, size: 29749
2021-09-20
21:42
Accomplish fileio standalone for Win32 with less intervention. file: [57fefd0efc] check-in: [af5dcc9c2a] user: larrybr branch: trunk, size: 29712
20:15
Allow fileio extension to be a stand-alone DLL for Win32 file: [896dcad10a] check-in: [d1cc3105b2] user: larrybr branch: trunk, size: 29883
2020-07-29
16:18
Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. file: [d85adf6217] check-in: [a80ae2c98b] user: drh branch: typos, size: 28556
2020-04-09
15:31
When compiling the shell for WinRT, avoid using Win32 APIs that are unavailable. file: [9b69e25da3] check-in: [85d3dc8c50] user: mistachkin branch: trunk, size: 28557
2020-01-07
19:45
Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. file: [bfa11a207d] check-in: [4c21373c21] user: drh branch: new-security-options, size: 28529
2019-03-26
16:21
Fix harmless compiler warnings. file: [288e7230e0] check-in: [a063f7c426] user: drh branch: trunk, size: 28375
2019-03-25
15:06
Fix the writefile() SQL function implemented by ext/misc/fileio.c such that any directories created have standard umask permissions, not permissions of the file that is to be written. file: [54dff4a21c] check-in: [f11c89595d] user: drh branch: trunk, size: 28360
2019-03-20
05:45
Fix various harmless compiler warnings seen with MSVC. file: [b8e9421ea5] check-in: [1c0fe5b576] user: mistachkin branch: noWarnings, size: 28363
2019-02-27
19:59
Fix the readfile() UDF so that it returns an empty BLOB, not an OOM error, when reading an empty file. file: [e7864c391e] check-in: [0edad5339e] user: drh branch: trunk, size: 28355
2019-01-11
23:08
Use 64-bit APIs in the fileio.c extension. file: [592d6531d8] check-in: [b49d56a0fa] user: drh branch: trunk, size: 28343
17:20
Improved detection and reporting of errors in the readfile() extension SQL function. file: [801d2ac9fa] check-in: [d2f0b5a483] user: drh branch: trunk, size: 28339
2019-01-08
20:02
Use 64-bit math to compute the sizes of memory allocations in extensions. file: [03ba86d5b3] check-in: [ca67f2ec0e] user: drh branch: trunk, size: 27626
2018-11-16
13:56
Enhance the xBestIndex interface of virtual table so that if the xBestIndex method returns SQLITE_CONSTRAINT then that particular combination of constraints is considered unusable and does not participate further in query planning. file: [e3153b0443] check-in: [684013cef6] user: drh branch: trunk, size: 27602
13:06
Fix comments and make magic numbers into #defines in the fsdir implementation. file: [45acde5c06] check-in: [c537c9c363] user: drh branch: trunk, size: 26944
08:36
Fix a problem with virtual table "fsdir" and some join queries. file: [df4ac09b20] check-in: [7fffcee0fc] user: dan branch: trunk, size: 26125
2018-11-05
23:01
Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. file: [70f933c2e5] check-in: [31942b3dd3] user: drh branch: read-only-shadow, size: 26091
2018-09-08
16:53
Fix typo in the Win32-specific code for the fileio extension. file: [7317d825fa] check-in: [e812e5d59a] user: mistachkin branch: trunk, size: 26042
2018-03-23
00:31
Fix harmless compiler warnings seen with MSVC. file: [48c7751c78] check-in: [2f2be1b181] user: mistachkin branch: trunk, size: 26041
2018-03-16
23:54
Win32 portability fixes to the 'fileio' extension. file: [da441efc13] check-in: [9d2b0f8b84] user: mistachkin branch: testFixes, size: 25991
2018-03-15
05:25
Draft fix for an fsdir() issue reported via the mailing list. file: [673d6bde25] check-in: [48641010c2] user: mistachkin branch: fsDirFix, size: 23256
2018-01-29
19:47
Add unix-only tests to check that the "unzip" program can unpack archives generated by the zipfile extension. file: [4cad3a78bf] check-in: [438c5c5237] user: dan branch: trunk, size: 23238
2018-01-23
15:26
Fix the modification-time setting logic in the fileio.c extension on Windows so that it works with utf8 filenames. file: [bd2f717be6] check-in: [f785b90415] user: drh branch: trunk, size: 23238
2018-01-17
13:15
Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. file: [06bd79dcc4] check-in: [bfbeffab77] user: drh branch: trunk, size: 23053
2018-01-12
14:34
Always use utimes() instead of utimensat() since the latter is not available even on some recent unix systems. file: [777c13f00b] check-in: [30ed7a4b64] user: drh branch: trunk, size: 22801
2018-01-10
17:19
In the fileio.c extension, change the filetype(MODE) function into lsmode(MODE). Use the new lsmode(MODE) function in shell.c. file: [1194228c96] check-in: [52d12ba9f3] user: drh branch: archive-improvements, size: 22726
15:53
Add the "filetype()" SQL function for interpreting file modes to the fileio.c extension. file: [19d4e5590a] check-in: [58c0c74c40] user: drh branch: archive-improvements, size: 22520
2018-01-09
14:27
Attempt to fix the fileio.c extension so that it builds on MinGW-64. file: [5176893c15] check-in: [a7446d3217] user: drh branch: trunk, size: 21845
02:27
Avoid a compiler warning when building with newer versions of MinGW file: [8bc7277143] check-in: [cba0206a15] user: drh branch: trunk, size: 21846
2018-01-08
17:09
Remove a superfluous define from the 'fileio' extension when compiled for Win32. file: [edf880df28] check-in: [6dcba6693f] user: mistachkin branch: trunk, size: 21820
2018-01-07
23:28
Avoid the use of utimensat() on older unix platforms. file: [672e89e125] check-in: [90cb01d8d6] user: drh branch: trunk, size: 21848
2018-01-05
18:51
Fix a bug introduced by efforts to reduce compiler warnings in check-in [364ac333b030f0] file: [f16e2ef879] check-in: [1d6cee9ad4] user: drh branch: sqlar-shell-support, size: 21594
17:10
Fix compiler warnings. file: [1e36947064] check-in: [19aabccfe3] user: mistachkin branch: sqlar-shell-support, size: 21577
14:55
Fix compiler warnings. file: [864984342e] check-in: [364ac333b0] user: drh branch: sqlar-shell-support, size: 21556
2018-01-04
23:49
In the 'fileio' extension code for Win32, use the FILE_FLAG_BACKUP_SEMANTICS flag when setting the file times, just in case the file is actually a directory. file: [868aa0572b] check-in: [4f34440600] user: mistachkin branch: sqlar-shell-support, size: 21560
22:46
Get the shell enhancements compiling with MSVC. file: [16cf8d9b93] check-in: [335387f9e0] user: mistachkin branch: sqlar-shell-support, size: 21529
2017-12-14
19:15
Have the writefile() function optionally set the modification-time of the files it writes or creates. And many small fixes to the new code on this branch. file: [014152d413] check-in: [7b51269cae] user: dan branch: sqlar-shell-support, size: 20424
2017-12-12
20:04
Add support for parsing options in non-traditional tar form to the ".ar" command. Have writefile() attempt to create any missing path components. And not to throw an exception if it is called to create a directory that already exists. file: [29b7fc9475] check-in: [38dbeb1e77] user: dan branch: sqlar-shell-support, size: 17398
2017-12-11
20:22
Enhance virtual table "fsdir" in ext/misc/fileio.c. Add support for "-C" to the shell command's ".ar c" command. file: [238d0c65a1] check-in: [0394889afe] user: dan branch: sqlar-shell-support, size: 15497
2017-12-07
21:03
Add the ".ar x" command to the shell. For extracting the contents of sqlar archives. file: [c84ec9c399] check-in: [0cc699d14a] user: dan branch: sqlar-shell-support, size: 14178
15:44
Begin adding support for the sqlar archive format to shell.c. There is no "extract" command so far, only "create". file: [bd2dd9bd22] check-in: [c9827a01a6] user: dan branch: sqlar-shell-support, size: 12719
2017-07-11
18:11
Fix harmless compiler warnings in the core. file: [b1aa06c0f1] check-in: [55e93f2560] user: drh branch: trunk, size: 2597
2014-08-11
14:21
Fix harmless compiler warnings. file: [d4171c815d] check-in: [52b03f045e] user: drh branch: trunk, size: 2517
2014-06-16
12:51
Fix the extension01.test script so that it works on windows. Fix a harmless compiler warning in the fileio extension. file: [beea82bb50] check-in: [baf95a1909] user: drh branch: trunk, size: 2548
2014-06-13
13:43
Added: Add the fileio.c loadable extension, that implements readfile() and writefile() SQL functions. file: [2927bf833e] check-in: [0ca104d821] user: drh branch: trunk, size: 2539