SQLite Forum

Timeline
Login

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

124 events by user larrybr occurring on or before 2021-04-29 16:55:26.

2021-04-29
16:55 Reply: WAL files deleted artifact: 8260b26f19 user: larrybr
09:37 Reply: bug report: an assert() in zipfile.c that may fail artifact: e44e4919da user: larrybr
2021-04-28
22:06 Reply: Blobs & SQLITE_TRANSIENT clarification artifact: 67174ff2c4 user: larrybr
04:20 Reply: Help, reading sqlite3_blob_open() artifact: 66203444d0 user: larrybr
00:37 Reply: Blobs & SQLITE_TRANSIENT clarification artifact: 4ce46dfe7a user: larrybr
2021-04-26
13:36 Reply: Merci a tous les contributeurs / Logiciel Expertizers artifact: 348ae19f7e user: larrybr
13:29 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 86b6226587 user: larrybr
2021-04-25
21:05 Reply: VACUUM fails on a database with enabled user authentication extension artifact: b9c91a059f user: larrybr
2021-04-24
23:29 Reply: Sending output to a pipe artifact: d30627f5c3 user: larrybr
16:05 Reply: How to convert to CTE artifact: be71b60721 user: larrybr
16:02 Edit reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: f9e40ac664 user: larrybr
16:01 Reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 29f7aa392f user: larrybr
14:41 Reply: Getting error when pipe sql into sqlite3 utility artifact: 86ade9713d user: larrybr
13:37 Reply: Sending output to a pipe artifact: e9c78978f7 user: larrybr
12:29 Edit reply: Getting error when pipe sql into sqlite3 utility artifact: 6f1d22e8de user: larrybr
12:28 Reply: Getting error when pipe sql into sqlite3 utility artifact: e21294bdfa user: larrybr
2021-04-22
18:07 Reply: Execute changes in Photoshop Elements artifact: 580c09a1ef user: larrybr
17:28 Reply: Execute changes in Photoshop Elements artifact: 3b4366167f user: larrybr
2021-04-21
22:03 Reply: Will there be a 64-bit Windows Download for v3.35.5? artifact: f1a4f529ef user: larrybr
20:00 Reply: V 3.35.5 artifact: 48d7e880d3 user: larrybr
03:39 Reply: Will there be a 64-bit Windows Download for v3.35.5? artifact: 8c8182630d user: larrybr
03:37 Reply: How to compile the libsqlitejdbc.so? artifact: c81316c902 user: larrybr
2021-04-20
00:09 Reply: simple insert issue with 3.35.5 - .sqliterc issue? artifact: fbf06099a4 user: larrybr
2021-04-19
15:24 Reply: Aliased function result with the same name issue artifact: e606e64e34 user: larrybr
2021-04-18
22:07 Reply: SQL query help for between times and grouping times artifact: e352fde8ab user: larrybr
16:25 Reply: Pragma compile_options does not show some options artifact: 8402de4d3f user: larrybr
14:17 Edit reply: Pragma compile_options does not show some options artifact: 21b430687e user: larrybr
01:47 Reply: ALTER TABLE DROP COLUMN corrupts data artifact: 96896f825d user: larrybr
2021-04-17
22:12 Edit reply: VACUUM fails on a database with enabled user authentication extension artifact: 94d49d63e1 user: larrybr
21:37 Reply: VACUUM fails on a database with enabled user authentication extension artifact: 84b9eb40cd user: larrybr
2021-04-16
17:19 Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: 361912b666 user: larrybr
14:15 Reply: Cant write from root user into sqlite when sticky bit is set artifact: 2633dc7065 user: larrybr
01:59 Edit reply: Bug In EXPLAIN Syntax Diagram artifact: 82da8fb347 user: larrybr
00:38 Reply: Bug In EXPLAIN Syntax Diagram artifact: d56a4067bf user: larrybr
2021-04-15
20:18 Reply: Pragma compile_options does not show some options artifact: 5651099630 user: larrybr
14:43 Reply: Pragma compile_options does not show some options artifact: f9c46e640f user: larrybr
10:22 Reply: Proposal: Implement the MOD(x, y) function artifact: 1ac414ede1 user: larrybr
10:11 Reply: Pragma compile_options does not show some options artifact: b7799ffc67 user: larrybr
09:21 Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: e28b13c50e user: larrybr
02:04 Reply: bug:update from virtual table (geopoly),and no return received artifact: 568251652a user: larrybr
01:54 Reply: Pragma compile_options does not show some options artifact: 1f373364d8 user: larrybr
01:12 Reply: Pragma compile_options does not show some options artifact: fc7f0eeaae user: larrybr
2021-04-14
18:35 Reply: bug:update from virtual table (geopoly),and no return received artifact: 3f833d25e8 user: larrybr
18:32 Reply: Pragma compile_options does not show some options artifact: 557605027b user: larrybr
16:50 Reply: bug:update from virtual table (geopoly),and no return received artifact: 4142d76a33 user: larrybr
12:52 Reply: bug:update from virtual table (geopoly),and no return received artifact: 0d55e37339 user: larrybr
12:33 Reply: object name reserved for internal use: sqlite_parameters artifact: e8705f22a0 user: larrybr
11:51 Reply: object name reserved for internal use: sqlite_parameters artifact: 78905344f8 user: larrybr
2021-04-13
18:58 Reply: how DISTINCT remove the duplicate rows? artifact: 71cfe8f5d9 user: larrybr
18:51 Reply: Pragma compile_options does not show some options artifact: 87ac14fdde user: larrybr
17:30 Reply: Typos on https://sqlite.com/cli.html page artifact: 77c59c83f1 user: larrybr
2021-04-12
23:44 Reply: Pragma compile_options does not show some options artifact: 2ad8a120ce user: larrybr
03:28 Reply: find in b+-tree node artifact: 39ad6998d5 user: larrybr
01:04 Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 1e5e023aa3 user: larrybr
2021-04-11
22:02 Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 239becbbdc user: larrybr
21:03 Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 9ce65e441c user: larrybr
20:12 Reply: meaning of "GROUP BY CONSTANT" artifact: 9f00be5bf3 user: larrybr
2021-04-09
14:42 Reply: Question .open chinook.db artifact: 719684ed5c user: larrybr
2021-04-07
14:39 Reply: Command line option '.read' - Windows version artifact: e89d6c97b3 user: larrybr
14:22 Reply: segfault in sqlite3 (3.35.4) artifact: e8853ff189 user: larrybr
09:46 Reply: segfault in sqlite3 (3.35.4) artifact: d76613f7e2 user: larrybr
2021-04-06
08:17 Reply: Compiling sqlite3 with readline support artifact: 4db8e9df49 user: larrybr
2021-04-05
18:53 Reply: open db in read only; explicitly store diff as WAL ? artifact: bcae9373b0 user: larrybr
18:02 Reply: Compiling sqlite3 with readline support artifact: 8e762e2343 user: larrybr
17:01 Reply: What indexes help Window Functions artifact: bb919a1701 user: larrybr
16:54 Reply: Command Line Shell set parameter as date artifact: 00d6ea28ed user: larrybr
16:52 Reply: Views with UNION ALL artifact: 3af1aac1fb user: larrybr
16:39 Reply: Compiling sqlite3 with readline support artifact: 39c9222f74 user: larrybr
15:56 Reply: Command Line Shell set parameter as date artifact: e174600a09 user: larrybr
02:10 Reply: .import csv and NULL values artifact: 6351a2cba5 user: larrybr
2021-04-04
23:47 Reply: About virutal table and FTS4 artifact: 114b6cbf53 user: larrybr
15:10 Reply: SQLite Plus: all the missing SQLite functions artifact: 80fb509690 user: larrybr
13:38 Reply: Command Line Shell set parameter as date artifact: 6315071645 user: larrybr
2021-04-03
13:51 Edit reply: Problem with single quotes Swift/MacOS artifact: b2a737c09d user: larrybr
13:40 Reply: Problem with single quotes Swift/MacOS artifact: 5f981c2d59 user: larrybr
2021-04-01
18:58 Reply: CLI manual could be clearer on which commands support pipes artifact: 8d8558213c user: larrybr
18:51 Reply: Enabling SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default artifact: 972ec9b449 user: larrybr
15:12 Reply: Enabling SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default artifact: 415b27dfa7 user: larrybr
13:00 Reply: Order of results of multiple SELECT statements separated by ";" artifact: f96d3425f4 user: larrybr
2021-03-31
18:24 Reply: Request for correction: EXCLUDE NO OTHERS artifact: 45d7a9ac42 user: larrybr
17:36 Reply: Request for correction: EXCLUDE NO OTHERS artifact: 4dfe72856e user: larrybr
10:40 Reply: "group by" not required artifact: e627915758 user: larrybr
2021-03-30
21:46 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 38d5607478 user: larrybr
2021-03-29
23:38 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 1f5ddb95b2 user: larrybr
23:35 Edit reply: SQLite Heap overflow artifact: 845854dae9 user: larrybr
23:34 Edit reply: SQLite Heap overflow artifact: 187919c75d user: larrybr
23:21 Reply: SQLite Heap overflow artifact: 2a973c8c5b user: larrybr
22:48 Reply: SQLite Heap overflow artifact: 7e20800161 user: larrybr
20:34 Reply: SQLite Heap overflow artifact: 62d0daf49a user: larrybr
18:42 Reply: Missing Exports artifact: 1435cfea38 user: larrybr
17:09 Reply: Missing Exports artifact: e5970965f1 user: larrybr
14:38 Reply: Missing Exports artifact: 1f615ae603 user: larrybr
12:22 Reply: Missing Exports artifact: dc845fc715 user: larrybr
2021-03-28
17:54 Edit reply: "ERROR ON LOAD EXTENSION" artifact: 520b30e47f user: larrybr
13:03 Reply: "ERROR ON LOAD EXTENSION" artifact: 415c4b5dbc user: larrybr
2021-03-27
23:50 Reply: Error: near "returning": syntax error artifact: 81e71caee1 user: larrybr
2021-03-25
23:51 Reply: possible to use output of a SELECT-query for ordering? artifact: 54867a15e3 user: larrybr
20:54 Edit reply: json_tree documentation improvement: change type "string" to "text" artifact: 2c7b60db49 user: larrybr
20:45 Reply: json_tree documentation improvement: change type "string" to "text" artifact: 2f619489ca user: larrybr
18:09 Reply: json_tree documentation improvement: change type "string" to "text" artifact: df0cfed45c user: larrybr
2021-03-24
17:44 Reply: Strange CLI .exit issue artifact: dbc2c10de3 user: larrybr
14:28 Reply: Strange CLI .exit issue artifact: d367232cae user: larrybr
01:59 Reply: Can sqlite blob field be appended with data? artifact: b8fbf59182 user: larrybr
2021-03-23
22:20 Reply: Change Default ORDER BY to descending. artifact: afc6eeda9c user: larrybr
22:06 Reply: DROP TABLE failure - is it intentional or a bug? artifact: c3620cde73 user: larrybr
12:47 Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: a9dd9bede2 user: larrybr
09:16 Reply: Strange CLI .exit issue artifact: da1853af1d user: larrybr
08:47 Reply: 3.25 math functions vs. extension-functions.c artifact: 7bd48efa2b user: larrybr
08:11 Reply: Strange CLI .exit issue artifact: 1eeb7da0a5 user: larrybr
00:40 Reply: Strange CLI .exit issue artifact: d28b288130 user: larrybr
2021-03-22
23:06 Reply: Strange CLI .exit issue artifact: 68f7382be7 user: larrybr
01:39 Edit reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: 7985095fbb user: larrybr
00:08 Reply: php error : SQLSTATEHY000: General error: 6 database table is locked artifact: b36d5a3d59 user: larrybr
2021-03-21
22:32 Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: 18d294fb4f user: larrybr
17:32 Reply: HTML login/registration with SQLite db table artifact: e077774285 user: larrybr
2021-03-20
23:38 Reply: bug pragma incremental_vacuum OOMs in .mode box artifact: 54f80107ca user: larrybr
18:27 Reply: bug pragma incremental_vacuum OOMs in .mode box artifact: 60112141ef user: larrybr
00:58 Reply: Help getting excel/csv file into SQLite? please help artifact: 761be89ccf user: larrybr
2021-03-19
22:34 Reply: How do I use sqlite3_malloc in Sqlite artifact: c75512b71a user: larrybr
21:16 Reply: How do I use sqlite3_malloc in Sqlite artifact: 2e02e1b6c0 user: larrybr
20:34 Reply: How do I use sqlite3_malloc in Sqlite artifact: adb3735d51 user: larrybr
15:49 Reply: Constexpr parsing of sql statement artifact: 2ced41cbee user: larrybr
15:42 Reply: Bug ? Same query that works in shell produces constraint violation when run by a C program with sqlite3_{prepare,bind,step} artifact: 17bc46104e user: larrybr
15:05 Reply: Proposed tiny change for SQLite on IBM z/OS artifact: 921fe15bbd user: larrybr