Jasai Hansdajasaiblogs.hashnode.dev·Jun 1, 2024Host Your PHP and MySQL Website for Free: A Step-by-Step GuideIn this guide, we'll walk you through the entire process, from setting up your server to deploying your site, without spending a dime. Let's get started! We are going to use infinityfree.com for totally free hosting. Setting Up Your Account on Infini...DiscussPHP
Shiv IyerforAll things PostgreSQL from MinervaDBpostgresqlblog.hashnode.dev·May 31, 2024The Effects of Bloated Tables and Indexes on PostgreSQL Cache and SpeedBloated tables and indexes in PostgreSQL can severely reduce cache efficiency and affect overall performance. Here’s how this happens: Cache Efficiency and Its Importance Cache efficiency refers to the effectiveness of the database's ability to keep ...Discuss·87 readsPostgreSQL
Ruchi Lamichhaneruchi77.hashnode.dev·May 31, 2024How to install wordpress in centos7 ?WordPress is a free, open-source website and blogging tool that uses PHP and MySQL. As the most popular Content Management System (CMS) on the internet, it offers over 20,000 plugins for extended functionality. This makes WordPress an excellent choic...DiscussWordPress
grant horwoodgbhorwood.hashnode.dev·May 30, 2024mysql: using json data and not hating itit's a universal truth that one of the primary jobs of backend developers is drinking from the firehose of json the frontends are constantly spraying at us. normally, we pick apart all those key/value pairs and slot them into the neatly-arranged colu...DiscussMySQL
Jamey Bartondbajamey.hashnode.dev·May 30, 2024How to list the users in a MySQL/MariaDB database and Manage PermissionsUser management involves granting database access, setting user permissions, and monitoring activities. This process, traditionally handled via command-line utilities, includes creating, modifying, and deleting accounts, and configuring user privileg...DiscussDatabases
Surgicalsurgical.hashnode.dev·May 29, 2024Planning Your Relational Database: Best Practices and Code ExamplesCreating a well-structured relational database is crucial for the efficiency and scalability of your applications. Whether you’re designing a new database from scratch or optimizing an existing one, understanding the best practices and various relati...DiscussRelational Database
Jamey Bartondbajamey.hashnode.dev·May 29, 2024A Single Killer Feature You Need For Collaborative Database Development: Source Control For MySQLDatabase development is a complex process that requires quality planning, technical skills, experience, and collaboration. Regardless of the project scope and the development team size, efficient partnership can help you improve, accelerate, and simp...DiscussDatabases
DolphinDBdolphindb.hashnode.dev·May 29, 2024Synchronizing Basic Product Data from MySQL with DolphinDB Cached TablesDolphinDB is a high-throughput distributed time-series database, specially designed for big data analysis scenarios in industrial IoT (IIOT) and finance. Data analysis in DolphinDB is often conducted based on the basic product information (such as th...DiscussMySQL
Harsh Mangeharshmange.hashnode.dev·May 26, 2024What is SQL Injection and how to prevent it?SQL injection is a type of web application vulnerability that allows an attacker to execute arbitrary SQL code on a database. This can be used to steal sensitive data, modify or delete data, or even take control of the entire system. Example Here's a...DiscussSQL
Shiv IyerforAll things PostgreSQL from MinervaDBpostgresqlblog.hashnode.dev·May 26, 2024How to Use Red-Amber-Green (RAG) Status Indicators for Table Selection in PostgreSQLIncorporating Red-Amber-Green (RAG) status indicators for table selection in PostgreSQL involves using color-coded statuses to represent different states or conditions of records. This can be particularly useful in dashboards or reports where visual ...Discuss·36 readsPostgreSQL