What does postgres/postgres do?

PostgreSQL is an object-relational database management system designed for the persistent storage and retrieval of structured information. It functions as an ACID-compliant database server, utilizing standard query language protocols to maintain data consistency and reliability across large-scale application datasets.

What are the main features of postgres/postgres?

The main features of postgres/postgres are: Relational Database Management Systems, Relational Databases, ACID Transactional Cores, SQL Query Interfaces, Data Persistence and Storage, Data Integrity Constraints, Multi-Version Concurrency Controls, Write-Ahead Logging.

What are some open-source alternatives to postgres/postgres?

Open-source alternatives to postgres/postgres include: dgraph-io/badger — Badger is an embeddable key-value store written in Go that provides persistent data storage for byte keys and values.… mysql/mysql-server — MySQL Server is a relational database management system designed to organize and store structured information. It… h2database/h2database — H2 is a JDBC-compliant relational database management system written in Java. It functions as an embeddable SQL… mbdavid/litedb — LiteDB is a serverless, embedded NoSQL document database for .NET applications. It persists data into a single… mongodb/mongo — This project is a distributed, document-oriented database system designed to store information in flexible,… neo4j/neo4j — Neo4j is a native graph database management system designed to store and query highly connected data using a…

Postgres | Awesome Repos

Features

Relational Database Management Systems - Provides a high-performance object-relational database engine for persistent storage and retrieval of structured information.
Relational Databases - Stores structured information in tables while enforcing strict data integrity and complex relational constraints.
ACID Transactional Cores - Guarantees atomicity, consistency, isolation, and durability for all data modifications and concurrent operations.
SQL Query Interfaces - Manages persistent data using standard query language protocols to ensure reliable storage and consistent access.
Data Persistence and Storage - Organizes information into tables with defined schemas to ensure consistent, long-term storage and retrieval.
Data Integrity Constraints - Enforces strict logical rules and constraints to maintain accuracy and consistency across related data sets.
Multi-Version Concurrency Controls - Maintains multiple versions of data rows to allow non-blocking read and write operations.
Write-Ahead Logging - Records data modifications to a sequential log before applying changes to ensure durability during system failures.
Database Engines - Advanced open-source relational database management system.
Database Management Systems - Powerful open-source object-relational database system.
Database Systems - Advanced relational database with SQL compliance.
قواعد البيانات - Enterprise-grade relational database system.
Custom Data Types - Allows definition of custom data types, operators, and indexing methods to support specialized data structures.
Object-Relational Mapping - Supports advanced data types and complex schemas for building highly structured, large-scale applications.
Shared Memory Buffers - Provides a global memory area for frequently accessed data pages to minimize disk I/O.
Structured Data Management - Organizes complex information into interconnected sets for reliable, high-performance access.
Structured Data Schemas - Stores records in defined schemas using specific data types to ensure organized and retrievable information.
Query Optimization Engines - Evaluates multiple execution plans using statistical data to determine the most efficient path for retrieving information.
Heap Storage Engines - Stores data records in unordered collections of pages, relying on separate index structures for efficient retrieval.
Process-Per-Connection Architectures - Spawns a dedicated backend process for each client connection to ensure isolation and fault tolerance.

بدائل مفتوحة المصدر لـ Postgres

مشاريع مفتوحة المصدر مشابهة، مرتبة حسب عدد الميزات المشتركة مع Postgres.

dgraph-io/badger
dgraph-io/badger
15,666عرض على GitHub
Badger is an embeddable key-value store written in Go that provides persistent data storage for byte keys and values. It is a persistent database that utilizes a tiered LSM tree storage model to optimize disk storage and retrieval efficiency. The system features an ACID transaction engine that ensures data integrity through serializable snapshot isolation and multi-version concurrency control. It also provides an encrypted key-value store with data-at-rest encryption and a managed encrypted key registry to secure stored information. The engine covers a broad set of capabilities including hig
Godatabasedocument-databasego
عرض على GitHub15,666
mysql/mysql-server
mysql/mysql-server
12,297عرض على GitHub
MySQL Server is a relational database management system designed to organize and store structured information. It functions as a comprehensive SQL server platform that provides reliable transactional integrity and high-performance query execution for enterprise data management. The system distinguishes itself through a pluggable storage engine architecture that decouples logical query processing from physical data storage, allowing for specialized handling of diverse workloads. It maintains data consistency and high concurrency through multi-version concurrency control and write-ahead logging
C++
عرض على GitHub12,297
h2database/h2database
h2database/h2database
4,607عرض على GitHub
H2 is a JDBC-compliant relational database management system written in Java. It functions as an embeddable SQL database that can run directly within an application process to remove network latency, or as an in-memory database for high-performance volatile storage. It also includes a web-based console for executing SQL commands and administering schemas. The system is characterized by its flexible deployment modes, including a standalone server mode for remote TCP/IP access and a mixed mode for simultaneous local and remote connectivity. It features a dialect emulation layer and compatibilit
Javadatabasejavajdbc
عرض على GitHub4,607
mbdavid/litedb
mbdavid/LiteDB
9,410عرض على GitHub
LiteDB is a serverless, embedded NoSQL document database for .NET applications. It persists data into a single portable file, functioning as a BSON data store that resides within the application process rather than running as a separate server. The system is ACID compliant, utilizing write-ahead logging to ensure atomic, consistent, isolated, and durable transactions. It includes built-in encryption to provide secure local data storage and protect files on disk from unauthorized access. The project covers object-document mapping to convert classes into document formats, indexed search capabi
C#
عرض على GitHub9,410

عرض جميع البدائل الـ 30 لـ Postgres

postgrespostgres

Postgres

Features

بدائل مفتوحة المصدر لـ Postgres

dgraph-io/badger

mysql/mysql-server

h2database/h2database

mbdavid/LiteDB

Frequently asked questions

سجل النجوم

بدائل مفتوحة المصدر لـ Postgres

dgraph-io/badger

mysql/mysql-server

h2database/h2database

mbdavid/LiteDB

Frequently asked questions