Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
111 events by user cuz occurring around 2021-09-15 12:17:26.
2022-01-01
| ||
09:39 | • Reply: My code's ATTACH will not create a new db but sqlite3's shell will? artifact: fad6186b00 user: cuz | |
2021-12-31
| ||
00:16 | • Reply: strings separated by ";" convert to columns artifact: f79ee7d366 user: cuz | |
2021-12-24
| ||
12:04 | • Reply: Selecting certain sub string artifact: 7d56d012ba user: cuz | |
2021-12-23
| ||
23:17 | • Reply: Select entries based on date/time plus one before and one after artifact: a880647268 user: cuz | |
23:09 | • Reply: Select entries based on date/time plus one before and one after artifact: 6e9cf2e735 user: cuz | |
2021-12-13
| ||
14:08 | • Reply: Importing XML artifact: e803944497 user: cuz | |
2021-12-11
| ||
15:21 | • Reply: Is an Installtion reqired on IIS ? artifact: be25b218c1 user: cuz | |
15:16 | • Reply: UPSERT but know what is inserted and what is updated artifact: b0ff6e8636 user: cuz | |
2021-12-10
| ||
14:19 | • Reply: Sqlite3 can happend deadlock? artifact: 8ce61e0739 user: cuz | |
2021-12-07
| ||
18:44 | • Reply: SEE release history artifact: 74a82c9d54 user: cuz | |
13:25 | • Reply: SEE release history artifact: cef114448c user: cuz | |
00:41 | • Reply: Venting about inconvenient limitations, feel free to ignore artifact: 431fe72b25 user: cuz | |
2021-12-02
| ||
17:42 | • Reply: Linking tables artifact: 60881ff48b user: cuz | |
16:33 | • Reply: Linking tables artifact: afaea8cb7d user: cuz | |
16:03 | • Reply: In perspective of disk usage, is the sizeof 'a' < INT ? artifact: ca8474171b user: cuz | |
15:55 | • Reply: Linking tables artifact: 1743aa7248 user: cuz | |
12:48 | • Edit reply: Howto group most similar values artifact: f454a5993d user: cuz | |
12:47 | • Reply: Howto group most similar values artifact: 216fe84a94 user: cuz | |
11:06 | • Reply: Howto group most similar values artifact: 3ec5cc868e user: cuz | |
10:52 | • Edit reply: Howto group most similar values artifact: 32190ab06f user: cuz | |
10:52 | • Edit reply: Howto group most similar values artifact: 283d47a255 user: cuz | |
10:51 | • Reply: Howto group most similar values artifact: c5e1aee9a8 user: cuz | |
10:24 | • Reply: Howto group most similar values artifact: a3e92ed16b user: cuz | |
2021-12-01
| ||
12:57 | • Reply: Will the database file be corrupted if using MEMORY journal mode ? artifact: d9829ba3b6 user: cuz | |
2021-11-29
| ||
20:14 | • Reply: Proposed new date/time function to return a unix timestamp artifact: e3ede39ef9 user: cuz | |
2021-11-25
| ||
15:28 | • Reply: Feature Request split string table-valued function artifact: dc60c431d4 user: cuz | |
10:51 | • Edit reply: Feature Request split string table-valued function artifact: 840c98a8e8 user: cuz | |
10:48 | • Reply: Feature Request split string table-valued function artifact: 71ccc5de85 user: cuz | |
2021-11-24
| ||
18:52 | • Reply: CBOR Support & challenging DB design problem for keeping history with big schema changes artifact: 15917792c7 user: cuz | |
18:17 | • Reply: How to free max heap size on execution of sqlite query using sqlite3_exec? artifact: 50a81fd714 user: cuz | |
2021-11-23
| ||
18:32 | • Reply: How to free max heap size on execution of sqlite query using sqlite3_exec? artifact: 49e3177b7b user: cuz | |
2021-11-14
| ||
10:18 | • Reply: A newbie's question about database structure design artifact: 2b377d4a77 user: cuz | |
09:49 | • Edit reply: Usage of application_id and magic.txt artifact: 6a768e7dca user: cuz | |
09:48 | • Reply: Usage of application_id and magic.txt artifact: 53e04f2de3 user: cuz | |
2021-11-08
| ||
20:33 | • Reply: Hide rows in table1 if same value found in table2 ? artifact: 688f53bade user: cuz | |
2021-11-02
| ||
14:52 | • Reply: Is the order conserved in a table from a VALUES clause? artifact: c279c2fa03 user: cuz | |
13:54 | • Reply: Is the order conserved in a table from a VALUES clause? artifact: d6d5a86b7d user: cuz | |
13:38 | • Reply: Is the order conserved in a table from a VALUES clause? artifact: 830317c28d user: cuz | |
2021-10-20
| ||
19:13 | • Reply: I need a little help with UPDATE? artifact: dcce7c2652 user: cuz | |
15:01 | • Reply: INDEX usage on inequality and IN artifact: 76ff3e4a5c user: cuz | |
2021-10-13
| ||
22:58 | • Reply: inconsistent output: insert on conflict with returning artifact: a490a6b058 user: cuz | |
12:25 | • Reply: binary .dump format artifact: 5ffa89363d user: cuz | |
09:51 | • Reply: binary .dump format artifact: bd7d3d1c1b user: cuz | |
2021-10-09
| ||
13:52 | • Reply: x86_64/amd64 sqlite3 binaries artifact: 90fb69202d user: cuz | |
2021-10-02
| ||
15:07 | • Reply: How to read Images from sqlite3 and show via opencv, PIL or Matplot lib ? artifact: 67bd9291c4 user: cuz | |
2021-09-30
| ||
21:18 | • Reply: sqlite3_exec: Any way to validate the first argument? artifact: 9b9468ede5 user: cuz | |
20:54 | • Reply: How to filter find duplicate and show row with same field using sqlite code? artifact: 2b969bffcc user: cuz | |
20:45 | • Reply: sqlite3_exec: Any way to validate the first argument? artifact: 5e446ddfdb user: cuz | |
20:15 | • Reply: Feature request: Stored Procedures artifact: 1321b318dc user: cuz | |
07:15 | • Edit reply: A little help with temp tables? artifact: e76ca95844 user: cuz | |
07:04 | • Reply: A little help with temp tables? artifact: c099d849b1 user: cuz | |
2021-09-28
| ||
23:09 | • Reply: Reset database artifact: 9eb4a71222 user: cuz | |
15:19 | • Reply: User -efined functions in the CLI? artifact: 8c4ca9f788 user: cuz | |
15:04 | • Reply: Possible bug in group_concat() ? artifact: 69c95b0314 user: cuz | |
2021-09-22
| ||
00:04 | • Reply: Queries across databases artifact: eb314c4733 user: cuz | |
2021-09-15
| ||
12:17 | • Reply: about "strict" mode artifact: e960514ad5 user: cuz | |
2021-09-14
| ||
21:15 | • Reply: DELETE FROM … RETURNING artifact: 961a86551c user: cuz | |
18:47 | • Reply: DELETE FROM … RETURNING artifact: 9166c79448 user: cuz | |
12:58 | • Reply: (Deleted) artifact: 85c08744da user: cuz | |
2021-09-09
| ||
15:17 | • Reply: Write-ahead logging on SAN artifact: d9c58a7d27 user: cuz | |
2021-09-08
| ||
17:06 | • Reply: A crash bug in function isLikeOrGlob() artifact: f7f6afa30e user: cuz | |
16:48 | • Edit reply: NEXT VALUE FOR in SQLite artifact: ac3c8a1056 user: cuz | |
16:45 | • Reply: NEXT VALUE FOR in SQLite artifact: abdd917fef user: cuz | |
16:11 | • Reply: A crash bug in function isLikeOrGlob() artifact: b7bb7b9ff7 user: cuz | |
00:10 | • Reply: Automatic indexing (idle question) artifact: 95055dabef user: cuz | |
2021-09-07
| ||
21:36 | • Reply: Automatic indexing (idle question) artifact: d0c96834dc user: cuz | |
2021-09-06
| ||
13:18 | • Reply: Automatic indexing (idle question) artifact: d88484807c user: cuz | |
12:15 | • Reply: Issues with sqlite3IsNaN() and HAVE_ISNAN artifact: c7e8a45861 user: cuz | |
2021-09-05
| ||
22:29 | • Reply: STRICT tables and UNIQUE indices artifact: ebf7f4ab5a user: cuz | |
22:21 | • Reply: STRICT tables and UNIQUE indices artifact: 9b6a3e5409 user: cuz | |
13:06 | • Reply: STRICT tables and UNIQUE indices artifact: 11364a882f user: cuz | |
2021-09-01
| ||
12:57 | • Reply: STRICT tables and UNIQUE indices artifact: db4044fa3c user: cuz | |
10:02 | • Reply: STRICT tables and UNIQUE indices artifact: c1387060bc user: cuz | |
2021-08-28
| ||
13:02 | • Reply: Best tool to handle SQLite code? artifact: b3869d4aae user: cuz | |
2021-08-24
| ||
12:46 | • Reply: When is "IS" used in SQLite? artifact: fc9e27adbf user: cuz | |
2021-08-23
| ||
13:08 | • Edit reply: When is "IS" used in SQLite? artifact: 072af59c63 user: cuz | |
13:06 | • Edit reply: When is "IS" used in SQLite? artifact: b256c9cebf user: cuz | |
12:54 | • Reply: When is "IS" used in SQLite? artifact: 4c63575b85 user: cuz | |
12:48 | • Reply: About STRICT tables artifact: 16545b5444 user: cuz | |
2021-08-21
| ||
21:30 | • Reply: about "strict" mode artifact: 11d1ecccbc user: cuz | |
21:24 | • Reply: about "strict" mode artifact: a11c4cbacd user: cuz | |
2021-08-20
| ||
19:39 | • Reply: Updated Website Idea artifact: e5c1ebdb3d user: cuz | |
01:45 | • Reply: How do I sort my Safari History.db History by DATE? artifact: d3947744b6 user: cuz | |
2021-08-17
| ||
17:04 | • Reply: sqlite DB + data file - write out all entries artifact: 02084d8119 user: cuz | |
14:35 | • Reply: sqlite DB + data file - write out all entries artifact: f403dfd4db user: cuz | |
2021-08-12
| ||
13:33 | • Reply: SQL lite irrespective query artifact: 21660da4e5 user: cuz | |
2021-08-10
| ||
13:18 | • Reply: Right and full outer joins artifact: ef85e82b09 user: cuz | |
2021-08-09
| ||
23:22 | • Reply: Getting a date range using "like" artifact: 95fb0a1295 user: cuz | |
2021-08-08
| ||
20:51 | • Reply: Virtual RDBMS over SQLite artifact: a7fcb39f5e user: cuz | |
20:32 | • Reply: Best practice: Save partial dates artifact: 0a3ed73ccd user: cuz | |
2021-08-04
| ||
20:33 | • Reply: Calculating Trip Duration in Minutes? artifact: 5d370848ce user: cuz | |
19:49 | • Reply: Calculating Trip Duration in Minutes? artifact: a94da99257 user: cuz | |
2021-07-30
| ||
21:17 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: 8872bab984 user: cuz | |
21:04 | • Reply: Round function returning -0.0 artifact: 4ecb18062a user: cuz | |
20:57 | • Reply: Abbreviation artifact: 9f3c5703a6 user: cuz | |
2021-07-27
| ||
15:16 | • Edit reply: Need 1.0.110.0 x64 Download artifact: 602e07ed6b user: cuz | |
15:14 | • Reply: Need 1.0.110.0 x64 Download artifact: a1055aa002 user: cuz | |
2021-07-26
| ||
09:13 | • Reply: sqlite3_carray_bind and constness artifact: 14a0b4daf9 user: cuz | |
08:53 | • Reply: sqlite3_carray_bind and constness artifact: b32a87b4c5 user: cuz | |
2021-07-24
| ||
19:52 | • Reply: Changing from MySQL to SQlite artifact: 90fcc74eb9 user: cuz | |
2021-07-23
| ||
11:37 | • Reply: how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause artifact: 230045404d user: cuz | |
2021-07-22
| ||
16:04 | • Reply: Csv or Vsv parsing blob column artifact: 69aa3ca667 user: cuz | |
2021-07-21
| ||
20:09 | • Reply: SELECT optimization for constant expression artifact: cdc8efd3f2 user: cuz | |
11:24 | • Reply: SELECT optimization for constant expression artifact: fdcfff048d user: cuz | |
11:03 | • Reply: SELECT optimization for constant expression artifact: 10c25d97ea user: cuz | |
2021-07-20
| ||
14:45 | • Reply: ROWID in compound SELECT artifact: cec8eb3f47 user: cuz | |
2021-07-19
| ||
12:52 | • Reply: Populating a tree from a flat table of subcategories artifact: 3bff990360 user: cuz | |
2021-07-17
| ||
22:54 | • Reply: (Deleted) artifact: 557c89d139 user: cuz | |
22:27 | • Edit reply: (Deleted) artifact: 89ee54c961 user: cuz | |
22:26 | • Reply: (Deleted) artifact: 1d51f050b1 user: cuz | |
2021-07-15
| ||
23:57 | • Reply: Should SQLite be able to optimize this query? artifact: 19acdf0b27 user: cuz | |