d:["$","div",null,{"className":"w-full","children":[["$","div",null,{"className":"mx-auto max-w-7xl px-6 lg:px-8 print:max-w-none mt-24 sm:mt-32 md:mt-56 print:mt-2 print:w-full print:px-2","children":["$","div",null,{"className":"mx-auto max-w-2xl lg:max-w-none print:w-full print:max-w-none","children":["$","$L13",null,{"className":"max-w-6xl","children":[["$","h1",null,{"data-testid":"landing_page-title","className":"font-display text-5xl font-semibold text-neutral-950 [text-wrap:balance] sm:text-7xl","children":"Boutique Software Agency"}],["$","p",null,{"data-testid":"landing_page-subtitle","className":"mt-6 text-base text-neutral-600 sm:text-lg","children":"We build custom software solutions"}]]}]}]}],["$","$L14",null,{"caseStudies":[{"id":"ixlayer","meta":{"date":"2022-03","clientKey":"ixLayer","title":"Diagnostic laboratory testing reimagined","subTitle":"ixlayer powers accessible, affordable, branded, diagnostic laboratory testing programs for health plans","description":"Custom solutions enable personalized healthcare experiences, powering 1,100+ nationwide programs and millions of diagnostic tests annually.","summary":"ixLayer enables you to easily deploy and manage remote lab testing and health diagnostics solutions. ixLayer's solution makes health testing simple.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/case-studies/ixlayer/hero.webp","service":"Backend and Frontend Development","testimonial":{"author":{"name":"","role":"","image":""},"content":""},"statistics":[],"technologies":["HL7","Django","Python","Postgres","Redis","Vuejs"],"clientName":"ixLayer","industry":"HealthTech","website":"https://ixlayer.com"},"isPublished":true,"href":"/case-studies/ixlayer","icon":"https://cdn.akadenia.com/images/akadenia-webp/clients/ix-layer/dark-icon.webp","content":["$","$L15",null,{"children":[["$","h2",null,{"id":"overview","children":["$","$L16",null,{"gaLocation":"case_studies_ixlayer","href":"#overview","children":"Overview"}]}],"\n",["$","p",null,{"children":"ixlayer is the leading provider of cloud-based platforms empowering diagnostic testing for greater operational efficiency, patient access, and improved outcomes. Seamlessly integrating with all systems to provide unparalleled access to effective health testing solutions, ixlayer's platform empowers health plans, retailers and biopharma organizations to accelerate speed to market and drive engagement and compliance, while improving brand loyalty."}],"\n",["$","h2",null,{"id":"what-we-did","children":["$","$L16",null,{"gaLocation":"case_studies_ixlayer","href":"#what-we-did","children":"What we did"}]}],"\n",["$","p",null,{"children":"Our team contributed to the development and enhancement of features within the ixLayer dashboard, collaborating closely with the ixLayer team. Our efforts were focused on addressing bugs and refining functionalities to bolster the effectiveness of ixLayer's cloud-based platforms. These platforms serve to elevate diagnostic testing processes, fostering heightened operational efficiency, enhancing patient accessibility, and ultimately facilitating improved outcomes."}]]}]},{"id":"just-pallets","meta":{"date":"2022-10","clientKey":"justPallets","title":"Custom and recycled pallets","subTitle":"Just Pallets & Crates is a recognized leader in the wooden packaging industry.","description":"Established in 2009 in Atlanta, GA, Just Pallets and Crates is a trusted supplier serving customers across Georgia and the United States.","summary":"Just Pallets and Crates specializes in custom and recycled pallets, along with custom crates. They have extensive experience in domestic and international deliveries and no job is too small.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/case-studies/just-pallets/hero.webp","service":"Website Development, IT Consulting","testimonial":"$17","statistics":[],"technologies":["Webflow","CSS","HTML","TypeScript"],"clientName":"JustPallets","industry":"Other","website":"https://justpallets.com"},"isPublished":true,"href":"/case-studies/just-pallets","icon":"https://cdn.akadenia.com/images/akadenia-webp/clients/just-pallets/dark-icon.webp","content":["$","$L15",null,{"children":[["$","h2",null,{"id":"overview","children":["$","$L16",null,{"gaLocation":"case_studies_just-pallets","href":"#overview","children":"Overview"}]}],"\n",["$","p",null,{"children":"Just Pallets and Crates was established in 2009 in Atlanta, GA. They specialize in custom and recycled pallets, along with custom crates. Just Pallets is a trusted and reliable supplier that serves customers across Georgia and throughout the United States."}],"\n",["$","h2",null,{"id":"what-we-did","children":["$","$L16",null,{"gaLocation":"case_studies_just-pallets","href":"#what-we-did","children":"What we did"}]}],"\n",["$","p",null,{"children":["We implemented and modernized ",["$","$L16",null,{"gaLocation":"case_studies_just-pallets","href":"https://justpallets.com","children":"https://justpallets.com"}]," website and we provided IT consultancy on a range of topics including company infrastructure security, devices management and protection of company assets"]}]]}]},{"id":"landing-ai","meta":{"date":"2023-01","clientKey":"landingAI","title":"Domain-Specific Large Vision Models (LVMs).","subTitle":"Build your own LVM using proprietary images to accelerate model development and supercharge your model performance","description":"We have built an app for them called LandingLens that was built with a wide array of features to help teams develop accurate ML visual solutions quickly.","summary":"Landing AI is an end-to-end AI platform specifically designed for industrial customers to build and effectively deploy AI visual inspection solutions.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/case-studies/landing-ai/hero.webp","service":"Web and Backend Development","testimonial":"$17","statistics":[],"technologies":["TypeScript","React","Cypress","Nodejs"],"clientName":"LandingAI","industry":"AI","iosApp":"https://apps.apple.com/us/app/landinglens/id1557715916","website":"https://landing.ai"},"isPublished":true,"href":"/case-studies/landing-ai","icon":"https://cdn.akadenia.com/images/akadenia-webp/clients/landing-ai/dark-icon.webp","content":["$","$L15",null,{"children":[["$","h2",null,{"id":"overview","children":["$","$L16",null,{"gaLocation":"case_studies_landing-ai","href":"#overview","children":"Overview"}]}],"\n",["$","p",null,{"children":"Landing AI™ is pioneering the Data-Centric AI movement in which companies with limited data sets can realize the business value of AI and move AI projects from proof-of-concept to full-scale production. LandingLens™, Landing AI's flagship product, makes computer vision easy for everyone. Founded by Andrew Ng, co-founder of Coursera, former chief scientist of Baidu, and founding lead of Google Brain, Landing AI is uniquely positioned to lead the development of AI from a technology that benefits a few to a technology that benefits all."}],"\n",["$","h2",null,{"id":"what-we-did","children":["$","$L16",null,{"gaLocation":"case_studies_landing-ai","href":"#what-we-did","children":"What we did"}]}],"\n",["$","p",null,{"children":"Our team spearheaded the development of the LandingLens mobile application, serving as a portable counterpart to the desktop landingAI dashboard. This mobile app facilitates convenient access to precise machine learning visual solutions, catering to users' needs for mobility and accessibility. Furthermore, we played a key role in enhancing the landingAI dashboard by crafting features that streamline model testing and deployment processes, ensuring a user-friendly experience with minimal effort."}]]}]},{"id":"perimeter","meta":{"date":"2023-01","clientKey":"perimeter","title":"Real-time evacuation management system","subTitle":"Perimeter empowers emergency managers and first responders to address the most important aspect of disaster response and recovery.","description":"Perimeter empowers emergency managers and first responders to address the most important aspect of disaster response and recovery.","summary":"Perimeter empowers emergency managers and first responders to address the most important aspect of disaster response and recovery.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/case-studies/perimeter/hero.webp","service":"Mobile Apps, Web Apps, Apis","testimonial":"$17","statistics":[{"value":"5","label":"US States"},{"value":"10+","label":"Counties"},{"value":"120+","label":"Safety Agencies"},{"value":"2M++","label":"Lives Protected"}],"technologies":["React Native","Mapbox","Nodejs","Postgres","Nextjs","AWS"],"clientName":"Perimeter","industry":"Other","iosApp":"https://apps.apple.com/us/app/perimeter-mobile/id1562227654?itsct=apps_box_link&itscg=30200","androidApp":"https://play.google.com/store/apps/details?id=com.chlela.perimeter&hl=en&pli=1","website":"https://perimeterplatform.com","embedLink":"https://perimetermap.com","rel":"noopener nofollow","galleryImages":[{"alt":"Base Map Select","path":"/case-studies/perimeter/screenshots/mobile-base-map.webp","aspect_ratio":"1290 / 2796"},{"alt":"Team Members","path":"/case-studies/perimeter/screenshots/web-team-members.webp","aspect_ratio":"3804 / 2000"},{"alt":"Edit Team","path":"/case-studies/perimeter/screenshots/mobile-edit-team.webp","aspect_ratio":"1290 / 2796"},{"alt":"Data Type Select","path":"/case-studies/perimeter/screenshots/web-data-type-select.webp","aspect_ratio":"3804 / 2000"},{"alt":"Remove User From Team","path":"/case-studies/perimeter/screenshots/web-remove-user-from-team.webp","aspect_ratio":"3804 / 2000"},{"alt":"Menu","path":"/case-studies/perimeter/screenshots/web-menu.webp","aspect_ratio":"3804 / 2000"},{"alt":"User Profile","path":"/case-studies/perimeter/screenshots/mobile-user-profile.webp","aspect_ratio":"1290 / 2796"},{"alt":"Member Invite","path":"/case-studies/perimeter/screenshots/mobile-member-invite.webp","aspect_ratio":"1290 / 2796"},{"alt":"Map Menu","path":"/case-studies/perimeter/screenshots/mobile-map-menu.webp","aspect_ratio":"1290 / 2796"},{"alt":"Location Info","path":"/case-studies/perimeter/screenshots/web-location-info.webp","aspect_ratio":"3804 / 2000"},{"alt":"Team Members","path":"/case-studies/perimeter/screenshots/mobile-team-members.webp","aspect_ratio":"1290 / 2796"},{"alt":"Add to team","path":"/case-studies/perimeter/screenshots/web-add-to-team.webp","aspect_ratio":"3804 / 2000"},{"alt":"Recent Updates","path":"/case-studies/perimeter/screenshots/web-recent-updates.webp","aspect_ratio":"3804 / 2000"},{"alt":"Find Location","path":"/case-studies/perimeter/screenshots/mobile-find-location.webp","aspect_ratio":"1290 / 2796"},{"alt":"Location Set","path":"/case-studies/perimeter/screenshots/web-set-location.webp","aspect_ratio":"3804 / 2000"},{"alt":"Add To Team","path":"/case-studies/perimeter/screenshots/mobile-add-to-team.webp","aspect_ratio":"1290 / 2796"},{"alt":"Map Legend","path":"/case-studies/perimeter/screenshots/web-map-legend.webp","aspect_ratio":"3804 / 2000"},{"alt":"Authenticate","path":"/case-studies/perimeter/screenshots/mobile-authentication.webp","aspect_ratio":"1290 / 2796"},{"alt":"Area Description","path":"/case-studies/perimeter/screenshots/web-area-description.webp","aspect_ratio":"3804 / 2000"}]},"isPublished":true,"href":"/case-studies/perimeter","icon":"https://cdn.akadenia.com/images/akadenia-webp/clients/perimeter/dark-icon.webp","content":["$","$L15",null,{"children":[["$","h2",null,{"id":"overview","children":["$","$L16",null,{"gaLocation":"case_studies_perimeter","href":"#overview","children":"Overview"}]}],"\n",["$","p",null,{"children":"Perimeter started as a research project out of UC Berkeley, where we first became aware of the need for new communication tools in public safety. Three years later, our team of Berkeley graduates is continuing to do everything we can to help responders keep themselves and their communities safe."}],"\n",["$","p",null,{"children":"Perimeter empowers emergency managers and responders to address the most important aspect of disaster response and recovery."}],"\n",["$","p",null,{"children":"Perimeter is open by design, supporting information sharing into other deployed solutions."}],"\n",["$","h2",null,{"id":"what-we-did","children":["$","$L16",null,{"gaLocation":"case_studies_perimeter","href":"#what-we-did","children":"What we did"}]}],"\n",["$","p",null,{"children":"Our team is responsible for developing and upholding the Perimeter mobile application, alongside maintaining the backend servers and web applications. Akadenia serves as the core engineering entity for the Perimeter platform, dedicated to crafting robust solutions that play a vital role in addressing critical facets of disaster response and recovery efforts."}],"\n",["$","h2",null,{"id":"system-architecture","children":["$","$L16",null,{"gaLocation":"case_studies_perimeter","href":"#system-architecture","children":"System Architecture"}]}],"\n",["$","$L19",null,{"gaLocation":"case_studies_perimeter","src":"https://cdn.akadenia.com/images/akadenia-webp/case-studies/perimeter/perimeter-architecture.webp","alt":"Perimeter System Architecture"}]]}]},{"id":"projectagram","meta":{"date":"2020-07","clientKey":"projectagram","title":"A photo flashlight toy.","subTitle":"An alternative to screen time that kids love","description":"Projectagram is a photo flashlight toy that allows you to project your photos on the wall. It is a great alternative to screen time for kids","summary":"Prōjectagram is a customizable photo flashlight that kids love as an alternative to screen time and to share great memories with loved ones.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/case-studies/projectagram/hero.webp","service":"Mobile apps, Online store, Admin apps","testimonial":"$17","statistics":[{"value":"#2","label":"Best selling kids toy on UncommonGoods"},{"value":"10000s","label":"Happy Kids, Parents and Grandparents"},{"value":"1000s","label":"Orders"}],"technologies":["React Native","TypeScript","React Navigation","Axios","GraphQL","MobX","Shopify","Microsoft Azure"],"clientName":"Prōjectagram","industry":"AI","iosApp":"https://apps.apple.com/ua/app/pr%C5%8Djectagram/id1499420041","androidApp":"https://play.google.com/store/apps/details?id=com.chlela.projectagram&hl=en_US","website":"https://projectagram.com","galleryImages":[{"alt":"Mobile App Getting Started Guide","path":"/case-studies/projectagram/screenshots/getting-started.webp","aspect_ratio":"1290 / 2796"},{"alt":"Landing Page","path":"/case-studies/projectagram/screenshots/web-landing.webp","aspect_ratio":"3804 / 2000"},{"alt":"Menu","path":"/case-studies/projectagram/screenshots/menu.webp","aspect_ratio":"1290 / 2796"},{"alt":"Projector","path":"/case-studies/projectagram/screenshots/web-mini-projector.webp","aspect_ratio":"3804 / 2000"},{"alt":"Gift Card","path":"/case-studies/projectagram/screenshots/web-gift-card.webp","aspect_ratio":"3804 / 2000"},{"alt":"FAQs","path":"/case-studies/projectagram/screenshots/web-faq.webp","aspect_ratio":"3804 / 2000"},{"alt":"No Selected Photos","path":"/case-studies/projectagram/screenshots/no-photos-selected.webp","aspect_ratio":"1290 / 2796"},{"alt":"Image Rotate","path":"/case-studies/projectagram/screenshots/rotate-image.webp","aspect_ratio":"1290 / 2796"},{"alt":"Getting Started","path":"/case-studies/projectagram/screenshots/web-help.webp","aspect_ratio":"3804 / 2000"},{"alt":"Image Crop","path":"/case-studies/projectagram/screenshots/crop-image.webp","aspect_ratio":"1290 / 2796"},{"alt":"Select Image","path":"/case-studies/projectagram/screenshots/select-image.webp","aspect_ratio":"1290 / 2796"},{"alt":"Privacy Commitment","path":"/case-studies/projectagram/screenshots/privacy-commitment.webp","aspect_ratio":"1290 / 2796"},{"alt":"Uploader Progress - Initial State","path":"/case-studies/projectagram/screenshots/uploarder-progress.webp","aspect_ratio":"1290 / 2796"},{"alt":"Privacy","path":"/case-studies/projectagram/screenshots/web-privacy.webp","aspect_ratio":"3804 / 2000"},{"alt":"Uploader Progress - Processing State","path":"/case-studies/projectagram/screenshots/uploader-progress2.webp","aspect_ratio":"1290 / 2796"},{"alt":"Testimonials","path":"/case-studies/projectagram/screenshots/web-testimonials.webp","aspect_ratio":"3804 / 2000"},{"alt":"Photo Uploader","path":"/case-studies/projectagram/screenshots/photo-uploader.webp","aspect_ratio":"1290 / 2796"},{"alt":"Checkout","path":"/case-studies/projectagram/screenshots/checkout.webp","aspect_ratio":"1290 / 2796"},{"alt":"Reels","path":"/case-studies/projectagram/screenshots/web-phtoto-reel.webp","aspect_ratio":"3804 / 2000"},{"alt":"Checkout - Shipping Information","path":"/case-studies/projectagram/screenshots/checkout1.webp","aspect_ratio":"1290 / 2796"},{"alt":"Checkout - Payment Details","path":"/case-studies/projectagram/screenshots/checkout2.webp","aspect_ratio":"1290 / 2796"},{"alt":"Reels","path":"/case-studies/projectagram/screenshots/web-map.webp","aspect_ratio":"3804 / 2000"},{"alt":"Checkout - Order Review","path":"/case-studies/projectagram/screenshots/checkout3.webp","aspect_ratio":"1290 / 2796"},{"alt":"Reels","path":"/case-studies/projectagram/screenshots/web-holiday-cutoff.webp","aspect_ratio":"3804 / 2000"},{"alt":"Login","path":"/case-studies/projectagram/screenshots/login.webp","aspect_ratio":"1290 / 2796"}]},"isPublished":true,"href":"/case-studies/projectagram","icon":"https://cdn.akadenia.com/images/akadenia-webp/clients/projectagram/dark-icon.webp","content":["$","$L15",null,{"children":[["$","h2",null,{"id":"overview","children":["$","$L16",null,{"gaLocation":"case_studies_projectagram","href":"#overview","children":"Overview"}]}],"\n",["$","p",null,{"children":"Prōjectagram photo projectors are loved across generations. Parents and grandparents love using it as a way to relive holiday and vacation memories."}],"\n",["$","p",null,{"children":"Prōjectagram was created one month into covid to serve as an alternative to screen time."}],"\n",["$","h2",null,{"id":"what-we-did","children":["$","$L16",null,{"gaLocation":"case_studies_projectagram","href":"#what-we-did","children":"What we did"}]}],"\n",["$","p",null,{"children":"Akadenia is entrusted with the development and upkeep of both the Projectagram mobile application and website, in addition to managing the servers responsible for hosting and processing all uploaded images. Our team ensures seamless operation and continual improvement of these platforms, delivering a reliable and efficient experience for users."}]]}]},{"id":"savvly","meta":{"date":"2022-08","clientKey":"savvly","title":"Easy and affordable financial security for life.","subTitle":"Savvly is an alternative investment that provides affordable financial security with a modern approach to pension.","description":"Savvly is a market-driven pension offering more money and peace of mind as you live past retirement. It provides easy, affordable financial security for life.","summary":"Savvly is a market-driven pension that can give you more money and peace of mind as you live longer past retirement age.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/case-studies/savvly/hero.webp","service":"Web Development, Mobile App Development, Infrastructure and Cloud Services","testimonial":"$17","statistics":[],"technologies":["TypeScript","Adonisjs","Microsoft Azure","Nextjs","React Native","Postgres"],"clientName":"Savvly","industry":"FinTech","iosApp":"https://apps.apple.com/us/app/savvly/id6452803457?itsct=apps_box_link&itscg=30200","androidApp":"https://play.google.com/store/apps/details?id=com.akadenia.savvly&hl=en_US","website":"https://savvly.com","galleryImages":[{"alt":"landing","path":"/case-studies/savvly/screenshots/mobile-app-landing-screen.webp","aspect_ratio":"1290 / 2796"},{"alt":"adminAgreement","path":"/case-studies/savvly/screenshots/admin-app-agreement-list.webp","aspect_ratio":"3804 / 2000"},{"alt":"learningCenter","path":"/case-studies/savvly/screenshots/mobile-app-learning-center.webp","aspect_ratio":"1290 / 2796"},{"alt":"fileUploads","path":"/case-studies/savvly/screenshots/advisor-app-file-upload.webp","aspect_ratio":"3804 / 2000"},{"alt":"login","path":"/case-studies/savvly/screenshots/mobile-app-login.webp","aspect_ratio":"1290 / 2796"},{"alt":"estimaterInput","path":"/case-studies/savvly/screenshots/mobile-app-estimator-input.webp","aspect_ratio":"1290 / 2796"},{"alt":"appClient","path":"/case-studies/savvly/screenshots/advisor-app-clients-agreements.webp","aspect_ratio":"3804 / 2000"},{"alt":"accountBalance","path":"/case-studies/savvly/screenshots/mobile-app-account-balance.webp","aspect_ratio":"1290 / 2796"},{"alt":"alternatePayouts","path":"/case-studies/savvly/screenshots/mobile-app-alternate-payouts.webp","aspect_ratio":"1290 / 2796"},{"alt":"appAgreement","path":"/case-studies/savvly/screenshots/advisor-app-agreement-review.webp","aspect_ratio":"3804 / 2000"},{"alt":"retirementCalculator","path":"/case-studies/savvly/screenshots/retirement-calculator.webp","aspect_ratio":"3804 / 2000"}]},"isPublished":true,"href":"/case-studies/savvly","icon":"https://cdn.akadenia.com/images/akadenia-webp/clients/savvly/dark-icon.webp","content":["$","$L15",null,{"children":[["$","h2",null,{"id":"overview","children":["$","$L16",null,{"gaLocation":"case_studies_savvly","href":"#overview","children":"Overview"}]}],"\n",["$","p",null,{"children":"Savvly is the private, market-driven social security of the future. Protected by the largest asset management firms, Savvly late-life payouts are designed to return 2-3x more than investing in the same funds on your own. By investing as little as $100/month or up to 10% of your total portfolio, you can retire early and boost your spending, knowing you'll be less likely to run out of money in old age."}],"\n",["$","h2",null,{"id":"what-we-did","children":["$","$L16",null,{"gaLocation":"case_studies_savvly","href":"#what-we-did","children":"What we did"}]}],"\n",["$","p",null,{"children":"Our team is tasked with the development and maintenance of the Savvly mobile application and servers, guaranteeing uninterrupted operation and ongoing enhancements for these platforms. Additionally, we spearheaded a comprehensive revamp of the Savvly website, enhancing its functionality and user experience to align with evolving industry standards and user expectations."}]]}]}],"parentSection":"landing_page"}],[["$","div",null,{"className":"mx-auto max-w-7xl px-6 lg:px-8 print:max-w-none mt-24 sm:mt-32 lg:mt-40 print:mt-2 print:w-full print:px-2","children":["$","div",null,{"className":"mx-auto max-w-2xl lg:max-w-none print:w-full print:max-w-none","children":["$","$L13",null,{"className":"max-w-6xl","children":[["$","h2",null,{"children":["$undefined",["$","span",null,{"data-testid":"landing_page-services_section-title","className":"block font-display [text-wrap:balance] text-3xl font-medium sm:text-4xl text-neutral-950","children":"Silicon Valley experience that goes beyond technical solutions"}]]}],"$undefined"]}]}]}],["$","div",null,{"className":"mx-auto max-w-7xl px-6 lg:px-8 print:max-w-none mt-16 print:mt-2 print:w-full print:px-2","children":["$","div",null,{"className":"mx-auto max-w-2xl lg:max-w-none print:w-full print:max-w-none","children":["$","div",null,{"className":"lg:flex lg:items-center lg:justify-end","children":[["$","div",null,{"className":"flex justify-center lg:w-1/2 lg:justify-end lg:pr-12","children":["$","$L13",null,{"className":"w-full flex-none lg:w-[45rem]","children":["$","div",null,{"className":"justify-center lg:justify-end relative flex aspect-[719/680] w-full max-w-md sm:max-w-none grayscale","children":["$","svg",null,{"viewBox":"0 0 655 680","fill":"none","className":"h-full","children":[["$","g",null,{"clipPath":"url(#:S1:-clip)","className":"group","children":[["$","g",null,{"className":"origin-center scale-100 transition duration-500 motion-safe:group-hover:scale-105","children":["$","foreignObject",null,{"width":655,"height":680,"children":["$","$L1a",null,{"data-testid":"landing_page-services_section-image","alt":"Cat standing on the desk","width":0,"height":0,"unoptimized":true,"className":"w-full bg-neutral-100 object-cover","style":{"aspectRatio":"655 / 680"},"src":"https://cdn.akadenia.com/images/akadenia-webp/bibi.webp","sizes":"(min-width: 1024px) 41rem, 31rem"}]}]}],["$","use",null,{"href":"#:S1:-shape","strokeWidth":"2","className":"stroke-neutral-950/10"}]]}],["$","defs",null,{"children":["$","clipPath",null,{"id":":S1:-clip","children":["$","path",null,{"id":":S1:-shape","d":"M537.827 9.245A11.5 11.5 0 0 1 549.104 0h63.366c7.257 0 12.7 6.64 11.277 13.755l-25.6 128A11.5 11.5 0 0 1 586.87 151h-28.275a15.999 15.999 0 0 0-15.689 12.862l-59.4 297c-1.98 9.901 5.592 19.138 15.689 19.138h17.275l.127.001c.85.009 1.701.074 2.549.009 11.329-.874 21.411-7.529 24.88-25.981.002-.012.016-.016.023-.007.008.009.022.005.024-.006l24.754-123.771A11.5 11.5 0 0 1 580.104 321h63.366c7.257 0 12.7 6.639 11.277 13.755l-25.6 128A11.5 11.5 0 0 1 617.87 472H559c-22.866 0-28.984 7.98-31.989 25.931-.004.026-.037.035-.052.014-.015-.02-.048-.013-.053.012l-24.759 123.798A11.5 11.5 0 0 1 490.87 631h-29.132a14.953 14.953 0 0 0-14.664 12.021c-4.3 21.502-23.18 36.979-45.107 36.979H83.502c-29.028 0-50.8-26.557-45.107-55.021l102.4-512C145.096 91.477 163.975 76 185.902 76h318.465c10.136 0 21.179-5.35 23.167-15.288l10.293-51.467Zm-512 160A11.5 11.5 0 0 1 37.104 160h63.366c7.257 0 12.7 6.639 11.277 13.755l-25.6 128A11.5 11.5 0 0 1 74.87 311H11.504c-7.257 0-12.7-6.639-11.277-13.755l25.6-128Z","fillRule":"evenodd","clipRule":"evenodd"}]}]}]]}]}]}]}],["$","$L1b",null,{"children":["$","ul",null,{"className":"text-base text-neutral-600 mt-16 lg:mt-0 lg:w-1/2 lg:min-w-[33rem] lg:pl-4","children":[["$","li",null,{"data-testid":"landing_page-services_section-list_item-description","className":"group mt-10 first:mt-0","children":["$","$L13",null,{"children":["$","div",null,{"className":"pt-10 group-first:pt-0 group-first:before:hidden group-first:after:hidden relative before:absolute after:absolute before:bg-neutral-950 after:bg-neutral-950/10 before:left-0 before:top-0 before:h-px before:w-6 after:left-8 after:right-0 after:top-0 after:h-px","children":[false,["$","strong",null,{"data-testid":"landing_page-services_section-list_item-title","className":"font-semibold text-neutral-950","children":"Mobile Apps. "}],"We build apps for Apple iOS and Google Android using React Native, TypeScript."]}]}]}],["$","li",null,{"data-testid":"landing_page-services_section-list_item-description","className":"group mt-10 first:mt-0","children":["$","$L13",null,{"children":["$","div",null,{"className":"pt-10 group-first:pt-0 group-first:before:hidden group-first:after:hidden relative before:absolute after:absolute before:bg-neutral-950 after:bg-neutral-950/10 before:left-0 before:top-0 before:h-px before:w-6 after:left-8 after:right-0 after:top-0 after:h-px","children":[false,["$","strong",null,{"data-testid":"landing_page-services_section-list_item-title","className":"font-semibold text-neutral-950","children":"Online Stores. "}],"Shopify gives us the flexibility to extend your store and dashboard with custom applications"]}]}]}],["$","li",null,{"data-testid":"landing_page-services_section-list_item-description","className":"group mt-10 first:mt-0","children":["$","$L13",null,{"children":["$","div",null,{"className":"pt-10 group-first:pt-0 group-first:before:hidden group-first:after:hidden relative before:absolute after:absolute before:bg-neutral-950 after:bg-neutral-950/10 before:left-0 before:top-0 before:h-px before:w-6 after:left-8 after:right-0 after:top-0 after:h-px","children":[false,["$","strong",null,{"data-testid":"landing_page-services_section-list_item-title","className":"font-semibold text-neutral-950","children":"Cloud. "}],"We are a team of full stack engineers with years of experience building apps, APIs, and integrations with external systems"]}]}]}],["$","li",null,{"data-testid":"landing_page-services_section-list_item-description","className":"group mt-10 first:mt-0","children":["$","$L13",null,{"children":["$","div",null,{"className":"pt-10 group-first:pt-0 group-first:before:hidden group-first:after:hidden relative before:absolute after:absolute before:bg-neutral-950 after:bg-neutral-950/10 before:left-0 before:top-0 before:h-px before:w-6 after:left-8 after:right-0 after:top-0 after:h-px","children":[false,["$","strong",null,{"data-testid":"landing_page-services_section-list_item-title","className":"font-semibold text-neutral-950","children":"Web apps. "}],"We build modern, secure and elegant web applications that leverage top industry standards"]}]}]}]]}]}]]}]}]}]],["$","$L1c",null,{"parentSection":"landing_page","className":"mt-24 sm:mt-32 lg:mt-40","items":[{"comment":"We have a long-lasting and successful relationship working with Guy and his team at Akadenia.","author":"Noah Wu","image":"https://cdn.akadenia.com/images/akadenia-webp/testimonials/noah-perimeter.webp","linkedin":"https://www.linkedin.com/in/noahwu","companyName":"Perimeter","position":"Co-founder, CTO - Perimeter"},{"comment":"From planning to delivery, Akadenia went above and beyond for us. They were extremely knowledgeable, flexible, and was such a pleasure to work with!","author":"Jesper Klingenberg","image":"https://cdn.akadenia.com/images/akadenia-webp/testimonials/jesper-timekit.webp","linkedin":"https://www.linkedin.com/in/jesperklingenberg","companyName":"Timekit","position":"CEO - Timekit"},{"comment":"Akadenia helped us implement a software development and release process which did wonders to our product quality","author":"Cyrille Habis","image":"https://cdn.akadenia.com/images/akadenia-webp/testimonials/cyrille-agridata.webp","linkedin":"https://www.linkedin.com/in/cyrille","companyName":"AgriData","position":"CEO - AgriData"},{"comment":"Akadenia is an outstanding software engineering team that has helped build and architect PalleTech's backend infrastructure.","author":"Anthony Wainman","image":"https://cdn.akadenia.com/images/akadenia-webp/testimonials/anthony-palletech.webp","linkedin":"https://www.linkedin.com/in/wainman","companyName":"PalleTech","position":"CTO - PalleTech"}]}],["$","$L1d",null,{"parentSection":"landing_page"}],[["$","div",null,{"className":"mx-auto max-w-7xl px-6 lg:px-8 print:max-w-none mt-24 sm:mt-32 lg:mt-40 print:mt-2 print:w-full print:px-2","children":["$","div",null,{"className":"mx-auto max-w-2xl lg:max-w-none print:w-full print:max-w-none","children":["$","$L13",null,{"className":"max-w-6xl","children":[["$","h2",null,{"children":["$undefined",["$","span",null,{"data-testid":"landing_page-industries_section-title","className":"block font-display [text-wrap:balance] text-3xl font-medium sm:text-4xl text-neutral-950","children":"Industries"}]]}],"$undefined"]}]}]}],["$","div",null,{"className":"mx-auto max-w-7xl px-6 lg:px-8 print:max-w-none mt-16 print:mt-2 print:w-full print:px-2","children":["$","div",null,{"className":"mx-auto max-w-2xl lg:max-w-none print:w-full print:max-w-none","children":["$","$L1b",null,{"className":"grid mt-10 grid-cols-1 gap-8 lg:grid-cols-3","children":[["$","$L1e","healthtech",{"parentSection":"landing_page-industries_section--5311f8ce","name":"HealthTech","id":"healthtech"}],["$","$L1e","fintech",{"parentSection":"landing_page-industries_section-3056dd21","name":"FinTech","id":"fintech"}],["$","$L1e","ai",{"parentSection":"landing_page-industries_section-828","name":"AI","id":"ai"}]]}]}]}]],["$","$L1f",null,{"items":[{"id":"reliable-error-tracking","meta":{"date":"2025-04-07","title":"The full reliable error tracking in Next.js guide","subTitle":"The full guide for error tracking in Nextjs in the app router","description":"Learn how to really capture errors that is handling in the server side rendering and the client side rendering in app router.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/blogs/reliable-error-tracking/hero.webp","authorKey":"mohamed","category":"NextJS","lastModifiedDate":"2023-04-10","author":{"name":"Mohamed Ibrahim","role":"Software Engineer","image":"https://cdn.akadenia.com/images/akadenia-webp/team/mohamed.webp","bio":"Mohamed is a software engineer with a focus on building scalable and reliable web and mobile applications. He has a passion for creating high-quality software solutions that are user-friendly and easy to maintain. Mohamed is also an advocate for clean code and best practices in software development."}},"isPublished":true,"href":"/posts/reliable-error-tracking","icon":"https://cdn.akadenia.com/images/akadenia-webp/team/mohamed.webp","content":["$","$L15",null,{"children":[["$","p",null,{"children":["Next.js provides a solid foundation for error handling, as outlined in their ",["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"https://nextjs.org/docs/app/getting-started/error-handling","children":"official documentation"}],". However, in practice, it doesn’t always capture every type of error—particularly those thrown inside promises, React hooks, or event handler callbacks."]}],"\n",["$","p",null,{"children":["This limitation has been discussed in the Next.js GitHub issues ",["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"https://github.com/vercel/next.js/issues/55462","children":"#55462"}]," and ",["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"https://github.com/vercel/next.js/issues/53756","children":"#53756"}],". Although these issues have been closed, the underlying concerns remain relevant. As a result, we needed a more reliable way to catch all errors occurring in our app, including the ones that slip through Next.js’s built-in mechanisms."]}],"\n",["$","p",null,{"children":"This guide introduces a robust error-tracking setup you can integrate into your app to ensure that no runtime error goes unnoticed. We’ve tested this approach in real-world applications and found it effective, especially when working with the App Router and a mix of server and client components."}],"\n",["$","p",null,{"children":"If Next.js later provides a built-in fix or improvement, we recommend adopting the official approach. But until then, this guide will save you time and provide a battle-tested solution. Depending on your setup, you can also pick and choose the parts that best fit your architecture."}],"\n",["$","h2",null,{"id":"types-of-errors","children":["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"#types-of-errors","children":"Types of errors"}]}],"\n",["$","p",null,{"children":"There are mostly but not closed to 3 types of errors that can be thrown in your frontend app:"}],"\n",["$","ol",null,{"children":["\n",["$","li",null,{"children":[["$","strong",null,{"children":"UI crashing errors"}],": This type of error is being thrown while rendering your component on the server side. This error prevents the function of your component returning the DOM that represents your component. This type of error is caught by NextJS. Looks like this component:"]}],"\n"]}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#616E88"},"children":"// src/app/page.tsx"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"function"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"getData"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"await"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"new"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"Promise"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"<"}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"string"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":">"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"resolve"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"reject"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"setTimeout"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"reject"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"new"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Error"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Error getting data"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"))"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"},"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#B48EAD"},"children":"1000"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"function"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Home"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"data"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"await"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"getData"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"()"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"div"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"className"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"flex flex-col items-center justify-center h-screen"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"data"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Home"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}]]}]}],"\n",["$","p",null,{"children":["Results in:\n",["$","$L19",null,{"gaLocation":"posts_reliable-error-tracking","src":"https://cdn.akadenia.com/images/akadenia-webp/blogs/reliable-error-tracking/error-screen-1.webp","alt":"App error screen of nextjs"}]]}],"\n",["$","ol",null,{"start":"2","children":["\n",["$","li",null,{"children":[["$","strong",null,{"children":"Hooks errors/ uncaught promise rejections"}],": These types of errors that happens within your hooks, usually within the useEffect hooks to get the data for instance or doing some animation. This is one type of errors that is not caught by NextJS error handler, like this example:"]}],"\n"]}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#616E88"},"children":"// src/app/page.tsx"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"use client"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"useEffect"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"useState"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"react"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"function"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Home"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"["}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"data"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"setData"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"]"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"useState"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"<"}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"string"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"|"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"null"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":">"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"null"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"useEffect"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"getData"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"data"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"await"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"new"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"Promise"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"<"}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"string"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":">"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"resolve"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"reject"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"setTimeout"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"reject"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"new"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Error"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Error getting data"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"))"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"},"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#B48EAD"},"children":"1000"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"setData"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"data"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"getData"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"()"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"},"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" [])"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"div"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"className"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"flex flex-col items-center justify-center h-screen"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"data"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Home"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}]]}]}],"\n",["$","p",null,{"children":["Results in:\n",["$","$L19",null,{"gaLocation":"posts_reliable-error-tracking","src":"https://cdn.akadenia.com/images/akadenia-webp/blogs/reliable-error-tracking/error-screen-2.webp","alt":"App screen showing console log of error type 2"}]]}],"\n",["$","ol",null,{"start":"3","children":["\n",["$","li",null,{"children":[["$","strong",null,{"children":"Event handlers errors"}],": These are the errors that is being thrown by a process that is being triggered from the user. This also is is one type of errors that is not caught by by NextJS error handler, like this example:"]}],"\n"]}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#616E88"},"children":"// src/app/page.tsx"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"use client"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Button"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"@components/button"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"function"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Home"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"div"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"className"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"flex flex-col items-center justify-center h-screen"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Button"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"onClick"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"() => {"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" throw new "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Error"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Error thrown from a button"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Click"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"me"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"to"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"throw"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"an"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"error"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Home"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}]]}]}],"\n",["$","p",null,{"children":["Results in:\n",["$","$L19",null,{"gaLocation":"posts_reliable-error-tracking","src":"https://cdn.akadenia.com/images/akadenia-webp/blogs/reliable-error-tracking/error-screen-3.webp","alt":"App screen showing console log of error type 3"}]]}],"\n",["$","h2",null,{"id":"solution","children":["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"#solution","children":"Solution"}]}],"\n",["$","p",null,{"children":["From our experience, it became clear that we needed a way to reliably capture the other two types of errors that Next.js doesn’t catch by default. Once you’re able to capture these, you open the door to a range of possibilities—whether it’s reporting them to an Application Performance Monitoring (APM) tool like Sentry or Datadog, or even displaying a custom toast notification to inform the user. How you choose to handle these errors is entirely up to your app’s needs.\nThat said, we’ll leave the handling of the first type—UI-crashing errors—to Next.js’s built-in ",["$","code",null,{"children":"global-error.tsx"}]," file. If you’d like to see an example of how we’ve structured ours, you can check it out below:"]}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#616E88"},"children":"// src/app/global-error.tsx"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"use client"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Button"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"@components/button"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"useEffect"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"react"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"function"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"GlobalError"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"({"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"error"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"reset"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" error"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"Error"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"&"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" digest"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"?:"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"string"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"reset"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"void"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"})"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"useEffect"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"error"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"error"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// Add your error handling logic here"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"},"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ["}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"error"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"])"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"html"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"lang"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"en"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" <"}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"body"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#616E88"},"children":"/* Your error handling UI */"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Button"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"onClick"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"() => {"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"reset"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"Reset"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}]]}]}],"\n",["$","h3",null,{"id":"create-an-error-tracer-component","children":["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"#create-an-error-tracer-component","children":"Create an error tracer component"}]}],"\n",["$","p",null,{"children":["The ",["$","code",null,{"children":"ErrorTracer"}]," component is our magical client-side component that will listen for global runtime errors and unhandled promise rejections. It uses the ",["$","code",null,{"children":"useEffect"}]," hook to add event listeners to the ",["$","code",null,{"children":"window"}]," object when the component mounts, logging errors to the console for easier debugging. It also cleans up the listeners on unmount to prevent memory leaks. The component returns null since it doesn’t render anything and is meant to be included at a high level in the app to monitor runtime issues. Please know that this component will only run in the client's browser without any server side rendering as it should handle the errors happening in the user's browser."]}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#616E88"},"children":"// src/components/error-tracer.tsx"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"use client"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"useEffect"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"react"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"function"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"ErrorTracer"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"useEffect"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"handleError"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"event"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"ErrorEvent"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"log"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Ahaaa we have caught the error: "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"event"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"error"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"?."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"message"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// Add error handling logic here"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"handleUnhandledRejection"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"event"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"PromiseRejectionEvent"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"log"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Ahaaa we have caught the unhandled rejection: "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"event"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"reason"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"?."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"message"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// Add unhandled rejection handling logic here"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"window"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"addEventListener"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"error"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"handleError"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"window"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"addEventListener"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"unhandledrejection"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"handleUnhandledRejection"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"window"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"removeEventListener"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"error"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"handleError"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"window"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"removeEventListener"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"unhandledrejection"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"handleUnhandledRejection"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"},"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" [])"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"null;"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// This component doesn't render anything"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}]]}]}],"\n",["$","h3",null,{"id":"hook-the-error-tracer-in-our-app-layout","children":["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"#hook-the-error-tracer-in-our-app-layout","children":"Hook the error tracer in our app layout."}]}],"\n",["$","p",null,{"children":["In this ",["$","code",null,{"children":"layout.tsx"}]," file, the ",["$","code",null,{"children":"ErrorTracer"}]," component is imported using Next.js’s ",["$","code",null,{"children":"dynamic"}]," import function, which allows components to be loaded lazily and conditionally. This is particularly useful for components that rely on browser-specific APIs, like window, which are not available during server-side rendering (SSR). By setting ",["$","code",null,{"children":"{ ssr: false }"}]," in the dynamic import options, we explicitly tell Next.js to load ErrorTracer only on the client side. This prevents SSR-related errors that would occur if the component tried to access window or document during the server render phase."]}],"\n",["$","p",null,{"children":"We use ErrorTracer inside the main layout component to ensure it’s initialized once and is active throughout the entire app lifecycle. This placement guarantees that any unhandled runtime errors or promise rejections across the application will be caught, making it ideal for monitoring and debugging in production."}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#616E88"},"children":"// src/app/layout.tsx"}]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"../styles/app.css"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"PropsWithChildren"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"react"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"dynamic"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"next/dynamic"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"ErrorTracer"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"dynamic"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"@components/error-tracer"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"ssr"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"false"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"function"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Layout"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"({"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"children"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"PropsWithChildren"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"html"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"className"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"h-full"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"lang"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"en"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"body"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"className"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"min-h-full"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":">"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"<"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"ErrorTracer"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"/>"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"children"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":""}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" )"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}]]}]}],"\n",["$","h2",null,{"id":"output","children":["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"#output","children":"Output"}]}],"\n",["$","p",null,{"children":["Here is the output when testing with the previous versions:\n",["$","$L19",null,{"gaLocation":"posts_reliable-error-tracking","src":"https://cdn.akadenia.com/images/akadenia-webp/blogs/reliable-error-tracking/error-screen-4.webp","alt":"App screen showing solution for error type 2"}],"\n",["$","$L19",null,{"gaLocation":"posts_reliable-error-tracking","src":"https://cdn.akadenia.com/images/akadenia-webp/blogs/reliable-error-tracking/error-screen-5.webp","alt":"App screen showing solution for error type 2"}]]}],"\n",["$","h2",null,{"id":"conclusion","children":["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"#conclusion","children":"Conclusion"}]}],"\n",["$","p",null,{"children":["In summary, while NextJS provides a robust framework for error handling, it doesn't catch all types of errors, particularly those within promises, hooks, and event handlers. By implementing a custom error handling infrastructure, including the ErrorTracer component and integrating it into your app layout, you can effectively capture and manage these errors. This approach not only ensures a more resilient application but also provides opportunities for enhanced debugging and user experience through custom error reporting and notifications. Until NextJS updates its error handling capabilities, this guide serves as a comprehensive solution for managing uncaught errors and promises in your NextJS applications. You are welcome to checkout our own repo for this as a ",["$","$L16",null,{"gaLocation":"posts_reliable-error-tracking","href":"https://github.com/akadenia/next-js-apm-setup/tree/feat/setup-error-infrastructure","children":"reference"}]]}]]}],"rating":{"value":5,"count":1}},{"id":"real-time-updates-using-pg-notify","meta":{"date":"2025-03-04","title":"Leveraging PG_NOTIFY for Real-Time Postgres Update Alerts","subTitle":"A simple guide to implementing real-time updates in your Node.js application using only your postgres database","description":"Learn how to leverage PG_NOTIFY for real-time updates in your Node.js application, enabling you to build more responsive and efficient applications using native postgres features","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/blogs/real-time-updates-using-pg-notify/hero.webp","authorKey":"tsatsu","category":"Database","lastModifiedDate":"2025-03-04","author":{"name":"Tsatsu","role":"Software Engineer","image":"https://cdn.akadenia.com/images/akadenia-webp/team/tsatsu.webp","bio":"Tsatsu is a software engineer with a focus on building scalable and reliable web and mobile applications. He has a passion for creating high-quality software solutions that are user-friendly and easy to maintain. Tsatsu is also an advocate for clean code and best practices in software development."}},"isPublished":true,"href":"/posts/real-time-updates-using-pg-notify","icon":"https://cdn.akadenia.com/images/akadenia-webp/team/tsatsu.webp","content":["$","$L15",null,{"children":[["$","p",null,{"children":["Imagine a scenario where your application instantly reacts to changes in your Postgres database, almost as if it had a sixth sense. That's not just wishful thinking; with PostgreSQL's ",["$","code",null,{"children":"PG_NOTIFY"}]," feature, you can make this a reality. Designed to keep systems in sync, PG_NOTIFY provides a way to trigger notifications on database updates. Let's dive into how you can harness this functionality to elevate data-driven applications and how it can improve event driven actions in you applications."]}],"\n",["$","h2",null,{"id":"what-is-pg_notify","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#what-is-pg_notify","children":"What Is PG_NOTIFY?"}]}],"\n",["$","p",null,{"children":"PG_NOTIFY is part of PostgreSQL's LISTEN/NOTIFY mechanism, providing an efficient way to signal applications about database events without continuous polling. When a specified event occurs – typically an update to a table – PG_NOTIFY dispatches a message which Listening processes can catch to perform subsequent actions. This isn't some run-of-the-mill feature; it's a game-changer for maintaining timeliness and reducing unnecessary database load."}],"\n",["$","h2",null,{"id":"how-does-it-work","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#how-does-it-work","children":"How Does It Work?"}]}],"\n",["$","ul",null,{"children":["\n",["$","li",null,{"children":[["$","em",null,{"children":"Step One"}],": An operation in the database triggers PG_NOTIFY."]}],"\n",["$","li",null,{"children":[["$","em",null,{"children":"Step Two"}],": A payload consisting of JSON or simple text accompanies the notification."]}],"\n",["$","li",null,{"children":[["$","em",null,{"children":"Step Three"}],": Applications running ",["$","code",null,{"children":"LISTEN"}]," commands intercept these payloads."]}],"\n",["$","li",null,{"children":[["$","em",null,{"children":"Step Four"}],": The app acts on the data, eg. sending notifications or syncing services."]}],"\n"]}],"\n",["$","h2",null,{"id":"setting-up-notifications","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#setting-up-notifications","children":"Setting Up Notifications"}]}],"\n",["$","p",null,{"children":"Here's a step-by-step guide on setting up PG_NOTIFY, we will be using node and typescript in this example but can be achieved in other languages and respective postgres clients. Assume we have a user table in our database with the following structure. In this scenario I want to trigger an email when a new user signs up but this could apply to other scenarios eg. update my cache when the user info is updated."}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"CREATE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"TABLE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" users ("}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" id "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"SERIAL"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"PRIMARY"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"KEY"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" first_name "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"VARCHAR"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#B48EAD"},"children":"255"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":") "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"NOT"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"NULL"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" last_name "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"VARCHAR"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#B48EAD"},"children":"255"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":") "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"NOT"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"NULL"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" email_address "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"VARCHAR"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#B48EAD"},"children":"255"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":") "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"NOT"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"NULL"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":","}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" created_at "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"TIMESTAMP"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"DEFAULT"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"CURRENT_TIMESTAMP"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" updated_at "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"TIMESTAMP"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"DEFAULT"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"CURRENT_TIMESTAMP"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":");"}]}]]}]}],"\n",["$","h2",null,{"id":"step-1-create-a-trigger-function","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#step-1-create-a-trigger-function","children":"Step 1: Create a Trigger Function"}]}],"\n",["$","p",null,{"children":"Create a postgres function that triggers the PG_NOTIFY event."}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"CREATE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"OR"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"REPLACE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"FUNCTION"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" notify_on_create"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"RETURNS"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" TRIGGER "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"AS"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" $$"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#81A1C1"},"children":"BEGIN"}]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" PERFORM pg_notify("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"'"}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"user_created"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"'"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":", NEW.id::"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"text"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":");"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"RETURN"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" NEW;"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"END"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"$$$ "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"LANGUAGE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" plpgsql;"}]]}]]}]}],"\n",["$","p",null,{"children":"It is possible to pass the entire updated payload as a json object in the notification payload but it is recommended to pass the id and then fetch the updated row in your listener function because the pg_notify function has a payload limit of 8000 bytes (8kb). If you're certain your payload will never exceed that size you can update the pg_notify call to the following to pass the entire updated payload"}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"PERFORM pg_notify("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"'"}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"user_created"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"'"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":", NEW.id::"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"text"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":");"}]]}]}]}],"\n",["$","h2",null,{"id":"step-2-attach-the-trigger-to-your-desired-table","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#step-2-attach-the-trigger-to-your-desired-table","children":"Step 2: Attach the Trigger to Your Desired Table"}]}],"\n",["$","p",null,{"children":"Bind the trigger to the action. It could be connect to one or more of the INSERT, UPDATE, or DELETE operations"}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"CREATE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" TRIGGER user_create_trigger"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"AFTER"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"INSERT"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"ON"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" user"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"FOR EACH "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"ROW"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"EXECUTE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"FUNCTION"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" notify_on_create"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":";"}]]}]]}]}],"\n",["$","h2",null,{"id":"step-3-listen-for-notifications","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#step-3-listen-for-notifications","children":"Step 3: Listen for Notifications"}]}],"\n",["$","p",null,{"children":["Setup a listener on your server that connects to the db and processes the update notification. We'll be using the node ",["$","code",null,{"children":"pg"}]," library"]}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"pg"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"pg"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"dbClient"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"new"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"pg"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Client"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"postgresql://postgres@localhost:5432/db"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"dbEventListener"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"log"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Connecting to database..."}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"dbClient"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"connect"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"err"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"if"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"err"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":") "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"throw"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"new"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"Error"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Error connecting to database:"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"err"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"log"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Connected to database successfully"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"dbClient"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"query"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"`"}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"LISTEN user_created"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"`"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// The event name used in your pg notify function definition"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"dbClient"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"on"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"notification"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"msg"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// The notification payload has the following structure"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// interface Notification {"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// processId: number;"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// channel: string;"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// payload?: string | undefined;"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"//}"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"log"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"`"}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Notification: "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"$${"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"msg"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"channel"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}`"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"log"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"`"}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Notification payload: "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"$${"}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"msg"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"payload"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}`"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}]]}]}],"\n",["$","h2",null,{"id":"step-4-act-on-the-data-update","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#step-4-act-on-the-data-update","children":"Step 4: Act On the Data Update"}]}],"\n",["$","p",null,{"children":"The payload will container the id of the newly created row. We can use that to fetch the user information from the database and handle any related business logic"}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"dbEventListener"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"console"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"log"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Connecting to database..."}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"dbClient"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"connect"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"err"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// ... existing code"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"dbClient"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"on"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"notification"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"msg"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"//...existing code"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"user"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"getUser"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"msg"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"payload"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#616E88"},"children":"// The payload contains the userId"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"await"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"sendEmail"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"user"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"emailAddress"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}]]}]}],"\n",["$","h2",null,{"id":"advantages-and-considerations","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#advantages-and-considerations","children":"Advantages and Considerations"}]}],"\n",["$","p",null,{"children":"Using PG_NOTIFY provides the following benefits"}],"\n",["$","ul",null,{"children":["\n",["$","li",null,{"children":"Minimizes Performance Hits: Say goodbye to constant polling, which can weigh down your system like an anchor."}],"\n",["$","li",null,{"children":"Heightens Responsiveness: With alerts being real-time, your apps can mirror database changes almost instantaneously."}],"\n",["$","li",null,{"children":"Scalability-Friendly: It caters nicely to growing systems, adapting without increasing complexity"}],"\n"]}],"\n",["$","p",null,{"children":"Despite the clear benefits, as with all software there are tradeoffs that need to be considered Overuse could lead to notification floods, so careful calibration is crucial. While PG_NOTIFY excels in many environments, extreme scale might require complementary strategies (eg. queues, retries) to ensure performance doesn't take a nosedive or critical operations aren't affected"}],"\n",["$","h2",null,{"id":"conclusion","children":["$","$L16",null,{"gaLocation":"posts_real-time-updates-using-pg-notify","href":"#conclusion","children":"Conclusion"}]}],"\n",["$","p",null,{"children":"The PG_NOTIFY function empowers software engineers to react to database updates fluently and immediately. By adopting this approach, you can implement reactive architectures that are both robust and elegant. This real-time responsiveness not only enhances user experience but also optimizes system performance by reducing unnecessary database load. However, it's crucial to calibrate the use of notifications to prevent overload and ensure that the system scales efficiently. With careful implementation, PG_NOTIFY can be a cornerstone in building scalable, efficient, and responsive data-driven applications."}]]}],"rating":{"value":5,"count":3}},{"id":"setup-postgis-with-adonisjs-v6","meta":{"date":"2025-03-01","title":"How to setup PostGIS with adonisJS v6 (lucid ORM)","subTitle":"A step-by-step guide to integrating PostGIS with AdonisJS v6 for efficient geospatial queries.","description":"Learn how to integrate PostGIS with AdonisJS v6 using Lucid ORM for geospatial queries. This guide covers installation, configuration, and running spatial queries efficiently.","heroImage":"https://cdn.akadenia.com/images/akadenia-webp/blogs/setup-postgis-with-adonisjs-v6/hero.webp","authorKey":"david","category":"database","lastModifiedDate":"2025-03-01","author":{"name":"David","role":"Software Engineer","image":"https://cdn.akadenia.com/images/akadenia-webp/team/david.webp","bio":"David is a software engineer with a focus on building scalable and reliable web and mobile applications. He has a passion for creating high-quality software solutions that are user-friendly and easy to maintain. David is also an advocate for clean code and best practices in software development."}},"isPublished":true,"href":"/posts/setup-postgis-with-adonisjs-v6","icon":"https://cdn.akadenia.com/images/akadenia-webp/team/david.webp","content":["$","$L15",null,{"children":[["$","p",null,{"children":["Setting up PostGIS itself is not much of a hassle. Ensure you have PostGIS installed—which may already be the case depending on your PostgreSQL environment. For example, if you are using Postgres from a cloud provider, PostGIS is typically included; if you're using Docker, simply replace your ",["$","code",null,{"children":"postgres"}]," image with the ",["$","code",null,{"children":"postgis/postgis"}]," image. If you’re running Postgres natively, please follow the installation guide in the ",["$","$L16",null,{"gaLocation":"posts_setup-postgis-with-adonisjs-v6","href":"https://postgis.net/documentation/getting_started/#installing-postgis","children":"official documentation"}],", as this guide focuses on configuration rather than installation."]}],"\n",["$","h3",null,{"id":"enable-postgis","children":["$","$L16",null,{"gaLocation":"posts_setup-postgis-with-adonisjs-v6","href":"#enable-postgis","children":"Enable postgis"}]}],"\n",["$","p",null,{"children":["With the context above, the assumption is you already have ",["$","code",null,{"children":"Postgis"}]," installed and you just want to see the code on how to configure and use it within adonisJS (lucid ORM). To enable postgis, we need to create a migration file with the below content in the migration file"]}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"CREATE"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" EXTENSION "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"IF"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"NOT"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"EXISTS"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" postgis;"}]]}]}]}],"\n",["$","p",null,{"children":"What the above SQL statement does is to configure and enable the postgis extension within the database you are connected to. You will notice about 2 tables created in the db, along with a dozen functions."}],"\n",["$","h3",null,{"id":"creating-a-column-that-uses-geospatial-type-geography--geometry","children":["$","$L16",null,{"gaLocation":"posts_setup-postgis-with-adonisjs-v6","href":"#creating-a-column-that-uses-geospatial-type-geography--geometry","children":"Creating a column that uses geospatial type (geography / geometry)"}]}],"\n",["$","p",null,{"children":["Now the next step is actually using the postgis we just installed. To do so, we will create a sample database table called ",["$","code",null,{"children":"user_profile"}]," which would have the below columns"]}],"\n",["$","p",null,{"children":"id - primary key"}],"\n",["$","p",null,{"children":"full_name - User’s full name"}],"\n",["$","p",null,{"children":["location - The User’s location (in coordinates) ie: ",["$","code",null,{"children":"5.6393728,-0.1709543"}]]}],"\n",["$","p",null,{"children":["NB: To describe a column to be of a geospatial type, we need to use either the geography or geometry data type. Either of them will work, but if you want to know the technical details and the difference between the 2, head on to read more ",["$","$L16",null,{"gaLocation":"posts_setup-postgis-with-adonisjs-v6","href":"https://www.notion.so/How-to-setup-PostGIS-with-adonisJS-v6-lucid-ORM-a2c4d133a115488cb23e627d34548c00?pvs=21","children":"here"}]]}],"\n",["$","p",null,{"children":"Talk is cheap, let me see the code :)"}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"BaseSchema"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"@adonisjs/lucid/schema"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"class"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"extends"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB","fontStyle":"italic"},"children":"BaseSchema"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"protected"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" tableName "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"user_profile"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"public"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"up"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"this"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"schema"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"createTable"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"this"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"tableName"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"table"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":")"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"=>"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"table"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"increments"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"id"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"table"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"string"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"full_name"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"table"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"geometry"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"location"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"public"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"async"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"down"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"this"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"schema"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"dropTable"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"this"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"tableName"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}]]}]}],"\n",["$","p",null,{"children":"As seen in the code above, you will notice we are using a special data type called geometry to define the column data type for the location column."}],"\n",["$","h3",null,{"id":"create-a-model","children":["$","$L16",null,{"gaLocation":"posts_setup-postgis-with-adonisjs-v6","href":"#create-a-model","children":"Create a model"}]}],"\n",["$","p",null,{"children":"Now that we are done creating our table, we will need a model to interact with our data. To do so we will use the code below"}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"BaseModel"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"column"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"computed"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"@adonisjs/lucid/orm"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"type"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"Coordinate"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" ["}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"number"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":","}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"number"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"]"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"type"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"PointGeometry"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" type"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"Point"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" coordinates"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"Coordinate"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"export"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"default"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"class"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"UserProfile"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"extends"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB","fontStyle":"italic"},"children":"BaseModel"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"public"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"static"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" table "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"user_profile"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D08770"},"children":"@column"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"isPrimary"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"true"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"public"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"declare"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" id"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"number"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D08770"},"children":"@column"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"()"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"public"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"declare"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" location"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"string"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D08770"},"children":"@computed"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"()"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"public"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"get"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"locationAsGeoJSON"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"()"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"GeoJsonGeometry"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"|"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#8FBCBB"},"children":"null"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"{"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"locationAsGeoJSON"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"this"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"$$extras"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"location_as_geojson"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"return"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"locationAsGeoJSON"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"?"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"JSON"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"parse"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"this"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"$$extras"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"location_as_geojson"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":":"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"null;"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]]}],"\n",["$","span",null,{"className":"line","children":["$","span",null,{"style":{"color":"#ECEFF4"},"children":"}"}]}]]}]}],"\n",["$","p",null,{"children":["The above code looks like any other adonisJS model, except for one thing, which is the ",["$","code",null,{"children":"locationAsGeoJSON"}]," property in the UserProfile class. You will notice its marked as ",["$","code",null,{"children":"computed"}]," which means, its not a table column field, but rather, its value is dynamically computed/generated at runtime when a query is run against the UserProfile model."]}],"\n",["$","p",null,{"children":["Then when we take a deeper look, we can see that it is JSON stringifying a field called ",["$","code",null,{"children":"location_as_geojson"}]," . We will get to the details of ",["$","code",null,{"children":"location_as_geojson"}]," in the next section, stay tuned."]}],"\n",["$","h3",null,{"id":"how-to-query-for-db-records-including-the-geospatial-column-types","children":["$","$L16",null,{"gaLocation":"posts_setup-postgis-with-adonisjs-v6","href":"#how-to-query-for-db-records-including-the-geospatial-column-types","children":"How to query for db records including the geospatial column types"}]}],"\n",["$","p",null,{"children":"With all we have done so far, you might be wondering, okay cool, that’s nice but how do i actually query the data from the db and get it in the format i want, ie: as a GeoJSON object. Worry no more, because the solution is right in the code below."}],"\n",["$","$L20",null,{"className":"shiki","style":{"backgroundColor":"#2e3440ff"},"children":["$","code",null,{"children":[["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"import"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"db"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"from"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"@adonisjs/lucid/services/db"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}],"\n",["$","span",null,{"className":"line"}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#81A1C1"},"children":"const"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"userProfiles"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"="}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#81A1C1"},"children":"await"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"UserProfile"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"query"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"()"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"select"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"*"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":")"}]]}],"\n",["$","span",null,{"className":"line","children":[["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":" "}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"select"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#D8DEE9"},"children":"db"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"."}],["$","span",null,{"style":{"color":"#88C0D0"},"children":"raw"}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"("}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#A3BE8C"},"children":"ST_AsGeoJSON(location) as location_as_geojson"}],["$","span",null,{"style":{"color":"#ECEFF4"},"children":"\""}],["$","span",null,{"style":{"color":"#D8DEE9FF"},"children":"))"}],["$","span",null,{"style":{"color":"#81A1C1"},"children":";"}]]}]]}]}],"\n",["$","p",null,{"children":["Now, looking at the code above, it looks like a normal adonisJS model query to find all records in that model’s table. But there’s something standing out here, which is ",["$","code",null,{"children":"ST_AsGeoJSON"}]," . ",["$","code",null,{"children":"ST_AsGeoJSON"}]," is a ",["$","code",null,{"children":"Postgis"}]," function that we are invoking, and then passing to it the value of the ",["$","code",null,{"children":"location"}]," field, which would in turn convert the value of the location field to a ",["$","$L16",null,{"gaLocation":"posts_setup-postgis-with-adonisjs-v6","href":"https://geojson.org/","children":"GEOJSON"}]," format. By default, when we query the location field, the DB would return a string representation of the geospatial information stored in that column."]}]]}],"rating":{"value":5,"count":2}}]}],["$","$L21",null,{"photo":"https://cdn.akadenia.com/images/akadenia-webp/team/guy-shahine.webp","parentSection":"landing_page","alt":"Guy Shahine","title":"Schedule Your Tech Assessment","subtitle":"Accelerate Your Development","text":"Connect with Guy Shahine to learn more about Akadenia services.","contactLink":"https://calendly.com/guy-shahine/30-min","contactLabel":"Book your free strategy session","mobileContactLabel":"Book a call","linkedinUrl":"https://www.linkedin.com/in/guyshahine/","position":"CEO - Akadenia"}]]}]