Is MySQL or PostgreSQL more ACID compliant for database projects?

  • Thread starter Thread starter ankitdixit
  • Start date Start date
  • Tags Tags
    Acid Mysql
AI Thread 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 Summary
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 'Learning Assembly and computer architecture for x86'

Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
View full post »

Thread 'Failure to be able to activate Arduino Mega 2650'

hi; i purchased 3 of these, AZDelivery 3 x AZ-MEGA2560-Board Bundle with Prototype Shield and each is reporting the error message below. I have triple checked every aspect of the set up and all seems in order, cable devices port, board reburn bootloader et al . I have substituted an arduino uno and it works fine; could you help please Thanks Martyn 'avrdude: ser_open(): can't set com-state for "\\.\COM3"avrdude: ser_drain(): read error: The handle is invalid.avrdude: ser_send(): write...
View full post »

Similar threads

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

Hot Threads

Recent Insights

Back
Top