Dominik KellerforLow-Code Software Engineeringfive.hashnode.dev·13 minutes ago14 Best Data Visualization Tools (Expert Analysis)Are you tired of staring at endless rows and columns of data, struggling to make sense of it all? Do you want to go further than Excel and create data visualizations that will make your reports and presentations stand out from the crowd? Look no furt...DiscussData Science
Shiv IyerforAll things PostgreSQL from MinervaDBpostgresqlblog.hashnode.dev·11 hours agoHow to Identify and Fix Anti-join Anomaly in PostgreSQLAn anti-join anomaly in PostgreSQL (or any SQL database) occurs when you need to select rows from one table that lack matching rows in another table, based on a specific condition or join key. This situation frequently arises when you need to identif...DiscussPostgreSQL
Danil Hendra Suryawan1tab2spaces.dhsrlab.com·20 hours agoExploring MySQL Replication💡 This the English version of the original article written in Bahasa Indonesia which can be found here. In the world of modern computing, it's quite clear that the trend is towards more and more distributed systems. Whether it's systems originally...Discuss·33 readsMySQL
BRAHIM AJAKAKajaxbo360.hashnode.dev·May 18, 2024How to Use Scopes in Laravel for Cleaner Code?Laravel, one of the most popular PHP frameworks, offers powerful tools to help developers write clean and maintainable code. One such tool is scopes, which allow you to encapsulate query logic that can be easily reused throughout your application. Th...DiscussPHP
Shiv IyerforAll things PostgreSQL from MinervaDBpostgresqlblog.hashnode.dev·May 18, 2024How to Set Up Dedicated DBA Connections in PostgreSQLIn PostgreSQL, the concept of a dedicated DBA (Database Administrator) connection similar to the "Dedicated Administrator Connection" (DAC) in SQL Server does not exist as a built-in feature. However, you can achieve a similar effect by reserving a c...DiscussPostgreSQL
Pankaj Sharmapankajsharma.hashnode.dev·May 18, 2024How To Use MySQL With MERN?Introduction The MERN stack, comprising MongoDB, Express.js, React, and Node.js, is a popular choice for building dynamic web applications. However, you may prefer using a relational database like MySQL instead of MongoDB for its robust querying capa...DiscussMySQL With MERN
Saurav Jhasrvjha.hashnode.dev·May 17, 2024Comparing MongoDB and MySQL: A Beginner's GuideOverview: MongoDB and MySQL are widely used Database management systems, but they differ significantly in their structure, features, and use cases. What is MongoDB? MySQL is a NoSQL database which is quite the opposite of a traditional table-based re...Discuss·11 likesMongoDB
BRAHIM AJAKAKajaxbo360.hashnode.dev·May 17, 2024A Beginner's Guide to Database Transactions in LaravelIntroduction: Database transactions are crucial for maintaining data integrity during complex operations. They ensure that a series of operations either all succeed or all fail, adhering to the ACID properties: Atomicity, Consistency, Isolation, and ...DiscussPHP
Shiv IyerProshiviyer.hashnode.dev·May 17, 2024Comprehensive Guide to Implementing Audit Logs in PostgreSQLImplementing audit logs in PostgreSQL can be done using several methods, including triggers, event triggers, and extensions like pgaudit. Here, I'll provide a detailed explanation of each method, focusing on implementing audit logs using SQL. Method ...Discuss·60 readsPostgreSQL
Shiv IyerProshiviyer.hashnode.dev·May 17, 2024PostgreSQL Monitoring and Diagnostics: Alternatives to SQL Server System_healthIn PostgreSQL, the alternative to the SQL Server System_health Extended Event Session for monitoring and diagnosing system health is a combination of logging, extensions, and built-in tools. Here are some of the key components you can use: 1. Logging...Discuss·44 readsPostgreSQL