Tuscany, Italy

4 days / 20 talks
Awesome and great speakers

October 16-21

Graham Stevens

Graham Stevens started his professional career as a watchmaker, moving on to become a laboratory assistant creating new organic molecules for pharmaceutical and agrochemical research. While working at the chemical company, he discovered the Apple II in 1980, teaching himself to program in Basic and becoming the de facto IT guy in the process. In late 1984, he advised his employer to purchase an Apple Macintosh and the rest, as they say, is history.

In 1985, Graham started creating database applications for the company with Omnis 3, which was single-user in those days. No network issues or problems with record locking back then. He has been working with Omnis ever since, through all iterations, eventually, in 1996, converting his Omnis 7 chemical inventory and stock control applications to client-server with Oracle as the backend.

His Omnis to Oracle skills bagged him a job in Tenerife at the start of the millennium as lead developer and Oracle DBA in a large holiday ownership company, producing resort sales, reservations and front desk software. After a year away from the Omnis world, working as an Oracle PL/SQL developer, he is now based in the UK, programming in Omnis again on an exciting new project using the latest technologies available from Tiger Logic.
The conversion, which wasn’t for the weak of heart, ended up being more of a rewrite, as all the code was made more object-oriented and was re-coded to use SQL instead of Omnis Data Files. Throughout the conversion he learned how to eke out every ounce of performance from Omnis Studio using Omnis tricks and C++ externals.

In addition to Omnis he also has a great deal of experience with PostgreSQL, PL/PGSQL stored procedures and triggers, Objective-C, and C++ externals and has used it to great advantage to make Theatre Manager faster and more capable. He’s always on the lookout for cool new things to integrate into Omnis so that he can make faster and more useful software.

Beyond OmnisSQL

OmnisSQL has served the Omnis developer community well over the decades but its scope is limited. There is a powerful way to break through its limitations – enter SQLLite!

The ability to use SQL against the Omnis Native Datafile has been an invaluable asset to the Omnis community, but let’s face facts: it does have its limitations. This session is aimed at developers who may be considering a conversion to SQL or those who have hit some of those limitations of OmnisSql and are looking for an alternative.Using SQLite, a self-contained, serverless SQL database engine, this session will aim to highlight the advantages of moving to a fully transactional, ACID compliant relational database for your Omnis applications without the necessity of installing a database server.Some of the key topics to be covered include:• constraints• ANSI joins• subqueries• outer joins• views• WITH clause• LIMIT• transactions•

set operators – UNION, INTERSECT, MINUS/EXCEPT• triggers

Table Magic

The Power and Elegance of the Omnis Table Class

One of the hidden treasures of Omnis Studio. Frequently overlooked but the source of so much productivity.

The database is the skeleton upon which every business application works. Accessing that database and manipulating its contents is the most fundamental interaction between the user and the source (i.e. the data), facilitated by Omnis and you, the developer.

• The table class offers an incredible amount of power in terms of : • Standard SQL calls

• Enhancing your data access utilising SQL joins within a query very powerfully

• Accessing stored procedures

As a non-visual object and one that lends itself very effectively to OO principles such as inheritance and polymorphism, the table class is one of the most potent “starting points” in contemplating both a DML to SQL or Omnis 7 to Studio conversion. It offers the most fertile environment to introduce newcomers to the object oriented paradigm and “change the way you think” about programming.

In this presentation the table class is explored using an evolutionary process, building up from the standard SQL access Omnis offers and seeing how the table class can enhance the developer experience and productivity in several ways.

• Roll your own, reusable SQL

• Simplifying your data access code

• Exploiting OO principles

• Automating standard logging columns

• Simplifying multiple database access within a single application

• Accessing encrypted data

If you are not already using table classes, or if you suspect you are only scratching the surface, this presentation is for you!



Follow Graham




About workshops


You’ll sign up for the session you want to attend on a first-come, first-served basis. Up to 6 participants may attend a session, if full, you can sign up for the same topic at a different time. During the session, the speaker will guide the audience through the main topic but you will be able to ask him/her to deviate and cover related areas. Sometimes participants offer new ideas and solutions to a problem.

Check the


Pursue any question or area not directly related to the core topic. Every speaker hosts at least 4 sessions which means there are about 11 to 12 simultaneous sessions running all the time with an average of 5 or 6 participants

Meet the Speakers

Check the


Flexible conference format means you can choose the best classes for you and at the best time. Some sessions will be repeated, so when you miss one, you can attend the same session later in the day or the week.

Check the Schedule