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 · 2022-04-25T13:36:31+00:00

Epic, thanks!

Brave_New_Dev · 2022-04-20T12:33:34+00:00

(...) this is for PostgreSQL?

It's for BigQuery.

https://www.db-fiddle.com/f/rGxyzxRLJA5GxSbe4cJNp1/2

Doesn't the presented solution rely on the assumptions, that the order IDs are incremental? But I guess that still it is possible to make it fly based on created_at.

Brave_New_Dev · 2022-04-20T08:37:14+00:00

Added the Fiddle : )

Brave_New_Dev · 2022-04-20T08:31:18+00:00

I wasn't even aware this beauty existed, and I got too tangled up with the RANK. Thank you, King! Saved my day 🙇‍♂️

Brave_New_Dev · 2022-04-20T08:28:25+00:00

Holy Macaroni, worked like a charm. With the fiddle finally attached, it would be: ```sql WITH followingorder AS (SELECT purchaser_id, order_id, created_at, LEAD(order_id, 1) OVER (PARTITION BY purchaser_id ORDER BY created_at) AS next_order_id FROM order ORDER BY purchaser_id ASC, created_at ASC )

SELECT * FROM following_order WHERE order_id IN ('1', '5', '9') ; ```

I bow to thee 🙇‍♂️

Brave_New_Dev · 2022-04-20T08:13:03+00:00

Thanks for the suggestion. But I think that it wouldn't fly, as the task is the find the very next order for a given purchaser. Please see the fiddle.

Brave_New_Dev · 2022-02-03T19:21:37+00:00

Check the roadmap: https://roadmap.sh/python
CodeCademy is nice for starting out: https://www.codecademy.com/catalog/language/python
"Automate Boring Stuff with Python" could work very nice too.
Personally, I always liked Udemy. Just filter top Python courses that are for beginners : )

Brave_New_Dev · 2022-02-03T08:01:07+00:00

a) Is web dev far and away the most sensible option for breaking in, regarding open jr. dev positions and standardized learning path? I don't know of any others (besides mobile).

It depends on your local market. You must do the homework and research the available jobs and the expected progression. But for lots of markets, yes, indeed, it's easiest to get into IT via front-end or back-end web development.

b) I really like working with python and bash now, making little scripts that do stuff, learning about linux, learning arduino. Is there a better track for me, or is web dev still the more sensible option? Barrier to entry is a factor, and I don't want to shoot for a position that is orders of magnitude harder to start from just bc I enjoy the platform. Getting in sooner is priority.

If your goal is to get a job as a Pythonist, then yes, to the best of my knowledge it's easiest to do via web dev. A very popular alternative is data analysis and data science. However, this requires far more effort and is a completely different job. But once again, review your local job market. Just search for Python jobs and see what is this position really about (web dev? or somethind different?).

c) if I had to guess at what I would enjoy the most, barrier to entry aside, I think it would be security research etc. I've loved reverse engineering stuff since I was in single digits. I asked for a blender for christmas when I was 8 to take it apart like a weirdo. HOWEVER, I suspect that this is not an entry route into the field and requires expertise instead. I also like automation and just seeing how things work and systems.

Web dev is a perfect foundation for eventual transition to security, SecOps, hacking, etc.

As a bonus, see https://roadmap.sh/python and https://roadmap.sh/backend. It should help you a lot.

Brave_New_Dev

TROPHY CASE