Page 1 of 1

PostgreSQL for Hollywood

Posted: Sun Apr 28, 2019 5:39 pm
by msu
The library allows Hollywood programs to communicate with PostgreSQL servers.
It should work with all supported operating systems.
I tested with Windows10, Android and AmigaOS3.9.

The current version is still in the alpha stage.

Download Version 1.0 alpha 2:
https://drive.google.com/open?id=1YF0_s ... zOFTGT5GLM

The documentation is unfortunately still in German.
The source code and examples are provided with comments in English.

Greetings, Michael

Re: PostgreSQL for Hollywood

Posted: Tue Apr 30, 2019 9:10 pm
by airsoftsoftwair
Nice!

Re: PostgreSQL for Hollywood

Posted: Wed May 01, 2019 1:25 am
by p-OS
I never used Postgre till now, but have experience with msql, mysql, Oracle, sqlite3. As there is no up2date mysql port to MorphOS (only old v4), but a quite decent one of Postgre, I likely will give it a try.

Thanx for this !

Your documentation is good ,too. But maybe you'd like to add the output of your examples in the tutorial section ?


I wonder why you decided to manually open the connection with the standard Hollywood function OpenConnection and the call your OpenDatabase statement ?
It might have been a good idea to have sth. like that:

Code: Select all

OpenDatabase(hostname,port,database,user,pwd)
or

Code: Select all

OpenDatabase("hostname:port:database",user,pwd)

Re: PostgreSQL for Hollywood

Posted: Wed May 01, 2019 11:02 am
by msu
Hello p-OS
p-OS wrote:
Wed May 01, 2019 1:25 am
I likely will give it a try.
Would be nice.
The more people test, the better the library becomes.
p-OS wrote:
Wed May 01, 2019 1:25 am
Your documentation is good ,too. But maybe you'd like to add the output of your examples in the tutorial section ?
Good idea.
I will do with the next version.
p-OS wrote:
Wed May 01, 2019 1:25 am
I wonder why you decided to manually open the connection with the standard Hollywood function OpenConnection and the call your OpenDatabase statement ?
It might have been a good idea to have sth. like that:
Code: Select allOpenDatabase(hostname,port,database,user,pwd)
Also a good idea.
Will try to implement that.

Thanks for the suggestions!

Re: PostgreSQL for Hollywood

Posted: Sun May 05, 2019 5:39 pm
by msu
Here is a new update.

Version 1.0 beta 1 (04.05.2019)
  • BLOBs (Binary Large Objects) are supported.
  • PG: OpenDatabase has been redesigned. The network connection will now be opened by the function itself.
  • The documentation has been adapted and expanded.
Please note:
The download location has changed. :oops:
You can download the library from now on in the German-speaking Hollywood forum.
https://forum.amiga-resistance.info/vie ... =38&t=3591

Greetings, Michael

Re: PostgreSQL for Hollywood

Posted: Fri May 17, 2019 8:35 pm
by msu
Since the last beta I have written programs testing this library.
I was able to find and fix a lot of bugs. Most of these were small mistakes, such as unreleased resources.
All in all, many millions of database queries have been completed in the past few days. That's why here is the first final version.
The binding variables have been added to the #SHORT type.

Re: PostgreSQL for Hollywood

Posted: Tue Jun 04, 2019 2:34 pm
by msu
Important:
The current version 1.0 currently has problems receiving large amounts of data.
There will be an update in the next few days.