Netherlands

4 days / 20 talks
Awesome and great speakers

November 3-8
https://i0.wp.com/www.omnisworld.co.uk/wp-content/uploads/2016/02/joemaus.jpeg?fit=320%2C320&ssl=1

JoeMaus

Joe works as an independent Omnis, database, and IT generalist consultant, using backends from Sybase, Oracle, MS SQL Server, and Postgres. He is currently involved in logistics, insurance, and horse show management using various versions of Studio and SQL database backends.

He began working with Omnis 3.1, moved to Omnis 7.3, and became an early Studio pioneer using version 1.2 (delivered to him on a hand written CD from Omnis Software!)

Historically, Joe has worked in various disciplines; from accounting apps for the graphic arts industry to systems to track defects and fixes in the astronautics field for Lockheed Martin. Other past projects include OB/GYN reporting and imaging, an Omnis ActiveX web application used by over 2000 sales people in 14 states, and radioactive inventory tracking. Most recently, in the logistics field, he has been using JSON with MS SQL Server to create files for sending to various shippers via web service interfaces.

Joe has spoken at past Omnis conferences, covering topics such as learning SQL in 4 days, smart lists, introduction to SQL and Advanced SQL sessions.

Joe lives in Wilmington, Ohio, USA. He became a Ski Patroller at the local “hill“ (in Indiana) in 2018 to get on the snow more often and help those having a bad day get through it safely and without further injury. You can also find him in Denver Colorado a few times a year, visiting friends, clients as well as skiing the larger hills in the Rockies.


JSON and complex objects

Reducing latency while delivering complex data structures to web clients in a single SQL call

See how JSON can help you handle complex structures in standard ways so everyone receives the same data from your database no matter how they consume the data (REST or function).

Omnis Studio works well with JSON.   With a bit of a framework, you can model and build complex objects easily, fetch them with a single fetch from the database, have them keep track of themselves and then update the database as necessary using JSON!

Performance can be 25% to 50% faster compared to traditional database accessor models!

In this session we’ll cover:

  • How JSON delivery assures data consistency
  • Building a JSON “table” and how to query JSON data
  • Building Postgres JSON functions to package, return, and update data using REST and regular Omnis queries
  • Showing an Omnis window consuming JSON by RESTful and Postgres functions and performing updates to the database using JSON
  • Integrating ChatGPT (or similar AI) into your development efforts

Advanced SQL topics focusing on your challenges!

Harnessing the power of SQL

See how advanced SQL itself can get data the way you want it with one fetch from the database and eliminate costly Omnis side workarounds like looping thought lists.

Bring your SQL challenges to this hands on session to work through advanced SQL topics like pivots, analytic functions, aggregations, inline views, Common Table Expressions (CTEs), and more and see how your challenges in getting data from the database with speed and efficiency can be handled.

In this session we’ll cover such topics as:

  • Good SQL practices and tricks along with an introduction to transactions
  • Indexing and temp tables
  • Group by and aggregation in general
  • Table pivots that work on any backend (examples: aged receivables lists, quarterly sales reports by region)
  • Top N results (eg top 10 customers) and difference queries
  • Integrating ChatGPT (or similar AI) into your query building efforts
  • Plus, we’ll devote time to your specific SQL challenges!


Make

Connection

Follow Joe


Meet

Company



About workshops

Format

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

Speakers

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

Schedule

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