When comparing ArangoDB vs SQL Server Express, the Slant community recommends SQL Server Express for most people. In the question“What are the best relational databases?” SQL Server Express is ranked 5th while ArangoDB is ranked 6th. The most important reason people chose SQL Server Express is:
SQL Server Express has deep integration with Visual Studio, Visual Web Developer and SQL Server Management allowing for ease-of-use and rich table and query designers. It may be the best choice for someone who develops in the Microsoft environment.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Document and graph-orientend
You can model your data as documents or as a graph - no data model lock-in. You can even combine both models and use them in a single AQL query.
Pro Supports joins
Unlike many NoSQL databases, ArangoDB does support joins in AQL queries.
Pro JavaScript-API
You can extend ArangoDB using JavaScript that runs directly on the Server (Google V8). You can build data-centric microservices that aggregate, validate, transform or enrich data (It's up to you, plain JavaScript) and provide those via a custom API route.
Pro Transaction save
You can use ACID Transactions for short and small data retrieval and/or modification operations in ArangoDB.
Pro Easy cluster setup
Pro Powerful Java Driver (Sync & Async)
ArangoDB has a very good Java Driver for synchronous and asynchronous. In addition the team there is working on a Spring Data integration.
Pro Rich developer tools
SQL Server Express has deep integration with Visual Studio, Visual Web Developer and SQL Server Management allowing for ease-of-use and rich table and query designers. It may be the best choice for someone who develops in the Microsoft environment.
Pro Easily manage SQL Server instances
"Manage SQL Server Express databases with SQL Server Management Studio Express. Connect to local SQL Server Express databases and manage objects with full Object Explorer integration. Write, execute, and test queries by using visual query plans, and access management and maintenance options."
Pro Free
With a variety of versions to choose from the SQL Server Express version is free of charge. It is capable of upgrading to higher tiers, but that requires a fee.
Pro Easy backup and restore
Can be deployed to all editions of SQL Server and Microsoft Azure SQL Database
Cons
Con Proprietary
Con Hardware limitations
Maximum number of cores: 4
Maximum memory utilized per instance: 1GB
Maximum size: 10GB
This hardware could be limiting with some high profile apps and sites.
