{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":262005933,"defaultBranch":"main","name":"dataguide","ownerLogin":"prisma","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2020-05-07T09:23:26.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/17219288?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1716150813.0","currentOid":""},"activityList":{"items":[{"before":"9442a5db278d4fad5cd6faa42e09193659787a2c","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/nth-check-and-gatsby-plugin-sharp-and-gatsby-plugin-mdx-2.1.1","pushedAt":"2024-05-19T20:33:33.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"ee58cdd8457f0ab1d15cecc348866018b9ed0440","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/engine.io-and-gatsby-6.2.1","pushedAt":"2024-05-19T20:33:26.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"c52b9f7d3eb95e5eb209b2abe26290fb03699ae6","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/trim-and-mdx-js/loader-and-mdx-js/mdx-and-gatsby-plugin-mdx--removed","pushedAt":"2024-05-19T20:33:18.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"7c6de38ae1f58f264fe3723d003aa5a4a7e18f2c","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/got-and-gatsby-and-gatsby-plugin-catch-links-and-gatsby-plugin-google-tagmanager-and-gatsby-plugin-image-and-gatsby-plugin-mdx-and-gatsby-plugin-sharp-and-gatsby-plugin-sitemap-and6c2ee886929386029cfa205a078363d9f5311490","pushedAt":"2024-05-19T20:33:07.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"f320ca92196655eca6162853d5d5bac217d26c21","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/loader-utils-and-mdx-js/loader-2.0.4","pushedAt":"2024-05-19T20:32:57.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"649be90a81c37f6a215aca984a4dc5ba9e3eb47e","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/gatsby-4.25.7","pushedAt":"2024-05-19T20:32:49.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"f762ced30d82119ab911e106bd54c18f349d5eca","after":null,"ref":"refs/heads/dependabot/npm_and_yarn/socket.io-parser-and-gatsby-4.2.4","pushedAt":"2024-05-19T20:32:40.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"1ec4bd39e14719cd12b8013a2b9836dde153cf84","after":"b2c2fce79a207f417a528a97fd6e4f1bc15e9d21","ref":"refs/heads/main","pushedAt":"2024-05-19T20:31:55.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"petradonka","name":"Petra Donka","path":"/petradonka","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7353770?s=80&v=4"},"commit":{"message":"Fix grammatical mistake. (#465)\n\nCo-authored-by: aidanCQ <aidan.keay@quantinuum.com>","shortMessageHtmlLink":"Fix grammatical mistake. (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2079381315\" data-permission-text=\"Title is private\" data-url=\"https://github.com/prisma/dataguide/issues/465\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/prisma/dataguide/pull/465/hovercard\" href=\"https://github.com/prisma/dataguide/pull/465\">#465</a>)"}},{"before":"23c2469a2813daf0da2e4eb57c10d8bf137beb0b","after":"1ec4bd39e14719cd12b8013a2b9836dde153cf84","ref":"refs/heads/main","pushedAt":"2024-05-19T20:31:00.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"petradonka","name":"Petra Donka","path":"/petradonka","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7353770?s=80&v=4"},"commit":{"message":"Update 02-comparing-sql-query-builders-and-orms.mdx (#469)\n\nI have removed a redundant \"that\" from the sentence","shortMessageHtmlLink":"Update 02-comparing-sql-query-builders-and-orms.mdx (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2239144692\" data-permission-text=\"Title is private\" data-url=\"https://github.com/prisma/dataguide/issues/469\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/prisma/dataguide/pull/469/hovercard\" href=\"https://github.com/prisma/dataguide/pull/469\">#469</a>)"}},{"before":"09ba455ec9c9741e6f852ef1196d057674b1305f","after":null,"ref":"refs/heads/dataguide","pushedAt":"2024-05-06T10:34:24.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"nikolasburk","name":"Nikolas","path":"/nikolasburk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4058327?s=80&v=4"}},{"before":"221910e9d449d07b7f06e9d7498c7123cd62fa66","after":"23c2469a2813daf0da2e4eb57c10d8bf137beb0b","ref":"refs/heads/main","pushedAt":"2024-05-06T10:34:23.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"nikolasburk","name":"Nikolas","path":"/nikolasburk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4058327?s=80&v=4"},"commit":{"message":"Add JOINs piece to relational databases section (#470)\n\n* add joins piece and images\r\n\r\n* Optimised images with calibre/image-actions\r\n\r\n* Add JOINs piece to index.mdx\r\n\r\n* Update authors.json\r\n\r\n* Update authors.json\r\n\r\n* add author to piece\r\n\r\n* Apply suggestions from code review\r\n\r\n* Apply suggestions from Niko's code review\r\n\r\nCo-authored-by: Nikolas <nikolas.burk@gmail.com>\r\n\r\n* Remove line breaks\r\n\r\n* Fix code snippet under lateral joins\r\n\r\n* image resizing and change index name\r\n\r\n* Optimised images with calibre/image-actions\r\n\r\n* update table properties image\r\n\r\n* Optimised images with calibre/image-actions\r\n\r\n* Add backticks to joins headings\r\n\r\n* Explain join syntax in a bulleted list\r\n\r\n* enlarge relationship betw tables image I hope\r\n\r\n* Update heading to types of joins\r\n\r\n* remove brackets from inner join query\r\n\r\n* define anti-join\r\n\r\n* Turn postgres definition into quote and move note to bottom of lateral joins\r\n\r\n* update sql queries under relations section\r\n\r\n* Update explanation about redundancy for one-to-many relation\r\n\r\n* emphasize that primary key is not always used\r\n\r\n* Update sql schemas\r\n\r\n* show query for result set\r\n\r\n* remove quote from sql schema\r\n\r\n* add crosslinks\r\n\r\n---------\r\n\r\nCo-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>\r\nCo-authored-by: Nikolas <nikolas.burk@gmail.com>","shortMessageHtmlLink":"Add JOINs piece to relational databases section (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2263624449\" data-permission-text=\"Title is private\" data-url=\"https://github.com/prisma/dataguide/issues/470\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/prisma/dataguide/pull/470/hovercard\" href=\"https://github.com/prisma/dataguide/pull/470\">#470</a>)"}},{"before":"3ae03ed76fecc97cdee2ec5515f891852103308a","after":"09ba455ec9c9741e6f852ef1196d057674b1305f","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T21:05:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"add crosslinks","shortMessageHtmlLink":"add crosslinks"}},{"before":"7184537c837e4d2343302691a1ce420c45ddc79f","after":"3ae03ed76fecc97cdee2ec5515f891852103308a","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T20:31:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"remove quote from sql schema","shortMessageHtmlLink":"remove quote from sql schema"}},{"before":"2ff23918d76657260bea1cf82f97a14e606123ad","after":"7184537c837e4d2343302691a1ce420c45ddc79f","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T20:28:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"show query for result set","shortMessageHtmlLink":"show query for result set"}},{"before":"d79092a3394ef436391be72be4de5d391364ca10","after":"2ff23918d76657260bea1cf82f97a14e606123ad","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T20:18:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Update sql schemas","shortMessageHtmlLink":"Update sql schemas"}},{"before":"7ab8e61191519b32075674502b3253276d101d2b","after":"d79092a3394ef436391be72be4de5d391364ca10","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T19:09:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"emphasize that primary key is not always used","shortMessageHtmlLink":"emphasize that primary key is not always used"}},{"before":"243315218b185c28a481afa902647a5af1f21c12","after":"7ab8e61191519b32075674502b3253276d101d2b","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T19:06:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Update explanation about redundancy for one-to-many relation","shortMessageHtmlLink":"Update explanation about redundancy for one-to-many relation"}},{"before":"7260f3c8940e27d24bad56a6670a2ac9600e62c3","after":"243315218b185c28a481afa902647a5af1f21c12","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T19:02:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"update sql queries under relations section","shortMessageHtmlLink":"update sql queries under relations section"}},{"before":"4bd10bb3ef47a348c189f373ba50d9b3cb014241","after":"7260f3c8940e27d24bad56a6670a2ac9600e62c3","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T18:53:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Turn postgres definition into quote and move note to bottom of lateral joins","shortMessageHtmlLink":"Turn postgres definition into quote and move note to bottom of latera…"}},{"before":"218ae50cb6256d60a3a81048552efd9cc3dfb65a","after":"4bd10bb3ef47a348c189f373ba50d9b3cb014241","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T18:43:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"define anti-join","shortMessageHtmlLink":"define anti-join"}},{"before":"74f475676b7942a92bc42953a3e3af48ef1c4853","after":"218ae50cb6256d60a3a81048552efd9cc3dfb65a","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T18:41:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"remove brackets from inner join query","shortMessageHtmlLink":"remove brackets from inner join query"}},{"before":"f7f73efbcc9434bc346599b172a714332a318aee","after":"74f475676b7942a92bc42953a3e3af48ef1c4853","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T18:38:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Update heading to types of joins","shortMessageHtmlLink":"Update heading to types of joins"}},{"before":"6c4d4378c2089d82183b190c384d9a378cb8fee5","after":"f7f73efbcc9434bc346599b172a714332a318aee","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T17:50:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"enlarge relationship betw tables image I hope","shortMessageHtmlLink":"enlarge relationship betw tables image I hope"}},{"before":"2a399eebe207110b04ba3336ff206c88e57b0555","after":"6c4d4378c2089d82183b190c384d9a378cb8fee5","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T17:16:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Explain join syntax in a bulleted list","shortMessageHtmlLink":"Explain join syntax in a bulleted list"}},{"before":"ee5f016faf10edf97d8358355fd06a5fc140a881","after":"2a399eebe207110b04ba3336ff206c88e57b0555","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T16:59:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Add backticks to joins headings","shortMessageHtmlLink":"Add backticks to joins headings"}},{"before":"4a8673241111a97685611fd6e8652d4684f9539d","after":"ee5f016faf10edf97d8358355fd06a5fc140a881","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T15:55:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Optimised images with calibre/image-actions","shortMessageHtmlLink":"Optimised images with calibre/image-actions"}},{"before":"7ffe9d43bfa29c47cbd38b7f0da9610de11ebc57","after":"4a8673241111a97685611fd6e8652d4684f9539d","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T15:53:49.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Merge branch 'dataguide' of https://github.com/prisma/dataguide into dataguide","shortMessageHtmlLink":"Merge branch 'dataguide' of <a href=\"https://github.com/prisma/dataguide\">https://github.com/prisma/dataguide</a> into …"}},{"before":"cf5ac0e460abfd5739ba3a69c6fe737cf9beeed4","after":"7ffe9d43bfa29c47cbd38b7f0da9610de11ebc57","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T15:02:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Optimised images with calibre/image-actions","shortMessageHtmlLink":"Optimised images with calibre/image-actions"}},{"before":"80f3651b52fcac010b6a3a2736b3b2803c5d26a3","after":"cf5ac0e460abfd5739ba3a69c6fe737cf9beeed4","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T15:00:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"image resizing and change index name","shortMessageHtmlLink":"image resizing and change index name"}},{"before":"58530b67e85ea5c43da706080ee6a91ec778db62","after":"80f3651b52fcac010b6a3a2736b3b2803c5d26a3","ref":"refs/heads/dataguide","pushedAt":"2024-04-26T14:18:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"grpatel","name":"Grishma Patel","path":"/grpatel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74070079?s=80&v=4"},"commit":{"message":"Fix code snippet under lateral joins","shortMessageHtmlLink":"Fix code snippet under lateral joins"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAETjy_fQA","startCursor":null,"endCursor":null}},"title":"Activity · prisma/dataguide"}