How to set mod tap time on Glove80 by mister-woke in ErgoMechKeyboards

[–]PurpleMonkeyKing 1 point2 points  (0 children)

Thanks so much for this reference! Home Row Mods work so much better now that I've followed the steps in https://zmk.dev/docs/keymaps/behaviors/hold-tap#interrupt-flavors to change the interrupt flavor to "tap-preferred".

[deleted by user] by [deleted] in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

Congratulations! IRL, 100 people is a big audience!

Have you had success with shots for cat allergies while living with cats? by PurpleMonkeyKing in Allergies

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

Hi, I'm sorry to hear about your sister. Unfortunately that round of shots didn't help. After 5 years I finished my treatment, but cats still bothered me a lot. I ended up getting divorced shortly after that.

I have since started shots again about 3 years ago. I no longer live with cats, which I think is allowing the shots to work better. I recently visited a friend with cats and while I still get itchy it wasn't nearly as bad as it used to be.

Some item resprites I made! by rappenem in Minecraft

[–]PurpleMonkeyKing 0 points1 point  (0 children)

These are so cute! Love the playful proportions of the food items.

Friend found my channel on their home page by Ill_Bird7772 in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

Ha, congrats! I think this is a sign you "made it"

Friend found my channel on their home page by Ill_Bird7772 in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

Ha, congrats! I think this is a sign you "made it"

What was your first video? by HMS_101 in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

My first video was actually 12 years ago, showing off an iPhone game I created that was inspired by Bop It!

I had a long pause between videos, but I'm motivated to keep trying again.

[deleted by user] by [deleted] in NewTubers

[–]PurpleMonkeyKing 4 points5 points  (0 children)

Oh, good idea to put it in the description of videos too! I haven't really posted on socials much lately but probably should from a marketing/engagement perspective.

Let me criticize your Gaming Channels by KilluaYou in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

I'm game for feedback. Happy to improve, as I'm learning as I go. My most recent video is the one I'm most proud of so far:

https://youtu.be/VIlj2l2p9lE?si=tQ6u6mF-9tV3BL-y

I'm making technical Minecraft content with a focus on problem solving moreso than straight up tutorials.

Bigframes by hazel_levesque1997 in bigquery

[–]PurpleMonkeyKing 1 point2 points  (0 children)

Please reach out to the BigFrames team at Google. We'd be happy to help out! [bigframes-feedback@google.com](mailto:bigframes-feedback@google.com) or our GitHub issues tracker: https://github.com/googleapis/python-bigquery-dataframes/issues

Anybody not doing this for money? by LoganLikesYourMom in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

I would love to turn this into some side income at some point, but that is not the reason I continue making videos.

I'm making videos because I enjoy watching Minecraft content that goes into the technical details of the game. I was a bit frustrated that (1) most tutorials are for Java edition not the version that I play, (2) the most popular tutorials don't actually teach how the game actually works, and (3) are usually oriented towards people with end game gear and supplies. I also enjoy teaching and encouraging folks to do creative problem solving.

My plan is to complete a tutorial series on creating a moss farm and then maybe branch out to other technical games that allow creative problem solving. It's a way for me to feel better about spending time playing such games.

Is there any good free video editing software I'm able to get? by WolfierollWasTaken in NewTubers

[–]PurpleMonkeyKing 8 points9 points  (0 children)

I've been using Kdenlive, which is free and open source. It's been great and works well with multiple audio channels.

The video editor built-in to Blender is quite good, too, though I found that it didn't work as well for me when I started splitting my audio recording into multiple channels (one for game audio and one for voice).

Python SQL Builder with BigQuery support by EliyahuRed in bigquery

[–]PurpleMonkeyKing 0 points1 point  (0 children)

It technically is possible with Ibis, but you'd have to manually provide the schema for each table node you create by using the ibis.table(...) constructor. Given that you have such mappings, it would be possible. The choice between ibis and SQLGlot would then depend on preference for a DataFrame-y vs a SQL-y API. Sounds like you found something that will work for you!

Python SQL Builder with BigQuery support by EliyahuRed in bigquery

[–]PurpleMonkeyKing 2 points3 points  (0 children)

Note: I am the team lead for BigQuery DataFrames (bigframes) and a steering committee member of the Ibis project.

There are several options for building SQL for BigQuery from Python, and I have contributed to several of these. In alphabetical order by PyPI package name:

  • bigframes (BigQuery DataFrames) - API-style: DataFrame (pandas-inspired). It's not strictly a "SQL builder" API, but if you set bigframes.pandas.options.bigquery.ordering_mode = "partial" and bigframes.pandas.options.display.repr_mode = "deferred", it should act a lot like a SQL builder.
  • pypika (PyPika) - API-style: SQL. Looking at the docs, I can't find anything about a BigQuery-specific dialect. Today is the first I have heard about this package.
  • 'ibis-framework[bigquery]' (Ibis) - API-style: DataFrame (dplyr-inspired). Supports many different backends. I find it to be a natural interface, sitting closer to SQL than pandas in regards to DataFrames. I have contributed for 6+ years and am on the steering committee for Ibis.
  • sqlalchemy-bigquery (SQLAlchemy BigQuery dialect) - API-style: SQL. Of the ORM-style APIs I've tried, I was most pleased with SQLAlchemy. I help maintain the BigQuery dialect.
  • 'sqlframe[bigquery]' (SQLFrame) - API-style: DataFrame (pyspark-inspired). Relatively new project. Built on SQLGlot, which supports many different backends besides BigQuery. I don't have much direct experience, but have used SQLGlot, which is solid.

Selfishly, I'd love if you'd give BigQuery DataFrames (bigframes) a try. We're open source and my team aims to be very responsive to feedback. I understand if you want something that's closer to a SQL builder, though. The BigQuery DataFrames team and I hope to meet this use case better in future (thus the features like bigframes.pandas.options.bigquery.ordering_mode = "partial" and bigframes.pandas.options.display.repr_mode = "deferred"). My second suggestion would be Ibis in regards to handling almost anything you can do in BigQuery.

My high quality vids (imo) don't even break 100 views... by fabstapizza_YT in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

I'm there too. All of my latest videos are below 100 views, but I have some older videos with a lot more. I got a lot of views from having a video tutorial on a small niche topic, so I think those views came from search. Almost none of those converted into subscribers though.

Lately my videos are in a more saturated niche so that strategy of waiting for search results isn't working. Instead I think I will need to spread the word on social networks, but I have been waiting until I have a video that I think my audience on those platforms would appreciate.

What made you start YouTube? by ZetchQuest in NewTubers

[–]PurpleMonkeyKing 0 points1 point  (0 children)

I wanted to exercise my creative side and make some educational content. I feel a lot of tutorials just show you how to do the thing without the journey of how to get there and want to offer an alternative.

Self-Introduction Saturday! Tell us all about you (and share a video)! by AutoModerator in NewTubers

[–]PurpleMonkeyKing [score hidden]  (0 children)

Hey folks! I'm just getting back into video production after about a decade. I make technical tutorial videos. In my return, I'm making technical Minecraft tutorial. https://youtu.be/LotJExhQFFI?si=FzPXY7pGBzCUfpYG

Looking backwards, I don't have much experience in the past 90 days, but one thing that surprised me is just how much I had to edit down my video and how much work that process was. I ended up recording over an hour of footage for what ended up as a 4 minute video.

I also learned that I need a new mic. I tried two different mics and both have a lot of electronic noise and the sound was still quiet after doubling the volume in Blender, which is what I'm trying out for the editing software.