EDB Postgres Advanced Server vs SQLite comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between EDB Postgres Advanced Server and SQLite based on real PeerSpot user reviews.

Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases.
To learn more, read our detailed Open Source Databases Report (Updated: March 2024).
765,386 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It gives us a solid, less expensive alternative to deploying with Oracle.""I like that EDB Postgres Advanced Server scales well. A valuable feature of the solution is multi-tenancy support. It also supports JSONB.""I rate EDB Postgres Advanced Server's stability an eight out of ten.""The low cost and functionality allows us to save money on smaller database projects."

More EDB Postgres Advanced Server Pros →

"SQLite’s most valuable feature is the ability to store granular-level backups of databases.""I use Flutter Technology with the JSF plugin.""The product is lightweight and highly scalable."

More SQLite Pros →

Cons
"The system is aging and not keeping up with the performance of new, enhanced database models.""An area for improvement in EDB Postgres Advanced Server is JSONB querying. It would be nice to have even stronger JSONB support from the solution.""I have faced performance issues in the community edition.""The security is not very robust and the product would be much more useful with more security options."

More EDB Postgres Advanced Server Cons →

"It could have a user-friendly GUI and better intelligence features.""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."

More SQLite Cons →

Pricing and Cost Advice
  • "Pricing is significantly lower than competing products."
  • "The product is either free with community support or very inexpensive with a small yearly fee for paid support."
  • "EDB Postgres Advanced Server is open source, so I don't pay for licensing."
  • "I have been working on the community edition."
  • More EDB Postgres Advanced Server Pricing and Cost Advice →

  • "I rate the product’s pricing a six out of ten."
  • "The tool is open-source."
  • More SQLite Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
    765,386 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:I rate EDB Postgres Advanced Server's stability an eight out of ten.
    Top Answer:I have faced performance issues in the community edition.
    Top Answer:SQLite’s most valuable feature is the ability to store granular-level backups of databases.
    Top Answer:I rate the product’s pricing a six out of ten.
    Top Answer:The product’s price requires optimization. It could have a user-friendly GUI and better intelligence features. It should be integrated with HADR solutions as well.
    Ranking
    6th
    Views
    4,949
    Comparisons
    2,561
    Reviews
    2
    Average Words per Review
    411
    Rating
    9.0
    9th
    Views
    1,837
    Comparisons
    1,825
    Reviews
    1
    Average Words per Review
    255
    Rating
    8.0
    Comparisons
    Learn More
    SQLite
    Video Not Available
    Overview

    EDB Postgres Advanced Server is a powerful and reliable database management system designed for production workloads. It offers a range of advanced features, making it an ideal choice for businesses looking to scale their operations. With support for multi-tenancy, JSONB, and production features similar to Oracle, the solution is versatile and can meet the needs of a wide range of organizations. 

    Overall, EDB Postgres Advanced Server is a robust and flexible database management system that can help businesses achieve their goals and stay competitive in today's fast-paced digital landscape.

    SQLite is an open-source, serverless, reliable, and flexible, SQL database engine. It is particularly favored in the realm of embedded database solutions and small to medium-sized projects. Unlike traditional database systems that operate on a client-server model, SQLite is a serverless database engine, meaning it runs directly within the application it powers. This unique architecture makes SQLite an ideal choice for applications where simplicity, efficiency, and minimal configuration are paramount.

    SQLite is an embedded database engine, which means it operates directly within the application that uses it, without requiring a separate server process. It is designed to be cross-platform, supporting multiple operating systems, and is is compatible with a wide range of programming languages, such as C, C++, Python, Java, and more. This makes it highly portable and suitable for a wide range of applications, from mobile devices to desktop software and web applications.

    The key advantages of SQLite is its reliability, the lightweight nature and efficient performance. It has a small footprint, typically requiring only a few megabytes of disk space, and can operate entirely in memory if needed. It is designed to be reliable and robust, with built-in features such as atomic commit and rollback, which ensure data integrity even in the event of system crashes or power failures. Finally, the SQLite solution requires no configuration or setup, making it easy to use and deploy. It can be embedded directly into applications without the need for complex installation or configuration procedures.

      SQLite Functionality

      • SQL Compliance: SQLite supports a substantial portion of the SQL standard, including features like transactions, triggers, views, and indexes.
      • File-based Storage: SQLite stores its entire database as a single cross-platform file on the host machine's file system.
      • ACID Compliance: SQLite fully supports ACID (Atomicity, Consistency, Isolation, Durability) transactions, ensuring data consistency and integrity in concurrent access scenarios.

      SQLite is an open-source project distributed under a public domain license, which means it can be used, modified, and distributed freely, without any licensing costs or restrictions.

      To summarize, SQLite is widely used in various applications, including web browsers (e.g., Mozilla Firefox, Google Chrome), mobile applications (e.g., Android, iOS), embedded systems, and desktop software. Its simplicity, portability, and efficiency make it a popular choice for developers who require a lightweight and reliable database solution, especially in resource-constrained environments or applications with modest data storage needs.

      Sample Customers
      Ericsson, Clear Capital, PinkRoccade, ABN Amro, WholeWorldBand, Van Genechten, Gallinat-Bank AG, Mariner, coresystems, Aquent, Contegix, AQA, Genscape, InMobi
      Oracle, Bloomberg, Bentley, Mozilla
      Top Industries
      VISITORS READING REVIEWS
      Computer Software Company18%
      Financial Services Firm16%
      Manufacturing Company9%
      Government8%
      VISITORS READING REVIEWS
      Computer Software Company19%
      Comms Service Provider17%
      Manufacturing Company8%
      University7%
      Company Size
      REVIEWERS
      Small Business14%
      Midsize Enterprise14%
      Large Enterprise71%
      VISITORS READING REVIEWS
      Small Business23%
      Midsize Enterprise12%
      Large Enterprise65%
      VISITORS READING REVIEWS
      Small Business28%
      Midsize Enterprise16%
      Large Enterprise57%
      Buyer's Guide
      Open Source Databases
      March 2024
      Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases. Updated: March 2024.
      765,386 professionals have used our research since 2012.

      EDB Postgres Advanced Server is ranked 6th in Open Source Databases with 6 reviews while SQLite is ranked 9th in Open Source Databases with 5 reviews. EDB Postgres Advanced Server is rated 8.0, while SQLite is rated 7.6. The top reviewer of EDB Postgres Advanced Server writes "Scales well; works in both development and production environments and has multi-tenancy and JSONB support". On the other hand, the top reviewer of SQLite writes "Helps to access data directly from my local storage or databases". EDB Postgres Advanced Server is most compared with PostgreSQL, Percona Server, MySQL, YugabyteDB and MariaDB, whereas SQLite is most compared with Firebird SQL, MariaDB, PostgreSQL, MySQL and Oracle Berkeley DB.

      See our list of best Open Source Databases vendors.

      We monitor all Open Source Databases 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.