How to choose a SQL database?

We live in a golden age of databases with numerous high quality commercial and free databases. This is great, but the disadvantage is not a simple obvious choice for those who need a database for his next project.

  • What are the limitations / criteria that you use to select a database?
  • How well do the various databases that you used meet these limitations / criteria?
  • What features do databases have?
  • Which databases are convenient for you, recommending to others?

etc...

+3
source share
6 answers

, , , , , , , .

, , , .

, , , , , .

, , -, , , .

, .

, , .

, , , , , , , , , .

+8

( , ):

  • : /?
  • :
  • ?
  • ?
  • : ? (, SQL Server 2000 32 IIRC)
+3

", ".

, , , , , , .

. / ? , , , Oracle, MS SQL Server, Sybase , , , - . , - ?

, , , .

" ", , - . , - Oracle PL/SQL - , , (, , ), . , , .

Oracle, MS SQL Server, MySQL, PostreSQL, SQLite Sybase, . , Sybase, ( , , ), .

, , , . -, , , SQLite , , Postgres. - ActiveRecord Rails , , .

+3

, ... , , , . , MySQL LAMP SQL Server MS, .

, . , , , :

.

. , , - .

, , , , .

, , , , , , .

+2

. , Oracle XE- 10g- , Application Express, - .

, 4 HD, 1 RAM . , , , , ​​ . Oracle , : -)

, SQLServer Microsoft "". - , Oracle Microsoft . , Open Source - .

, : -)

+2
  • Linux, - - MySQL (, PostreSQL)
  • Mainstream SME - MS SQL
  • Big Iron ( ..) - Oracle

-, , - - , , , . , ,

  • , .
  • - , - .

, - , , , .., ( ) , .

0

Source: https://habr.com/ru/post/1696552/


All Articles