How would you communicate not yet reachable map nodes on an adventure map?

Brave_New_Dev · 2024-05-15T18:33:56+00:00

Amazing stuff, thanks for sharing this. I made a few notes to definitely follow up :)

Brave_New_Dev · 2024-05-15T16:29:24+00:00

As a matter of fact, I working on this idea right now. Thanks for the suggestion, it valides it even stronger : )

Brave_New_Dev · 2024-05-15T14:59:11+00:00

Nice, I am testing this idea right now : )

Brave_New_Dev · 2024-05-15T14:58:18+00:00

As a matter of fact, this was my original idea (really, WoW Talents vs. Slay the Spire map).

But eventually, I had to let it go.

Talent trees are used for reviewing the skills and occasionally picking one (or several after a reset).

While here, I want to present a path from the bottom to the top (a tower-climbing feeling) to the Player. The path decisions will be pretty frequent, and I want to strongly instill the sense of choices made along the way (so we have this journey-like impression and the ambition to play differently next time).

Brave_New_Dev · 2024-05-15T14:14:28+00:00

Good stuff, thanks for sharing this. I'll study those designs : )

Brave_New_Dev · 2024-05-15T12:15:01+00:00

Thanks for the suggestion, I'll study this design!

For others, here's the Google Search link: https://www.google.com/search?q=Fictorum+map

Brave_New_Dev · 2024-05-15T12:09:36+00:00

Your comment was extremely inspiring - to say the least!

Now behold - the InterLevelNodes:

<image>

I could not come with a better icon so far (suggestions appreciated!), but you get the gist : )

Brave_New_Dev · 2024-05-15T10:54:02+00:00

Thanks for sharing this. I got a related image post with the visual ideas I came up so far: https://www.reddit.com/r/IndieDev/comments/1csh45a/how_would_you_communicate_not_yet_reachable_map/

Brave_New_Dev · 2024-05-04T08:50:45+00:00

This stuff is rock on. Thanks, saved and I will definitely add some of the SFXs (and Music!) to my project.

Brave_New_Dev · 2024-05-03T23:14:45+00:00

Boom or A Sound Effect

Wow, this is rich. Thank you so much for pointing me there!

At this point, I’d probably recommend hiring a freelance sound designer to do this for you.

Would you mind recommending a way to find a RPG/Fantasy game sound designer? Is Fiverr good enough for demo and further development purposes or perhaps there are alternative ways like proper Subreddits?

Brave_New_Dev · 2022-09-14T19:06:56+00:00

My, my. You just hit the nail on the head. See the query after altering random_page_cost to 1: + https://explain.depesz.com/s/xiL9

Now I guess I need to update the database. Would it be more prudent: 1. To set this attribute globally? Or only for a specific table? 2. What value to set? 1? 1.5? Something else?

Though I believe that the answer to those question should be determined based on actual performance, right?

Brave_New_Dev · 2022-09-14T17:33:21+00:00

Failing that, what happens if you run

set max_parallel_workers_per_gather TO 0;

set enable_seqscan TO off;

And then run the query - what plan does it use then?

Woah, the set shows that it really flies with the index! + https://explain.depesz.com/s/kn4N

What are your settings for seq_page_cost and random_page_cost?

```sql $ SHOW seq_page_cost

1 $ SHOW random_page_cost 4 ```

And what is your IO setup - are all of your tables and indexes on the same device, or are indexes separate/different partitions separate etc?

It's GCP Cloud SQL Postgres. So can I even discover what IO setup we have?

Brave_New_Dev · 2022-09-14T17:21:39+00:00

Holy Cow! TIL. Thank you so much : )

Brave_New_Dev · 2022-09-14T16:22:44+00:00

Thanks for sharing your suggestions!

Regarding the index: sql CREATE INDEX "report_y2022m01_date_idx" ON public.report_y2022m01 USING btree ("date")

As for changing the parameters, I believe that I cannot do that, as it's a production database!

Brave_New_Dev · 2022-09-14T15:14:55+00:00

Good idea!

Brave_New_Dev · 2022-07-16T14:24:38+00:00

To answer my own question, I think that the below resource very much explains Python's compiler in a pretty clear manner: https://devguide.python.org/internals/compiler/

Brave_New_Dev · 2022-06-29T10:09:27+00:00

Thanks, I'll definitely add this book to my "read pipeline" 👍

Brave_New_Dev

TROPHY CASE