Welcome to a guide and list of the different types of computer programmers. Digital devices and automation are everywhere in this age, and programmers are in huge demand. Maybe you are interested in the job called “programmer”? Or maybe you are just curious? To keep the story short, “programmer” is a very generic title these […]
9 Types of Computer Programmers (And What They Do) Read More »
Welcome to a quick guide on the differences between server-side and client-side scripts. Have you just started with web development or interested to learn more? Scripts that run on the user’s device are called “client-side scripts”. Generally less secure because users have direct access to the scripts. Usually deals with the user interface – Show
Server-Side VS. Client-Side Scripts (The Differences) Read More »
Welcome, and you are probably here because of the confusion between WAMP, LAMP, MAMP, and XAMPP. Techies sure like to abbreviate everything, just what the heck do these mean? For a quick answer: WAMP – Windows, Apache, MySQL, PHP LAMP – Linux, Apache, MySQL, PHP MAMP – Mac, Apache, MySQL, PHP XAMPP – Cross-platform (X),
What is WAMP LAMP MAMP XAMPP (Plus Their Differences) Read More »
So you have heard of the AI craze, and YouTubers all over the world are “creating apps with a simple prompt”. Does that spell “the end” for programmers and software developers? As a developer who has adopted AI, I came to a simple conclusion: AI cannot replace all programmers and developers. While AI is capable
Will AI Replace Programmers? (No, Not All) Read More »
Welcome to a quick tutorial on how to get and count duplicate records in MySQL. So you want to filter out all the duplicate records? Or maybe get a count of the number of duplicates? Assuming that only one table and column are involved, duplicate records can be retrieved with a simple query – SELECT
Get & Count Duplicate Records In MYSQL (Simple Examples) Read More »
Welcome to a quick tutorial and examples on how to calculate the difference between dates in MYSQL – In minutes, days, months, and years. Yes, these are probably the most common questions. How to calculate the difference between 2 dates? How to add or minus days? How many days have passed till today? Let us
MYSQL Calculate Difference Between 2 Dates (Simple Examples) Read More »
Welcome to a tutorial and examples on how to do MySQL search queries. Yes, this is a very common question and pitfall among beginners. How difficult can a SELECT query be? Not so straightforward, apparently. There are 3 common ways to do search queries in MySQL Exact match search (get all records that match the
MYSQL Search Queries (Exact vs Like vs Fuzzy) Read More »
Welcome to a tutorial on how to create a simple responsive PHP video gallery. Once upon a time in the stone age of the Internet, we have to struggle with all kinds of funky 3rd party video plugins to even play a single video. Fast forward to today, things are really easy. Creating a simple
Very Simple PHP Video Gallery (No Database, From Folder) Read More »
Welcome to a tutorial on how to import SQL files. So you have downloaded an SQL file from the Internet, and don’t know how to import it? There are 3 common ways to import an SQL file into MYSQL: Run mysql -u USER -p DATABASE_NAME < PATH/TO/FILE.sql in the command line (or terminal). Use MySQL
3 Ways To Import SQL File In MySQL (Step-By-Step Guide) Read More »
So you want to generate awesome anime pictures with Stable Diffusion, only to discover that prompts like “cute anime girl” and “cool anime guy” don’t produce good results? Well, here is a quick sharing of my experiments with various models, poses, and styles – Hope this helps to save you some time. TABLE
Stable Diffusion Anime Prompts (A Detailed Guide) Read More »