PostgreSQL, MySQL, SQLite, Oracle . What is the fundamental difference between them. In which projects each of them is used. Is it possible to evaluate from a position better / worse. What is worth reading on this topic to understand. And which of the bases is better to choose for: - blog - browser game

Closed due to the fact that the question is too general by the participants aleksandr barakin , Alex , fori1ton , user194374, Duck Learns to Hide 1 December '16 at 9:27 .

Please correct the question so that it describes the specific problem with sufficient detail to determine the appropriate answer. Do not ask a few questions at once. See “How to ask a good question?” For clarification. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • 2
    between different databases the same difference as between different aircraft: a helicopter plane and a hang glider. like the flying apparatus they have the same purpose. for now, all you need to worry about is their availability (free / paid). while studying sql there is no point in bothering about choosing a database, - choose the one you plan to work with in the near future - jmu
  • For browser IMHO better NoSQL =) (as for the blog xDDD) - Zowie

2 answers 2

The principal difference in speed and typing ... As for speed, there are bases that, for example, make a selection faster, while others make additions more quickly. And you need to think which base will be more convenient and faster to work for your project. I think you will be closer to SQLite and MySQL.

All written above IMHO. =)

  • So what specific faster make the sample faster for example? - Merlin

Between Oracle RDBMS and other difference - in the license: commercial in the first and freely distributed in other cases. Although after the acquisition of MySQL and for them there is now a commercial license.

  • > after the acquisition of MySQL and to be precise, after the acquisition of Sun (the company which owned the rights to MySQL) - jmu