Database Access and Table Classes: Episode 9 of Web AppDevelopment Basics with Omnis Studio скачать в хорошем качестве

Database Access and Table Classes: Episode 9 of Web AppDevelopment Basics with Omnis Studio

In this video, you will learn how to connect an Omnis Studio application to a database. Step by step, you will learn how to use the integrated database tool to create a SQLite database, create tables, and use table classes to store and retrieve data from your studio application. Although this video demonstrates the connection to SQLite, you can also use Omnis Studio with other relational databases such as MySQL, PostgreSQL, Oracle, and many more. The concepts shown can be applied to these systems. You can find more information here: https://www.omnis.net/developers/reso... This video offers a practical introduction to database connectivity and helps you to further develop your applications professionally. What you will learn in this episode: • Creating a database session with the SQL browser • Creating database tables using the SQL browser and schema classes • Configuring the database connection in your studio application • Configuring a table class • Loading and displaying data in a list variable • Saving data from a “Row” variable to the database. Recommended background knowledge:    • Variable Scopes: Episode 4 of the ser...   Gs1tsCY-_RUBOV&index=4 Here you can download the library and the SQLite database with the state from the 9th episode: https://drive.google.com/drive/folder... cNfTXpv4lfKvvfwepwM6?usp=sharing Sections covered in this video: 00:00 Welcome 01:59 SQL Browser 02:57 Set up SQLite database 03:58 Table set up via Schema 05:43 Connecting application with the database 07:34 Table Classes 10:18 Load data 11:35 Save records 13:26 Enhancement challenge and conclusion Find more from us here: Facebook:   / omnisstudio   Instagram:   / omnissoftware   LinkedIn:   / omnis-software-ltd   X: https://x.com/Omnisstudio