Need advice about which tool to choose?Ask the StackShare community!
Redis vs SQLite: What are the differences?
What is Redis? An in-memory database that persists on disk. Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.
What is SQLite? A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. 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.
Redis can be classified as a tool in the "In-Memory Databases" category, while SQLite is grouped under "Databases".
"Performance", "Super fast" and "Ease of use " are the key factors why developers consider Redis; whereas "Lightweight", "Portable" and "Simple" are the primary reasons why SQLite is favored.
Redis is an open source tool with 37.4K GitHub stars and 14.4K GitHub forks. Here's a link to Redis's open source repository on GitHub.
Airbnb, Uber Technologies, and Instagram are some of the popular companies that use Redis, whereas SQLite is used by Typeform, Intuit, and Coderus. Redis has a broader approval, being mentioned in 3261 company stacks & 1781 developers stacks; compared to SQLite, which is listed in 314 company stacks and 477 developer stacks.
Pros of Redis
- Performance875
- Super fast535
- Ease of use510
- In-memory cache442
- Advanced key-value cache321
- Open source189
- Easy to deploy179
- Stable163
- Free152
- Fast120
- High-Performance39
- High Availability38
- Data Structures34
- Very Scalable32
- Replication23
- Great community20
- Pub/Sub19
- "NoSQL" key-value data store17
- Hashes14
- Sets12
- Sorted Sets10
- Lists9
- BSD licensed8
- NoSQL8
- Async replication7
- Integrates super easy with Sidekiq for Rails background7
- Bitmaps7
- Open Source6
- Keys with a limited time-to-live6
- Strings5
- Lua scripting5
- Awesomeness for Free!4
- Hyperloglogs4
- outstanding performance3
- Runs server side LUA3
- Networked3
- LRU eviction of keys3
- Written in ANSI C3
- Feature Rich3
- Transactions3
- Data structure server2
- Performance & ease of use2
- Existing Laravel Integration1
- Automatic failover1
- Easy to use1
- Object [key/value] size each 500 MB1
- Simple1
- Channels concept1
- Scalable1
- Temporarily kept on disk1
- Dont save data if no subscribers are found1
- Jk0
Pros of SQLite
- Lightweight160
- Portable134
- Simple121
- Sql80
- Preinstalled on iOS and Android28
- Free1
- Telefon1
- Tcl integration1
- Portable A database on my USB 'love it'1
Sign up to add or upvote prosMake informed product decisions
Cons of Redis
- Cannot query objects directly11
- No WAL1
- No secondary indexes for non-numeric data types1
Cons of SQLite
- Not for multi-process of multithreaded apps2
- Needs different binaries for each platform1