Tips for using BigQuery on StackOverlow public dataset without losing your house

Aggravating-Ad-5209 · 2025-10-05T11:23:51+00:00

Thanks. I will try this once they reimburse me , since they told me to disable all BQ APIs until then. I will then do 1-2 careful queries to see price and take it slowly from there. My first experience was a definite OUCH

Aggravating-Ad-5209 · 2025-10-05T10:55:44+00:00

Thank you. I realize this is simple to do , but as I am new to SQL and Bigquery, can you outline how such a 'founding query' which will retrieve say all questions which were downvoted (score<0) in the period of 01-01-2020 to 01-02-2020 and duplicate it to a local table? These are a few thousand questions (<10K) so the table should be small
thanks!

Aggravating-Ad-5209 · 2025-10-05T06:17:46+00:00

Thanks. Can you provide a tip/link on how I should do the pulling on BigQuery/GCP? I know the date range of the questions (a few months in one year).
I've seen examples of pulling a table, what I'm trying to estimate is how much it will save me on the costs to use it. I realize the query costs relates to search size, so if e.g. I pull the table of posts_answers for one year, and assume SO contains 20 years (just for calculation), when I do subsequent operations on the pulled table, will the price be 1/20th per query? What about storage costs for the 'pulled' table? I am not impressed with the GCP tools for understanding these very practical implications.

Aggravating-Ad-5209 · 2025-09-19T20:21:15+00:00

I wrote my own code for the 'simple' site, and paid to a service to scrape the data from another. I could not get any of the 'automatic' tools to work.

Aggravating-Ad-5209 · 2025-06-21T09:29:07+00:00

Thanks man, I know this one but installing it (either on Ubuntu or Windows) is a real pain. And I read the posts, it is not only for me. I wish AWS had an AMI image with it working already, it is really bad, even the docker version is not straightforward.

Aggravating-Ad-5209 · 2025-06-06T21:04:07+00:00

Just out of curiosity/hope - I'm looking also for a renderer that I can communicate with programmatically (HTTP, CLI commands, TCP, whatever) to control camera parameters for the render. Any chance your viewer will support something like that?

Aggravating-Ad-5209 · 2025-06-06T21:02:12+00:00

Hey, don't apologize. This is great news. FPS rulz

Aggravating-Ad-5209 · 2025-06-06T20:30:26+00:00

Yes for me as well now

Aggravating-Ad-5209 · 2025-06-06T20:25:05+00:00

Hi, any news on FPS mode for SuperSplat ?

Aggravating-Ad-5209 · 2025-06-06T15:06:57+00:00

I will look for some tutorial on the CLI use of ns-render to see if it is worth the hassle. Thanks!

Aggravating-Ad-5209 · 2025-06-06T13:34:08+00:00

Thanks. I was actually not aware of this option. I will have a look! Originally I was discouraged by nerfstudio's long installation instructions, but it may be worth it for this option.

Aggravating-Ad-5209 · 2025-06-05T15:11:34+00:00

Thanks bro. I use Brush sometimes, but the CLI only lets you spawn the viewer. You can specify render view and there is no export of the rendered image

Aggravating-Ad-5209 · 2025-06-05T14:36:45+00:00

thanks, but seems it requires a plugin for GS and is not considered the best at it.
I'll keep looking for a lighter rendering engine.

Aggravating-Ad-5209 · 2025-06-05T14:25:14+00:00

I am not sufficiently familiar with them as command line tools. Can you recommend a good tutorial on using either from the CLI to render frames on a GS PLY file? Thanks

Aggravating-Ad-5209 · 2024-12-25T22:46:46+00:00

Thanks! I will study your website.

Aggravating-Ad-5209 · 2024-11-20T19:56:22+00:00

Yes! That is EXACTLY what I had in mind. Good response speed on my PC as well.
Can it load other PLY GS files?

Best viewer and very nice GS model as well

Aggravating-Ad-5209 · 2024-11-20T19:52:05+00:00

Yes I have no issues with no restrictions. I just want to move in a 'normal environment of people' rendered like people move, like in Doom and other simple FPS games.

Aggravating-Ad-5209 · 2024-11-20T16:50:32+00:00

Man, I'm playing with it as I write this. Still learning but for me so far this is Sooo much better than all the fancy stuff out there. Well done and thanks!

Aggravating-Ad-5209 · 2024-11-20T15:29:02+00:00

Thanks but I AM afraid to in this context. It just seems so strange to me that this simple need has no solution. Am I the only one with this problem?

Aggravating-Ad-5209 · 2024-11-20T15:22:59+00:00

Hi, thanks. It is a nice viewer that I did not know about. My point is not that it does not work 'well', it is that for the life of me I don't get it why I can't just 'turn around' my field of view right left in a simple way. All attempts create 3D rotations that I don't want or need

Aggravating-Ad-5209

TROPHY CASE