DEV Community

Alejandro Duarte
Alejandro Duarte

Posted on • Edited on

1

Getting started with SkySQL using Java, JavaScript, and Python

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 is a second-generation cloud database service for deploying:

On:

Integrating with:

  • Qlik - Extend SkySQL into live streams to enable modern analytics and microservices
  • Striim - Build real-time data pipelines with SkySQL
  • MindsDB - Rapid Generative AI Development and Deployment using SQL

And with features such as:

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 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” 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

There are also a series of YouTube videos on:

MariaDB official YouTube channel

If you prefer source code, there’s a GitHub repository with examples in Java, JavaScript.js, and Python 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 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

Heroku

Build apps, not infrastructure.

Dealing with servers, hardware, and infrastructure can take up your valuable time. Discover the benefits of Heroku, the PaaS of choice for developers since 2007.

Visit Site

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay