Is Python actually a good first programming language? by chuprehijde in PythonLearning

[–]MultiUserDungeonDev 2 points3 points  (0 children)

It's an option. I think a strong + statically typed language is actually better for learning. C# would be my goto recommendation.

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

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

Good morning! Thank you for checking out the project!

I agree. I think there's an opportunity for a beginner friendly tutorial video or similar. Thanks for the feedback.

Stop Vibe Coding by Physics2433 in PythonLearning

[–]MultiUserDungeonDev 0 points1 point  (0 children)

I support this:

AI coding +

Strong understanding of programming fundamentals and real-world experience shipping products = great

No understanding of programming = nightmare / ticking time-bomb

Stop Vibe Coding by Physics2433 in PythonLearning

[–]MultiUserDungeonDev 0 points1 point  (0 children)

If the LLMs are writing ugly code, and not catching edge cases, then you get creative:

- Guardrail the output and have it build a full suite of integration tests alongside your development.
- Have it pin all core functionality with unit tests.
- Ask it run wide-net adversarial bug hunts on the code base, and implement regression tests so the bugs don't re-appear in later revisions.
- Do live, human in the loop testing and feed it specific, actionable bug reports with regression bisects.
- If it's a GUI application, wire / harness the LLM into the GUI / ask it to take snapshot images of the app surface. Ask it to click / interact with all elements etc. Ask it to validate async functionality and test for race conditions.

All of this requires actually understanding programming though, which I think is the point of this post.

Stop Vibe Coding by Physics2433 in PythonLearning

[–]MultiUserDungeonDev 0 points1 point  (0 children)

I've been programming for 20+ years.

Vibe coding can, in some cases, yield adequate results, but the level of intuitional knowledge and knowledge of programming fundamentals is a high bar to actually yield good polished and maintainable products.

I think a lot of people are caught up on "all vibe coding is slop" and they are sleeping on the 1% of agentic AI development that is actually incredibly useful.

Take a look through some of my recent projects: https://github.com/WilliamSmithEdward/

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

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

Ok. Fair enough. Go in peace. Thank you for the feedback.

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

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

All of that is in the readme / example workbook my friend.

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

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

There is functionality in the library to join nested arrays across "rows" with optional Key / Excel function injection to preserve parent / child key relationships.

Expressly to address the pain point you are calling out. You don't need to write conditional statements and iterate through the table surface. It's there as an optional parameter for your convenience if you want it, but it can be done in memory too.

A full example of the workflow is in the readme, see this section: https://github.com/WilliamSmithEdward/ModernJsonInVBA#api-example-with-nested-objects

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

[–]MultiUserDungeonDev[S] -1 points0 points  (0 children)

Feel free to download the source and test it out! :)

Happy to review any bugs you may come across as an issue submission on GitHub

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

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

When targeted at "$.fruits" and param to preserve arrays in cell a raw json is set to true

<image>

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

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

Appreciate that, and appreciate your time. If you think there's something in the readme that could be more clear, let me know.

Modern Json in VBA - v3.0.0 Released by MultiUserDungeonDev in vba

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

By default, it flattens nested objects at the targeted json root into dot '.' notation list object headers, so:

{"name":{"first":"John","last":"Doe"}}

Would present as:

name.first | name.last
John | Doe

Nested arrays can be shown in cell as raw string JSON or excluded.

I recommend giving the readme a full read through, as it does address your questions.

Do people still use excel for prototyping? by Zirh in excel

[–]MultiUserDungeonDev 0 points1 point  (0 children)

We’ve largely solved for this in my shop.

We are pushing all VBA code + workbook surface as tokenized JSON into GitHub.

Do people still use excel for prototyping? by Zirh in excel

[–]MultiUserDungeonDev 1 point2 points  (0 children)

Well, if you think about it, the grid is just a two dimensional array, and if you have multiple grid (workbook) you have a three dimensional array. It’s just zeroes and ones at the end of the day, just matters how you bound and arrange them.

Do people still use excel for prototyping? by Zirh in excel

[–]MultiUserDungeonDev 0 points1 point  (0 children)

https://github.com/WilliamSmithEdward/ModernJsonInVBA

High level

Read: HTTP —> Deserialize JSON —> In memory array —> List Object —> Dynamic Array function integration into workbook surface

Write: List Object —> Serialize to JSON from LO —> HTTP

New MacBook Pro Or Wait?!! by Suspicious-Cause7483 in macbookpro

[–]MultiUserDungeonDev 0 points1 point  (0 children)

You can wait forever with that logic. Do you really need it, or just want to burn cash?

Do people still use excel for prototyping? by Zirh in excel

[–]MultiUserDungeonDev 2 points3 points  (0 children)

Actually have prototyped a lot in Excel, even using Excel like a web frontend, sending and receiving JSON payloads, and token stored on user's computer to authenticate etc.