{"id":21986,"date":"2022-02-23T11:00:50","date_gmt":"2022-02-23T10:00:50","guid":{"rendered":"https:\/\/beta.cybus.io\/product\/connectivity-portfolio\/sql\/"},"modified":"2024-09-02T15:10:21","modified_gmt":"2024-09-02T13:10:21","slug":"sql","status":"publish","type":"page","link":"https:\/\/www.cybus.io\/en\/product\/connectivity-portfolio\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"\n
\n
\n
Back to connectivity portfolio<\/a><\/div>\n<\/div>\n\n\n\n

SQL<\/h2>\n\n\n\n
\n\n\n\n

CONNECTIVITY PORTFOLIO | implement SQL<\/p>\n\n\n\n

What is SQL?<\/h3>\n\n\n\n

SQL (Structured Query Language) is the protocol used to connect and interact with relational databases like MySQL, MariaDB, PostgreSQL and so on. Relational databases are very popular and most often used to handle structured data with predefined relationships between them. The data is organized in tables and can be accessed using queries with different levels of complexity. <\/p>\n\n\n\n

What is SQL used for?<\/h3>\n\n\n\n

Using the Connectware SQL protocol, it is possible to establish connections to all network reachable databases, no matter if they are in the cloud or on premise. Data can be read using predefined queries. The queries are highly flexible to use when combined with variables that act as placeholders and are replaced at runtime. By displaying the requested data in JSON format, the data can be conveniently processed and easily transferred to other systems.<\/p>\n\n\n\n

While read accesses take place at defined points in time or in a certain interval, write accesses are carried out immediately. As with reading access, writing to a database is performed by specifying a query which will then be enriched with payload at runtime.<\/p>\n\n\n\n

Implement SQL with Cybus<\/h3>\n\n\n\n

Almost every use case relies on the ability to store and retrieve data \u2013 using the Connectware SQL protocol implementation, this can seamlessly be achieved without having to modify the database at all.<\/p>\n\n\n\n

\n
request demo<\/a><\/div>\n<\/div>\n<\/div><\/div><\/div><\/div>\n\n\n\n
\n
\n
\"Application<\/figure>\n<\/div>\n\n\n\n
\n

Application examples<\/h2>\n\n\n\n

Use Cases with SQL<\/h3>\n\n\n\n