Skip to main content
Open

Support for PostgreSQL as RDBMS type

Related products:Software FactoryIndicium Service Tier
  • February 21, 2025
  • 7 replies
  • 135 views

Mark Jongeling
Administrator

The Thinkwise platform currently supports SQL Server, Oracle and DB2, three widely used RDBMS. According to Statista, they are indeed quite a popular choice and suited for large enterprise-level applications we make with Thinkwise.

PostgreSQL (Postgres) is a open source RDBMS unlike the others, that there are no license fees, is highly extensible, and is used over all the world, even by major companies.

I would love to see the interest by the Community for the Thinkwise platform to support PostgreSQL.

Did this topic help you find an answer to your question?

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
NewOpen

Freddy
Forum|alt.badge.img+16
  • Thinkwise Local Partner Brasil
  • February 21, 2025
Mark Jongeling wrote:

The Thinkwise platform currently supports SQL Server, Oracle and DB2, three widely used RDBMS. According to Statista, they are indeed quite a popular choice and suited for large enterprise-level applications we make with Thinkwise.

PostgreSQL (Postgres) is a open source RDBMS unlike the others, that there are no license fees, is highly extensible, and is used over all the world, even by major companies.

I would love to see the interest by the Community for the Thinkwise platform to support PostgreSQL.

Concur, in Brazil I see it a lot as well alongside MongoDB (nosql). 


Mark Jongeling
Administrator
Forum|alt.badge.img+23

in Brazil I see it a lot as well alongside MongoDB (nosql). 

I have no experience with MongoDB to be honest, but I feel MongoDB is not so much suited for applications build with Thinkwise. Or am I mistaken ​@Freddy?


Forum|alt.badge.img+13
  • Hero
  • February 23, 2025

Regarding current developments we started having internal discussions around becoming less dependent on Microsoft. PostGreSQL support would be a very welcome addition to the SQL family for the Thinkwise platform. Personally I’m all for supporting open-source platforms. This is also why I’m highly motivated to get our Dotnet applications to run on a Linux platform, something we’re about to test internally and possibly transfer our development environment onto within the foreseeable future. Our SQL Servers already run on Linux machines and have been doing so successfully for many years.

Another consideration could be to switch the Thinkwise platform to a Dotnet fork. With alternatives for Windows, SQL Server and Dotnet the platform and thus our organization would be a lot less dependent on Microsoft software and services.

I hope more people will hop on this train as it might prove vital for continuity.

Small addendum: I’m not sure if it’s already supported but it could be nice to be able to plugin an on-premise LLM into the software factory specifically for reviewing and even writing SQL code. This LLM could have full access to the database for producing relevant code and because it runs on-premise it doesn’t have to talk to the outside world keeping our data safe.


Mark Jongeling
Administrator
Forum|alt.badge.img+23
Roland wrote:

Small addendum: I’m not sure if it’s already supported but it could be nice to be able to plugin an on-premise LLM into the software factory specifically for reviewing and even writing SQL code. This LLM could have full access to the database for producing relevant code and because it runs on-premise it doesn’t have to talk to the outside world keeping our data safe.

That's a great idea! Feel free to create an idea for this.


Forum|alt.badge.img+13
  • Hero
  • February 23, 2025
Mark Jongeling wrote:
Roland wrote:

Small addendum: I’m not sure if it’s already supported but it could be nice to be able to plugin an on-premise LLM into the software factory specifically for reviewing and even writing SQL code. This LLM could have full access to the database for producing relevant code and because it runs on-premise it doesn’t have to talk to the outside world keeping our data safe.

That's a great idea! Feel free to create an idea for this.

https://community.thinkwisesoftware.com/ideas/connect-software-factory-with-local-llm-5786

 


Freddy
Forum|alt.badge.img+16
  • Thinkwise Local Partner Brasil
  • February 24, 2025
Mark Jongeling wrote:

in Brazil I see it a lot as well alongside MongoDB (nosql). 

I have no experience with MongoDB to be honest, but I feel MongoDB is not so much suited for applications build with Thinkwise. Or am I mistaken ​@Freddy?

Hi ​@Mark Jongeling no, it's primarily No-SQL, but I was mentioning it because I think we had quite some potentials which came from Mongo DB. Perhaps an interesting one to add to the Upcycler. 

But PostgreSQL would be welcome, to have an open-source alternative to at least start with. 



Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings