{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":66190150,"defaultBranch":"main","name":"openlibrary-search","ownerLogin":"LibrariesHacked","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2016-08-21T09:07:55.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/6617372?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1707347324.0","currentOid":""},"activityList":{"items":[{"before":null,"after":"834ad0fd39e7b02df4697e553ecf56700d8bcc9a","ref":"refs/heads/14-i-am-experiencing-slow-query-performance-in-my-postgresql-database","pushedAt":"2024-02-07T23:08:44.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"12 postgres tables only loading 2000 rows a table (#15)\n\n* Refining readme and gitignore\r\n\r\n* Cleaning up chunked process\r\n\r\n* Tidying readme file\r\n\r\n* Bugs in chunked process only allowing one chunk to load\r\n\r\n* Ensuring data load only loads one table at a time\r\n\r\n* Updating readme\r\n\r\n* Removing initial drop database command\r\n\r\n* Updating readme and formatting","shortMessageHtmlLink":"12 postgres tables only loading 2000 rows a table (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2106722820\" data-permission-text=\"Title is private\" data-url=\"https://github.com/LibrariesHacked/openlibrary-search/issues/15\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/LibrariesHacked/openlibrary-search/pull/15/hovercard\" href=\"https://github.com/LibrariesHacked/openlibrary-search/pull/15\">#15</a>)"}},{"before":"57d9177058f62839bfdc94e230c76171f7cb1f31","after":null,"ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-30T00:34:36.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"}},{"before":"b5c8128b7534c52e30f71de845a36ae0f0c6bc88","after":"834ad0fd39e7b02df4697e553ecf56700d8bcc9a","ref":"refs/heads/main","pushedAt":"2024-01-30T00:34:33.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"12 postgres tables only loading 2000 rows a table (#15)\n\n* Refining readme and gitignore\r\n\r\n* Cleaning up chunked process\r\n\r\n* Tidying readme file\r\n\r\n* Bugs in chunked process only allowing one chunk to load\r\n\r\n* Ensuring data load only loads one table at a time\r\n\r\n* Updating readme\r\n\r\n* Removing initial drop database command\r\n\r\n* Updating readme and formatting","shortMessageHtmlLink":"12 postgres tables only loading 2000 rows a table (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2106722820\" data-permission-text=\"Title is private\" data-url=\"https://github.com/LibrariesHacked/openlibrary-search/issues/15\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/LibrariesHacked/openlibrary-search/pull/15/hovercard\" href=\"https://github.com/LibrariesHacked/openlibrary-search/pull/15\">#15</a>)"}},{"before":"3839ec49414ef45e95aee1cb6f3431b7f877b8fe","after":"57d9177058f62839bfdc94e230c76171f7cb1f31","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-30T00:34:22.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Merge branch 'main' into 12-postgres-tables-only-loading-2000-rows-a-table","shortMessageHtmlLink":"Merge branch 'main' into 12-postgres-tables-only-loading-2000-rows-a-…"}},{"before":"f63f210ca9f6723011e3d0921ed66283978edb39","after":"3839ec49414ef45e95aee1cb6f3431b7f877b8fe","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-30T00:26:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Updating readme and formatting","shortMessageHtmlLink":"Updating readme and formatting"}},{"before":"7c96083a2058f205999d5eeb5cee7ed8b03a8b9c","after":"f63f210ca9f6723011e3d0921ed66283978edb39","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-13T18:39:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Removing initial drop database command","shortMessageHtmlLink":"Removing initial drop database command"}},{"before":"0faf556f6546fd2ced0db200fd49d1486f20bcb6","after":"7c96083a2058f205999d5eeb5cee7ed8b03a8b9c","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-08T06:59:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Updating readme","shortMessageHtmlLink":"Updating readme"}},{"before":"4ae33a4aab476ec7ef1bfc50655ff946e8d0bb79","after":"0faf556f6546fd2ced0db200fd49d1486f20bcb6","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-07T22:56:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Ensuring data load only loads one table at a time","shortMessageHtmlLink":"Ensuring data load only loads one table at a time"}},{"before":"00eea946647d091c0dfdc930520c5ac623c8db2f","after":"4ae33a4aab476ec7ef1bfc50655ff946e8d0bb79","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-07T17:45:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Bugs in chunked process only allowing one chunk to load","shortMessageHtmlLink":"Bugs in chunked process only allowing one chunk to load"}},{"before":"df7960ef6665d5aad41ca4efe2c585b91d180381","after":"00eea946647d091c0dfdc930520c5ac623c8db2f","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-06T23:10:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Tidying readme file","shortMessageHtmlLink":"Tidying readme file"}},{"before":"b4b6f6d638504dcbed54c0e20f93aea8aa5239d8","after":"df7960ef6665d5aad41ca4efe2c585b91d180381","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-06T00:03:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Cleaning up chunked process","shortMessageHtmlLink":"Cleaning up chunked process"}},{"before":"3ad8df5bcb4935b3dfec5e05a5cac9111a900ddb","after":"b4b6f6d638504dcbed54c0e20f93aea8aa5239d8","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2024-01-04T23:40:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Refining readme and gitignore","shortMessageHtmlLink":"Refining readme and gitignore"}},{"before":"3ad8df5bcb4935b3dfec5e05a5cac9111a900ddb","after":"b5c8128b7534c52e30f71de845a36ae0f0c6bc88","ref":"refs/heads/main","pushedAt":"2023-09-16T22:03:21.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"Fix openlibrary-data-loader.sql query (#13)","shortMessageHtmlLink":"Fix openlibrary-data-loader.sql query (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1897229091\" data-permission-text=\"Title is private\" data-url=\"https://github.com/LibrariesHacked/openlibrary-search/issues/13\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/LibrariesHacked/openlibrary-search/pull/13/hovercard\" href=\"https://github.com/LibrariesHacked/openlibrary-search/pull/13\">#13</a>)"}},{"before":null,"after":"3ad8df5bcb4935b3dfec5e05a5cac9111a900ddb","ref":"refs/heads/12-postgres-tables-only-loading-2000-rows-a-table","pushedAt":"2023-04-28T22:23:48.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"DaveBathnes","name":"Dave","path":"/DaveBathnes","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8709533?s=80&v=4"},"commit":{"message":"1 error loading editions (#10)\n\n* Reworking documentation\r\n\r\n* Readme work\r\n\r\n* Starting database scripts\r\n\r\n* Working on database tables\r\n\r\n* Refining table scripts\r\n\r\n* Table creation scripts\r\n\r\n* Bulk of database loading scripts\r\n\r\n* Updating readme\r\n\r\n* Updating ISBN table population\r\n\r\n* Refining order of creating indexes\r\n\r\n* Communicative load process (#7)\r\n\r\n* Communicative load process (#9)\r\n\r\n* add command to make sure openlibrary database is being used when running the script (#6)\r\n\r\n* create a sql file to load a temp table with file information\r\n\r\n* create data loader than can take database files in chunks\r\n\r\n* add new step to load process\r\n\r\n* remove temp table after script finishes\r\n\r\n* add file loader and make it create a loadable file for temp database table\r\n\r\n* add command to auto load filenames into temp table\r\n\r\n* clean up add load script\r\n\r\n* add load scripts\r\n\r\n* rename files to remove the 2 I added\r\n\r\n* add python file to split up data into smaller chunks\r\n\r\n* add some sample files to demonstrate this version quickly\r\n\r\n* reduced the size of sample files\r\n\r\n* add section for moving the files to the unprocessed folder\r\n\r\n* incorporate the changes I made into the readme\r\n\r\n* update notes\r\n\r\n* update one of the code examples\r\n\r\n* make loader mark files that have been loaded instead of deleting them from the loader\r\n\r\n* rephrased message\r\n\r\n* add time stamps and notices\r\n\r\n* refine chunk notes\r\n\r\n* Adjusting bulk loader to use /copy command\r\n\r\n* Minor readme update\r\n\r\n---------\r\n\r\nCo-authored-by: Chloe-Meinshausen <meinshac@gmail.com>","shortMessageHtmlLink":"1 error loading editions (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1585786265\" data-permission-text=\"Title is private\" data-url=\"https://github.com/LibrariesHacked/openlibrary-search/issues/10\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/LibrariesHacked/openlibrary-search/pull/10/hovercard\" href=\"https://github.com/LibrariesHacked/openlibrary-search/pull/10\">#10</a>)"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAD9PdySwA","startCursor":null,"endCursor":null}},"title":"Activity · LibrariesHacked/openlibrary-search"}