SQLite Forum

Timeline
Login

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

89 events by user holgerj occurring around 2021-02-01 12:14:30.

2024-04-25
12:27 Reply: UPDATE ... RETURNING returns unmodified rows? artifact: b66f4aa2d9 user: holgerj
2024-03-04
13:12 Reply: Dates in the past artifact: 9a9a411e8a user: holgerj
2024-03-03
21:46 Reply: Dates in the past artifact: b80b967bd2 user: holgerj
2024-03-02
12:16 Edit reply: Dates in the past artifact: ac9cf22190 user: holgerj
12:14 Reply: Dates in the past artifact: 3bcd6bcc74 user: holgerj
2024-02-23
14:35 Reply: Feature idea: Allow date / time function modifiers to use ISO 8601 durations artifact: 80ff32fe4d user: holgerj
2024-01-18
16:47 Reply: Bug converting date to ISO date artifact: b747412acb user: holgerj
2024-01-12
14:05 Reply: Compute the last day of quarter artifact: 5bd9d7195d user: holgerj
2023-12-05
14:08 Edit reply: SQLITE_BUSY The database file is locked artifact: 88e599d135 user: holgerj
14:08 Reply: SQLITE_BUSY The database file is locked artifact: 37fce84e67 user: holgerj
2023-12-01
15:09 Reply: Different column type when using UNION ALL artifact: 4fb109ac26 user: holgerj
2023-11-24
16:56 Reply: SQLite.Interop.dll on Linux problem artifact: cdd12a2185 user: holgerj
2023-11-21
12:04 Reply: SQLite.Interop.dll on Linux problem artifact: 2e5c0e5e44 user: holgerj
2023-11-19
12:17 Reply: Saving a sqlite db file history with fossil scm artifact: 2b4ad32838 user: holgerj
2023-11-01
14:42 Reply: SQLite version 3.44.0 now in beta artifact: 24bb6a6cb1 user: holgerj
2023-09-11
14:56 Edit: Version 3.43.1 - Tcl interface artifact: 6b4df709a0 user: holgerj
14:54 Post: Version 3.43.1 - Tcl interface artifact: e47db43ab1 user: holgerj
2023-08-28
14:18 Reply: sqlite and security artifact: 5d0d4fc093 user: holgerj
2023-08-12
10:58 Reply: NPE bug while doing an update operation artifact: 5479b14821 user: holgerj
2023-06-22
19:34 Reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: aab8d76817 user: holgerj
2023-06-21
12:53 Edit reply: postgres ilike operator artifact: 93a43d3f0b user: holgerj
12:52 Reply: postgres ilike operator artifact: 420f032653 user: holgerj
2023-06-20
18:33 Reply: postgres ilike operator artifact: 74aa3b69c3 user: holgerj
18:23 Edit reply: postgres ilike operator artifact: 1144e45d14 user: holgerj
16:57 Reply: postgres ilike operator artifact: 59cacdbc9f user: holgerj
2023-06-14
14:16 Reply: "PRAGMA journal_mode" without effect ? artifact: 4a653ff280 user: holgerj
2023-06-02
12:54 Reply: 2023 SQL standard foundation document published artifact: 4ec4c54a9e user: holgerj
2023-04-26
17:46 Reply: Parse sortable date from "Sat Apr 22 1:01:51.887" artifact: d6a5bd870d user: holgerj
2023-04-24
16:35 Reply: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: 6cc4cefd54 user: holgerj
2023-03-30
13:34 Edit reply: CROSS JOIN doc bug? artifact: 6b2459c296 user: holgerj
13:25 Reply: CROSS JOIN doc bug? artifact: 5439147ddd user: holgerj
2023-03-29
13:36 Edit reply: CROSS JOIN doc bug? artifact: 7b45ea1ae8 user: holgerj
13:35 Reply: CROSS JOIN doc bug? artifact: 33a0931610 user: holgerj
2023-02-06
12:23 Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: d5372b15bb user: holgerj
2023-01-11
12:04 Reply: Empty column What is not NULL? Right way to convert to NULL? artifact: 2a7decdeea user: holgerj
2022-12-11
12:25 Reply: Add to function strftime new format "%u" artifact: 364020ebc5 user: holgerj
2022-12-01
15:31 Reply: sqlite3_step() always returning TDS_MORE artifact: 0e43c65998 user: holgerj
2022-11-25
20:30 Reply: Tcl Interface to SQLite Library artifact: c9e920fba2 user: holgerj
2022-11-18
12:01 Reply: Base85, Yet another text/blob conversion artifact: 202e816b24 user: holgerj
2022-10-06
12:17 Reply: DISTINCT artifact: 0df033dbac user: holgerj
2022-09-29
13:09 Reply: Feature Request Case sensitive columns artifact: 5e575586ac user: holgerj
2022-09-16
12:10 Reply: Data entry form like MS Access artifact: 13504dd2b2 user: holgerj
12:06 Reply: SELECT BY DATE with CURRENT_TIMESTAMP artifact: c6c8078e5e user: holgerj
2022-09-09
20:21 Reply: sqlite3, bash reports: 'no such file or directory' artifact: b2d1fb4631 user: holgerj
2022-09-03
21:40 Reply: Varying the case sensitivity of the LIKE operator? artifact: 091109b7c4 user: holgerj
2022-08-17
14:35 Reply: Special feature in sqlite: definite time triggers artifact: 2c2550ef2b user: holgerj
14:31 Edit reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: 2be37c0b2c user: holgerj
2022-08-16
13:33 Reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: c72c4c6ff6 user: holgerj
2022-07-30
12:10 Reply: strftime accepts wrong date artifact: 9b409bd978 user: holgerj
2022-07-27
12:21 Reply: Need Help artifact: 657314694d user: holgerj
2022-07-25
14:02 Reply: What is wrong with this query artifact: 50546244d1 user: holgerj
2022-07-17
17:50 Reply: max() function broken artifact: 27cac0aa31 user: holgerj
2022-05-24
12:29 Reply: Unexpected Result by WHERE when Joining Tables artifact: baf8531340 user: holgerj
2022-05-07
22:35 Reply: doc: date/time functions are technically non-compliant with ISO 8601 artifact: 3c864e6360 user: holgerj
2022-04-01
15:52 Reply: some weird date side effects artifact: d074c9e1af user: holgerj
2022-03-14
15:37 Reply: Creating column constraint to allow only digits artifact: 9e22cfca77 user: holgerj
2022-03-04
17:37 Reply: Book,Author,Book_Author artifact: b74130b1c0 user: holgerj
2022-02-09
12:47 Reply: sqlite3 '-batch' option appears undocumented artifact: 0b776192e2 user: holgerj
12:39 Reply: drop table with fk's challenging error report could use improvement artifact: 0d5dc79bb2 user: holgerj
2022-01-23
12:09 Reply: Proposed JSON enhancements. artifact: cea976617c user: holgerj
2022-01-20
13:49 Reply: Proposed JSON enhancements. artifact: 63eed44f5f user: holgerj
2022-01-08
15:29 Reply: Calculating time between two dates artifact: 3fb0d6e2df user: holgerj
2021-12-28
12:33 Reply: Foreign key joins artifact: be6e2ed0cf user: holgerj
2021-12-27
12:28 Reply: Foreign key joins artifact: e4576591f6 user: holgerj
2021-11-14
12:14 Reply: A newbie's question about database structure design artifact: 29a1161684 user: holgerj
2021-10-10
12:25 Reply: x86_64/amd64 sqlite3 binaries artifact: 7c26c30129 user: holgerj
2021-10-09
12:21 Reply: x86_64/amd64 sqlite3 binaries artifact: aba1013ae0 user: holgerj
2021-08-13
12:21 Reply: Test ACID properties SQLITE artifact: 737fbec672 user: holgerj
2021-06-30
13:15 Reply: Loading bundled extensions in dotnet on linux artifact: b7e78a4fd0 user: holgerj
13:11 Reply: Very Newbie Question artifact: 535bdf3bd5 user: holgerj
2021-05-28
12:39 Reply: nested case statement not working artifact: 8dcc7ad8fd user: holgerj
2021-05-21
12:55 Reply: Column name includes quotes used in RETURNING expr artifact: 6724f28e07 user: holgerj
2021-05-04
06:37 Reply: "Office Space"... I'm losing all those pennies artifact: 1ad02cb8a7 user: holgerj
2021-04-21
12:40 Reply: The NUMERIC data type? artifact: 0b84318a48 user: holgerj
2021-02-14
12:34 Reply: SQLite isolation clarification needed artifact: a5e327668b user: holgerj
2021-02-01
12:14 Reply: How should RETURNING work with a cascading delete? artifact: 4ca09d6125 user: holgerj
2021-01-28
12:17 Reply: Are there any plans / chances of supporting a RETURNING clause? artifact: cf1749029a user: holgerj
2020-12-22
13:29 Reply: bad plan for a query with an OR condition artifact: 6fdb48f661 user: holgerj
2020-12-20
15:48 Reply: 'ON DELETE CASCADE' seems to not be working artifact: 88a426c0e4 user: holgerj
2020-12-19
18:44 Reply: 'ON DELETE CASCADE' seems to not be working artifact: 7b75765b26 user: holgerj
2020-12-15
15:06 Reply: Change from SQL Server CE to SQLite. Something similar to SQLCEResultSet and SQLCEUpdatableRecord. artifact: 6eaff4217d user: holgerj
2020-12-06
16:41 Reply: SQLite 3.34 binary not working on Ubuntu 20.04 (not found) artifact: 067ffb55aa user: holgerj
16:39 Reply: SQLite 3.34 binary not working on Ubuntu 20.04 (not found) artifact: fd3a87777e user: holgerj
16:37 Reply: SQLite 3.34 binary not working on Ubuntu 20.04 (not found) artifact: d1c0e0d975 user: holgerj
2020-12-05
17:42 Reply: SQLite 3.34 binary not working on Ubuntu 20.04 (not found) artifact: 0e65ee081b user: holgerj
2020-12-04
10:51 Post: SQLite 3.34 binary not working on Ubuntu 20.04 (not found) artifact: 25971b2267 user: holgerj
10:30 Reply: libreadline problem with Ubuntu 20.04 artifact: 803374b4d5 user: holgerj
2020-11-26
12:13 Reply: Proposal: Add the SUBSTRING alias to the SUBSTR function artifact: 9a244bbd23 user: holgerj
2020-11-19
13:44 Post: libreadline problem with Ubuntu 20.04 artifact: 68fdfa584e user: holgerj