PostgreSQL for Hollywood

Show off your project created with Hollywood
Post Reply
User avatar
msu
Posts: 43
Joined: Mon Jun 13, 2016 11:36 am
Location: Sinzig/Germany

PostgreSQL for Hollywood

Post by msu » Sun Apr 28, 2019 5:39 pm

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

User avatar
airsoftsoftwair
Posts: 2985
Joined: Fri Feb 12, 2010 2:33 pm
Location: Germany
Contact:

Re: PostgreSQL for Hollywood

Post by airsoftsoftwair » Tue Apr 30, 2019 9:10 pm

Nice!

p-OS
Posts: 103
Joined: Mon Nov 01, 2010 11:56 pm

Re: PostgreSQL for Hollywood

Post by p-OS » Wed May 01, 2019 1:25 am

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)

User avatar
msu
Posts: 43
Joined: Mon Jun 13, 2016 11:36 am
Location: Sinzig/Germany

Re: PostgreSQL for Hollywood

Post by msu » Wed May 01, 2019 11:02 am

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!

User avatar
msu
Posts: 43
Joined: Mon Jun 13, 2016 11:36 am
Location: Sinzig/Germany

Re: PostgreSQL for Hollywood

Post by msu » Sun May 05, 2019 5:39 pm

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

User avatar
msu
Posts: 43
Joined: Mon Jun 13, 2016 11:36 am
Location: Sinzig/Germany

Re: PostgreSQL for Hollywood

Post by msu » Fri May 17, 2019 8:35 pm

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.

User avatar
msu
Posts: 43
Joined: Mon Jun 13, 2016 11:36 am
Location: Sinzig/Germany

Re: PostgreSQL for Hollywood

Post by msu » Tue Jun 04, 2019 2:34 pm

Important:
The current version 1.0 currently has problems receiving large amounts of data.
There will be an update in the next few days.

Post Reply