There are many great companies that use PostgreSQL
Has the connector been updated to address this issue? The email below was posted on 2016-02-11; the GitHub repo was last updated shortly before that.
Ricardo Silva wrote:
Yes, the version that was posted on git prior to me updating this thread should include the fix to work in P9.1.
However, I did not get around to add support for Long Integers.
Maybe it'll happen now that OutSystems 10 is out :)
Correction. I'm sorry but no.
The repository was not updated. Thing is, what I needed to do was rebuild the connector with a different version of the SDK and that isn't a part of the repository.
I don't believe any change to the code was required, only to one of its dependencies.
You need to download the ardoPGSQL_QF.zip which I attached to my reply to Braxton.
Does anyone know if the Database Integration API has been removed? Found this post and though it would be great to write a wrapper around a proprietary interface to our own system but after contacting Outsystems support the response was just sorry you cant do it :(,.
The Database Integration API has not been removed.
Do you have an ADO.NET or JDBC driver for your system? If so, and if it behaves like a database, you should be able to use the Database Integration API.
No we don't have ado.net or jdbc drivers. I've looked through what documentation I can find and your code plus this presentation http://fast.wistia.net/embed/iframe/6aec9pc3r8?popover=true and realise that it will be hard but should be possible. The problem I'm having is that I when I try asking Outsystems support for access to the API they just keep saying "Unfortunately, as a non-supported database we don't have a workaround in order you to achieve such functionalities (scaffolding and data access)."
Investigating deeper and we can create our own ado.net driver if needed.
In that case, and if you are confident that your system behaves like a database (has tables with attributes against whom SQL queries can be made), I suggest you to contact support asking explicitly for access to the Database Integration API.
This way you can explore this venue.
yeah that's what I was trying to do but didn't get anywhere. Trying again.
Is possible to user this plugin in my personal environment in any way?
No, it's not possible to add additional database integration plugins on your personal environment.
You should install the platform on-premises or buy a full fledged PaaS in order to be able to make use of this plugin.
To everyone who might be interested, I have just released version 1.0 of ardoPostgreSQL database integration plugin.
It's for version 10 of OutSystems and should completely conform to the same introspection standards as the built-in plugins.
All feedback is welcome :)
Good job on this plugin.
It's very useful...
Is this available for both stack?
Can you point me out how to getting started on creating database plugin myself?
Thank you very much.
The plugin is available and fully supported for both .NET and Java stacks.
In order to build your own plugin you just need to get in touch with our Product Management to get access to the limited availability program surrounding the Database Integration API.
You have more information in this post from Arlindo.
Do we still need to do this boolean workaround in 1.0?
By the way which postgresql version does this database connector support?
well, I tested it against PostgreSQL 9.4 server.
The previous version was tested against 9.1 mainly, but not much changed since then.
The language is the same, so I'd say it supports whatever the base driver supports. If you find any issue with a specific version, please let me know and I'll try and look into it.