lunacoding

[lunacoding]

Me upon discovering an online game that helps you learn git: haha I've been using git for years now, I could skip ahead many levels, methinks hahaha no, no, I'll be humble and start on level 1

Me on level 5: You can do what??? There are commands for what???

[lunacoding]

I remember attending those "girls in technology" programs and they just felt very alienating. You visited several places involving tech and they were all guys talking like you had no idea what anything is. No women in sight except receptionists/cleaners.

The program that intended me to join the tech industry just further hammered home that I don't belong there.

The best "girls in tech" was me working my way in by myself and gaining the self-esteem and confidence to not only not give a shit, but also thinking the men don't know shit more than I did, and are in most cases hired because they're men who feels entitled to a position in IT because they man and man logical.

I don't know how many incompetent men I've met in my career path that think they are a gift from the IT gods.

My tip for the girls/women reading this is gain the self-esteem enough to ignore what men are doing and wants us to be. Find your own path based on your skill. I can guarantee that an incompetent male will take many job positions but as your skill grow and as the men fail (often upwards) sooner or later the employer don't have any choice other than hiring you.

And then it's your time to shine. I almost immediately became the top malware analyst they had as I sharpened my skills every day while the men thought they did a good enough job because they were hired after all.

Then they'll ask you how you're so good at it, and that's worth the struggle you went through.

So don't give up on your dream blah blah basically ignore men, ignore their strategies for getting hired, you know what to do and you know how to get better. Find other women and encourage each other ok? You can do this! 💕

[lunacoding]

I made a beginner coding resource! 👩🏾‍💻💗

Hiya! 👩🏾‍💻💗

I made a coding infographic/slideshow for anyone getting into coding and are stuck! I'm seeing a lot of new codeblr blogs coming up recently and they're all beginners and I have been getting a lot of asks which basically all ask "I'm new to coding, how do I start?", so I decided to make this at 1am in the morning real quick! 🥲😭

I genuinely hope that this resource proves beneficial to someone out there. And remember, if you find yourself still facing challenges or need assistance with anything else, please don't hesitate to reach out. I'm here to help! ✨

Link to the PDF: LINK

[lunacoding]

✧･ﾟ: Customize your highlight color! :･ﾟ✧

I recently came across a blog where when I went to highlight some text I noticed it was a unique color!!! (」°ロ°)」

AND IT'S SO SIMPLE TO DO

all you do is go to your css file and add this:

::selection { background: <hexcolor> }

Enjoy!! ♡⸜(˶˃ ᵕ ˂˶)⸝♡

[lunacoding]

Essentials You Need to Become a Web Developer

HTML, CSS, and JavaScript Mastery

Text Editor/Integrated Development Environment (IDE): Popular choices include Visual Studio Code, Sublime Text.

Version Control/Git: Platforms like GitHub, GitLab, and Bitbucket allow you to track changes, collaborate with others, and contribute to open-source projects.

Responsive Web Design Skills: Learn CSS frameworks like Bootstrap or Flexbox and master media queries

Understanding of Web Browsers: Familiarize yourself with browser developer tools for debugging and testing your code.

Front-End Frameworks: for example : React, Angular, or Vue.js are powerful tools for building dynamic and interactive web applications.

Back-End Development Skills: Understanding server-side programming languages (e.g., Node.js, Python, Ruby , php) and databases (e.g., MySQL, MongoDB)

Web Hosting and Deployment Knowledge: Platforms like Heroku, Vercel , Netlify, or AWS can help simplify this process.

Basic DevOps and CI/CD Understanding

Soft Skills and Problem-Solving: Effective communication, teamwork, and problem-solving skills

Confidence in Yourself: Confidence is a powerful asset. Believe in your abilities, and don't be afraid to take on challenging projects. The more you trust yourself, the more you'll be able to tackle complex coding tasks and overcome obstacles with determination.

[lunacoding]

Hi, how do you make projects. I feel I haven't really done any project truly because I keep using tools to find code and stuff for few things....is this wrong or should I do everything on my own for a project?

Hiya! I get what you mean, I went through the same thing at the beginning and even nowadays! I made a post about how to come up with ideas >> click but here is some advice:

UI Design Inspiration = I check out Pinterest for cool design ideas. It helps me come up with interesting looks for my projects. I made a post about it. >> click

Project Research and Development = When starting a new project, I search on Google for something similar to get an idea. Then, I tweak it to make it my own. The stereotypical beginner projects but with a twist.

Incorporating Personal Interests: I bring my hobbies into my projects. For example, a portfolio page project was inspired by a character from JoJo's Bizarre Adventure because I'm a big fan. >> click

Using Online Resources: It's not wrong to use online resources. Many developers, including myself, have the code editor up with references. For me, I sometimes have w3schools or react documentation for guidance when stuck. To me, it's the same as having references when you're an artist.

Balancing Independence and Assistance: While it would be awesome to do everything on my own, the reality is it's okay to get help. The internet is there for a reason – to give us inspiration and help us out when we hit a roadblock!

Hope this helps!

[lunacoding]

I'm trying to debug a fairly subtle syntax error in a customer inventory report, and out of sheer morbid curiosity I decided to see what my SQL syntax checker's shiny new "Fix Syntax With AI" feature had to say about it.

After "thinking" about it for nearly a full minute, it produced the following:

SELECT SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION SELECT COUNT(id) FROM customers WHERE customers.deleted = 0 AND customers.id = NULL UNION

I suspect my day job isn't in peril any time soon.

[lunacoding]

SQL Fundamentals #2: SQL Data Manipulation

In our previous database exploration journey, SQL Fundamentals #1: SQL Data Definition, we set the stage by introducing the "books" table nestled within our bookstore database. Currently, our table is empty, Looking like :

books

| title | author | genre | publishedYear | price |

Data manipulation

Now, let's embark on database interaction—data manipulation. This is where the magic happens, where our "books" table comes to life, and we finish our mission of data storage.

Inserting Data

Our initial task revolves around adding a collection of books into our "books" table. we want to add the book "The Great Gatsby" to our collection, authored F. Scott Fitzgerald. Here's how we express this in SQL:

INSERT INTO books(title, author, genre, publishedYear, price) VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Alternatively, you can use a shorter form for inserting values, but be cautious as it relies on the order of columns in your table:

INSERT INTO books VALUES('The Great Gatsby', 'F. Scott Fitzgerald', 'Classic', 1925, 10.99);

Updating data

As time goes on, you might find the need to modify existing data in our "books" table. To accomplish this, we use the UPDATE command.For example :

UPDATE books SET price = 12.99 WHERE title = 'The Great Gatsby';

This SQL statement will locate the row with the title "The Great Gatsby" and modify its price to $12.99.

We'll discuss the where clause in (SQL fundamentals #3)

Deleting data

Sometimes, data becomes obsolete or irrelevant, and it's essential to remove it from our table. The DELETE FROM command allows us to delete entire rows from our table.For example :

DELETE FROM books WHERE title = 'Moby-Dick';

This SQL statement will find the row with the title "Moby-Dick" and remove it entirely from your "books" table.

To maintain a reader-friendly and approachable tone, I'll save the discussion on the third part of SQL, which focuses on data querying, for the upcoming post. Stay tuned ...

[lunacoding]

SQL Fundamentals #1: SQL Data Definition

Last year in college , I had the opportunity to dive deep into SQL. The course was made even more exciting by an amazing instructor . Fast forward to today, and I regularly use SQL in my backend development work with PHP. Today, I felt the need to refresh my SQL knowledge a bit, and that's why I've put together three posts aimed at helping beginners grasp the fundamentals of SQL.

Understanding Relational Databases

Let's Begin with the Basics: What Is a Database?

Simply put, a database is like a digital warehouse where you store large amounts of data. When you work on projects that involve data, you need a place to keep that data organized and accessible, and that's where databases come into play.

Exploring Different Types of Databases

When it comes to databases, there are two primary types to consider: relational and non-relational.

Relational Databases: Structured Like Tables

Think of a relational database as a collection of neatly organized tables, somewhat like rows and columns in an Excel spreadsheet. Each table represents a specific type of information, and these tables are interconnected through shared attributes. It's similar to a well-organized library catalog where you can find books by author, title, or genre.

Key Points:

Tables with rows and columns.

Data is neatly structured, much like a library catalog.

You use a structured query language (SQL) to interact with it.

Ideal for handling structured data with complex relationships.

Non-Relational Databases: Flexibility in Containers

Now, imagine a non-relational database as a collection of flexible containers, more like bins or boxes. Each container holds data, but they don't have to adhere to a fixed format. It's like managing a diverse collection of items in various boxes without strict rules. This flexibility is incredibly useful when dealing with unstructured or rapidly changing data, like social media posts or sensor readings.

Key Points:

Data can be stored in diverse formats.

There's no rigid structure; adaptability is the name of the game.

Non-relational databases (often called NoSQL databases) are commonly used.

Ideal for handling unstructured or dynamic data.

Now, Let's Dive into SQL:

SQL is a :

Data Definition language ( what todays post is all about )

Data Manipulation language

Data Query language

Task: Building and Interacting with a Bookstore Database

Setting Up the Database

Our first step in creating a bookstore database is to establish it. You can achieve this with a straightforward SQL command:

CREATE DATABASE bookstoreDB;

SQL Data Definition

As the name suggests, this step is all about defining your tables. By the end of this phase, your database and the tables within it are created and ready for action.

1 - Introducing the 'Books' Table

A bookstore is all about its collection of books, so our 'bookstoreDB' needs a place to store them. We'll call this place the 'books' table. Here's how you create it:

CREATE TABLE books ( -- Don't worry, we'll fill this in soon! );

Now, each book has its own set of unique details, including titles, authors, genres, publication years, and prices. These details will become the columns in our 'books' table, ensuring that every book can be fully described.

Now that we have the plan, let's create our 'books' table with all these attributes:

CREATE TABLE books ( title VARCHAR(40), author VARCHAR(40), genre VARCHAR(40), publishedYear DATE, price INT(10) );

With this structure in place, our bookstore database is ready to house a world of books.

2 - Making Changes to the Table

Sometimes, you might need to modify a table you've created in your database. Whether it's correcting an error during table creation, renaming the table, or adding/removing columns, these changes are made using the 'ALTER TABLE' command.

For instance, if you want to rename your 'books' table:

ALTER TABLE books RENAME TO books_table;

If you want to add a new column:

ALTER TABLE books ADD COLUMN description VARCHAR(100);

Or, if you need to delete a column:

ALTER TABLE books DROP COLUMN title;

3 - Dropping the Table

Finally, if you ever want to remove a table you've created in your database, you can do so using the 'DROP TABLE' command:

DROP TABLE books;

To keep this post concise, our next post will delve into the second step, which involves data manipulation. Once our bookstore database is up and running with its tables, we'll explore how to modify and enrich it with new information and data. Stay tuned ...

Part2

[lunacoding]

New neocities template just dropped, bitches! Here’s code for a gallery page. Figured some of you guys could probs use it.

Kalechips is very into simplicity and accessibility, so this should look decent on phones as well.

[lunacoding]

Welcome to my long awaited masterpost where I collect all the resources and answered questions people have asked me and categorise them into one post so I don't end up repeating myself over and over again. I don't mind explaining things over again but it is more of "Oh, I've answered a question like this before"!

Now, Tumblr won't let me put all those links into one post so I made an extra page on my blog where you can access all of the resources!

These resources are for Computer Science, coding, programming, what to learn how to build websites, C# links, Java links, anything tech-related, I have resources for it!

note: this page will be updated from time to time so keep referring back to the original post to see any new resources I've added~!

The Masterpost - ♡ link ♡

⤷ ♡ my shop ○ my mini website ○ pinned ○ navigation ♡

[lunacoding]

This the type of tweets I hate seeing.

a) Its like “oh cool I didn’t know I could make so much with just JavaScript” (News flash: pure vanilla JavaScript can’t unless you’re super lucky, you’ll need to learn a bunch of other JavaScript related technologies to get even 17% of that pay monthly)

b) No job will make you earn that much so that means you’ll have do freelancing where you get clients and do the work for them and get paid of it (Fiverr and UpWork kind of thing), to be earning that much per month is $240k a year

c) Some will feel bad about their skills and even increase that imposter syndrome feeling because they’re not learning JavaScript or they are but learning the “wrong JavaScript”, already increasing pressure on themselves.

d) What even is the “wrong JavaScript”? (News flash: he doesn’t clarify it anywhere in the tweet or on his page).

All I’m saying is this lowkey damaging some, if not most, of the coding community online. If you follow people like this on anywhere and you constantly see these kinds of tweets are you’re learning, it’ll just create doubt within yourself like “What am I doing wrong?” Especially for beginners.

Some will say “oh this can motivate people! Make them work hard to earn this much” and that’s great, find motivation in anything, I’m happy! But reading the comments under this tweet was more like “what am I doing wrong? / “cap” / this is helping with my imposter syndrome” like??

I don’t know this guy’s intentions with this tweet; either clout, for likes, or he genuinely means what he said but it’s not helping at all 😅

If you’re learning to code, please follow the RIGHT people online, no “tech influencers” who do things for clout like this. Find genuine people who are learning like you or someone you can use as a mentor e.g. @tenaciousdeveloper he’s a great inspiration on here, or anyone you see learning coding on here.

That’s all! ☺️

⤷ ♡ my shop ○ my mini website ○ pinned ○ navigation ♡

[lunacoding]

do you have any tips for speaking to/reaching out to recruiters? i'm looking for new grad roles and ppl keep telling me to but i don't even know where to start or find any and all the articles online are so intimidating

Hiya 💗

The people are right, it's one of the best ways to put yourself out there! Oh, this is going to be a long one~!

I'll share tips from my own experience, this might help you, this might because I did it any other way but this:

I applied to a bunch of jobs: like for 5 days straight I was just apply just for the sake of it. The more jobs, the more recruiters have my CV/Resume in their database. I recommend LinkedIn the most as it's super easy to drop a message to the recruiter.

Applied to jobs that I had 50%+ chance of getting a call to: Obviously this means apply to jobs where you have the skills and the experience (work or in building projects etc). I say this because say they do call you but they ask you if you have this certain tech stack and you say no... end of call really. So, for me, I had like 2 or 3 things they were asking for in a candidate so I got through to the calling stage!

LinkedIn is actually your friend, don't be afraid: During my random job searching and whilst I was in my job, I had recruiters message me about job opportunities. Why? Because of my profile. You need to have your LinkedIn vamped up, check mine out for reference (click the LinkedIn icon). But make sure to have your skills e.g. About > Top skills, your work experience (paid or volunteer) and any certificates you have! If you're brave, not like me, start posting on there for a while.

LinkedIn again but Connections: Oh my days please follow people, even if you don't know them personally. I have 300+ connections (not to brag) but I only know like two handful of the people, the rest are of people who connect with people who I follow, I have met like 5 recruiters through this way.

Actually message the recruiters???: Okay so you followed the people, your CV/Resume is done and dusted and now you're ready to message those recruiters! In my case, I had more recruiters message me than the other way round only because I'm shy hehe so I wait for them to make the first move. They would probably send a whole message about the new job that have posted and see if you're interested and then, if you like the job, you can say "Yes please" or whatever is the appropriate reply is, and then they will send further information or arrange a phone call! If you want to message them first, I would find them more after applying for a job on LinkedIn, they usually add the recruiter in the job posting as a way for people to message them.

DO NOT FEEL AFRAID IN MESSAGING RECRUITERS: I say this because a) imagine 100 people apply for the job, only 5 would message the recruiter (I don't know if the stats are right, I just remembered that from bootcamp-) because everyone else is too afraid to do it! Missed opportunity! b) recruiters actually want people to message them. Now in terms of what to write to them? I don't know really. I would always go for the classic "don't repeat what's on your resume", they're going to read it anyways, so just talk a bit about your experience and skills A BIT like

"Hello/Hi, my name is [name]. I hope this message finds you well. I wanted to express my strong interest in the [Job Title] position at [Company Name], for which I recently submitted my application. I'm enthusiastic about the opportunity to join [Company Name] and contribute to [mention something specific you find appealing about the company or role, if possible]. I believe my skills and experience align well with the requirements of the position. Thank you for considering my application, and I look forward to the possibility of discussing my qualifications in more detail. Best regards, [name]

No hire, don't be sad: Even if they don't hire you, or go through the next stages, keep in touch by even asking questions about what's on the market/what's new, how you could do better for other jobs you want to apply to that were similar to the ones you failed at. They could point you to the right direction! One recruiter said she wanted me to have more projects I was passionate about online like on GitHub or GitLab, even if they were "silly" projects - at the time, I didn't have much projects online so it made sense! See, I took that advice and now I'm a project making machine (a bit)! Advice they give sticks forever!

Remember, reaching out to recruiters and applying for jobs is a numbers game. The more applications you submit, the better your chances of landing interviews. I really hope this helps and I didn't make too many spelling mistakes! This is all of the things I could note down from the top of my head!

I've made other posts on on my coding blog about career advices:

🌐 Tips for Landing Your First Entry-Level Developer Job

🌐 Career Services For Web Dev (could be useful to you too!)

🌐 The Talent Cloud Community: Careers Workshop

Good luck with your job search!

⤷ ♡ my shop ○ my mini website ○ pinned ○ navigation ♡

[lunacoding]

How difficult is learning how to code? I've seen a lot of discussion about how a lot of older fandom people are used to building their own sites and stuff and how younger people on the internet don't really know how to do that, so I've been thinking of getting into it...

--

Coding coding or html? 90s-style sites are really, really basic on a technical level. I learned in an afternoon from that girl's eye-searingly orange/pink tutorial site back in the day.

Actual coding comes in many levels of complexity. Learn a dab of python, and you can do things like automate downloading all the works in your AO3 history. Easier still is learning just enough to run other people's scripts.

One of the bigger issues with building sites/tools that people interact with is security. If you have anything other people are logging into and you suck at that, their passwords are going to get leaked. But if you're building a more static thing that doesn't store other people's data, that's a lot easier.

There are tons of free tutorials online for all sorts of tech things. Figure out what you're interested in and I'm sure you can find some.

[lunacoding]

Codeblr Blogs Unite - Discord Server

Hiya everyone! | The original post 💗

I'm excited to announce that the amazing @vexacarnivorous started a new Discord server for members of the Codeblr community, and the Stuyblr community, on Tumblr!

As a fellow student and coding enthusiast, I know how important it is to have a supportive community that can offer guidance and motivation. The community here are super supportive and caring about each other coding journeys!!

That is why @vexacarnivorous created this server, to provide a space where we can all come together and help each other achieve our academic and coding/programming goals.

The server has channels dedicated to discussing different study paths such as stem, web dev, comp-sci and more! Sharing study tips and resources, and even hosting study sessions together in the voice channels! We even have a ✨Holy Mentor✨who can help with questions!

Join The Server!

Let's work together to make the most of our study and coding journeys! (if I missed anything else out, do let me know @vexacarnivorous)

[lunacoding]

I made a beginner coding resource! 👩🏾‍💻💗

Hiya! 👩🏾‍💻💗

I made a coding infographic/slideshow for anyone getting into coding and are stuck! I'm seeing a lot of new codeblr blogs coming up recently and they're all beginners and I have been getting a lot of asks which basically all ask "I'm new to coding, how do I start?", so I decided to make this at 1am in the morning real quick! 🥲😭

I genuinely hope that this resource proves beneficial to someone out there. And remember, if you find yourself still facing challenges or need assistance with anything else, please don't hesitate to reach out. I'm here to help! ✨

Link to the PDF: LINK

[lunacoding]

How to learn: HTML | Resources ✨

Sunday 10th September 2023

I have come back with a new resource I've made! This time about how to learn HTML! I'm starting from the basics right now and working my way up of 'how to learn' info resources!😅

I've made a HTML resource in the past (one | two) but this one is a bit more detailed and has tips of how I studied HTML. I use HTML on the daily so though I would share my knowledge with more people. Again, just like my previous resource "Starting your coding journey", this is more targeted towards absolute beginners or for people who want to learn how to customise their Tumblr blog/Neocite! 👩🏾‍💻

Anyhoo, check it out and let me know what you think: LINK