Google Cloud SQL’s Linear Optimization Vector Search Magic

Google had a PostgreSQL database with the pgvector extension hosted on a PaaS during early development period, however it wasn’t indexed or used for production workloads

[{"selector":"#anim-35638590-22e0-468e-981c-2d626c30208b [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-66.94277061469137%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-4d0fd8fa-0cf1-47ea-a803-dd1488306145","keyframes":[{"offset":0,"transform":"translate3d(0, -138.72054%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -39.008215848%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -13.261683624%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -4.980067386%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.164040424%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":600,"fill":"both"}]

They decided on Google Cloud SQL for PostgreSQL once pgvector support was enabled, considering Linear’s current data volume

[{"selector":"#anim-8db9875f-7c48-41fe-8356-54853878fc0f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.295454761738494%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-74c74a99-c43f-4b68-8ca6-cdb0accc355d","keyframes":{"opacity":[1,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-e2ff220f-5124-4217-a5bf-4d7c222f9a1b","keyframes":{"transform":["scale(3)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

The learning curve for team was nonexistent since this decision was also in line with how to now use databases, models, ORMs, etc

[{"selector":"#anim-066982d8-69b9-4a47-b4c5-551a27fcf08b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Google Cloud SQL for PostgreSQL powers main working database.Similarity-search features’ vectors might be stored in a separate database as Google Cloud SQL for PostgreSQL comes with the pgvector extension

[{"selector":"#anim-a792f2bf-f4b3-457f-bf13-96eafaaf4cc1 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(34.249999904429615%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-634509ce-5b30-4eae-8d89-03e8d2408b66","keyframes":{"transform":["rotate(-540deg) scale(0.1)","none"],"opacity":[0,1]},"delay":0,"duration":1000,"fill":"both","iterations":1}]

They are confident in choice of Google Cloud SQL for PostgreSQL as major database option, and whole technological stack is built using NodeJS and Typescript

[{"selector":"#anim-1bfd9c14-2635-496e-bf46-75b85ac83fca [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-34.1867468919976%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-98dcc984-9813-48df-9113-472b2a99302b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-efb80cb9-3b54-457d-a3f2-b9a0575f8616","keyframes":{"transform":["translate3d(0px, -120.7393%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Google Cloud SQL for PostgreSQL has been quite helpful.they must depend on managed services since lack a dedicated operations staff

[{"selector":"#anim-553253d3-51eb-418c-aa92-850b3a1815a4 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-ee3bab80-553c-4d1e-974e-d0eaab4a5c68","keyframes":{"transform":["translate3d(-122.29965%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-9d194db3-c21a-429e-b599-88a957555ba9","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

They run synchronized WebSocket servers, public and private GraphQL APIs, and background job task runners on Google Cloud For More Details Visit Govindhtech.com

[{"selector":"#anim-c0d8cac0-a12d-40fe-b353-51aeadb65163 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(31.919642747431954%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2566bc61-17ce-4ba4-8135-f1d471ac008c","keyframes":[{"offset":0,"transform":"translate3d(0, -139.13914%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -39.125926168%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -13.301701784%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -4.995095126%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.170570584%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":600,"fill":"both"}]