Skip to main content

Introduction

Welcome to the world of database creation within our Digisquares platform. In this guide, we'll take you on a journey through the process of designing and managing databases without the need for extensive coding expertise. Whether you're a seasoned developer or just starting your coding journey, our Digisquares platform simplifies the creation of databases, making it accessible and efficient.

Multi-Database​

We support multiple popular SQL databases to offer flexibility and compatibility for various business needs:

  • MySQL: One of the most popular open-source databases for web applications.
  • PostgreSQL: Known for its advanced features and support for large-scale applications.
  • SQLServer: Microsoft's database solution that integrates well with Windows applications.
  • MariaDB: A community-developed fork of MySQL that remains fully open-source.

These databases all follow the common SQL language standard, with slight variations in advanced features, data types, and performance characteristics. Our Digisquares platform allows easy integration and seamless management across these databases, making it easy for businesses to scale.

Database Connection Types​

In the Digisquares platform, you can manage databases with two types of connections:

1. Default Connection​

The default connection is set up when you create your project. Based on the database selected during the project creation, the platform automatically configures and manages this default database connection. This ensures that all necessary operations and configurations are handled seamlessly without additional input.

  • Automatic Setup: The platform handles the connection to the selected database automatically.
  • Pre-configured: Database settings are optimized based on the selected project type.
  • No extra configuration required: You can start working with your database as soon as the project is created.

2. External Connection​

The external connection provides flexibility by allowing you to integrate with an existing or external database. This gives you the ability to connect to and manage databases that are hosted outside of the Digisquares platform.

With this feature, you can set up Integrations to connect to your external databases, offering a powerful way to extend the platform’s database management capabilities.

  • Flexible Integration: Connect to any external database of your choice.
  • Seamless Management: Once integrated, you can manage your external database within the platform just like a default connection.
  • Custom Configuration: Tailor the integration to meet your database requirements and ensure optimal performance.

Both connection types allow you to effectively manage and scale your databases according to your project's needs, whether using the built-in default connection or an external one through integration.

1. Creating Tables​

Creating a table is one of the fundamental steps in database management. To create a table, you must start by specifying a unique table name, followed by adding columns with appropriate data types and attributes. You can find more detailed information on table creation here.

2. Adding Indexes​

Adding indexes to a table is crucial for optimizing query performance. When creating an index, you can specify a unique index name, select the type of index that best suits your needs, and choose the columns to include. Learn more about adding indexes here.

3. Procedures​

Creating Procedures​

  • We support AI to help create stored procedures with ease. A procedure is a stored set of SQL statements that can be executed as needed. To create a procedure, specify a unique procedure name, define the parameters, and write the SQL logic. You can also explore the steps to create a procedure here.

    CREATE PROCEDURE procedure_name (IN parameter INT)
    BEGIN
      -- Procedure logic goes here
    END;

4. Functions​

Creating Functions​

  • We support AI to help create SQL functions. A function is similar to a procedure but returns a value. To create a function, specify the return type, parameters, and the SQL logic. You can explore more about creating functions here.

    CREATE FUNCTION function_name(parameter INT)
    RETURNS INT
    BEGIN
    RETURN parameter * 2; -- Example logic
    END;
Did you know?

There are many popular SQL databases including SQLite, MySQL, Postgres, Oracle and Microsoft SQL Server. All of them support the common SQL language standard, which is what this site will be teaching, but each implementation can differ in the additional features and storage types it supports.

Summary​

The ability to create databases in a Digisquares platform empowers organizations by accelerating database development, enabling non-technical users to participate, simplifying integration with other systems, and facilitating scalability and flexibility. This ultimately leads to increased productivity, faster time-to-market, and improved data management capabilities for businesses.