Getting started with SkySQL using Java, JavaScript, and Python
Published: 2023-06-09 13:52:09

Unless you have a single server running on-prem with quick physical access to it and no need for high availability and scalability, managing databases is not that easy. System updates, security configurations and patches, provisioning, monitoring, networking, replication, scalability, backup management, and cost control, among others, are aspects that you have to keep in mind when deploying databases. Software developers want a database that’s boring, but at the same time exciting because it just works. This is exactly what SkySQL offers.


## What is SkySQL?

[SkySQL](https://mariadb.com/products/skysql/) is a second-generation cloud database service for deploying:



* A single instance of [MariaDB Enterprise Server](https://mariadb.com/docs/server/products/mariadb-enterprise-server/)
* A cluster of MariaDB Enterprise Server with one primary and multiple [replicas](https://mariadb.com/docs/server/data-operations/replication/enterprise-server/) for read-scalability
* A [MariaDB ColumnStore](https://mariadb.com/products/columnstore/) cluster for analytics
* A [MariaDB Xpand](https://mariadb.com/products/enterprise/xpand/) cluster for read and write-scalability
* A serverless [Apache Spark](https://mariadb.com/products/skysql/serverless-analytics/) engine with a notebook for AI/ML analytics

On:



* [Amazon Web Services](https://aws.amazon.com/marketplace/pp/prodview-uaoi4womvi6la)
* [Google Cloud Platform](https://console.cloud.google.com/marketplace/product/mariadb-public/mariadb-for-gcp)
* Others (like Azure) are coming soon

Integrating with:



* [Qlik](https://www.qlik.com/us/trial/replicate?ga-link=qdi-hero) - Extend SkySQL into live streams to enable modern analytics and microservices
* [Striim](https://go2.striim.com/aws-trial) - Build real-time data pipelines with SkySQL
* [MindsDB](https://cloud.mindsdb.com/register/mariadbskysql) - Rapid Generative AI Development and Deployment using SQL

And with features such as:



* [Remote observability](https://mariadb.com/docs/skysql-dbaas/service-management/nr-monitoring/observability/) of MariaDB databases deployed outside SkySQL (including on-prem)
* [Cloud backup](https://mariadb.com/docs/skysql-cloudbackup/cloudbackup-management/) management of MariaDB database deployed anywhere
* [SQL query editor](https://mariadb.com/docs/skysql-dbaas/connect/nr-query-editor/) for running SQL statements and visualizing tabular data
* [Automatic scaling](https://mariadb.com/docs/skysql-dbaas/service-management/nr-autonomous/) on workload changes (up/down and in/out)
* [Geospatial data service](https://mariadb.com/products/skysql/geospatial/) to create web services from aerial imagery, elevation, or other geospatial data
* [Developer Notebook](https://mariadb.com/resources/blog/new-mariadb-skysql-release-adds-serverless-analytics-auto-scaling-query-editor-and-more/): Explore data on any SkySQL service, no ETL code required
* [Query Federation](https://mariadb.com/resources/blog/new-mariadb-skysql-release-adds-serverless-analytics-auto-scaling-query-editor-and-more/): Join across SkySQL services and any Spark Datasource

In summary, you can handle any kind of data workload with the database services available in SkySQL. Connecting to a database deployed using SkySQL is the same as connecting to a secured MariaDB database server running on-prem or in any cloud—use the [MariaDB Connector](https://mariadb.com/docs/skysql-previous-release/connect/programming-languages/) for your programming language and you are good to go.


## Connecting to SkySQL services

You can learn more about SkySQL by watching the recording of the webinar “[Developing Unstoppable Applications with the SkySQL Cloud Database Service](https://go.mariadb.com/23Q2-WBN-GLBL-DBaaS-Developing-Unstoppable-Applications-SkySQL-2023-03-28_Registration-LP.html)” in which I explain what a second-generation database service is, why you need it, how to use the SkySQL portal, and how to connect to SkySQL services.



![Developing unstoppable applications with the SkySQL cloud database service](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/t63rgpaojoe005cdhtd5.png)


There are also a series of [YouTube](https://www.youtube.com/mariadb) videos on:



* [Get started with SkySQL and create your first database in the cloud for free](https://www.youtube.com/watch?v=qDJYn8xmIy8)
* [Connect to SkySQL services from tools like DBeaver and IDEs](https://www.youtube.com/watch?v=x9mSb6yzH7k)
* [Connect to SkySQL services from Java](https://www.youtube.com/watch?v=MZY2Q7DjueM)
* [Connect to SkySQL services from JavaScript/Node.js](https://www.youtube.com/watch?v=7DaLCWs2piU)
* [Connect to SkySQL services from Python](https://www.youtube.com/watch?v=RGJSIqKk1oM)



![MariaDB official YouTube channel](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ichutjm3i3w2k7vsn07k.png)


If you prefer source code, there’s a [GitHub repository with examples in Java, JavaScript.js, and Python](https://github.com/mariadb-developers/skysql-quickstart) that show how to connect to SkySQL services using the MariaDB Connectors without using persistence frameworks. If you want to use persistence frameworks, you can use the same connection parameter values shown in these examples.


## Trying SkySQL for free

You can create a database in the cloud in seconds for free using SkySQL. You don’t need a credit card. Sign up at [https://skysql.mariadb.com](https://skysql.mariadb.com/) using your Google, GitHub, LinkedIn, or email accounts and create a new service. Then explore your new service using the provided trial credit in your SkySQL account.



![SkySQL portal sign up page](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4og845s79e368goiye7t.png)