We performed a comparison between Oracle Database In-Memory and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."I like Oracle because it is a backward-compatible solution."
"The most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions."
"The solution's ROI is excellent."
"The solution is very fast."
"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."
"Security is the most valuable feature."
"The application development is very user-friendly."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"I use Flutter Technology with the JSF plugin."
"Sometimes, you want data to persist within the app even when there's no internet connectivity. To avoid showing blank screens, we can use SQLite to store data locally and then sync it with the cloud database when connectivity is restored."
"The product is lightweight and highly scalable."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"Lacks sufficient integration with other tools."
"Technical support is below our expectations currently. It could be improved."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"The platform’s pricing needs improvement."
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"I would like Oracle Database In-Memory to include a data replication feature."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"The performance could be better."
"I primarily use SQLite for small-scale applications due to its limitations in storing large amounts of data. For larger-scale projects, I typically opt for MySQL or other alternatives. Storing a large number of dates in SQLite can significantly impact its performance."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"There are some difficulties on the server side. When syncing data with databases like SQL Server or Oracle, SQLite requires a kind of double effort."
"It could have a user-friendly GUI and better intelligence features."
Oracle Database In-Memory is ranked 2nd in Embedded Database with 27 reviews while SQLite is ranked 4th in Embedded Database with 7 reviews. Oracle Database In-Memory is rated 8.8, while SQLite is rated 7.4. The top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". On the other hand, the top reviewer of SQLite writes "Good for scenarios where you need offline capabilities within your mobile applications, stable and useful plugin". Oracle Database In-Memory is most compared with SAP HANA, Progress OpenEdge RDBMS, IBM Db2 Database, SQL Server and MariaDB, whereas SQLite is most compared with Firebird SQL, MariaDB, PostgreSQL, MySQL and Oracle Berkeley DB.
See our list of best Embedded Database vendors.
We monitor all Embedded Database reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.