{"id":1086,"date":"2018-08-27T20:03:11","date_gmt":"2018-08-27T20:03:11","guid":{"rendered":"https:\/\/labdeck.com\/?page_id=1086"},"modified":"2023-12-28T22:37:44","modified_gmt":"2023-12-28T22:37:44","slug":"databases","status":"publish","type":"page","link":"https:\/\/labdeck.com\/databases\/","title":{"rendered":"Databases"},"content":{"rendered":"\n

MatDeck has incorporated a range of functions and tools that can be used for straightforward and effective data exchange with Microsoft SQL, MySQL, PostgreSQL and SQLite databases. The user can store and read large amounts of data, combine this data with GUI elements to create a diverse range of applications and forms; as well as saving the results of the calculations into one of the supported database engines, reading and modifying the stored data and sharing it.<\/p>\n\n\n\n

The main advantage of using MatDeck to work with databases is the simplicity of its usage and interaction with database engines. All supported database engines interact with MatDeck documents and scripts through the same functions and GUI elements; you can use the SQL syntax of the engine you are working with but through the same scope and aim of MatDeck functions to finish projects faster. Database data can be stored locally in MatDeck variables, tables and other objects, you can also print them in a row format, manipulate them or visualize them in graphs or GUI gadgets\/apps<\/p>\n\n\n\n

With MatDecks Database Browser we can establish a connection with any supported database engines: Microsoft SQL, MySQL, PostgreSQL, and SQLite.  When choosing one of the database engines radio buttons, the form adapts itself by setting the engine default port and enabling\/disabling the GUI elements needed to establish connection. The Database Browser enables you to view: data stored in  database tables; you can find out how tables are defined; what are the names of columns; what data type they can store; column default values; what kind of keys are used; column character sets, collations, privileges and so on.<\/p>\n\n\n\n

\"data
Data Preview<\/figcaption><\/figure>\n\n\n\n
\"table
Table Definition – Column Properties<\/figcaption><\/figure>\n\n\n\n

There is also tab that can show the database Data Definition Language (DDL) script for the table,<\/p>\n\n\n\n

\"ddl
DDL Table Script<\/figcaption><\/figure>\n\n\n\n

Indexes and Triggers definitions and additional properties<\/p>\n\n\n\n

\"table
Table Indexes<\/figcaption><\/figure>\n\n\n\n

From the Query <\/em>tab we can execute custom queries and view the execution results<\/p>\n\n\n\n

\"custom
Custom Query Execution<\/figcaption><\/figure>\n\n\n\n

MatDeck Database Browser is simple yet very useful tool which empowers users to accomplish basic interactions with databases, and to find out all database\/tables definitions and properties that can help them in further database interactions through MatDecks functions and script.<\/p>\n\n\n\n