{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":233057893,"defaultBranch":"master","name":"bqst.github.io","ownerLogin":"bqst","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2020-01-10T13:56:59.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/1244906?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1691526398.0","currentOid":""},"activityList":{"items":[{"before":"9ae31d08a2560c6b3f34d9142cae4e4bf879cdd3","after":"50039274c04852bd97f10a320367a95a11d67cc9","ref":"refs/heads/master","pushedAt":"2024-02-02T19:31:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🔧 refactor(post): simplify slugify function in PostgreSQL post\n\nThe slugify function has been refactored to be more concise and readable. The changes include removing the use of multiple WITH clauses and combining the operations into a single RETURN statement. This makes the function easier to understand and maintain.","shortMessageHtmlLink":"🔧 refactor(post): simplify slugify function in PostgreSQL post"}},{"before":"3f970ab1f4649a6502de0bfb32d2b78f067b3f95","after":"9ae31d08a2560c6b3f34d9142cae4e4bf879cdd3","ref":"refs/heads/master","pushedAt":"2024-02-02T19:30:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"✨ feat(blog): add new blog post 'Using PostgreSQL to Generate Unique Slugs'\n\nThis new blog post explains how to use PostgreSQL to generate unique slugs for web applications, enhancing SEO and user experience.","shortMessageHtmlLink":"✨ feat(blog): add new blog post 'Using PostgreSQL to Generate Unique …"}},{"before":"6e6149b95858d9b55c357bf96a9c402a720e7243","after":"3f970ab1f4649a6502de0bfb32d2b78f067b3f95","ref":"refs/heads/master","pushedAt":"2024-02-02T19:28:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"✨ feat(blog): add new blog post about generating unique slugs with PostgreSQL\n\nThis commit adds a new blog post that explains how to use PostgreSQL to generate unique slugs for a web application. The post provides a detailed guide on creating a function to generate slugs and ensuring their uniqueness using a recursive query.","shortMessageHtmlLink":"✨ feat(blog): add new blog post about generating unique slugs with Po…"}},{"before":null,"after":"4e991a1a39416ab3c25acafa9e7c40aefc9eecbc","ref":"refs/heads/dependabot/bundler/commonmarker-0.23.10","pushedAt":"2023-08-08T20:26:38.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"},"commit":{"message":"build(deps-dev): bump commonmarker from 0.23.9 to 0.23.10\n\nBumps [commonmarker](https://github.com/gjtorikian/commonmarker) from 0.23.9 to 0.23.10.\n- [Release notes](https://github.com/gjtorikian/commonmarker/releases)\n- [Changelog](https://github.com/gjtorikian/commonmarker/blob/v0.23.10/CHANGELOG.md)\n- [Commits](https://github.com/gjtorikian/commonmarker/compare/v0.23.9...v0.23.10)\n\n---\nupdated-dependencies:\n- dependency-name: commonmarker\n  dependency-type: indirect\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>","shortMessageHtmlLink":"build(deps-dev): bump commonmarker from 0.23.9 to 0.23.10"}},{"before":"ebeff2f949d27f48f00d655a38547f0c42d87b1b","after":"6e6149b95858d9b55c357bf96a9c402a720e7243","ref":"refs/heads/master","pushedAt":"2023-07-01T20:06:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(seo-ruby-on-rails-the-comprehensive-guide-2019.markdown): update links format and add missing URLs\n\n- Update the format of the links to be in a bullet point list.\n- Add missing URLs for the links.\n\nReferences:\n- [https://www.antoine-brisset.com/blog/seo-ruby-on-rails-1/](https://www.antoine-brisset.com/blog/seo-ruby-on-rails-1/)\n- [https://nebulab.it/blog/abc-of-seo-for-ruby-on-rails-developers/](https://nebulab.it/blog/abc-of-seo-for-ruby-on-rails-developers/)\n- [https://2017doneright.com/comprehensive-guide-on-seo-in-rails-8b124ca81d37](https://2017doneright.com/comprehensive-guide-on-seo-in-rails-8b124ca81d37)","shortMessageHtmlLink":"📝 docs(seo-ruby-on-rails-the-comprehensive-guide-2019.markdown): upda…"}},{"before":"69c8d9816e74d033d36cd54dacc0d4dabcd1b163","after":"ebeff2f949d27f48f00d655a38547f0c42d87b1b","ref":"refs/heads/master","pushedAt":"2023-07-01T20:04:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(seo-ruby-on-rails-the-comprehensive-guide-2019): add article","shortMessageHtmlLink":"📝 docs(seo-ruby-on-rails-the-comprehensive-guide-2019): add article"}},{"before":"c6251c1b02ba4b239b96f42f25258ee42a4bd0e2","after":"69c8d9816e74d033d36cd54dacc0d4dabcd1b163","ref":"refs/heads/master","pushedAt":"2023-07-01T14:03:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(supabase-authentication-data-access-nextjs-nuxtjs.markdown): add image of postgres primary key\n🎨 style(supabase-authentication-data-access-nextjs-nuxtjs.markdown): format markdown file","shortMessageHtmlLink":"📝 docs(supabase-authentication-data-access-nextjs-nuxtjs.markdown): a…"}},{"before":"10d91517079d12d74afbf6f4a4842bbd953d54cf","after":"c6251c1b02ba4b239b96f42f25258ee42a4bd0e2","ref":"refs/heads/master","pushedAt":"2023-07-01T13:57:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 chore(supabase-authentication-data-access-nextjs-nuxtjs.markdown): update post title to include relationships","shortMessageHtmlLink":"📝 chore(supabase-authentication-data-access-nextjs-nuxtjs.markdown): …"}},{"before":"16750695bd7daf96c2451b2ba5be90080d209c0f","after":"10d91517079d12d74afbf6f4a4842bbd953d54cf","ref":"refs/heads/master","pushedAt":"2023-07-01T13:49:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(supabase-authentication-data-access-nextjs-nuxtjs.markdown): add guide on using Supabase for user authentication and data access in NextJS/NuxtJS projects","shortMessageHtmlLink":"📝 docs(supabase-authentication-data-access-nextjs-nuxtjs.markdown): a…"}},{"before":"2a904839a9432516d868c06288d1308bb1d26d85","after":"16750695bd7daf96c2451b2ba5be90080d209c0f","ref":"refs/heads/master","pushedAt":"2023-06-17T15:09:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(postgresql): add conclusion and security guidelines to pg_cron scheduling task tutorial","shortMessageHtmlLink":"📝 docs(postgresql): add conclusion and security guidelines to pg_cron…"}},{"before":"470344351930746d6443bdfd42cce02f51978cea","after":"2a904839a9432516d868c06288d1308bb1d26d85","ref":"refs/heads/master","pushedAt":"2023-06-17T15:05:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🔒 chore(Gemfile.lock): update faraday and minitest dependencies\n🔒 chore(Gemfile.lock): update racc dependency to version 1.7.1","shortMessageHtmlLink":"🔒 chore(Gemfile.lock): update faraday and minitest dependencies"}},{"before":"007324fb2f38ebcd2556c43ca0a08558acade559","after":null,"ref":"refs/heads/dependabot/bundler/commonmarker-0.23.7","pushedAt":"2023-06-17T15:04:48.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":"b1350de76af7e851ee2f66ad94c573986005c4c0","after":null,"ref":"refs/heads/dependabot/bundler/activesupport-6.0.6.1","pushedAt":"2023-06-17T15:04:41.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":"46e2d1c5adae81ae0a54e21a0ac6cf2ee05e2f78","after":null,"ref":"refs/heads/dependabot/bundler/nokogiri-1.13.10","pushedAt":"2023-06-17T15:04:21.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":"9e6bf0ee8715f500caabdd95abd4e95294bcaeaf","after":"470344351930746d6443bdfd42cce02f51978cea","ref":"refs/heads/master","pushedAt":"2023-06-17T14:40:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(postgresql): add command to list log details for all scheduled jobs in pg_cron","shortMessageHtmlLink":"📝 docs(postgresql): add command to list log details for all scheduled…"}},{"before":"bc881e6263ea2f33033aad82a7479e612b4562aa","after":"9e6bf0ee8715f500caabdd95abd4e95294bcaeaf","ref":"refs/heads/master","pushedAt":"2023-06-17T14:33:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🗑️ chore(_head.html, bqst-fr.png): remove unused Twitter card meta tags and French image asset","shortMessageHtmlLink":"🗑️ chore(_head.html, bqst-fr.png): remove unused Twitter card meta ta…"}},{"before":"ea70bab30126951c091709cc3391b550a388955d","after":"bc881e6263ea2f33033aad82a7479e612b4562aa","ref":"refs/heads/master","pushedAt":"2023-06-17T14:31:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🆕 feat(config.yml): add title_image field with path to the blog's logo\n🔥 chore(config.yml): remove jekyll-analytics plugin configuration\n🆕 feat(bqst-fr.png): add blog's logo image file","shortMessageHtmlLink":"🆕 feat(config.yml): add title_image field with path to the blog's logo"}},{"before":"3cffedc5db2fe5d92dcf0e208ad978b1af28503f","after":"ea70bab30126951c091709cc3391b550a388955d","ref":"refs/heads/master","pushedAt":"2023-06-17T14:16:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🔧 chore(_config.yml): remove whitespace before github_username value\n✨ feat(_includes/_head.html): add Twitter card meta tags\n🐛 fix(_posts/2019-12-26-rmagick-installation-issue-mac.markdown): add summary and author fields\n✨ feat(_posts/2023-06-05-country-code-to-flag-emoji.markdown): add summary and author fields\n✨ feat(_posts/2023-06-17-postgresql-scheduling-task-with-pg-cron.markdown): add summary and author fields","shortMessageHtmlLink":"🔧 chore(_config.yml): remove whitespace before github_username value"}},{"before":"9052c642fa7caa98bc038197db28bb808e9f1e51","after":"3cffedc5db2fe5d92dcf0e208ad978b1af28503f","ref":"refs/heads/master","pushedAt":"2023-06-17T14:10:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🔖 chore(postgresql-scheduling-task-with-pg-cron.markdown): remove trailing newline character","shortMessageHtmlLink":"🔖 chore(postgresql-scheduling-task-with-pg-cron.markdown): remove tra…"}},{"before":"69cfa2cb4559debc743ed6b45d072e3bb0d5183c","after":"9052c642fa7caa98bc038197db28bb808e9f1e51","ref":"refs/heads/master","pushedAt":"2023-06-17T14:09:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(postgresql-scheduling-task-with-pg-cron): add instructions for setting up blog_posts table\n🔒 chore(postgresql-scheduling-task-with-pg-cron): change pg_cron job to run every 15 minutes and unlock post if locked_until timestamp has passed","shortMessageHtmlLink":"📝 docs(postgresql-scheduling-task-with-pg-cron): add instructions for…"}},{"before":"424a227d865d48fed9b6194d863f84a86ff01c26","after":"69cfa2cb4559debc743ed6b45d072e3bb0d5183c","ref":"refs/heads/master","pushedAt":"2023-06-17T13:59:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(postgresql): add references and commands to list and unschedule jobs in pg_cron","shortMessageHtmlLink":"📝 docs(postgresql): add references and commands to list and unschedul…"}},{"before":"e3944917d37228c31b36364466401b5ee0830576","after":"424a227d865d48fed9b6194d863f84a86ff01c26","ref":"refs/heads/master","pushedAt":"2023-06-17T13:54:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🚀 feat(posts): add new post on scheduling tasks with pg_cron in PostgreSQL\n🔧 chore(posts): update categories for two existing posts\n🔧 chore(posts): update tags for two existing posts","shortMessageHtmlLink":"🚀 feat(posts): add new post on scheduling tasks with pg_cron in Postg…"}},{"before":"471a92fd0cdbb614507485f1bbe7a38d58a7e994","after":"e3944917d37228c31b36364466401b5ee0830576","ref":"refs/heads/master","pushedAt":"2023-06-17T13:45:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🐛 fix(rmagick-installation-issue-mac.markdown): fix typo in the post","shortMessageHtmlLink":"🐛 fix(rmagick-installation-issue-mac.markdown): fix typo in the post"}},{"before":"5d79ddcea74f10dee7ff3bc2ce7c2f14b14b2638","after":"471a92fd0cdbb614507485f1bbe7a38d58a7e994","ref":"refs/heads/master","pushedAt":"2023-06-17T13:45:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🐛 fix(_posts): fix code block formatting in 2019-12-26-rmagick-installation-issue-mac.markdown\n🚀 chore(contact): update contact page formatting and heading level","shortMessageHtmlLink":"🐛 fix(_posts): fix code block formatting in 2019-12-26-rmagick-instal…"}},{"before":"920c8054269973ebaa22c975eb432723916f7b0a","after":"5d79ddcea74f10dee7ff3bc2ce7c2f14b14b2638","ref":"refs/heads/master","pushedAt":"2023-06-05T08:34:26.633Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🎉 feat(contact): add contact page with links to social media and email address","shortMessageHtmlLink":"🎉 feat(contact): add contact page with links to social media and emai…"}},{"before":"6bbff6ab487ebac8b92bb1bc8a7c88f7b1a7d2a7","after":"920c8054269973ebaa22c975eb432723916f7b0a","ref":"refs/heads/master","pushedAt":"2023-06-05T08:26:46.651Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(README.md): add setup instructions, post creation instructions, license, acknowledgements, and contact information to README file","shortMessageHtmlLink":"📝 docs(README.md): add setup instructions, post creation instructions…"}},{"before":"7a1144ff5bc4a45f44cd80d35e9f8fca79d74d18","after":"6bbff6ab487ebac8b92bb1bc8a7c88f7b1a7d2a7","ref":"refs/heads/master","pushedAt":"2023-06-05T08:22:10.983Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"📝 docs(country-code-to-flag-emoji): add a blog post on how to convert country codes to flag emojis in JavaScript","shortMessageHtmlLink":"📝 docs(country-code-to-flag-emoji): add a blog post on how to convert…"}},{"before":"f86f73ac01bf0692d3fc0b46a1ecb8925b3aec47","after":"7a1144ff5bc4a45f44cd80d35e9f8fca79d74d18","ref":"refs/heads/master","pushedAt":"2023-06-05T08:10:42.142Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"✨ feat(favicon): add favicon.ico file to project","shortMessageHtmlLink":"✨ feat(favicon): add favicon.ico file to project"}},{"before":"b86aad98e4dfea431692baae5dd6595932858fd6","after":"f86f73ac01bf0692d3fc0b46a1ecb8925b3aec47","ref":"refs/heads/master","pushedAt":"2023-06-05T08:03:51.541Z","pushType":"push","commitsCount":1,"pusher":{"login":"bqst","name":"Bastien","path":"/bqst","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1244906?s=80&v=4"},"commit":{"message":"🔒 chore(Gemfile.lock): update dependencies to latest versions","shortMessageHtmlLink":"🔒 chore(Gemfile.lock): update dependencies to latest versions"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAD8IoPmQA","startCursor":null,"endCursor":null}},"title":"Activity · bqst/bqst.github.io"}