Introducing G2.ai, the future of software buying.Try now

Compare Apache Derby and SQLite

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Apache Derby
Apache Derby
Star Rating
(23)3.8 out of 5
Market Segments
Small-Business (39.1% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Apache Derby
SQLite
SQLite
Star Rating
(259)4.3 out of 5
Market Segments
Small-Business (44.8% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about SQLite
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that SQLite excels in ease of setup, with a score of 9.1, making it a preferred choice for small businesses looking for a quick and straightforward database solution. In contrast, Apache Derby, while still user-friendly, has a slightly lower setup score of 9.0.
  • Reviewers mention that SQLite's query optimizer is highly effective, scoring 8.5, which contributes to its performance in handling complex queries efficiently. Apache Derby, however, has a lower score of 7.3 in this area, indicating potential challenges in optimizing query performance.
  • G2 users highlight SQLite's superior data manipulation capabilities, scoring 8.0, which allows for more flexible and efficient handling of data. Apache Derby, on the other hand, received a score of 7.3, suggesting that users may experience limitations in this aspect.
  • Reviewers say that SQLite's stability is a strong point, with a score of 8.3, indicating reliable performance over time. In comparison, Apache Derby's stability score of 7.9 suggests it may not be as robust in long-term use.
  • Users on G2 report that SQLite's support for various data types is impressive, scoring 8.4, which enhances its versatility for different applications. Apache Derby, while still competent, scored lower at 7.3, indicating fewer options for data types.
  • Reviewers mention that while both products have similar scalability scores of 6.7, SQLite is often preferred for smaller applications due to its lightweight nature, whereas Apache Derby may be better suited for larger, more complex environments.
Pricing
Entry-Level Pricing
Apache Derby
No pricing available
SQLite
No pricing available
Free Trial
Apache Derby
No trial information available
SQLite
No trial information available
Ratings
Meets Requirements
8.2
22
8.5
211
Ease of Use
8.6
23
8.9
211
Ease of Setup
9.0
10
9.1
83
Ease of Admin
8.2
10
8.8
79
Quality of Support
8.1
19
7.8
161
Has the product been a good partner in doing business?
8.0
9
8.3
61
Product Direction (% positive)
6.4
23
7.5
205
Features by Category
7.4
20
8.1
190
Management
Not enough data
8.9
29
Not enough data
8.7
31
Not enough data
8.5
28
Not enough data
7.9
29
Support
Not enough data
8.2
28
Not enough data
8.4
32
Not enough data
8.3
30
Not enough data
8.3
30
Security
Not enough data
7.8
28
Not enough data
8.0
27
Not enough data
7.7
27
Not enough data
7.6
29
Performance
Not enough data
7.8
26
Not enough data
8.1
27
Not enough data
8.1
27
Not enough data
8.2
27
Not enough data
8.5
28
Database Features
7.3
20
8.1
175
8.0
20
8.4
173
7.9
20
8.3
177
6.7
20
6.7
162
7.0
19
6.9
159
7.3
20
8.0
174
7.3
20
8.3
179
Categories
Categories
Shared Categories
Apache Derby
Apache Derby
SQLite
SQLite
Apache Derby and SQLite are categorized as Relational Databases
Unique Categories
Apache Derby
Apache Derby has no unique categories
SQLite
SQLite has no unique categories
Reviews
Reviewers' Company Size
Apache Derby
Apache Derby
Small-Business(50 or fewer emp.)
39.1%
Mid-Market(51-1000 emp.)
30.4%
Enterprise(> 1000 emp.)
30.4%
SQLite
SQLite
Small-Business(50 or fewer emp.)
44.8%
Mid-Market(51-1000 emp.)
24.0%
Enterprise(> 1000 emp.)
31.2%
Reviewers' Industry
Apache Derby
Apache Derby
Computer Software
39.1%
Information Technology and Services
13.0%
Government Administration
13.0%
Education Management
8.7%
Medical Practice
4.3%
Other
21.7%
SQLite
SQLite
Information Technology and Services
30.4%
Computer Software
21.6%
Higher Education
5.2%
Financial Services
3.6%
Internet
3.2%
Other
36.0%
Alternatives
Apache Derby
Apache Derby Alternatives
MySQL
MySQL
Add MySQL
PostgreSQL
PostgreSQL
Add PostgreSQL
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
Google Cloud SQL
Cloud SQL
Add Google Cloud SQL
SQLite
SQLite Alternatives
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
MySQL
MySQL
Add MySQL
Oracle Database
Oracle Database
Add Oracle Database
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (RDS)
Add Amazon Relational Database Service (RDS)
Discussions
Apache Derby
Apache Derby Discussions
Monty the Mongoose crying
Apache Derby has no discussions with answers
SQLite
SQLite Discussions
Where can i find better documentation for SQLite? Any tutorials?
1 Comment
Krishna  m.
KM
https://www.sqlitetutorial.net/Read more
Is SQLite free to use?
1 Comment
Abhishek U.
AU
Yes. It is free and easy to use. Read more
Monty the Mongoose crying
SQLite has no more discussions with answers