The Role of Open Source & PostgreSQL at Smals

At Smals, a Belgian nonprofit ICT service provider working exclusively for the public sector, innovation and efficiency are paramount. With a legacy stretching back to 1939, Smals has consistently adapted to meet the challenges of data and information management in a rapidly evolving technological landscape. A cornerstone of this effort has been the strategic adoption of open source solutions, particularly PostgreSQL, to build sustainable, high-performance systems.

A Brief History of Smals and Data Management

Smals serves over 320 government organisations, offering infrastructure management, software development, and recruitment services. As the organisation expanded its scope, so did its data management challenges. From early manual record-keeping to today’s vast data ecosystems, Smals has witnessed, and contributed to, decades of innovation in data technologies.

By the 1980s, relational databases like those conceptualized by Edgar Codd became a fundamental tool. Fast forward to today,

Smals operates more than 4,450 databases, with PostgreSQL playing a growing role in this ecosystem.

Despite its deep history with traditional proprietary systems like Oracle, Smals has embraced PostgreSQL as a strategic choice for new projects and migrations.

Why Open Source?

Open source aligns with Smals’ values of sustainability, community collaboration, and quality-driven solutions. Smals leverages open source tools to:

• Foster innovation:
  Open source communities are hubs of technological progress, offering cutting-edge features and developments.
• Enhance flexibility:
  Open standards and modularity enable smoother migrations and integrations.
• Mitigate vendor lock-in:
  Open source solutions like PostgreSQL eliminate dependency on restrictive proprietary licenses, reducing costs and increasing autonomy.

PostgreSQL in Action

PostgreSQL has proven itself as a robust, reliable, and scalable database solution for Smals. Some of its key uses include:

• Database management: PostgreSQL handles nearly 800 databases within Smals’ environment, enabling consistent performance across critical systems.
• Business continuity: Tools like the PostgreSQL Failover Manager and backup solutions ensure system resilience and data recovery.
• Flexibility in deployment: Smals offers PostgreSQL as part of self-service options for development teams, supporting both cloud and on-premises environments.

Strategic Advantages of PostgreSQL

1. Cost Efficiency: As a free and open source solution, PostgreSQL reduces licensing costs and operational overheads.
2. Standard Compliance: Its adherence to open standards facilitates smooth transitions between database systems.
3. Quality and Innovation: PostgreSQL’s active development community ensures ongoing improvements and new features.

Challenges and Lessons Learned

Transitioning to PostgreSQL is not without its challenges. Migrations from Oracle, for example, often involve complex rewriting of stored procedures and schema adjustments. Additionally, lifecycle management, including upgrades and performance tuning, requires careful planning and expertise.

Despite these challenges, PostgreSQL’s advantages far outweigh its limitations, making it an excellent choice for Smals’ strategic goals. The organisation has also recognized the importance of fostering a micro-community among its team and peers to share knowledge and solutions.

Looking Ahead

As Smals continues its journey, it aims to deepen its integration of open source tools while refining its data management strategies. Upcoming priorities include exploring containerized PostgreSQL deployments and improving data governance to meet the demands of an AI-driven future.

Conclusion

Smals’ experience highlights the transformative potential of open source solutions like PostgreSQL in building sustainable, resilient, and innovative ICT infrastructures. By combining the strengths of open source tools with a forward-thinking approach to data management, Smals sets an inspiring example for public sector organisations worldwide. The journey from legacy systems to modern, open source-driven architectures is challenging, but with collaboration and strategic vision, it’s a path well worth taking.