I work now exclusively with the MSSQL database and there were no problems until the order came that needed to be deployed to the server and of course I had to buy licenses here, only MSSQL for the $ 25,000 processor itself is very expensive. There is a great need to use open-source database that would work without problems with Asp.net mvc5. Please advise which database is most suitable for medium and large projects? and given the threshold of entry

  • one
    sql server express is free. perhaps it will be quite enough. given the fact that much can be cached, and not to make queries to the database. - Stack

3 answers 3

And what data do you want to store there? Without this, it is difficult to say something.

For document-oriented there are bases like: RethinkDB, Riak, arangodb. And they are all free.

We personally use RethinkDB for our online games. Very easy to understand. ReQL query language is similar to SQL. In which case it is not difficult to screw clustering with replication / shchirdingom.

From traditional SQL free databases there is MySQL, PostgreSQL.

Although, many are switching from MySQL to PostgreSQL. There is still Monga, but I do not dislike her, so I can not advise her.

  • Hello! @Suvitruf And what data do you want to store there? - ordinary text, numbers, date ... well, basically a database for CRM systems - Emir Mamashov
  • @EmirMamashov then MySQL is the simplest and quickest solution. - Suvitruf ♦
  • documented yet mongodb and couchbase. Mongu kicked Timlide for behavior on really large amounts of data, I personally will pull the couch base, because it is simply impossible to administer. I also saw OrientDB in the lists, but as far as I understand it, it’s primarily a graph one. - etki
  • @Etki I don't like Mongu. I had questions for her about replication like. - Suvitruf ♦
  • @Suvitruf MySql is a good option, but will it go for large applications? - Emir Mamashov

What are the volumes of the database? If small - then MS SQL Server Express is free.

If you need large volumes and free of charge at the same time, then PostgreSQL.

And the clarification to the question - "for Asp.net mvc5" is meaningless. Asp.net mvc5 will work with any DBMS for which there is an ADO.NET driver.

  • Hello! @Pavel was a variant of MS SQL Server Express, but the database will be large. "Asp.net mvc5 will work with any DBMS for which there is an ADO.NET driver." - I do not think that for all it exists as well as documentation examples and using asp.net mvc5. - Emir Mamashov
  • @EmirMamashov there is what? - Pavel Mayorov
  • ADO.NET Driver - Emir Mamashov
  • @EmirMamashov and if this driver does not exist, then the database for .NET is still there. - Pavel Mayorov
  • That's exactly what I clarified that "for Asp.net mvc" makes sense, because if I hadn’t specified the answers, there would have been other databases that, as you say, do not exist (for .NET) - Emir Mamashov

For example, SQL Server Express is free.
Used in a public mapping service with a relatively large load and data volume. On the Microsoft website there is a detailed description - here .

Another option is Azure cloud services. Look at Data & Storage - there are different possibilities for working with any volumes of data.

  • Hello! @Stack was a version of MS SQL Server Express, but the database will be large - Emir Mamashov
  • updated answer: see azure services. - Stack
  • Do not forget a close relative of MSSQL-I - SYBASE ASE, which also has express, and also with its limitations (base up to 5GB) - Sergey