Agenda & Information for the Meetings held in 2019. See Next Meeting for next meeting.
For each of the meeting dates there is a link to the meeting summary.
See Downloads 2019 for the available files associated with the meetings
Date: 11th March 2019
- Home-grown RAD Server – Brian Long & Nick Gabb
Put off by the dizzying fees EMBT charge for RAD server licensing I decided to “grow my own” system to suit the needs that I’d considered RAD Server for. After some brain-storming, chewing the cud and generally putting the world to rights an idea gestated that we thought just might cover all the required bases. A general purpose minimalist REST server implemented in C#, which defers all requests to a Delphi DLL using a simple parameterised control mechanism, resulting in flexibility and performance. This session looks in more detail at the requirements and the implementation.
- Advanced SELECT SQL: Nested statements, other tips and tricks, cursors and procedures – Adam Brett
SQL started as a syntax to define and retrieve data from relational databases. As data-structures have grown more complex SQL has developed to a point where it now more-or-less qualifies as a language. Many programmers know a little SQL, but often use compiled code to do a lot of the “hard graft” of managing data, and therefore have limited knowledge of the full breadth and power of modern SQL.
This session may be the first of several, and is intended to be of an intermediate standard and review “somewhat more advanced” aspects of SQL SELECT and data retrieval, working on beyond basic SELECT statements, looking at and reviewing common pitfalls and gotchas. While this appears a basic problem, it can become complex, if users are attempting to collate large and complex relational data-structures.
The session will be interactive, with SQL queries being written and compared through the session. Know-alls in the room will be welcome to pitch in, particularly to discuss differences between the SQL demonstrated and their own versions of the language, and perhaps also with better ways to write particular statements.
There are many sub-dialects of SQL. This session will use ElevateDB, a written-in-Delphi relational SQL database which fully implements the ISO-SQL-2003 standard. This should mean that most of the SQL covered is common and comprehensible to those present.
- SQL Server black-box – Mark Jacobs
Using FTP only to talk to the server and upload/maintain web pages the nugget will cover:
MS SQL server and connecting to it.
Database and table maintenance considerations.
Email invitations and password resets.
User levels and maintenance.
Date: 13th February 2019
- Talk: Taekwondo Case Study – Neil Parrish
Neil recently provided software for coverage of the Manchester Taekwondo Grand Prix, shown online by the BBC. The system took feeds from the electronic scoring system and combined it with
info from the venue system to drive the TV graphics. We’ll see how it all worked, what was easy and what was not including how to produce a REST server with Delphi Pro.
- Nugget: Dynamically Decoding Googles search results – Mark Jacobs
I devised a random website page on my jacobsm.com, which uses a dictionary of search words (the English dictionary with 267,751 words in it). It selects a word at random from this list and then uses Google search to get the first 25 results within the last month into a list. It then selects one of these 25 links at random and attempts to render it in an IFRAME on the random site page. I will be demonstrating it in action, and dissecting how it works and the caveats I had to program around in order to get it working properly.
- Talk: Auto-generated SQL v. write your own in SQL Server – Eric Thorniley
We have two opposite approaches to connecting to databases. We can use an object-relational mapper (ORM) which allows us to create our business objects and persist them without troubling ourselves with any SQL – it does it all for us. The alternative is to start by designing the data structure in the database and then build our code to use it.
I have a project where the supplier of the main system used a commercial ORM system but, in my extensions to it, I used the old-fashioned method of designing a data structure first. The connection between the two system was via hardware controllers that knew nothing of either database.
I will go through some of the consequences of the two approaches, including some significant performance issues.
- Nugget: RAD Server – Ian Hamilton
An intro to RAD Server, what it is and how to start with it.
Date: 15th January 2019
HMRC’s “Making Tax Digital”
- Talk on HMRC’s Making Tax Digital
- Talk on how to work with OAUTH-2
- Talk on HMRC’s documentation
- Discussion on how to consume RESTFULL API’s in general
- Code Huddle – 3 groups – how far can you?
For the rest of 2019 dates
Agendas for previous years can be found here: