Geek Answers Handbook

PostgresSQL mysql publicity differences

I need to start building the architecture for the database project, but I really don't know the differences between the engines.

Can anyone explain the pros and cons of each of these three engines? We must choose one of them, and the only thing I really know about is the following:

  • Mysql and Postgres:
    • Free, but not as good as the oracle
    • Mysql as a security issue (is this true?)
  • Oracle:
    • The best database engine in the world
    • Expensive

Can someone clear the other differences between them? This is a medium / large (we think about 100-200 tables) project with a low budget, what would you choose? And with a higher budget?

Thank you all for your help in clarifying the differences.

ps: I hope I do not duplicate the existing message, but I tried to search and I did not find it.

+5
4

; sql, . Postgres (AKA PostgreSql), Ingres, DB2, Informix, Sybase Oracle - , ANTS. , Oracle - ( )... , mySql SQL Server ( , ).

- - :

  • (. )
  • ( , ) )
  • ( , "" /).
  • / .

, , lvarchar:

oracle = varchar (% x) sybase = db2 = "long varchar" informix = lvarchar postgres = varchar (% x) ants = varchar (% x) ingres = varchar (% x,% y)

, , ; Oracle SILENTLY .... -, , , - " " , , , ! , Oracle ; ( - ).

ANTS, , , , , DB, , , .

- Postgres; _real_world_, /.

+12

SQL , , . , .

, , .

MYSQL Postgres

, Oracle Express (XE) edition, , . , , , - , .

+4

, Oracle . 100-200 . .

http://www.mysqlperformanceblog.com/ a> (and their excellent book) to see how MySQL can handle huge deployments.

Currently, most RDBMS can do almost everything you need in a very serious application.

+2
source

More articles:


All Articles