SQLite Forum

Timeline
Login

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

50 most recent forum posts by user casaderobison

2021-12-16
17:51 Edit reply: Can I assume that the TRIGGER runs from within my transaction? (artifact: cdb81b8c60 user: casaderobison)
17:50 Reply: Can I assume that the TRIGGER runs from within my transaction? (artifact: ac7c56de91 user: casaderobison)
17:00 Reply: Can I assume that the TRIGGER runs from within my transaction? (artifact: 1f64725d36 user: casaderobison)
08:52 Reply: Can I assume that the TRIGGER runs from within my transaction? (artifact: d9507d24f8 user: casaderobison)
08:36 Reply: Can I assume that the TRIGGER runs from within my transaction? (artifact: fbaa14f807 user: casaderobison)
2021-12-12
15:28 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: dac45863a4 user: casaderobison)
00:35 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 097971a28e user: casaderobison)
2021-12-11
22:47 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 6ca41ebe33 user: casaderobison)
22:37 Edit reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 79dd2dfbb9 user: casaderobison)
22:34 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 2ea98e5e6c user: casaderobison)
2021-11-25
16:20 Edit reply: Sqlite high IO load makes usage impossable (artifact: 0c592dd114 user: casaderobison)
16:19 Reply: Sqlite high IO load makes usage impossable (artifact: 45e56dd186 user: casaderobison)
2021-11-21
00:07 Edit reply: IS NULL optimization on NOT NULL constraints breaks on corrupted databases (artifact: afe0cc3b66 user: casaderobison)
00:06 Reply: IS NULL optimization on NOT NULL constraints breaks on corrupted databases (artifact: 67d4a053fa user: casaderobison)
2021-11-20
11:41 Reply: IS NULL optimization on NOT NULL constraints breaks on corrupted databases (artifact: 07d271b96c user: casaderobison)
2021-11-19
22:38 Reply: Hot backup database in WAL mode by coping (artifact: 8dfd8df07e user: casaderobison)
17:58 Reply: Hot backup database in WAL mode by coping (artifact: 61cabcc8dd user: casaderobison)
2021-11-17
18:33 Reply: Hot backup database in WAL mode by coping (artifact: d19a1b562e user: casaderobison)
2021-11-13
00:33 Reply: Making the SQL standard public (artifact: 244a668e02 user: casaderobison)
2021-11-03
21:00 Edit reply: Get SQLITE_READONLY when using UPDATE command (artifact: c4f57ce7d6 user: casaderobison)
20:59 Reply: Get SQLITE_READONLY when using UPDATE command (artifact: f9a32ac9d3 user: casaderobison)
2021-11-02
07:33 Reply: NFS 4 that is guaranteed to work with Sqlite (artifact: 60f5237a7c user: casaderobison)
2021-10-26
21:32 Edit reply: Configuring SQLite to wait indefinitely (artifact: fbe2f75316 user: casaderobison)
21:30 Reply: Configuring SQLite to wait indefinitely (artifact: 5eab27608c user: casaderobison)
2021-10-20
18:26 Edit reply: INDEX usage on inequality and IN (artifact: dd71bd32c5 user: casaderobison)
18:25 Reply: INDEX usage on inequality and IN (artifact: 2811f9486e user: casaderobison)
2021-10-19
15:37 Edit reply: INDEX usage on inequality and IN (artifact: 49c57f4368 user: casaderobison)
15:37 Reply: INDEX usage on inequality and IN (artifact: 7b8214a5e1 user: casaderobison)
2021-10-18
01:01 Reply: Column names and aliases in expressions (artifact: cf3e43fb16 user: casaderobison)
2021-09-22
18:46 Reply: cannot start a transaction within a transaction using sqlite shell (artifact: aebedf4f85 user: casaderobison)
15:53 Reply: sqlite3 CLI .expert mode returns “Error: not an error”, if suggested index name is created, but does not match suggestion (artifact: 0d66575cd4 user: casaderobison)
2021-09-18
05:56 Edit reply: about "strict" mode (artifact: 1f20993829 user: casaderobison)
05:54 Reply: about "strict" mode (artifact: b9227841ba user: casaderobison)
01:24 Reply: about "strict" mode (artifact: 24ba2e0241 user: casaderobison)
2021-09-17
00:28 Reply: Javascript enforcement (artifact: 33814009b0 user: casaderobison)
2021-09-13
07:35 Reply: Wishing CLI could be usefully embedded (artifact: bcbeda858f user: casaderobison)
02:09 Reply: Wishing CLI could be usefully embedded (artifact: 8cd7a7a857 user: casaderobison)
2021-09-10
22:59 Reply: 3.33.0 column mode breaks -noheader in CLI (artifact: 8d0a0b3ada user: casaderobison)
2021-09-09
19:43 Edit reply: SQLite3.exe fails to handle huge multi-line-comment (artifact: 4b1b0e60c5 user: casaderobison)
19:39 Reply: SQLite3.exe fails to handle huge multi-line-comment (artifact: bba6337482 user: casaderobison)
16:20 Reply: How to insert duplicate rows? (artifact: 46a1265b14 user: casaderobison)
16:16 Reply: SQLite3.exe fails to handle huge multi-line-comment (artifact: 8dd4bb93e5 user: casaderobison)
01:19 Reply: SQLite3.exe fails to handle huge multi-line-comment (artifact: 12f1bec3ed user: casaderobison)
2021-09-06
15:21 Reply: The characters to be escaped in Sqlite3 to prevent Sql Injection (artifact: 49b9aa4d48 user: casaderobison)
2021-09-04
23:25 Reply: The characters to be escaped in Sqlite3 to prevent Sql Injection (artifact: 83f791e7a7 user: casaderobison)
13:10 Reply: A suggestion: temp0000, temp0001.. (artifact: 761f3f6361 user: casaderobison)
12:04 Reply: A suggestion: temp0000, temp0001.. (artifact: cb461ec111 user: casaderobison)
2021-09-03
21:31 Reply: A suggestion: temp0000, temp0001.. (artifact: 7f7a9b418a user: casaderobison)
2021-09-02
23:12 Reply: What happens if I define LONGDOUBLE_TYPE as double? (artifact: 3528c4a846 user: casaderobison)
19:33 Reply: What happens if I define LONGDOUBLE_TYPE as double? (artifact: 2d661e8c8a user: casaderobison)