OINO.cloud takes the database schema in your Sql Server, Postgresql or MariaDb/Mysql DBMS and automatically creates a REST API with JSON / CSV support. Your API is always up to date, comes with Swagger-definitions and advanced features like date formatting, sorting, pagination, multipart binary files, hashids, row level caching and much more.
Since OINO.cloud knows your datamodel, it can parse input data for supported columns and knows how to serialize them. Just send the necessary fields or extra ones and OINO.cloud knows to update the correct ones. Or use CSV if it's more convenient.
OINO.cloud comes with template engine and supports standard HTML-forms making it easy to use technologies like HTMX for simple web apps that don't need authentication. You can for example create web forms for data submission like feedback/contact forms or even editing .
Since OINO.cloud generates SQL automatically, it can utilize the most powerful DBMS features like filtering and sorting and pagination out of the box. No more waiting for API-project to deliver basic features in order to deliver customer value.
It's hard to have your data available where it's needed securely. Instead of having the whole database open to the internet you can expose individual APIs just where they are needed. Different access tokens can be created for different clients with appropriate rights and network restrictions.
You can use OINO.cloud and HTML templates to directly embed live data to websites without building complex integrations. Below HTMX is used to fetch a set of database rows that are tranlated using a a template to a HTML table. Radio buttons are same API request with different sorting options updating the rows in TBODY.
| Product Name | Unit Price | Units In Stock | Units On Order |
|---|
OINO.cloud allows you to easily get real time data from any database where you need it like embedded to a website or imported to Excel or PowerBI.
OINO.cloud CSV and JSON output works with typical web data import for data analytics and business intelligence solutions like Excel, PowerBI and Tableau allowing data from any database table to be included in your reports and data desktops.
