Nikhil Soman Sahunikhilsomansahu.hashnode.dev·Sep 11, 2024how to connect mysql with spring bootTo connect MySQL with Spring Boot, you'll need to follow these steps: Add MySQL dependencies to your project Configure the database connection Create a simple entity and repository Here's a concise guide: Add dependencies to your pom.xml: <dep...MySQL
TreNyceneice76.hashnode.dev·Aug 23, 2024Introduction to SQLIntroduction As a developer or coder who looks into backend development, you've probably heard or encountered the term SQL(Structured Query Language) pronounced S-Q-L, letter by letter, but what is SQL, and why should developers learn it? SQL is a po...My SQL Learning Journeysqljourney
Shiv Iyerpostgresqlblog.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 ...47 readsPostgreSQL
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...1 likedb replication
attitude academyattitudeacademy.hashnode.dev·Apr 30, 202410 Essential MySQL Tips Every Computer Science Student Should KnowIntroduction: Are you a computer science student eager to sharpen your database management skills? MySQL, a widely-used relational database management system, is a must-know tool for anyone venturing into the world of computers. In this article, we'l...MySQL
Shiv Iyershiviyer.hashnode.dev·Apr 21, 2024Understanding Temporary Tables and Redo Logs in PostgreSQL: Functions and Best PracticesIn PostgreSQL, temporary tables and redo logs are two distinct concepts that serve different purposes within the database management system. Here's a detailed explanation of both: Temporary Tables in PostgreSQL Temporary tables in PostgreSQL are usef...114 readsPostgreSQL
Vikrant Bhatblog.vikrantbhat.com·Mar 9, 2024FeaturedHow to migrate data off Planetscale to another freely-hosted MySQL database in 5 minutesIntroduction Planetscale has sunset its much beloved free tier (hobby plan), as it was announced by its CEO a couple of days back in their blog post. Over the last 2-3 years, a lot of developers and even early-stage companies have managed to use Plan...47 likes·550 readsPlanetScale
Rakesh Kumar Jangidrakamodify.store·Jan 19, 2024Relational Database Server implementation on Rhel Linux-9Introduction: MySQL is like a big, digital filing cabinet where you can store, organize, and retrieve your data. It’s important because it’s fast, reliable, and easy to use. It’s different from other databases because it’s open-source, which means an...73 readsLinux-Administration-SeriesMySQL
Kim Nakyeongnakkim.hashnode.dev·Jan 13, 2024MongoDB에서 MySQL로 데이터 이전 with csvExpress.js와 MongoDB를 이용하여 작성했던 게시판 프로젝트가 있다. 헤로쿠가 무료 플랜을 중단하면서 서버가 내려갔었는데, 친구들의 요청이 있기도 했고 NestJS와 MySQL + kysely를 손에 익힐 겸 다시 재작성하고 있다. 프로젝트를 살리는 김에 이전 글들을 볼 수 있으면 좋을 것 같다는 생각이 들었다. 그러니 알아보자. MongoDB의 데이터를 MySQL로 이전하는 방법 MongoDB에서 데이터 추출 mongoexport ...35 readsmysqldump
Olutayo Ogunladeolutayoogunlade.hashnode.dev·Dec 1, 2023Exploring Python ORM: A Guide Using MySQLdbIntroduction to Python ORM and MySQLdb In the context of databases and programming, "mapping" often refers to the process of establishing a connection or relationship between two different entities. In object-oriented programming (OOP), developers wo...1 likeAlx
