Knowing which version of MySQL you are running is vital when making sure your code is compatible and that you are using supported features. Here’s how to find out which you are running. For example, older versions of MySQL lack features for handling JSON data and… Read More »How To Check your MySQL (Or MariaDB) Version [Easy]
This article shows you how to use the string.replace() method in Python to replace elements in a string of characters and includes useful examples. Python String replace Syntax The replace() function can be called on existing string variables like so: string.replace(find, new, count) Where: string is the existing string… Read More »Python String replace Method [With Examples]
The title pretty much explains this project- it’s a tank, that can shoot BBs – powered by a Raspberry Pi and Python Code. It’s pretty awesome. This is part one of a two-parter and handles all of the hardware and wiring and a Python script for test… Read More »Raspberry Pi & Python Powered Tank
The Python range() function returns an immutable sequence of integers between a given start and endpoint, incrementing by a given amount. Python range Syntax Here’s the syntax for the Python range() function: range(start, stop, step) Note that: start is the integer to start incrementing from – it will be included in… Read More »Python range Function – How to Use It [With Examples]
Being able to redirect the user to a different page in PHP can be useful if you’ve moved a page to a different location or want to send the user elsewhere – directing them to an access denied or error page instead of the page… Read More »How to Make a PHP Redirect to a Different Page [Quick & Easy]
We like Python. Anaconda is a popular distribution of Python and the R programming languages, which includes package management and deployment tools, with hundreds of packages pre-installed. Anaconda is aimed at data scientists and people working with machine learning, but it’s useful for anyone. It… Read More »How to Install Anaconda (Python & R) on Ubuntu
This article takes you through the creation of a COVID vaccination rate notifier. This project works by scraping data from the web and then displaying system notifications with Python. It hasn’t been the greatest year – but there’s light at the end of the tunnel.… Read More »COVID Vaccination Rate Notifier [Project] – Scraping and Displaying with Python
MySQL SELECT queries are commands that pull data from your database tables according to conditions each record must meet. Complex queries will often need to combine the results from two or more SELECT queries – this is what the UNION operator does. UNION Syntax SELECT… Read More »Using the ‘UNION’ Operator in MySQL and MariaDB
In this project, we take you through building, packaging, and publishing a command-line application using Python to resize and watermark images. Whenever I complete an article for LinuxScrew, I need to go through and add watermarks and make other small adjustments to any photos I’ve… Read More »Building a Python Script to Resize & Watermark Images [Code Included]
In this guide, we cover foreign key constraints in MySQL and MariaDB, along with a number of useful examples. MySQL (and its fork MariaDB) are Relational Database Management Systems (RDBMS) – Database Systems which hold data in tables which can be related to each other. Tables in… Read More »Guide to Foreign Key Constraints in MySQL and MariaDB [With Examples]