Invitation to Rubicon RAD REST presentation August 17 2022 via Zoom in Oregon

It has been very quiet on this forum lately. That’s fine with me!

Personally, I have been working on a completely new type of sample project for Rubicon, which combines many interesting technologies (below). I am working up to explaining all this to the Oregon Delphi User Group on August 17th, and very much hoping that people can get some new ideas about how to build custom search engines with Delphi.

All the source code will be in the webhubdemos project which is open source and in subversion on sourceforge. The project is still being fine-tuned and the source code probably will not fully settle for another couple of weeks.

Highlights:

  • Delphi customized RAD REST compiled for win64 to give search results over http(s) in json, suitable for any browser javascript client as we as any custom client you might care to write with Delphi or any other languarge.

  • FireDAC with Postgresql for the TEXT and WORDS, hosted on Amazon AWS RDS.

  • The sample content is a blog ( my blog, as it happens ) with very little data but a full-featured custom search engine, so that we can show some of what Rubicon can do.

  • The main web site content was done in the simplest possible way, essentially as static .html files hosted on S3 and then surfaced with AWS CloudFront for speed. There is a database-driven engine behind this, which does the exporting. That was coded with Delphi and WebHub. In spite of the content being static, the searching is fully dynamic, going against a separate URL over https. The basic idea can be implemented with any web framework.

  • The RAD REST executable runs on a AWS EC2 instance (t2.nano with Windows). It runs securely over https on port 8080 (only to avoid conflict with other things that run on ports 80 and 443 already on the machine). The secure certificate was provided by LetsEncrypt (free) and hooked into the Indy IOHandler. The certificate was generated by WACS (aka win-acme, win-acme.com which is my favorite LetsEncrypt client on Windows.

  • We have implemented a dynamic version of the blog site using Go in addition to WebHub, and we (Ann and Manya) worked out a way to share the syntax across both of those systems. We shared both the SQL queries themselves plus the HTML markup that generated all the pages.

  • The Rubicon TEXT is surfaced via a SQL view making use of a Postgresql feature that I only just learned about, namely STRING_AGG.

For details about the presentation including getting the Zoom link on the day, please visit https://odug.org/2022-08

Best,
Ann

1 Like

I’m excited to hear this presentation! And as the coordinator for the Oregon Delphi User Group, I’d like to warmly welcome anyone who wants to join this meeting by following the link to ODUG’s web site: Add Full Text Search to Your Delphi Web Apps using Rubicon and REST | Oregon Delphi User Group and click the “Register in advance” link to get a confirmation email containing the Zoom meeting link (that registration link is available now–save your spot!).

It’ll be held at 6:00 PM PDT (Pacific Daylight Time) so if that doesn’t work for you, the meeting will be recorded and made available afterwards.

I hope to meet some of you online on Wednesday!

David Cornelius
Cornelius Concepts, LLC
Coordinator, ODUG

1 Like

The presentation went very well and we all learned a lot.

For a recording of the presentation and to download a PDF of the slides, visit the announcement page of the ODUG website: Add Full Text Search to Your Delphi Web Apps using Rubicon and REST | Oregon Delphi User Group

Thank you for organizing it all, David !

Cheers.