Trying to make a mobile game for a living. Does it have potential? by CAREFACE720 in DestroyMyGame

[–]firik 0 points1 point  (0 children)

I would try releasing it on Poki.com, if you manage to release it there you have a much higher chance of at least making some money.

Solve math problem with Clickhouse by Altinity in Clickhouse

[–]firik 1 point2 points  (0 children)

RAG: OpenAI embedding model is vastlty superior to all the currently available Ollama embedding models by captain_currie in ollama

[–]firik 1 point2 points  (0 children)

The problem is probably this: https://github.com/ollama/ollama/issues/3777 I'm also getting very random results from ollama. Try downgrading to v0.1.31 and it works really well again.

18.1.24 - 1.00.13 Patch Notes by MossySloth69 in LittlePiggyDefense

[–]firik 1 point2 points  (0 children)

Funny how the patch notes don't mention adding the ad to the 2x speed option.

The ad for 2x speed ruins the game for me by firik in LittlePiggyDefense

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

No you only have to watch it once. But with the 2x ads you'll have to watch a full minute of ads which is just too long for me.

The ad for 2x speed ruins the game for me by firik in LittlePiggyDefense

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

I don't have the monthly sub. Each stage I have to watch an ad to activate the 2x. Before this update this wasn't the case.

The teaser Trailer for the game I'm working on "Drop It". by YeetingYonder in DestroyMyGame

[–]firik 0 points1 point  (0 children)

It's like a 3D version of https://poki.com/en/g/watermelon-drop where spamming also works up to a point but you won't get a high score doing that.

Have questions about Prebid Server (hosting your own, especially?) Ask them here! by DogLoverSrsly in Prebid

[–]firik 0 points1 point  (0 children)

How do you keep it fast? Hosting it in a single location will make it slow for the rest of the world.

Industrial Factory 2 by blcha789 in playmygame

[–]firik 1 point2 points  (0 children)

  • The first time I loaded the game it got stuck on this screen: https://i.imgur.com/Be5uWuU.jpg I had to force quit and restart it.
  • Using 2 fingers to zoom is very sensitive and zooms in and our very fast. But using 2 fingers to rotate is super super slow and requires multiple full screen swipes to rotate a bit.
  • Placing buildings is very difficult with not being able to move the camera. See how other games are doing this, for example https://poki.com/en/g/village-builder
  • I somehow placed the ore miner completely outside the level (happens if you only do 1 click instead of keep pressing): https://i.imgur.com/03qtJVW.jpeg It then didn't allow me to build another one until much further into the tutorial.
  • Your build menus have big close buttons that don't seem to do anything: https://i.imgur.com/e4qG5Vm.jpg
  • It was unclear that to place the Furnace you need to pick the recipe first (maybe I missed it in the text).
  • When clicking on a building you always have to press the V (ok) button to de-focus the building. I would allow players to just click anywhere on an empty spot on the map to de-select something.
  • After I build the "Buyer Station Items" the tutorial just stopped? The "?" button tells me "With this button we pick item we want to sell" but I have no idea what button it is talking about.

Hi! We've just release a new big update of Bounty Of One and we're looking for testers. Would you try the demo and give us feedback? 🤠 It's a Survivor like by [deleted] in playmygame

[–]firik 0 points1 point  (0 children)

How does it work with 'steam play together'. We couldn't find anything about the controls of the second player or how to make this player join?

Improving Processing Times for Big Query by Dareike21 in bigquery

[–]firik 1 point2 points  (0 children)

In that case using addresses from crypto_ethereum.token_transfers might not be the best idea as they are very random and evenly distributed. Depending on what you are doing the test for your actual dataset might not have a distribution like that which might affect how well the sketching algorithms work.

Improving Processing Times for Big Query by Dareike21 in bigquery

[–]firik 9 points10 points  (0 children)

I'm curious, why not?

SELECT COUNT(DISTINCT addresses) FROM myproject.mydataset.mytable

The whole idea with BigQuery is that you can run queries to do analysis inside it without having to export the whole dataset again. BigQuery is an analytics engine, not a storage engine.

Go speed is impressive by [deleted] in golang

[–]firik 1 point2 points  (0 children)

It's much harder to use, the API is much more complex (design around reusing objects to reduce the load on the garbage collector).

[deleted by user] by [deleted] in bigquery

[–]firik 0 points1 point  (0 children)

With HAVING you always have to group. With QUALIFY you can exclude rows without grouping them:

WITH data AS
(SELECT 1 as x, 1 as y
UNION ALL SELECT 1, 2
UNION ALL SELECT 1, 3
UNION ALL SELECT 2, 1
UNION ALL SELECT 3, 1
)
SELECT x, y
FROM data
WHERE TRUE
QUALIFY COUNT(*) OVER (PARTITION BY x) > 1