A few weeks ago, I took a deep dive into SQL queries in order to review it and finish up some data analytics projects I started a while ago.

This blog post is a quick start guide to SQL queries for those who are just getting started with them.

In it, I discuss how to use the SELECT, FROM, WHERE, GROUP BY, and ORDER BY reserved words. Including code snippets and examples using Google's Big Query.

Follow the link to read more: https://blog.ananfito.dev/quick-start-guide-to-sql-queries

#LearnInPublic #SQL #CodeNewbies

Whew! This blog post was a doozy, but I'm glad I got it out in the world. 😅

After 1 year of studying frontend web development, here are my top learning resources. If you're #LearningWebDevelopment, I hope they help bring you closer to your goal. Happy coding! 💻

https://blog.ananfito.dev/one-year-of-learning-frontend-web-development

#Scrimba #FrontendMentor #SoloLearn #FreeCodeCamp #KevinPowellCSS #LearnInPublic #CodeNewbie

I've just completed a front-end coding challenge from Frontend Mentor! 🎉

You can see my solution here: https://www.frontendmentor.io/solutions/repsonsive-results-summary-component-no-figma-file-dyJ6ieWaFR

Any suggestions on how I can improve are welcome!

#LearningWebDev #FronendMentor #WebDev #LearnInPublic

Met one of the co-founders of glasp.co in a little ux research and friend making zoom call today!

Glasp is a neat social highlighting app, where you "glasp" what you find interesting. A network for note takers, connecting knowledge seekers and sharers based on what they've tagged or highlighted.

Your glasps form a collective repository of knowledge, helping you learn through what others have glasped too.

https://glasp.co

#SocialMedia #LearnInPublic
#Glasp #Productivity #Tools

Continuing with my #LearnInPublic quest, in this week’s blog post I discuss my three favorite ways to center elements in CSS:

- margin and max-width
- flex
- grid

I include code snippets and a live demo. Follow the link to read: https://blog.ananfito.dev/how-to-three-methods-for-centering-elements-with-css

#LearningWebDev #CodeNewbie #CSS

In my latest blog post, I share my top 7 git commands and how I use them. This post was inspired by the #LearnInPublic philosophy shared by Swyx on the latest episode of the Scrimba podcast.

https://ananfito.hashnode.dev/git-command-cheatsheet

Setting up my tiny goals for building in public with Virtual Coffee community 🎯

#BuildInPublic #learninpublic #webdev #CodeNewbies #DEVCommunity

https://dev.to/adiatiayu/getting-back-to-coding-with-learning-and-building-in-public-44io

Alrighty then, let's resume the #learninpublic and #buildinpublic adventures. https://crusty-rustacean-dev.shuttleapp.rs

#DigitalGardens At first I felt very excited to share my notes on my digital garden, and now I'm rethinking it. I feel somewhat exposed, not knowing where to put the line between what is shareable and what should be private. It also feel like I'm still in a quest for validation more than to #LearnInPublic. Maybe I have to think in private for a while.

Other #pkm enthusiasts, any insights on the "public" dimension of sharing your notes?

Found the perfect podcast to crush weights with! 💪 'SuperHero Sweat' blends motivation & laughs! Mr. Bitcredible-approved! 🦸‍♂️🎧 Subscribe now!👌 #NowListening #PodcastRecommendation #FitnessGoals #LearnInPublic #MastoFun! #BitBook

As proof, here's the commit showing fixing my silliness. I'm sure y'all can point out more silliness.

#cpp #programming #LearnInPublic

https://github.com/taylor-built-solutions/DNSUpdater/commit/dcb66db3ef3e044150e0eacdd669b3c0d0665070

Proof that C++ compilers and their developers are great:

1. GCC caught a case where I should've made a parameter const reference because I never changed it

2. It reminded me to std::move a parameter into it's member variable instead of copying *again*

#cpp #LearnInPublic

Decided to go live now to learn more about #Flame engine in public! #LearnInPublic

https://www.twitch.tv/salih_gueler https://twitter.com/i/web/status/1643240791987421187

Ended up doing a partial rewrite of SwiftGPT using this package I found. https://github.com/alfianlosari/ChatGPTSwift

Very relieved. Now I can focus more on actually building out the app and getting comfortable with Swift instead of troubleshooting my crappy OpenAI queries.

#LearnInPublic #BuildInPublic #macOS

We had the last official 'meet' of my dev cohort, "The 404's" today... and I was recogised in class with the "bold innovator" award! 🎉 #WomenWhoCode #LearnInPublic #WebDev

I feel like I'm overkilling some aspects here. But I guess I'm not trying to minimize man-hours or part counts or whatever. I'm trying to learn. Gotta be verbose the first time around. Take time later to be terse.

#engineering #electronics #programming #design #LearnInPublic

Rather tired after a late night (doing nothing, really), but that knowledge isn't going to learn itself! Carrying on with #scrimba FEDCP and moving on to #MobileFirst design with @bobziroll

#frontendDeveloper #webdev #learninpublic

Being a Developer Advocate: Week 22

Late but it is there finally.
⚡️ Managing your energy level
📽️ More video-editing

#DevRel #DeveloperRelations #LearnInPublic

https://dev.to/johannesdienst/being-a-developer-advocate-week-22-397c

Being a Developer Advocate: Week 22

Late but it is there finally.
⚡️ Managing your energy level
📽️ More video-editing

#DevRel #DeveloperRelations #LearnInPublic

https://dev.to/johannesdienst/being-a-developer-advocate-week-22-397c

@hx2A @melissawm @TomLarrow

Boy oh boy, MUCH FASTER! I just had to make the palette components np.arrays and use the noise source as index to them!

I think I can almost understand what I'm doing 😂​

#Python #Numpy #py5 #LearnInPublic