Madaline Albrightmaddie.hashnode.dev·19 hours agoOperating MySQL within a Docker container and configuring it with DBeaver.What is Docker: Docker is a popular tool for making and using containers, which are like little safe spaces for software. You put your software and all the stuff it needs inside, and it runs without messing up anything else. With Docker, you can easi...DiscussDocker
Saiful Alamblog.msar.me·21 hours agoDatabase Join QueriesThis is a Series of Article to start the series visit here. In the realm of web development, database interactions are crucial for storing, retrieving, and manipulating data efficiently. Laravel, a popular PHP framework, offers robust support for da...DiscussDatabase Design with LaravelDatabases
Krishnakrishnaporje.hashnode.dev·May 16, 2024MySQL DB Replication On CentOS & RHELPrerequisites: Ensure both master and slave servers have the same version of MySQL installed. Allocate disk space on both servers at least three times the size of the database. Ensure that the same configuration files (my.cnf) are present on both the...Discuss·1 likedb replication
Fikky Ardiantogonexwind.hashnode.dev·May 15, 2024Step-by-Step Guide to Installing MariaDB on Mac OSHi everyone, today I'm going to share a detailed, step-by-step guide on how to install MariaDB on macOS. This process will help you get MariaDB up and running smoothly on your system. So let's get started! For this installation, I will be using Homeb...DiscussMariaDB
Jamey Bartondbajamey.hashnode.dev·May 14, 2024Tune Performance using MySQL Query EXPLAIN PlanMySQL EXPLAIN plan helps you understand how MySQL queries are executed and what indexing techniques are better for running queries efficiently. The EXPLAIN plan is a handy statement, especially when you need to optimize MySQL queries. Everyone has ex...DiscussMySQL
Douglas Sabwa Indumwablog.douglas.africa·May 13, 2024Remote MySQL database connection on the cPanelcPanel is a web-based control panel that provides a graphical interface and automation tools designed to simplify the process of hosting and managing a server/website ranging from emails files, databases, domains, and more. Assume you have databases ...Discuss·84 readscpanel
hai nguyenhainguyen.hashnode.dev·May 12, 2024PostgreSQL Serial ID: Concurrent Inserts behaviorNote on Concurrent Inserts behavior of serial PK column in PostgreSQL Table setup: CREATE TABLE public.test_serial ( id SERIAL PRIMARY KEY, reason VARCHAR(10) NOT NULL ); Concurrent inserts in multiple transactions (long-running transactions). S...DiscussPostgreSQL
Jamey Bartondbajamey.hashnode.dev·May 12, 2024How to Add, Show, and Drop MySQL Foreign KeysWhat is a foreign key in MySQL? We’ll start with the definition. A foreign key is a column or a group of columns that allow cross-referencing related data across tables in a database. A foreign key relationship comprises a parent table (that contains...DiscussMySQL
Shiv IyerProshiviyer.hashnode.dev·May 12, 2024How to Implement Syslog Logging Using JournalD in PostgreSQLLogging to syslog is a well-established feature in PostgreSQL that has been available for many years. Despite its long-standing presence, only a handful of users use this capability. This realization has motivated me to develop a comprehensive introd...Discuss·35 readsPostgreSQL
Shehryar Aminsharryy.hashnode.dev·May 11, 2024Hacking SQLite functions in PHPIntroduction As a software developer, have you ever encountered the challenge of using SQLite due to its lightweight and server-less nature, especially during development and testing phases? If so, you'll appreciate learning how to mock SQLite functi...Discuss·96 readsSQLite