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

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!