Arditya Wildan Hakimardityawildan.hashnode.dev·15 hours agoCara Setting LEMP stackLinux eNginx MySQL PHP (LEMP) merupakan salah satu stack development yang cukup umum digunakan. Saya sendiri suka menggunakan stack ini karena sesuai dengan development environment saya pribadi dan juga tempat kerja saya. Kenapa OS nya berbasis Linux...DiscussPHP
Shiv IyerProshiviyer.hashnode.dev·18 hours agoImplementing Single-Session User Limits in PostgreSQL: Strategies and TechniquesRestricting users to only one session each in PostgreSQL can be essential for managing system resources effectively, enforcing security policies, or complying with licensing agreements. PostgreSQL does not provide a built-in mechanism specifically de...Discuss·37 readsPostgreSQL
Shiv IyerProshiviyer.hashnode.dev·20 hours agoHow can you access multiple PostgreSQL Servers using the same host and port?Accessing multiple PostgreSQL servers using the same host and port typically involves a technique called connection pooling or the use of a proxy that can direct traffic to different database instances based on the incoming request criteria. Here’s h...Discuss·28 readsPostgreSQL
Đorđe Karanovićdkblog.hashnode.dev·21 hours agoHow to deploy Spring boot app to Azure with MySQL DatabaseIn this tutorial, we'll explore the steps to deploy Spring Boot application integrated with a MySQL database on Azure. Prepare your spring boot application Create your spring boot application and include dependencies such as 'Spring Web', 'Spring Da...Discuss·29 readsJava
Shiv IyerProshiviyer.hashnode.dev·Apr 23, 2024Optimizing Linux Server Settings for Enhanced ClickHouse Performance: A Guide for High-Volume Data IngestionOptimizing a Linux server for ClickHouse, especially to handle high-velocity, high-volume data ingestion, involves several layers of system tuning. These enhancements are designed to maximize the performance of ClickHouse by leveraging the full poten...DiscussClickHouse
Majesty Rajmajestyraj.hashnode.dev·Apr 23, 2024SMS Confirmations From UsersQUESTION : Meta/Facebook sends SMS texts when users attempt to 2FA (2-factor authenticate) into the platform to log in. In order to successfully 2FA they must confirm they received the SMS text message. Confirmation texts are only valid on the date t...DiscussSQL
Lalit Kaushikdigitalhuts.hashnode.dev·Apr 23, 2024Getting Started with SQL: A Step-by-Step GuideIntroduction to SQL Structured Query Language, or SQL, is an effective tool for administering and working with relational databases. It serves as a standard language for interacting with databases, enabling users to store, retrieve, and manipulate da...DiscussSQL
Jamey Bartondbajamey.hashnode.dev·Apr 23, 2024How to run a SQL script or file in MySQL & MariaDBIn database development, it is important to test the database with different data scenarios to ensure its functionality, performance, and reliability. Data import facilitates the population of test data sets, allowing developers to simulate real-worl...DiscussMySQL
Webhortizwebhortiz.hashnode.dev·Apr 21, 2024Explore fulltext search in laravel 10, 11 with RelationsWhile using LIKE operator in laravel can basically get the job done in Laravel when working on simple applications with small datasets Fulltext allows you to perform efficient searches on large text-based data. It is particularly useful when you need...DiscussNatural language search Laravel
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 20, 2024Strategies for Enhancing SQL Server Performance with Reduced LoggingAchieving optimal SQL Server performance with reduced logging involves several strategies to minimize the amount of data logged to the transaction log. This is especially relevant in high-volume transaction environments where logging can become a bot...DiscussSQL