CouchDB vs Microsoft SQL Server vs SQLite

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

CouchDB
CouchDB

313
279
+ 1
137
Microsoft SQL Server
Microsoft SQL Server

4.5K
3.3K
+ 1
530
SQLite
SQLite

4K
3.2K
+ 1
511
- No public GitHub repository available -
- No public GitHub repository available -

What is CouchDB?

Apache CouchDB is a database that uses JSON for documents, JavaScript for MapReduce indexes, and regular HTTP for its API. CouchDB is a database that completely embraces the web. Store your data with JSON documents. Access your documents and query your indexes with your web browser, via HTTP. Index, combine, and transform your documents with JavaScript.

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

What is SQLite?

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose CouchDB?
Why do developers choose Microsoft SQL Server?
Why do developers choose SQLite?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
    What companies use CouchDB?
    What companies use Microsoft SQL Server?
    What companies use SQLite?

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with CouchDB?
    What tools integrate with Microsoft SQL Server?
    What tools integrate with SQLite?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to CouchDB, Microsoft SQL Server, and SQLite?
    MongoDB
    MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
    Couchbase
    Developed as an alternative to traditionally inflexible SQL databases, the Couchbase NoSQL database is built on an open source foundation and architected to help developers solve real-world problems and meet high scalability demands.
    Cloudant
    Cloudant’s distributed database as a service (DBaaS) allows developers of fast-growing web and mobile apps to focus on building and improving their products, instead of worrying about scaling and managing databases on their own.
    MariaDB
    Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
    RethinkDB
    RethinkDB is built to store JSON documents, and scale to multiple machines with very little effort. It has a pleasant query language that supports really useful queries like table joins and group by, and is easy to setup and learn.
    See all alternatives
    Decisions about CouchDB, Microsoft SQL Server, and SQLite
    Josh Dzielak
    Josh Dzielak
    Developer Advocate at DeveloperMode · | 5 upvotes · 132.6K views
    Firebase
    Firebase
    Pouchdb
    Pouchdb
    CouchDB
    CouchDB
    Cloudant
    Cloudant

    As a side project, I was building a note taking app that needed to synchronize between the client and the server so that it would work offline. At first I used Firebase to store the data on the server and wrote my own code to cache Firebase data in local storage and synchronize it. This was brittle and not performant. I figured that someone else must have solved this in a better way so I went looking for a better solution.

    I needed a tool where I could write the data once and it would write to client and server, and when clients came back on line they would automatically catch the client up. I also needed conflict resolution. I was thrilled to discover Pouchdb and its server-side counterpart CouchDB. Together, they met nearly all of my requirements and were very easy to implement - I was able to remove a ton of custom code and have found the synchronization to be very robust. Pouchdb 7 has improved mobile support too, so I can run the app on iOS or Android browsers.

    My Couchdb instance is actually a Cloudant instance running on IBM Bluemix. For my fairly low level of API usage, it's been totally free, and it has a decent GUI for managing users and replications.

    See more
    Jonathan Pugh
    Jonathan Pugh
    Software Engineer / Project Manager / Technical Architect · | 21 upvotes · 719.4K views
    Framework7
    Framework7
    JavaScript
    JavaScript
    TypeScript
    TypeScript
    Figma
    Figma
    Visual Studio Code
    Visual Studio Code
    Webpack
    Webpack
    Babel
    Babel
    Ruby
    Ruby
    HTML5
    HTML5
    CouchDB
    CouchDB
    Pouchdb
    Pouchdb
    Font Awesome
    Font Awesome
    Apache Cordova
    Apache Cordova
    CSS 3
    CSS 3
    PhoneGap
    PhoneGap
    #Css
    #CSS3
    #SCSS
    #Sass
    #Less
    #Electron
    #HandleBars
    #Template7
    #Sketch
    #GraphQL
    #HTML5
    #GraphCool

    I needed to choose a full stack of tools for cross platform mobile application design & development. After much research and trying different tools, these are what I came up with that work for me today:

    For the client coding I chose Framework7 because of its performance, easy learning curve, and very well designed, beautiful UI widgets. I think it's perfect for solo development or small teams. I didn't like React Native. It felt heavy to me and rigid. Framework7 allows the use of #CSS3, which I think is the best technology to come out of the #WWW movement. No other tech has been able to allow designers and developers to develop such flexible, high performance, customisable user interface elements that are highly responsive and hardware accelerated before. Now #CSS3 includes variables and flexboxes it is truly a powerful language and there is no longer a need for preprocessors such as #SCSS / #Sass / #less. React Native contains a very limited interpretation of #CSS3 which I found very frustrating after using #CSS3 for some years already and knowing its powerful features. The other very nice feature of Framework7 is that you can even build for the browser if you want your app to be available for desktop web browsers. The latest release also includes the ability to build for #Electron so you can have MacOS, Windows and Linux desktop apps. This is not possible with React Native yet.

    Framework7 runs on top of Apache Cordova. Cordova and webviews have been slated as being slow in the past. Having a game developer background I found the tweeks to make it run as smooth as silk. One of those tweeks is to use WKWebView. Another important one was using srcset on images.

    I use #Template7 for the for the templating system which is a no-nonsense mobile-centric #HandleBars style extensible templating system. It's easy to write custom helpers for, is fast and has a small footprint. I'm not forced into a new paradigm or learning some new syntax. It operates with standard JavaScript, HTML5 and CSS 3. It's written by the developer of Framework7 and so dovetails with it as expected.

    I configured TypeScript to work with the latest version of Framework7. I consider TypeScript to be one of the best creations to come out of Microsoft in some time. They must have an amazing team working on it. It's very powerful and flexible. It helps you catch a lot of bugs and also provides code completion in supporting IDEs. So for my IDE I use Visual Studio Code which is a blazingly fast and silky smooth editor that integrates seamlessly with TypeScript for the ultimate type checking setup (both products are produced by Microsoft).

    I use Webpack and Babel to compile the JavaScript. TypeScript can compile to JavaScript directly but Babel offers a few more options and polyfills so you can use the latest (and even prerelease) JavaScript features today and compile to be backwards compatible with virtually any browser. My favorite recent addition is "optional chaining" which greatly simplifies and increases readability of a number of sections of my code dealing with getting and setting data in nested objects.

    I use some Ruby scripts to process images with ImageMagick and pngquant to optimise for size and even auto insert responsive image code into the HTML5. Ruby is the ultimate cross platform scripting language. Even as your scripts become large, Ruby allows you to refactor your code easily and make it Object Oriented if necessary. I find it the quickest and easiest way to maintain certain aspects of my build process.

    For the user interface design and prototyping I use Figma. Figma has an almost identical user interface to #Sketch but has the added advantage of being cross platform (MacOS and Windows). Its real-time collaboration features are outstanding and I use them a often as I work mostly on remote projects. Clients can collaborate in real-time and see changes I make as I make them. The clickable prototyping features in Figma are also very well designed and mean I can send clickable prototypes to clients to try user interface updates as they are made and get immediate feedback. I'm currently also evaluating the latest version of #AdobeXD as an alternative to Figma as it has the very cool auto-animate feature. It doesn't have real-time collaboration yet, but I heard it is proposed for 2019.

    For the UI icons I use Font Awesome Pro. They have the largest selection and best looking icons you can find on the internet with several variations in styles so you can find most of the icons you want for standard projects.

    For the backend I was using the #GraphCool Framework. As I later found out, #GraphQL still has some way to go in order to provide the full power of a mature graph query language so later in my project I ripped out #GraphCool and replaced it with CouchDB and Pouchdb. Primarily so I could provide good offline app support. CouchDB with Pouchdb is very flexible and efficient combination and overcomes some of the restrictions I found in #GraphQL and hence #GraphCool also. The most impressive and important feature of CouchDB is its replication. You can configure it in various ways for backups, fault tolerance, caching or conditional merging of databases. CouchDB and Pouchdb even supports storing, retrieving and serving binary or image data or other mime types. This removes a level of complexity usually present in database implementations where binary or image data is usually referenced through an #HTML5 link. With CouchDB and Pouchdb apps can operate offline and sync later, very efficiently, when the network connection is good.

    I use PhoneGap when testing the app. It auto-reloads your app when its code is changed and you can also install it on Android phones to preview your app instantly. iOS is a bit more tricky cause of Apple's policies so it's not available on the App Store, but you can build it and install it yourself to your device.

    So that's my latest mobile stack. What tools do you use? Have you tried these ones?

    See more
    AWS Elastic Beanstalk
    AWS Elastic Beanstalk
    Heroku
    Heroku
    Ruby
    Ruby
    Rails
    Rails
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL
    MariaDB
    MariaDB
    Microsoft SQL Server
    Microsoft SQL Server
    Amazon RDS
    Amazon RDS
    AWS Lambda
    AWS Lambda
    Python
    Python
    Redis
    Redis
    Memcached
    Memcached
    AWS Elastic Load Balancing (ELB)
    AWS Elastic Load Balancing (ELB)
    Amazon Elasticsearch Service
    Amazon Elasticsearch Service
    Amazon ElastiCache
    Amazon ElastiCache

    We initially started out with Heroku as our PaaS provider due to a desire to use it by our original developer for our Ruby on Rails application/website at the time. We were finding response times slow, it was painfully slow, sometimes taking 10 seconds to start loading the main page. Moving up to the next "compute" level was going to be very expensive.

    We moved our site over to AWS Elastic Beanstalk , not only did response times on the site practically become instant, our cloud bill for the application was cut in half.

    In database world we are currently using Amazon RDS for PostgreSQL also, we have both MariaDB and Microsoft SQL Server both hosted on Amazon RDS. The plan is to migrate to AWS Aurora Serverless for all 3 of those database systems.

    Additional services we use for our public applications: AWS Lambda, Python, Redis, Memcached, AWS Elastic Load Balancing (ELB), Amazon Elasticsearch Service, Amazon ElastiCache

    See more
    Daniel Quinn
    Daniel Quinn
    Senior Developer at Workfinder · | 2 upvotes · 105.1K views
    atThe Paperless ProjectThe Paperless Project
    SQLite
    SQLite
    PostgreSQL
    PostgreSQL

    SQLite is a tricky beast. It's great if you're working single-threaded, but a Terrible Idea if you've got more than one concurrent connection. You use it because it's easy to setup, light, and portable (it's just a file).

    In Paperless, we've built a self-hosted web application, so it makes sense to standardise on something small & light, and as we don't have to worry about multiple connections (it's just you using the app), it's a perfect fit.

    For users wanting to scale Paperless up to a multi-user environment though, we do provide the hooks to switch to PostgreSQL .

    See more
    Gabriel Pa
    Gabriel Pa
    CEO at NaoLogic Inc · | 6 upvotes · 96.3K views
    atNaologicNaologic
    Memcached
    Memcached
    Couchbase
    Couchbase
    CouchDB
    CouchDB

    We implemented our first large scale EPR application from naologic.com using CouchDB .

    Very fast, replication works great, doesn't consume much RAM, queries are blazing fast but we found a problem: the queries were very hard to write, it took a long time to figure out the API, we had to go and write our own @nodejs library to make it work properly.

    It lost most of its support. Since then, we migrated to Couchbase and the learning curve was steep but all worth it. Memcached indexing out of the box, full text search works great.

    See more
    Interest over time
    Reviews of CouchDB, Microsoft SQL Server, and SQLite
    No reviews found
    How developers use CouchDB, Microsoft SQL Server, and SQLite
    Avatar of Brillium, Inc.
    Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

    We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

    Avatar of Romans Malinovskis
    Romans Malinovskis uses SQLiteSQLite

    We build queries in PHP with DSQL that work with SQLite. We also have SQLite data controller, so that you can build SQLite-based models.

    Avatar of King's Digital Lab
    King's Digital Lab uses CouchDBCouchDB

    Document (JSON) DB.

    • - queries must be pre-defined as views (not as flexible as query formulation on the fly)
    • - community and ecosystem not as large as mongodb
    • + PouchDB is an excellent JS library to interact with CouchDB or even work in offline-then-sync moce
    Avatar of Coolfront Technologies
    Coolfront Technologies uses SQLiteSQLite

    Used during the "build process" of Coolfront Mobile's Flat rate search engine database. Flat rate data that resides in Salesforce is transformed using SQLite into a format that is usable for our mobile Flat rate search engine (AKA: Charlie).

    Avatar of Sripathi Krishnan
    Sripathi Krishnan uses SQLiteSQLite

    RDBTools is a self-hosted application, and it is important that the installation process is simple. With SQLite, we create a new database file for every analysis. Once the analysis is done, the SQLite file can be thrown away easily.

    Avatar of Smileupps
    Smileupps uses CouchDBCouchDB

    By being built on, of, in and around CouchDB, Smileupps offers to its customers secure and reliable CouchDB hosting and a CouchDB-based app store to build and sell serious business-enabled web applications

    Avatar of Andrew Miller
    Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

    Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

    Avatar of David Flynn
    David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

    Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

    Avatar of Perljobs.Ru
    Perljobs.Ru uses SQLiteSQLite

    All the dynamic data (i.e.: jobs) is stored in a simple SQLite database.

    Все динамические данные (вакансии) хранятся в простой SQLite БД.

    Avatar of Olo
    Olo uses Microsoft SQL ServerMicrosoft SQL Server

    Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

    Avatar of A. M. Douglas
    A. M. Douglas uses SQLiteSQLite

    There's really no call for something heavier for this site. SQLite is simple, easy to use and quite reliable given its age.

    Avatar of Arbor Health, LLC
    Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

    Managing script output and input, as well as data cleansing.

    Avatar of Giant Swarm
    Giant Swarm uses CouchDBCouchDB

    We use CouchDB in an internal analysis tool for usage data.

    Avatar of Mathias Vonende
    Mathias Vonende uses CouchDBCouchDB

    Storage for unstructured, linked and timeseries data.

    Avatar of Aaron Buchanan
    Aaron Buchanan uses CouchDBCouchDB

    json store + geo + _changes

    How much does CouchDB cost?
    How much does Microsoft SQL Server cost?
    How much does SQLite cost?
    Pricing unavailable
    Pricing unavailable
    Pricing unavailable
    News about CouchDB
    More news