Thursday, January 4, 2024

Notes on SQL

Quick note today-- I'm wrapping up on an SQL / ETL bootcamp and wanted to mention on my coding journey that I think others will understand.

A hurdle I've had to get over is that immediate panic when something goes wrong. I fall prey to wanting to be perfect all the time. I'm using a tutorial from Alex the Analyst in the example--he's amazing, but from a pedagogical point of view doesn't quite foster strong foundational learning--best to use the manual and learn something yourself though. Alex can't do that for you, and almost nobody can do that for you.


So without the right questions to ask, do you even know how to get out of this mess? You probably do. But I did not and didn't know the prompt to ask ChatGPT, nobody to ask, and needed to sift through the SQL manual again, exactly how people learning new technology have to figure things out. It was the USE [database] portion that was missing, and everything else turned out to be just fine without my panic.


This kind of dumb, level one thing happens to me regularly. Sometimes 2 months into a new language I'll forget the simplest step, and review all my Youtubers only to realize they don't have the answer covered.

So this post is about learning to use user manuals. Making sure that you go through at least some of it on your own, and make sure you foster some of that curiosity and self-exploration as if you are an explorer.

Also one last funny thing. Small assignment for class to create a database diagram example. Love this kind of design thing, hate that I don't know of a program that makes it easy to both visualize AND customize the work, so I just draw it with a free program and then customize it with Paint (lol, I know, it'll get better).


>'
Okay, see ya!




Monday, January 1, 2024

Happy New Year! Working with Godot, Considering the Value of Low-Definition Sprites

I have been thinking long and hard about what kind of style my terrible first game should be in, and I've decided to draw it in chibi pixels, just like my old sprites from RPG Maker.


Some friends have commented, "He's so cute!" Which I actually really appreciate so much that it's changed the direction from where I thought I might go with this platformer. There's something psychologically magical about poor graphics which forces the player to fill in any gaps and imagine what the objects and characters would look like if they were life-sized. I haven't decided whether or not I'd include full scale character portraits as they leave less to the imagination:

Also, drawing this gal took me like 4 hours. It's a lot to consider while DALL-E or Microsoft Design may churn something like this out in mere moments!

As for coding this time, I've realized that Godot includes quite a lot of built-in scripts for designing a game. I'm working with 2D graphics at the moment, and I find it neat that they've implemented jump physics and gravity into the script templates. You can see from the screencap below that Godot provides the developer with speed and jump velocity.




That's all for today. I'm meeting with my friends later today to discus different mechanics in games; we've been refining our ideas to think of what would be an interesting game to start out with and what would be required to implement that.




Friday, December 29, 2023

Humble RPG Maker 2000 Beginnings

When I was a kid (about 17 or 18 years old) I spent an entire school year and that summer "creating" a game for my friend Katie. This was about 2006. I used RPG Maker 2000 and paint to throw together scripts, animation, physics, and many hand-drawn assets to work up something of a starter RPG. I didn't realize at the time that I was working with event commands, variables, control flow, placeholder commands, and plugins to make this game work. I always wanted to major in computer science, but I never quite realized that life could be for me. I never knew that I was already getting the fundamentals of control flow down. For instance, in RPG Maker, the developer might check if a player has a certain item before allowing a door to open, or in as written in a pseudo-code example:

FUNCTION keyCheck():
    IF Golden_Key EQUALS 1 THEN
        RETURN True
    ELSE
        RETURN False

I also wouldn't realize it at the time, but this gave me a sense of purpose. I would transcend time in such a way that a week would go by and I'd barely notice it. I'd be thinking instead that I hadn't made enough progress on the game and that this was ultimately a waste of time that could never amount to anything. The writing was surely so cheesy and probably cringe to look at the logistics again, but I don't have to worry about that because I'll never know . . .

Some years later, I saved everything to a flash drive USB and mailed it to Katie who was living in New York City at the time. Just by fate, my computer crashed and burned before I had the chance to back up anything and I hadn't quite become aware of servers or cloud storage (which was well on its way to taking over everything). Because of the way mail worked / didn't work at her old Bushwick neighborhood, she never received the flash drive, and it was lost for good.

Or so I thought.

Flash forward to 2023, where I've been playing videogames online with Katie and two other friends about every Sunday since covid began. We've all been teaching ourselves the Godot engine, which has me feeling very nostalgic for these days I've described. I am both wishful thinking that I could go back to 2006 and encourage my younger self to go after what matters, and also happy that I've had enough life experience to make something that would make a bigger impact. 

I've also been taking coding bootcamps, some better than others. I learn more and more about databases, backing things up, and obviously trying out some AI models, and it's helped me realize the power of having secure data and what that can actually mean for soemone. 

I'm a minimalist who still has enough childike wonder to believe in "energy," so I take a lot of joy in throwing stuff out and burning old stuff, including uploading things to servers and throwing the physical objects away. I burned up flash drive after flash drive, finally coming across an old terrabyte I'd saved years ago that I'd held onto despite thinking it was broken.

It just needed a new cord. 👺

I believe that "fate" and maybe that same energy brought me to do this, maybe you're a mature person believe in "real" things and just find this to be a dumb coincidence. Either way, it turns out the old dusty terrabyte drive contained my old sprites, pieces of the original game, and so many of the other resources and code I'd thrown together.

It's like I have another chance, and got all my time back.

Some highlights / lowlights I'll post below. Maybe I'll make this a regular thing to stay humble, maybe it's meant to be a one-off. I'm excited for this new journey, and want to use my eventual success story as a template to show how someone can leap from point A to point B with a little time and dedication. Something like, "It's never too late, even in 2024 when people are automating processes and not replacing those lost jobs with anything where someone can make a living and people are nearly destitute according to Linkedin not being employed for over a year damndowecareatallaboutotherpeopledoesanyofthismattershouldtherobotsjustwinalready.."

Some old facesets below. I believe the first may have been an edit of an original Squaresoft character if someone feels impelled to help identify(?) who it is. I loved the art style, and I vaguely remember thinking the original character looked like a lady, so I used it as a template to edit and create the others:


My best friend had this wonderful exotic shorthair cat named By'Tor. You know I had to include him:


 
(used Asesprite to show you how he looked walking around in RPG Maker)



Apparently the blank pink tiles in front of the gray arrow tiles (near the equipment room) triggers a scene that takes the player into a battle scene, something of the colosseum archetype.

 


The writing, as expected: horrible. 

If you can see the dialogue message (console.log("I had a little help training)), I am refering to the training in the colesseum that literally happens DIRECTLY before this scene. The reader does not need a reminder, and why would a knight character admit vulnerability so soon? Ugh, terrible, terrible writing. 

But some interesting switches, events, and placeholder commands to pull up the stored name of each character with the ¥ n[1] (representing the character in placeholder 1). I don't know why the Japanese Yen sign was used, but I bet it stands out as obvious non-text in the same way we use something like %n or $var as placeholders today. I'm not going to pretend to understand Japanese code at just getting my grip on English coding.

Anyway, sometime this weekend I plan to post an update on my progress with Godot, noting the way things have changed over the course of 17 years, and in what ways things have remained the same, along with setting some future goals for 2024.

Merry Xmeth, hope you had a Hannukah, keep enjoying your Kwanzaa, "let me know in the comments" if any other cool thing happens this time of year, and feliz año nuevo en 2024!






Saturday, November 18, 2023

From Word Blogging to STEM Blogging!

 I haven't been here in a long time!


After totally uphauling my life (when my aunt gossips about me, she calls it "going through life changes" LOL),  I've decided to start coding. 

Now, about six months after the decision to leave my Project Management position with a local security company, I've decided to record some of the interesting bits of coding. I believe I only just now have the confidence to start talking about it. It's a slow, grueling journey, but other coders are as supportive as their jobs alot them time to be. 

The older I get the more precious (and easily forgotten) all the details become. So why not b l o g?

I'll still be writing about alligators and crocs (duh, I just went to the Everglades y'all) but I'll also be dropping in to actively blog about my coding journey. I've been doing this programming stuff in a box for about six months and didn't realize I'd get serious enough to need to blog about this, but that's how life goes, isn't it?

More soon. "Stay alive, till then."

>'

Friday, August 22, 2014

Disney Gator, When I'm Human


Got nobody checking up on me now.

I had a a one-day $10,000+ party.

They call it a wedding. Worth it, maybe?

Here's to you, Louis.




>' omnomnom

Tuesday, April 8, 2014

Renewable Energies

Ah, the final entry for nature writing. It's been truly eye-opening.

It seems as though we've finally found a couple of sources of renewable energy that respect nature. The windspire at the Pittsburgh Zoo collects energy to power the front gate. Made in the United States from recyclable materials, the windspire is eco-friendly, rotating at a lower safer speed. On top of that, the zoo, like many other places, uses luminescent solar poles to light the pathways. The poles capture sunlight during the day and use that harvested energy to show light throw the LED bulbs when it gets dark. Of course, I can't help but be a little cynical about all of it. Who would I be if I weren't cyncial, right? While the street light luminescent poles seem to be a perfect alternative, how much energy does a slow turning windspire produce if it's only powering the marquee for the Pittsburgh Zoo? Can we afford to have that many spires, and what would the world be like if it were a land of windspires? 100 years from now, will human beings regret the invention of the windspire and the windmills that generate electricity because we've run out of wind? Probably not, because we understand science now. Look, I'm being sarcastic again.

People fight age; people fight wisdom. A teenager feels much smarter than a child, a young adult wiser than a teen. In middle age a lot of people reflect upon their foolish decisions for all those years because now it seems they've reached stability. But if the middle aged person or older person understands everything, they're only pretending.

Do we pretend that we understand nature as our species gets older?

Or are we finally understanding sustainability now?

Otis the alligator and the baby alligator haven't come back in time for the class to end. I could despair over this fact or I could think of it in terms of writing. Sometimes when a writer begins a piece, it's not headed in a certain direction. Just like letting the narrative take the route it has found by surprise, I've let this blog do the same. And believe me, this is not the end for writing about nature. Along with my classmates, I've been going well over the minimum word count from week to week. It's evident this assignment excites many of us. So for now, I'll end this short. Brevity, short and sweet at 514 words.

I understand now that I have to start nature essays with a topic of interest rather than start with the memoir mentality. This is my defined process, which I've learned not everyone has. I admire those who can write otherwise, and I think that I've met some of the most amazing and beautiful writers (or gotten to know them better). They teach me so much, whether in class, over Pamela's pancakes, over Ritter's pancakes, or at a future visit to the zoo together- they just really get me, and I'm fortunate to have met these people. By researching, interviewing, and writing about things that interest me, the metaphors and similes come naturally rather than forced. Researching is my source of renewable energy.



(I dig when Ryan posts a song, so here's what's going through my head right now. Dawes wrote this song thinking of the lack of life experience and having not really that much to sing about- being so young and lacking life experience. Looking to the future works well, I'd say.)










 




Sunday, March 30, 2014

"Summer" Xia, Red Panda

(Probably making a sound effect somewhere along the lines of "nyum nyum nyum.")

Remember this stuff from a couple entries ago?
I listed nearly a hundred grasses I knew were NOT this plant.
Since people are walking around, since Pittsburgh is waking up to spring and at the zoo some more people are interested again, or at least about the twenty folks I've seen today are, I ended up asking someone, an old man dressed in a black sweatsuit, what the "funeral flower" was. I hold one stereotype very strong- that old people are so much smarter about the natural world. Maybe because my other stereotype is people my age grew up with too much televisions and video-games or whatever, but that's an aside. How silly now, of me to think it was a funeral flower or some kind of grass. I never realized this: bamboo grows in two forms.

There are of course the woody bamboos I know about. This is the kind I imagine the pandas and red pandas and those weird lemurs are munching on. Animals like rats will eat the fruits that come out of bamboos and mountain gorillas, chimps and elephants will eat it as well, and receive an effect from the fermented sap as a sort of animal alcohol. Drink up, fellers. Also bug larvae will eat this and the caterpillars which eat the sap are considered a local delicacy in Thailand and some parts of China. This further supports my argument that bugs are delicious and should be eaten with a smile.

Anyway, the smaller, softer "harbaceous bamboos" are known as "olyreae." This is what the plant is and it is strange that the more popular wood-like bamboo has been the only bamboo in my mind. At least the red panda knows better.

The first time I ever saw a red panda I thought for sure it must be a red-headed relative to the raccoon. They wear a white bandit mask of fur and use their long bushy striped tails to balance. They've got claws and look a little bit like cats in the face, with their whiskers and sharp teeth. And if they got the chance, they'd probably eat garbage, too. 

However, these animals are not raccoons. They have been classified as ailuridae, a complicated and debated species classification only given to these special animals, all of the like-species ailuridae extinct. For a small summation of the information I've found about the species, check out this wiki.



As you can see, Xia, delivered to Pittsburgh, PA from a zoo in North Dakota, paces without stopping, at least for the twenty minutes we watched her. Even watching her movement made us a little dizzy. I immediately thought of earlier in this blog project, when I caught a polar bear pacing back and forth, shaking her head to and fro and wiggling to a silent samba. I thought of the tigers pacing back and forth, a roller coaster of grunts and groans over the same mounds of land they'd seen for all of their captive life. For as long as I can remember, I've seen animals pacing at zoos. I've assumed it meant the same thing it does in human beings: boredom, anxiety, unhappiness.  So I took a step further and searched online to figure out the pacing.

Blogs on pacing:

"Abnormal behaviour such as a stereotypic movement is very much a concern when it occurs in relation to animals held in captivity. From a behavioural standpoint, the behavioural and spatial requirements of nondomestic animals in captivity greatly depends on the species."

"Despite this, red pandas do adapt well in captivity, and they are found in zoos worldwide. Many Carnivores (order Carnivora, not ‘things that eat meat’) traditionally do very poorly in zoos; just think of a polar bear pacing back and forth repetitively in its enclosure. Red pandas, however seem to do just fine, which is a good thing for them because captive breeding programs can go a long way to restoring and maintaining the native population."
(Refer to my video in rebuttal to the second excerpt)

And I also found this, from the website of the Born Free Foundation, a wildlife charity dedicated to protecting animals:

"If the captive environment does not cater for the species-specific needs of the animal, there can be a deterioration in both physical and mental health such as the development of abnormal behaviour, disease and even early mortality...
Pacing and Circling:

Continuous walking back and forth or in a circle, following the same path. Signs of regular pacing include definite paths worn in the ground. Seen in many captive animals, especially big cats and canids (eg wolves)."


It's not the scientific proof I was hoping to find, but it reinforces that pacing is pacing, regardless of which mammal we are. I knew the pacing of human beings and I knew that this was a bad thing, just by the human experience and relating that to the animal experience. I knew this from realizing we are the same. Pacing is sometimes like searching for understanding- it can be really frustrating and lead to nowhere. And yet, we keep moving forward, trying the same path to notice something that might not have been so lucid the first couple of rounds. Sometimes it helps. Sometimes I find my wallet after looking in the same spots for hours. Sometimes it doesn't help. But let's try to figure out how Xia came to be "Xia."

Xia is the red panda's name given by the zoo in North Dakota. She is almost three years old now. Sun, my friend from Handan, China, has taught me a lot about understanding the way Chinese names and symbols are formed.
夏[Xià] is a mixture of radicals. The two radicals are:

𦣻 [
Shǒu] from the archaic symbol    for "head." To me, it looks like the head of a dog.

and
夂 [
Zhǐ] for the archaic symbol   for "a man who makes an effort." They look like axes or clubs, some sort of tool.

Chinese mythology tells the story that there were ten suns in the sky, rambunctious brothers who made the world too hot with all their antics. Nothing could grow with all that hot air. So Hou Yi, a Robin Hood-like hero, shot down nine of the ten brothers, therein allowing the Earth to grow plants and survive with the heat of the surviving brother. To add to the mysteries of the sun, an eclipse was explained with stories of a magical dog of heaven biting a piece of the sun. So of course, as I continue to learn we've always been this way, human beings would yell and holler, making lots of noise to scare the magical dog away and end the eclipse.

We always think we're the heroes. That we're solving problems. That we can solve the problems. That the red panda's population is down to 250,000 in the wild so we should keep them and make them safe, safe from the destruction most likely we have caused. We label things. We make it so. And maybe it does make a difference. I'm not an expert and have no plans to be. 

Working together with the meanings of a "head" to ward away and the "hard work of man," the Chinese, through years of history, came to the meaning for Xia, or 夏, as the character for "summer." The red panda's name in English is "Summer," or Chinese for summer/great/grand/or big. 

The weather feels like it's restless, much in the way that Xia is. Pacing. The weather goes back and forth, cold and hot, undecided on whether the plants will live. One day the weather is 30°, the next it's 70°. Hou Yi has done his work to make sure it doesn't get too hot down here, but the weather is still restless, so do something humans. The weather is restless, like the insomniac battle I work through during the week, sleeping for only a handful of hours during the week. Almost every Friday is spent in sleep debt remittance, usually snoozing from 4pm to 9am the next morning. It'd be nice to find a balance, to figure out how spring will wake up from the sheets of snow and bring life into the bamboo for Summer to eat. I want this eclipse of bad weather to be over with, to be another thing of memory, to not seem so bad after all, in retrospect.

So what, in the end, should we do to fix everything?

Maybe make some noise for summer, everyone.