{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":584946477,"defaultBranch":"main","name":"sqlite-vss","ownerLogin":"asg017","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-01-03T23:27:31.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/15178711?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1691288717.0","currentOid":""},"activityList":{"items":[{"before":"8fc44301843029a13a474d1f292378485e1fdd62","after":"8d3c6ff2fca651104563779a0d927ea4fba40347","ref":"refs/heads/main","pushedAt":"2024-05-05T20:00:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"e951c6d6233dfd5dfcb8d859525ddd5ff9f19388","after":"8fc44301843029a13a474d1f292378485e1fdd62","ref":"refs/heads/main","pushedAt":"2023-08-30T18:08:04.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"Update mix.exs source url (#99)\n\nHex was linking to the wrong spot, so I updated it to be the right one.","shortMessageHtmlLink":"Update mix.exs source url (#99)"}},{"before":"c8aade0bd441d651771b4dab7dc5bad17d27d861","after":"e951c6d6233dfd5dfcb8d859525ddd5ff9f19388","ref":"refs/heads/main","pushedAt":"2023-08-17T01:03:20.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"new tokenizer for vss0 column defs, test updates, edit faiss_ondisk","shortMessageHtmlLink":"new tokenizer for vss0 column defs, test updates, edit faiss_ondisk"}},{"before":"fb5648c37f037569054c7d5be50cd5d4b6997f1f","after":"c8aade0bd441d651771b4dab7dc5bad17d27d861","ref":"refs/heads/main","pushedAt":"2023-08-17T00:59:53.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"support on disk indices (#90)\n\n* add option for on_disk to parse_constructor\r\n\r\n* add .cache to git ignore\r\n\r\n* add support for on_disk index option\r\n\r\n* change to storage_type, skip shadow index for on disk, in memory on disk check\r\n\r\n* add storage_type option to doc","shortMessageHtmlLink":"support on disk indices (#90)"}},{"before":"48cf198f81476397463e72a93d9c8fed7cb4682f","after":"fb5648c37f037569054c7d5be50cd5d4b6997f1f","ref":"refs/heads/main","pushedAt":"2023-08-06T02:25:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.2","shortMessageHtmlLink":"v0.1.2"}},{"before":"4b840aadd5b15163ab1f77323caa621b52ad4bf6","after":"48cf198f81476397463e72a93d9c8fed7cb4682f","ref":"refs/heads/main","pushedAt":"2023-08-06T02:08:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.2-alpha.3","shortMessageHtmlLink":"v0.1.2-alpha.3"}},{"before":"2535b3fa9e5337a1ecf84e45dba5ed3da35ee4e0","after":"4b840aadd5b15163ab1f77323caa621b52ad4bf6","ref":"refs/heads/main","pushedAt":"2023-08-06T01:34:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"add sqlite-utils plugin","shortMessageHtmlLink":"add sqlite-utils plugin"}},{"before":null,"after":"85b06e53c9758848f4925f9aed44f78c2f017a23","ref":"refs/heads/rowid-in","pushedAt":"2023-08-06T01:28:45.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"checkpoint","shortMessageHtmlLink":"checkpoint"}},{"before":"d4b63d9adc9041f47b8be9546e4e6b8e677aabb1","after":"2535b3fa9e5337a1ecf84e45dba5ed3da35ee4e0","ref":"refs/heads/main","pushedAt":"2023-07-24T21:06:43.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.2-alpha.2","shortMessageHtmlLink":"v0.1.2-alpha.2"}},{"before":"66813745a9793a14b3f0d0bd28d0c430a52a0e89","after":"d4b63d9adc9041f47b8be9546e4e6b8e677aabb1","ref":"refs/heads/main","pushedAt":"2023-07-24T20:14:59.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.2-alpha.1","shortMessageHtmlLink":"v0.1.2-alpha.1"}},{"before":"4c7414f9350513ac9c8c24764ad4bd064876d78e","after":"66813745a9793a14b3f0d0bd28d0c430a52a0e89","ref":"refs/heads/main","pushedAt":"2023-07-20T15:31:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.1","shortMessageHtmlLink":"v0.1.1"}},{"before":"35d4e467567be584982b318b051fdb091cba3094","after":"4c7414f9350513ac9c8c24764ad4bd064876d78e","ref":"refs/heads/main","pushedAt":"2023-07-20T15:16:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.1-alpha.22","shortMessageHtmlLink":"v0.1.1-alpha.22"}},{"before":"0c983bb169f1269685cf7ca38871986f68ca6b67","after":null,"ref":"refs/tags/v0.1.1-alpha.22","pushedAt":"2023-07-20T15:15:50.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"}},{"before":"db73988665c375309703d5c72afef1186b41bb1f","after":"35d4e467567be584982b318b051fdb091cba3094","ref":"refs/heads/main","pushedAt":"2023-07-19T22:29:35.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"Update license field following SPDX 2.1 license expression standard (#80)","shortMessageHtmlLink":"Update license field following SPDX 2.1 license expression standard (#80"}},{"before":"0d57a073b871aa12dfcf8dd7f53c773fc63fd537","after":"db73988665c375309703d5c72afef1186b41bb1f","ref":"refs/heads/main","pushedAt":"2023-07-18T20:12:21.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"add cosine similarity function (#77)\n\n* add function for cosine similarity\r\n\r\n* remove fat fingered space","shortMessageHtmlLink":"add cosine similarity function (#77)"}},{"before":"1d92a7baec1e951338cf5a11d535ddd546bbadcb","after":"0d57a073b871aa12dfcf8dd7f53c773fc63fd537","ref":"refs/heads/main","pushedAt":"2023-07-18T02:30:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.1-alpha.21","shortMessageHtmlLink":"v0.1.1-alpha.21"}},{"before":"4c0f8c88cbab84e0f593450dd113e0e68ab03a84","after":"1d92a7baec1e951338cf5a11d535ddd546bbadcb","ref":"refs/heads/main","pushedAt":"2023-07-17T14:39:27.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"docs","shortMessageHtmlLink":"docs"}},{"before":"540caca3cabc045c25bb1f2988c4c420c7d81f7e","after":"4c0f8c88cbab84e0f593450dd113e0e68ab03a84","ref":"refs/heads/main","pushedAt":"2023-07-17T14:05:15.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"fix apt-get on linux?","shortMessageHtmlLink":"fix apt-get on linux?"}},{"before":"1b1b7effaffd32ee4c2a0af0ce31eec555609d07","after":"540caca3cabc045c25bb1f2988c4c420c7d81f7e","ref":"refs/heads/main","pushedAt":"2023-07-17T13:48:40.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"add metric type for vector comparison (#75)\n\n* add metric type for vector comparison\r\n\r\n* add a few tests, remove comment, disable Lp\r\n\r\n* use better test and add comment about js","shortMessageHtmlLink":"add metric type for vector comparison (#75)"}},{"before":"14837c86af89c51fe30d6235a4662e3b720656e0","after":"1b1b7effaffd32ee4c2a0af0ce31eec555609d07","ref":"refs/heads/main","pushedAt":"2023-07-12T02:39:55.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"Updated SQLite to v3.41.2 (#73)\n\nUpdated SQLite snapshot to autoconf v3.41.2 for easy version maintenance","shortMessageHtmlLink":"Updated SQLite to v3.41.2 (#73)"}},{"before":"c0ff505cb9df515352342a010ccfaef4a5353070","after":"14837c86af89c51fe30d6235a4662e3b720656e0","ref":"refs/heads/main","pushedAt":"2023-07-01T20:40:36.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"go demo, better cflags/SQLITE_VSS_LIB_DIR config","shortMessageHtmlLink":"go demo, better cflags/SQLITE_VSS_LIB_DIR config"}},{"before":"2c3d831248d7ec41411391e3162fe7c99075c33e","after":"c0ff505cb9df515352342a010ccfaef4a5353070","ref":"refs/heads/main","pushedAt":"2023-06-30T01:48:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"change shadow table rowid to INTEGER PRIMARY KEY AUTOINCREMENT to survive vacuuming","shortMessageHtmlLink":"change shadow table rowid to INTEGER PRIMARY KEY AUTOINCREMENT to sur…"}},{"before":"f2d5cd18329435745ee086ebadd73becb29627d6","after":"2c3d831248d7ec41411391e3162fe7c99075c33e","ref":"refs/heads/main","pushedAt":"2023-06-21T17:39:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.1-alpha.20","shortMessageHtmlLink":"v0.1.1-alpha.20"}},{"before":"927b52a5cb3350b952d98e222791b81b7012c935","after":"f2d5cd18329435745ee086ebadd73becb29627d6","ref":"refs/heads/main","pushedAt":"2023-06-21T17:02:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"test-loadable fixes, searchMax instead of limit, extra EOF check","shortMessageHtmlLink":"test-loadable fixes, searchMax instead of limit, extra EOF check"}},{"before":"0cf1b838314c6174365533f79e83e26feab2c0b8","after":"927b52a5cb3350b952d98e222791b81b7012c935","ref":"refs/heads/main","pushedAt":"2023-06-21T17:00:21.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"Plugging memory leaks (#60)\n\n* Reference value in resultVector\r\n\r\nTo get rid of as much pointer logic as possible\r\n\r\n* Using namespace std\r\n\r\n* Applying more unique_ptr semantics\r\n\r\n* More heap cleanups\r\n\r\n* Naming conventions + cleanups\r\n\r\n* Code formatting\r\n\r\n* Formatting + getting rid of heap object (write)\r\n\r\n* Getting rid of more leaks + formatting\r\n\r\n* Getting rid of more heap memory\r\n\r\n* Getting rid of more heap memory logic + code formating\r\n\r\n* WAY better vectors logic for inserts/deletes/trainings\r\n\r\n* Removing dead code\r\n\r\n* Significant cleanup\r\n\r\n* Update sqlite-vector.cpp\r\n\r\n* Making sure we compile on mac + cleanups\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Better error messages\r\n\r\n* Way better memory handling\r\n\r\n* Fixing array out of bounds error\r\n\r\n* Making sure we resize vector before invoking search\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Temporary rearranging workflows to trigger build\r\n\r\n* Resetting pipelines back again\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Shrinking vectors\r\n\r\n* shrink to fit for vectors\r\n\r\n* More shrink to fit\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Memory leak fix\r\n\r\n* Update sqlite-vector.cpp\r\n\r\n* Update sqlite-vector.cpp\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Minor changes\r\n\r\n* Fixing unit tests\r\n\r\n* Fixing tests\r\n\r\n* Update test-loadable.py\r\n\r\n* Update test-loadable.py\r\n\r\n* Update test-loadable.py\r\n\r\n* Update sqlite-vss.cpp\r\n\r\n* Last touches\r\n\r\n* Resetting workflow files back to original state\r\n\r\n* Removing size check\r\n\r\nIf we use PCA to reduce dimensions, size check will fail.\r\n\r\n* Revert \"Removing size check\"\r\n\r\nThis reverts commit 472308df8637a69ada804ad353d3153f178f669c.\r\n\r\n* Catching exceptions and returning as errors\r\n\r\n* By changing to sqlite3_create_function_v2 it returns success\r\n\r\nChanging from sqlite3_create_function to sqlite3_create_function_v2 fixes the creation of the vector0 function. It's in general a bad habit of \"mixing APIs\", so I guess this explains the weird bug where sqlite3_create_function wouldn't return success.\r\n\r\n* See comments\r\n\r\n1. Changed from pointer logic to unique_ptr for range_search_result\r\n2. Consistent usage of SQL inline in code\r\n3. Minor code cleanups and simplifications\r\n4. More error checking\r\n\r\n---------\r\n\r\nCo-authored-by: thomas-hansen-resolve ","shortMessageHtmlLink":"Plugging memory leaks (#60)"}},{"before":"67aae7cbf27f8bb3fe7f20abe1d0df31a0662ba7","after":"0cf1b838314c6174365533f79e83e26feab2c0b8","ref":"refs/heads/main","pushedAt":"2023-06-21T03:09:53.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"Merge branch 'main' of github.com:asg017/sqlite-vss","shortMessageHtmlLink":"Merge branch 'main' of github.com:asg017/sqlite-vss"}},{"before":"5b0f770f798fc8a793d9d393f188a55359e83ea1","after":"67aae7cbf27f8bb3fe7f20abe1d0df31a0662ba7","ref":"refs/heads/main","pushedAt":"2023-06-08T17:05:00.734Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"fix typo in README.md (#53)","shortMessageHtmlLink":"fix typo in README.md (#53)"}},{"before":"a345eb0711c7088e735f7ee15d3f535fa9f1278e","after":"5b0f770f798fc8a793d9d393f188a55359e83ea1","ref":"refs/heads/main","pushedAt":"2023-06-06T15:42:33.907Z","pushType":"push","commitsCount":2,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.1-alpha.19","shortMessageHtmlLink":"v0.1.1-alpha.19"}},{"before":"82c146fe25d0cb5b62df45cae68120122e6d3d63","after":"a345eb0711c7088e735f7ee15d3f535fa9f1278e","ref":"refs/heads/main","pushedAt":"2023-06-06T15:22:57.589Z","pushType":"push","commitsCount":3,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"v0.1.1-alpha.18","shortMessageHtmlLink":"v0.1.1-alpha.18"}},{"before":"b32cd96f8564726349f718b1203aaaedd777a63b","after":"82c146fe25d0cb5b62df45cae68120122e6d3d63","ref":"refs/heads/main","pushedAt":"2023-06-06T15:20:00.684Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"asg017","name":"Alex Garcia","path":"/asg017","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/15178711?s=80&v=4"},"commit":{"message":"Include version file for Elixir binding (#48)\n\n* Create VERSION for elixir binding\r\n\r\n* Update mix.exs for version path\r\n\r\n* Update release.yaml to copy latest version on release","shortMessageHtmlLink":"Include version file for Elixir binding (#48)"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEQf60JQA","startCursor":null,"endCursor":null}},"title":"Activity · asg017/sqlite-vss"}