Integrate and Connect Any Database

You can interface with any type of database, whether relational or non. You can create your database directly in the Instant Developer IDE, or connect to any existing database and manage it.

Yes. In the Instant Developer IDE you can design and create your databases from scratch.

The solution conceived for exactly this situation is the Cloud Connector, the ad-hoc system included in Instant Developer that provides secure, high-performance access to data from the cloud, without needing to open the company network to the outside.

The ORM (Object Relational Mapping) model in Instant Developer is a powerful object-oriented data manipulation system that enables you to free yourself from the complexities of managing queries, since you don’t use them directly on the database. It also frees you from the need to adapt your code in order to interface with the various types of DBMS usable in the projects. Here is a short list of the advantages:

• Design of the data model directly from the development environment.
• Automatic management of translating queries among the various database languages.
• Security, prevention of SQL Injection.
• Automatic deploy both in the cloud (PostgreSQL, Oracle, SQL Server, MySQL, DB2, AS400) and in offline devices (SQLite).
• Integration of databases, file systems, and on-premise services with the cloud.
• Optimization of query performance.
• Instant Developer’s ORM framework is isomorphic, making it suitable for all usage contexts (web, mobile, PWA), not just in the back-end. The code always produces the same results, so it doesn’t need to be rewritten for different contexts.

The translation of queries among the various database languages is managed automatically. All you need to worry about is using the ORM (Object Relational Mapping) paradigm in your code to insert, edit, or delete records from the database. Then Instant Developer will take care of composing the necessary queries based on the DBMS.

Absolutely. Instant Developer converts and stores all your code in an object graph, connecting all the elements of the information system. That’s why it understands the code you’re writing, helping to implement best practices in terms of security. For example, in writing SQL code you’re always automatically protected against SQL Injection types of attacks. If you’re not using Instant Developer, you can never be completely sure that you might not suffer an attack on your database!

The base libraries already include the components and services that programmers use most. Integrating others is easy, because you simply import them as packages.

Whether you’re developing a mobile app or a web app, you can turn to the web to get third-party components that meet your needs, including open-source ones, and integrate them into your app. For example, you can integrate Cordova plug-ins, Node.js packages, and JavaScript libraries, but the possibilities are endless, and you’ll always have the option to do so when you want to implement any type of functionality that modern cloud applications require and customize the server-side or client-side behavior for your app.

Yes. Instant Developer allows you to use third-party APIs and change them as needed or to develop APIs from scratch so you have maximum integration flexibility.

The Instant Developer synchronization framework allows for structured management of the interaction between the back-end and devices and of the complete lifecycle of the connection. Because of this, you can easily develop apps that can also work without connectivity.

Instant Developer allows you to manage all the complexities of the digital transformation system architecture, where the various components must communicate with each other, often in real time. Messaging, IoT notifications, and aligning an offline database with its cloud counterpart are just a few examples of the problems with these systems that the Instant Developer synchronization framework was designed to solve.

Instant Developer includes a synchronization and messaging exchange system among application and device sessions with these main characteristics:

• Automatic management of the connection with the counterpart in the cloud.
• Real-time exchange of messages among sessions and applications.
• Management of messages in off-line mode.
• Handling of remote operations on documents (instances of classes in which database tables are mapped and which manage the records).

Synchronization of document status between off-line databases and cloud back-ends.

The problems you need to solve in these cases derive from the fact that mobile device databases have different limits than server databases. Here are just a few of the aspects that are managed and monitored by using the Instant Developer synchronization framework:

• Which and how much data the device must manage.
• Which entities are managed by which collaborating users.
• When to synchronize the data.
• How to handle a lack of connection.

All of these issues are more common than you might imagine, and often crop up when development is already underway. Thanks to the Instant Developer synchronization framework, you can step in to solve them in a simple way.