Melbourne ADUG Meeting, Monday 19 February 2024 (Tomorrow)

Hi,

I saw Graeme’s message about Firebird UDF’s and earlier today thought I would have a play which I did, So I thought I might talk about that tomorrow briefly.

Also, [hopefully] long time on my list to look at has been PostGresql.

So a bit of database.

Finally, but perhaps importantly I need to organise some more presentations for our meetings for the coming year (or a least a few months).

Thanks

When: 6:00pm for a 6:15pm start
Where: At the Melbourne Men’s Shed, and on Zoom.

Zoom link will be up here shortly before the meeting starts.

1 Like

Hi Roger

Are you a FireBird user?

If you are can I contact you if I have any questions.

Re your talk: are you speaking about UDF’s, UDR’s for both?

Regards
Graeme

Topic: Melbourne ADUG Meeting
Time: Feb 19, 2024 06:00 PM Canberra, Melbourne, Sydney

Join Zoom Meeting

Meeting ID: 856 0861 4173
Passcode: 334507


One tap mobile
+61731853730,85608614173#,*334507# Australia
+61861193900,85608614173#,*334507# Australia


Dial by your location
• +61 7 3185 3730 Australia
• +61 8 6119 3900 Australia
• +61 8 7150 1149 Australia
• +61 2 8015 6011 Australia
• +61 3 7018 2005 Australia
• +1 312 626 6799 US (Chicago)
• +1 346 248 7799 US (Houston)
• +1 360 209 5623 US
• +1 386 347 5053 US
• +1 507 473 4847 US
• +1 564 217 2000 US
• +1 646 558 8656 US (New York)
• +1 646 931 3860 US
• +1 669 444 9171 US
• +1 669 900 9128 US (San Jose)
• +1 689 278 1000 US
• +1 719 359 4580 US
• +1 253 205 0468 US
• +1 253 215 8782 US (Tacoma)
• +1 301 715 8592 US (Washington DC)
• +1 305 224 1968 US
• +1 309 205 3325 US

Meeting ID: 856 0861 4173
Passcode: 334507

Find your local number: Zoom International Dial-in Numbers - Zoom

Do we have a problem ? (Waiting for meeting to start).

Robert
0405 808 433

Hi Geoff

Is the zoom meeting open yet?

Regards
Graeme

Sorry Geoff will be here shortly.

Meeting links

https://www.firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref40/fblangref40-ddl-extfunc.html

https://www.google.com/url?sa=i&url=https%3A%2F%2Ftvtropes.org%2Fpmwiki%2Fpmwiki.php%2FMemes%2FItsAlwaysSunnyInPhiladelphia&psig=AOvVaw0Nd8FvR7zyW-IdGBZkWMGM&ust=1708420158469000&source=images&cd=vfe&opi=89978449&ved=0CBMQjRxqFwoTCMiV0JWGt4QDFQAAAAAdAAAAABAE

1 Like

Further info on the fastest language

Language Race - Introduction on how the contest was set up:

https://www.youtube.com/watch?v=pv4Yq35Chx0

A list of the videos:

https://www.youtube.com/playlist?list=PLF2KJ6Gy3cZ5Er-1eF9fN1Hgw_xkoD9V1

The Top 5 Fastest Languages

https://www.youtube.com/watch?v=pSvSXBorw4A

I assume this is the repository

https://github.com/PlummersSoftwareLLC/Primes

The complete list of results?

https://github.com/luizsol/primesresult

1 Like

Issue with Getit last night:

Getit on 11.2 issue, a possible fix.

Regedit

(Adjust this location for your setup, but likely 22.0)
Computer\HKEY_CURRENT_USER\SOFTWARE\Embarcadero\BDS\22.0\CatalogRepository

Change ServiceURL, make it https://getit.embarcadero.com

Restart/Start Delphi.

With luck getit will now work, but not sure if codesite express is still available on it.
I can’t see it, but then I have full version installed, so it might hide it.

1 Like

Thanks Roger

Will have a look later this arvo

Regards
Graeme

From Monday, some URLs for Firebird UDF’s

URLs.

How to write UDF’s in Delphi?
https://www.firebirdfaq.org/faq83/

Tutorial on Firebird 3.0 UDFs / External Functions (A question, no real answers)
https://stackoverflow.com/questions/45119198/tutorial-on-firebird-3-0-udfs-external-functions

(Very old)
https://firebirdsql.org/en/writing-udfs-in-delphi-for-interbase-firebird/

Some Docs
https://www.firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref30/fblangref30-ddl-extfunc.html

1 Like

I posted this on the main Delphi fb group … @Roger_Plant 's suggestion got things (at least appearing to) work here
in the two out of four versions I had where GetIt wasn’t running.

@glenn.dufke suggested it might not be the best idea …
but I guess if this issue was holding you up from doing things … ¯_(ツ)_/¯

If it was for serious code … maybe you wouldn’t want to take a chance on a hack with your lifeline IDE.
Maybe there could be subtle bugs introduced if you installed something that thought it was one version instead of another ???
(But you’d kinda hope the actual installation process (vs the UI / network access part) would be solid enough not to allow something it shouldn’t)

I’d like to think I am personally responsible for this progress. :rofl:

Hi Paul

I did try Roger’s suggestion but had no success - still timed out.

I even entered the URL Roger suggested into my browse and got an error.

That was yesterday; I’m going to try on another machine tomorrow.

Regards
Graeme

Hi Paul

After noticing Darian Miller’s post I tried Getit and was able to successfully view the avaiable Getit entries for Delphi 11.3.

Success at last.

Regards
Graeme

1 Like

You should not amend your registry keys for 20, 21 and 22 - it may appear to work but in fact it will not. You will almost certainly get served up erroneous packages at best and corrupt your installation at worst.

Don’t do it! :grimacing:

1 Like

Thank you for that :slight_smile:

1 Like