Is MySQL or PostgreSQL more ACID compliant for database projects?

  • Thread starter Thread starter ankitdixit
  • Start date Start date
  • Tags Tags
    Acid Mysql
Click For Summary
MySQL and PostgreSQL both support ACID compliance, but their implementations differ. MySQL is not fully ACID compliant unless using the InnoDB or NDB storage engines, which ensure transactions are atomic, consistent, isolated, and durable. To utilize InnoDB, users can refer to the MySQL documentation for setup instructions. PostgreSQL, on the other hand, is inherently ACID compliant across all its operations, making it a reliable choice for database projects requiring strict adherence to these principles. Users are encouraged to explore official documentation for both databases to understand their capabilities and configurations better.
ankitdixit
Messages
5
Reaction score
1
TL;DR
Which one supports ACID compliant between MySQL and PostgreSQL
Hello All, I am working on a database project and I am good at SQL commands. I want to know which one supports ACID compliant between MySQL and PostgreSQL. I have asked this question on Quora and according to this post, MySQL is not completely ACID compliant. It supports ACID only when used in InnoDB and NDB. Can anyone tell me how i can use them with InnoDB? Or PostgreSQL is supported or not?
 
Technology news on Phys.org

Thread 'For those who ask: "What programming language should I learn?"'

Learn If you want to write code for Python Machine learning, AI Statistics/data analysis Scientific research Web application servers Some microcontrollers JavaScript/Node JS/TypeScript Web sites Web application servers C# Games (Unity) Consumer applications (Windows) Business applications C++ Games (Unreal Engine) Operating systems, device drivers Microcontrollers/embedded systems Consumer applications (Linux) Some more tips: Do not learn C++ (or any other dialect of C) as a...
View full post »

Similar threads

What does it mean that MySQL is a server application?
  • · Replies 16 ·
Replies
16
Views
3K
Best courses to revise SQL in 2 days?
  • · Replies 6 ·
Replies
6
Views
2K
Python Query runs fine in MySQL, but returns empty list in Python
  • · Replies 7 ·
Replies
7
Views
4K
Searching through many tables in MySQL
  • · Replies 21 ·
Replies
21
Views
3K
Create Distributed Database w/ MySQL, MS SQL, Oracle & PostgreSQL
  • · Replies 6 ·
Replies
6
Views
3K
Learning Database Concepts & Applications
  • · Replies 16 ·
Replies
16
Views
3K
Getting Started with MySQL: Advice for Beginners
  • · Replies 3 ·
Replies
3
Views
2K
Python I need to make an application that uses database in python
  • · Replies 17 ·
Replies
17
Views
2K
PHP How Can I Replace My Static Website with a Dynamic Website Using PHP & MySQL?
  • · Replies 4 ·
Replies
4
Views
3K
Renaming Columns in DB Table: Apex SQL or Examine Dependenci
  • · Replies 3 ·
Replies
3
Views
2K