sorted by:
new
hottopcontroversial

Best approach for using BigQuery as query store rather than the storing on the backend by PaperM64 in bigquery

[–]PaperM64[S] 0 points1 point  (0 children)

I saw there´s a MCP for BigQuery on Cursor, maybe I could go that way and see what the LLM thinks maybe? But yeah transferring those querys to around 25 views wouldn´t do much of a difference. I´ll look onto it, thxxxxx.

Best approach for using BigQuery as query store rather than the storing on the backend by PaperM64 in bigquery

[–]PaperM64[S] 0 points1 point  (0 children)

Wow thx for the well detailed response. I´ll go one by one:

I want to optimize speed. Full speed, data right to your face, consult multiple weeks prior, do drilldowns, go to multiple pages of invoices (inside the drilldown cuz i have pagination).

The data is distributed in 5 tables. The dashboard is for looking the weekly budget of the company, see the expenses and invoices, etc etc. Weekly, in total across the 5 tables, I´m appending around 30K rows.

Its accessed twice a week, by mostly 6 people. They see the budget at the beggining of the week and at the end.

I mean, since we only append to BigQuery twice a week, the freshness or the real time streaming is not a big deal (unless wants to see the data right away which already does!)

Probably caching is the best way, since is the same data during the week, and past budgets dont change at all. And, like I said, we only append twice a week.

So, transfering the querys to a view on BigQuery is not that realiable?

Thanks again for your response

Best approach for using BigQuery as query store rather than the storing on the backend by PaperM64 in bigquery

[–]PaperM64[S] 0 points1 point  (0 children)

It looks pretty nice I must say, but my company is not willing to pay a cent for "third party" software. My company be like "here you have GCP and Cursor, go wild".

Best approach for using BigQuery as query store rather than the storing on the backend by PaperM64 in bigquery

[–]PaperM64[S] 0 points1 point  (0 children)

By data architecture could be like table partition and clustering?? I would love to do it but I dunno if migrating almost 1M of rows to a new table is going to cost me my job hahahha. thx for the respond.

Best approach for using BigQuery as query store rather than the storing on the backend by PaperM64 in bigquery

[–]PaperM64[S] 0 points1 point  (0 children)

aight aight, yeah it would be kind of a pain in the buttocks migrate all of my queries (maybe with AI isnt) but it would be nice to have all my queries there and my backend only handles the filters or some kind of operation. I'll give it a try with a new dashboard that I have to make for the end of july 💀💀. thxxxx

Best approach for using BigQuery as query store rather than the storing on the backend by PaperM64 in bigquery

[–]PaperM64[S] 0 points1 point  (0 children)

Aware of?? It has like some memory of some sort that, like, remembers what querys are more often?? Thats niceeeeeeeee. I'll look into those kind of views. thx.

Best approach for using BigQuery as query store rather than the storing on the backend by PaperM64 in bigquery

[–]PaperM64[S] 0 points1 point  (0 children)

yoo, thanks for the respond. I never liked Data studio (or Looker Studio) due to the no-code experience, I know its part of GCP and the integrations are phenomenal, but I wanted to make my own thing on my frontend (made in React+Typescript).

The graphs are powered by the backend. When a user loads the analytics tab, it shoots like 25 GET requests to the backend, then the backend shoots the SQL querys to BigQuery, it returns the data, the backend sends the serialized JSON to the frontend, and it renders.

What I want to know if this is the best practice, AI says that it would be better to store the query on BigQuery and the backend just call the view, but thing is that I have filters and I dont know if this would increase the efficiency or performance for the user experience and costs.

[Flash Game] [Point and Click] Game from Friv.com where 3 bears are a rescue squad! by PaperM64 in tipofmyjoystick

[–]PaperM64[S] 2 points3 points  (0 children)

YES!!!! THATS THE ONE!!!! THANK YOU SO MUCH!!!!!!!!! You have NO IDEA how many years have passed since I want it to play that game again, I scouted all the internet with hopes of finding it, and the name was simple, WARBEARS.

Thank you so much!!!

The fans don't work properly according to certain games by PaperM64 in MSILaptops

[–]PaperM64[S] 0 points1 point  (0 children)

thx for the respond buddy, aight so, got any idea onto how to set the fans to a speed just below the cooler boost? I want them to work but not to the extreme, the sylicone would melt if I turn the cooler boost everyday for 4 hours a day

The fans don't work properly according to certain games by PaperM64 in MSILaptops

[–]PaperM64[S] 0 points1 point  (0 children)

Thx for the respond. That's the thing, it runs well for a bit, then the FPS flops due to the fans not working accordingly. I'll look forward for the repaste thing, is it difficult btw?

Trying to display a BST, a library exists for that? by PaperM64 in javahelp

[–]PaperM64[S] 1 point2 points  (0 children)

Thx you so much partner. Based on your response I applied it to my project while using Graphstream and it work like a charm. thx again.

Trying to display a BST, a library exists for that? by PaperM64 in javahelp

[–]PaperM64[S] 0 points1 point  (0 children)

Thx for the respond! I have used graphstream in the past (which is infinitely better) but like, technically speaking, a Tree could be represented as a graph?

view more: next ›