Splendid Data Blog
All the latest
Insight, news and more from us
Here we’ll share our latest news, industry trends and any announcements.
Featured posts
Oracle to PostgreSQL migrations – A combination of science and art (Part I)
For me, migrating Oracle databases to PostgreSQL is a combination of science and art. Science is designed to be objective and guided by data and art is subjective and heavily influenced by feelings and opinions. Traditionally, art and science are treated as two separate disciplines, but when they are studied together, it becomes clear how one influences the other.
PostgresPURE is updated for all minor releases
February 9, 2023, the PostgreSQL community has made available the new minor releases of PostgreSQL 11 through 15. For us, this means that based on these new minor releases, we have to start working on compiling the new releases of PostgresPURE. Meanwhile, we have done...
Cortex 2.4 is released
Our aim was to finalise this new release of Cortex before the end of 2022 and we succeeded. This new release supports PostgreSQL 15 (including native merge statement), it has functionality to include external SQL’s (queries) to a migration from Oracle to PostgreSQL,...
PostgresPURE ready for PostgreSQL 15
PostgresPURE, 100% open source, combines PostgreSQL with a powerful set of software tools to launch and manage your PostgreSQL database environments. So just before the end of 2022, we have finalised the new releases of PostgresPURE. In addition to new minor versions...
Continuous development of Cortex
We work on Cortex every day to improve its capabilities. For the last months of 2022, we have been working hard to deliver a new release of Cortex. In this new release of Cortex we have further improved our translation engines for migrating the Oracle Data and Code...
Azure Database for PostgreSQL flexible server announced
Azure Database for PostgreSQL - Flexible Server combines the fully managed community edition of PostgreSQL databases with the broadest PostgreSQL extension support to handle mission-critical workloads with predictable performance and dynamic scalability. Interested in...
Thinking of modernizing your Oracle databases to PostgreSQL? Automation saves you time, money and headaches
For many organisations, modernising their licensed databases, such as Oracle, to PostgreSQL in the cloud is an urgent need. All with the aim to drive flexibility and scalability while lowering costs and risks. So why are many business leaders hesitant to make that...
New minor releases of PostgresPURE
PostgresPURE, 100% open source, combines community versions of PostgreSQL with a powerful set of open source components to launch and manage your PostgreSQL database environments, and comes with sustainable release management and 24/7 premium support. What did we do?...
Cortex 2.1 is released
Splendid Data is continuously working on Cortex with the aim of making the migration from Oracle databases to native PostgreSQL increasingly effective and efficient. The on-going development of Cortex takes into account the experiences of the many use cases both of...
It is very rare, but it can happen. An unplanned new release of PostgreSQL 14
Due to a bug in the earlier versions of PostgreSQL 14, the PostgreSQL Global Development Group issued a new release on June 16, 2022. This new version (PostgreSQL 14.4) fixes an issue that can lead to silent corruption of indexes. Obviously this means for us that we...
New minor releases of PostgresPURE
PostgresPURE is 100% open source and combines community versions of PostgreSQL with a powerful set of open source components to launch and manage your PostgreSQL database environments. Added to this, it comes with sustainable release management and 24/7 premium...
Ora2Pg is free. But Cortex is cheaper. How?
The Atos Database Modernization program aims to convert legacy databases to open source or cloud databases at the highest level of automation for the lowest cost. And so to help our customer make the best decision for their business, in terms of the best product to...
Database migration is now even easier with Cortex 2.0
Cortex 2.0 is here. Smarter, faster, easier to use. When we first released Cortex two years ago, we focused on bringing together all the functionality we’d developed over many years to make the migration of Oracle databases to PostgreSQL (community version) as...
The latest releases of PostgresPURE are live
PostgresPURE, 100% open source, combines PostgreSQL with a powerful set of software components to launch and manage your PostgreSQL database environments. And now, it’s even more useful and effective with a new release. PostgreSQL is always evolving and pushing its...
Why PostgreSQL is my favourite database
I’ve been working with database systems for over 20 years, including Oracle, Sybase and MySQL – but for me, PostgreSQL is the best of them all. So what makes PostgreSQL such a great database system? In all honesty, having used it for over a decade, I could fill many pages with my answer. But …
PostgreSQL Expert Insight Series – Blog 4 of 4: Moving data around
So here we are at the last of my series of four blogs. If you’ve picked up the other three: Blog 1 of 4: Aggregation, Blog 2 of 4: Checking text within a larger string and Blog 3 of 4: Primary key considerations, thanks for reading! And watch this space, I’m preparing...
PostgreSQL Expert Insight Series – Blog 3 of 4: Primary key considerations
Hello and welcome to the third of my blogs. If you’ve picked up the first one: Blog 1 of 4: Aggregation and the second one: Blog 2 of 4: Checking text within a larger string, thanks for reading! So as I said before, I’ve always admired the desire of the PostgreSQL...
PostgreSQL Expert Insight Series – Blog 2 of 4: Checking text within a larger string
Hello and welcome to the second of my blogs. If you’ve picked up the first one: Blog 1 of 4: Aggregation, thanks for reading! So as I said before, I’ve always admired the desire of the PostgreSQL community to share knowledge and expertise. Following in that tradition...
PostgreSQL Expert Insight Series – Blog 1 of 4: Aggregation
Hello from me I’ve always admired the desire of the PostgreSQL community to share knowledge and expertise. Following in that tradition I’d like to share a few pearls of PostgreSQL wisdom that I’ve picked up over the years as a PostgreSQL developer. But before I start...
How to ensure Oracle® database migrations don’t fail
Nowadays many organisations want to migrate to the cloud to become flexible, scalable and to save costs. However, as many of them use Oracle, they are facing issues with their database management and the restrictive license terms that Oracle has put in place. A core reason is …
Why we created an alternative to Oracle
Apple started in a garage, as did Amazon. And just like them, our journey focussing on an alternative to Oracle began quite humbly on the living room table. At the time, open source was…
Open source in daily practice
There is no longer any discussion about the benefits of open source software within organisations. In order to take full advantage of these benefits now and in the future, it is wise to have a number of things in place. Organisations often…
Oracle to PostgreSQL migration – Insights through overview
Like many, you too are standing at the great crossroads of Digital Transformation, where the question "Can I reduce Oracle's footprint in my IT environment?" arises. This is a recognisable crossroads for us, as well as a recognisable question. The answer to the...
Simplify your Oracle to PostgreSQL migration
Databases are your most expensive, most complex and your most valuable asset. Migrating from one database technology to another is not something that was common practice in the past. With many organizations engaged in digital transformation, in which the cloud plays...
Avoiding the Obstacles; migrating from Oracle to PostgreSQL
The digital transformation has made many companies aware of the need to move to the cloud. With this switch, business becomes scalable, more flexible and IT costs will drop significant. So it isn’t surprising that you are wondering whether it is possible to migrate an...
Break free from Oracle’s grip
Are you looking to migrate from Oracle to more modern and versatile solutions? A guide for Oracle Forms and Oracle Database users looking to migrate from Oracle to more modern and versatile solutions. Facing prohibitive licensing costs and a dwindling developer...
What can Splendid Data mean for Independent Software Vendors (ISVs)?
You are an ISV and you want your product to be available on a PostgreSQL database environment in addition to Oracle. PostgreSQL is Oracle’s fastest growing competitor and is also open source. This has the advantage that offering your software product based on...
Migrate to the Cloud? A perfect time to reduce the Oracle footprint
Migrating to the Cloud, private, hybrid or public Cloud is an important current topic for many organizations. The advantages of switching to a Cloud strategy are numerous. However, the migration of your Oracle databases can cause a lot of headaches in the Cloud...
In the stranglehold of…? Watch the small print – the conditions!
If you want to get out of the stranglehold of the commercial software license models by switching to open source software, make sure you don’t make the same mistake again, this time with supposedly open source software based on subscriptions. Open source software is...
In Oracle’s stranglehold? Reduce Oracle’s footprint!
A trend that we see more and more often today, both nationally and internationally is the migration of Oracle databases to open source PostgreSQL databases. All this to reduce Oracle’s footprint within organizations. The benefits of migrating to open source PostgreSQL...