Backups are essential for keeping your data safe, and automating the backup process can save you both time and effort. If your database is ever lost or corrupted, having a recent backup can be a lifesaver. Regular backups are crucial for any website or application using a MySQL database. Automating this process ensures that backups occur regularly, without the need to remember to perform them manually. In this guide, we’ll show you how to create a simple Bash script to automate MySQL database backups. Then, we’ll set up a Cron job to run this backup script automatically at scheduled times,…
Author: drweb
I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.The UI layoutThis is what your layout might look like:LHS menu where you can switch challenges.All currently available cases. You’ll start with one and unlock new ones. Ordered like a mailbox, with the oldest at the bottom.Flavor text introducing the challenge.Ingestion script to load the data into your personal cluster.The main question that needs to be answered.Answer field — usually includes hints about the expected answer format.Three hints — IIRC, not all are available from the start; you might need to wait before requesting…
The rapid development of online gaming and gambling facilities, and the billions they generate around the world, require fair processes that can be proven. This not only protects consumers but also helps operators present a trustworthy product and maintain a good reputation.Python’s versatility for multiple tasks makes it the perfect option for the online gaming industry, making it easier for operators to prove that they are trustworthy and improve customer confidence. Online iGaming expert Carlos De Lanuza provides consumers with expert advice on everything from how to sign up at crypto casinos to their benefits, one of which is their…
The race to accelerate digital transformation across business units within an organization has led to a rapid surge in APIs, though unfortunately, without a central strategy in place. In 2023, the majority of internet traffic (71%) was API calls, with typical enterprise sites seeing an average of 1.5 billion API calls. Large companies with over 10,000 employees tend to have over 250 internal APIs. This challenge is exacerbated by the growth of SaaS applications in organizations’ IT landscapes, with each application bringing its own integration and API needs. On average, an organization manages over 1,000 different apps. Besides, it is not…
In December of 2024, we published a blog with Anthropic about their totally new spec (back then) to run tools with AI agents: the Model Context Protocol, or MCP. Since then, we’ve seen an explosion in developer appetite to build, share, and run their tools with Agentic AI – all using MCP. We’ve seen new MCP clients pop up, and big players like Google and OpenAI committing to this standard. However, nearly immediately, early growing pains have led to friction when it comes down to actually building and using MCP tools. At the moment, we’ve hit a major bump in…
AufgabenWir suchen einen erfahrenen und talentierten Senior Backend Developer mit Fachkenntnissen in PHP und Cloud-Technologien zur Verstärkung unseres Teams. Du bist mitverantwortlich für die erfolgreiche Umstellung und Weiterentwicklung unserer Cloud Anwendung ZEP. Du wirst dich um die Entwicklung, Erstellung und Wartung der Backend-Infrastruktur unserer Webanwendungen kümmern und deren Leistung, Skalierbarkeit und Sicherheit gewährleisten.QualifikationDu passt zu uns, weil…du mehrjährige Erfahrung in der objektorientierten Entwicklung mit PHP sowie modernen Frameworks wie Laravel mitbringstdu Vue.js, Inertia.js und Tailwind CSS entweder bereits kennst oder motiviert bist, dich intensiv einzuarbeitendu Webanwendungen mit sauberem Code entwickelst und dabei auf Performance, Sicherheit und Wartbarkeit achtestdu solide Kenntnisse…
I was chatting with a customer recently and they wanted to know which host was sending in queries that were causing problems in real time. This post looks at where you can find the hostname for running queries, which is in two places.This is part of a series of posts on Redgate Monitor. Click to see the other posts.The Server OverviewThere are two places where you can see the host name. From the server overview, you can go to the current activity, or the new Query Executions tab in preview.Current ActivityIn the server overview, there is a lot of data,…
I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of that.Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.The ScenarioLet’s set up a simple table with some data.CREATE TABLE PKChangeTest (ImportantNumber VARCHAR(20) NOT NULL CONSTRAINT PKChangeTestPK PRIMARY KEY, CustomerName VARCHAR(50), StatusValue INT)GOINSERT dbo.PKChangeTest (ImportantNumber, CustomerName, StatusValue)VALUES (‘1234567’, ‘Steve’, 1), (‘2345678’, ‘Andy’, 1), (‘3456789’, ‘Brian’, 1), (‘1235667’, ‘Leon’, 1), (‘1265567’, ‘Dave’, 1), (‘9914567’, ‘Bill’, 1)GOIf I look at this table,…
So, you’ve just installed Ubuntu 25.04 “Plucky Puffin” on your computer—congrats! I recently did the same, and let me tell you, this release feels fresh, fast, and packed with cool features, but as with any new system, there are a few things I always do right after installation to make my setup smoother and more enjoyable. Here’s my step-by-step guide, based on what worked for me. 1. First Things First: Update Everything Even though Ubuntu 25.04 is brand new, there are always some updates waiting, so it’s a good idea to take care of them right away. I opened the…
Photo by Lucian Alexe on Unsplashpg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as an extension. It allows you to schedule PostgreSQL commands directly from your database, similar to using cron jobs at the operating system level. pg_cron on PG Flex is pretty easy to use, making it easy to schedule regular database maintenance and processing tasks directly from within PostgreSQL.Enabling pg_cronNavigate to your Azure Database for PostgreSQL Flexible Server in the Azure portalGo to “Server parameters” under Settings in the left navigation panelSearch for the parameter “azure.extensions”Add “pg_cron” to the list of extensions…