Database

Image: Which open-source database is right for you? 5 options comparedGolden Dayzshutterstock

Which open-source database is right for you? 5 options compared

Open-source databases are a more affordable and often highly reliable alternative to well-known commercial solutions, which is why even large corporations use them. But which system is best suited to which purpose? Our database systems comparison takes a closer look at some…

Read more
Image: What is MongoDB findOne and how to use itAI-generated

What is MongoDB findOne and how to use it

If you want to search for a specific document in a collection, using MongoDB findOne is a great way to do it. Although it filters through the entire collection, it only returns a single result. In this article, we’ll introduce you to MongoDB findOne, explain how it works and show…

Read more
Image: How to use MongoDB queriesAI-generated

How to use MongoDB queries

When using MongoDB, queries are an indispensable tool for searching through your data. Although the method is simple and logically structured, it can still be difficult to understand, especially if you are just getting started with the database. In this article, we break down…

Read more
Image: How to remove Docker volumes step by stepAI-generated

How to remove Docker volumes step by step

Docker volumes are persistent and take up resources on your host system. You should remove unused Docker volumes to free up valuable disk space for other applications or data. But how do you remove a Docker volume? In this step-by-step guide, we look at the technical aspects,…

Read more
Image: How to save an HTML form to a MySQL databaseGorodenkoffshutterstock

How to save an HTML form to a MySQL database

A PHP script offers a simple and effective way to take information submitted through a website’s HTML form and store it in a MySQL or MariaDB database. This tutorial walks you through the basics of adding form data to your database, including how to create a straightforward PHP…

Read more
Image: What is managed cloud hosting and how can businesses benefit from it?AI-generated

What is managed cloud hosting and how can businesses benefit from it?

When searching for the right server environment, you’ll increasingly come across the term managed cloud hosting. This solution promises real-time scalability and a comprehensive range of services provided by the hosting provider, including the setup and maintenance of the hosting…

Read more
Image: What is PostgreSQL’s INSERT INTO?Olga RomShutterstock

What is PostgreSQL’s INSERT INTO?

The INSERT INTO command in PostgreSQL allows you to add one or more new rows to a table along with their corresponding values. In this article, we take a look at the command’s structure and the parameters that are used with it. With clear examples, you’ll learn how to efficiently…

Read more
Image: How to use PostgreSQL DELETELightspringshutterstock

How to use PostgreSQL DELETE

Looking to clean up a table in PostgreSQL? With the DELETE command; you can remove specific entries or get rid of all the data in a table. In this article, we’ll take a look at what the command is, how its syntax is structured and how to remove an individual row or all the data…

Read more
Image: How to use PostgreSQL schemasra2 studioShutterstock

How to use PostgreSQL schemas

Managing a database with lots of tables can quickly become overwhelming. Luckily, with PostgreSQL schemas, you can group related tables together, making it easier to organise and work with your database. This article explains the syntax for PostgreSQL schemas, including how to…

Read more
Image: How to add or remove columns in PostgreSQL with ALTER TABLEUndreyShutterstock

How to add or remove columns in PostgreSQL with ALTER TABLE

If you want to add, remove or modify columns in a table, the ALTER TABLE command in PostgreSQL is the go-to solution. In this article, we look at the syntax and functionality of the command, walk you through detailed examples, and explore various actions you can perform to…

Read more