Our valued clients
EuroDB EuroDB is a commercial database built on the PostgreSQL engine.
EuroDB gains a number of integrated modular tools that extend its capabilities, improve management efficiency, analysis, and security. EuroDB is delivered together with technical support carried out by certified architects and engineers.
PostgreSQL features
PostgreSQL is an open source database engine that has been in development for over 25 years. It currently supports all popular data types and provides support for storing large binary objects, such as images, music or videos. In addition, it offers support for data types known from NoSQL databases (JSON, HSTORE). PostgreSQL also offers programming interfaces for many languages, including C/C++, Java™, Perl, Python, Ruby, Tcl, ODBC.
The EuroDB database system (PostgreSQL) supports mechanisms such as:
- Schemas
- Multiversion concurrency control
- Point-in-time recovery
- Tablespaces
- Table partitioning
- Replication
- Nested transactions
- Various backup methods
- Advanced query planner to quickly diagnose performance issues
- Acceleration of query execution by JIT compilation
- Write-ahead log
- International encoding sets
- Multibyte character strings (mbstring)
- Unicode.
Advantages of EuroDB (PostgreSQL)
Integrity
Data integrity protection mechanisms such as: compound primary keys, foreign keys, cascading updates and deletes, checking constraints, uniqueness constraints, non-empty field constraints.
GiST Indexes
The Indexing system that provides access to a wide range of sorting and searching mechanisms. The GiST extensions such as OpenFTS, which allows full text search and PostGIS, the database for geographical systems, make it versatile.
Partitioning
Partitioning significantly accelerates queries when tables contain very large data sets.
Nested Tables
Table inheritance making it possible to treat existing tables as base classes, allowing developers to use mechanisms known from object oriented programming languages.
Rules
Rule sets allowing transformations of query types into different ones according to established rules.
JSON
Support for efficient handling of JSON data with JSONB type and dedicated functions.
Events
Event-handling system that allows communication between clients (peer to peer) and client notifications of changes in the table.
EuroDB usage
Relational databases (OLTP)
Smaller data warehouses (OLAP)
Modern distributed relational systems
Data storage in schemaless structures (JSON, HSTORE)
Examples of use
Transactional system of a large e-commerce platform
Business analytics system for the abovementioned platform
Distributed backend system for a mobile application
High-availability system for controlling industrial automation
and much more.
Data limits
Database size | No limit |
Table size | 32TB |
Row size | 1.6TB |
Field size | 1GB |
Rows per table | No limit |
Columns per table | 250 – 1600 (depending on type) |
Indices per table | No limit |
EuroDB – inquire or order
Related articles
PostgreSQL 15.2 has arrived – a detailed list of changes
Great news for Postgres fans. The latest version of the PostgreSQL database is now available. It offers state-of-the-art security and stability standards. In this article, we'll lean into the changes in PostgreSQL 15.2.
Upgrade of PostgreSQL-like databases with EuroDB as an example
An upgrade should be a standard activity of every database administrator. It is recommended if you want to take advantage of new functionality or improve database performance. Therefore, in today's article we will talk about upgrading versions of database systems like PostgreSQL.
Happy new PostgreSQL! New Year's news on version 15.1 and predecessors
At the end of 2022, we received a series of new updates from the Postgres team that improve the quality and security of our databases. In this article we will take a closer look at the latest PostgreSQL patches, list the versions that received patches, for which this is the last official patch. We invite you to read on.