Maverick System mvAPI

Dick Thiot has made his mvAPI C# application available to the multivalue community. It is available for download on GitHub at

It allows a multivalue developer to provide data from a multivalue database to a web page. The solution requires the BlueFinity’s mv.NET product to provide the access to the Multivalue database.

The mvAPI solution handles the HTTP POST and GET requests to call a BASIC subroutine with the ability to pass data to the BASIC subroutine. The solution then will wait for data from the subroutine to return to the webpage.

I created a simple test case using our ForeMost ERP application. It is an Open Order Dashboard. The webpage makes use of some JavaScript libraries to display the data in a table with some additional features.

The BASIC subroutine is very simple. It reads data from our database and formats the data as a JSON string to return to the webpage to be displayed. The webpage calls the BASIC subroutine by using an AJAX call. The returned data is displayed using the jQuery DataTable javascript library to display the data.

The Open Orders are now available to any web browser connecting to the Open Order webpage. The web page can be used for any display of data in a tabular format. There are only a few lines of JavaScript that need to be modified to display data from a different BASIC subroutine.

Many thanks to Dick Thiot of Maverick Systems to make this wonderful C# solution to the multivalue community!

Contact Ashwood Computer, Inc. if you would like to get a copy of the webpage we developed.

5 Reasons MultiValue Beats Relational Databases

Chances are, your business uses some types of relational databases. Since the dawn of the Internet, SQL databases and similar competitors have been dominant forces within the market. Their familiarity is comfortable, but that doesn’t mean they’re better.

MultiValue databases provide some very powerful benefits which you should really consider taking advantage of. MultiValue databases can be considered an type of “NoSQL”, in case you aren’t familiar. This means data is organized neatly into objects, which can contain nested objects. This is much more efficient and logical than the traditional relational database model.

Benefits of MultiValue Databases

1. Efficient Programming

Most popular programming languages mandate object-oriented code. It’s more sensible to work with an object-oriented database model alongside this code.

MultiValue and NoSQL databases are more flexible than relational databases. It is easier to query the data you need, so developers can focus more on creating new value-add features than on ETL.

2. Performance

MultiValue was engineered with high performance and scalability in mind. Queries of a relational database can take an incredibly long time to execute, especially when numerous join statements are included in the query. For practical applications, joins are frequently necessary, since you need to review and analyze data from multiple perspectives.

The object-oriented database structure of MultiValue increases database performance and can also increase application performance, as you’re less likely to need additional data transformation code to get the data into your desired format.

3. Flexible Data Structures

Relational database models generally only support one flattened data structure with tables related to each other. With MultiValue, you can include multiple data structures, which can be chosen based on the ideal format desired.

MultiValue data is dynamic because it can be stored in your database in the exact same format as your application – again, improving performance and simplifying your code base.

4. Scalability

MultiValue is both horizontally and vertically scalable. Growing businesses may frequently need to capture new information. With MultiValue, this is not a difficult problem at all. You can even store data with a different structure in the same collection, whereas in SQL a significant database overhaul is generally required.

5. Simplified Querying

SQL queries can become monsters as you try to combine numerous tables and implement complex query logic. MultiValue querying is significantly streamlined by comparison. Since the data is stored in such a logical, organized manner, querying is a breeze. MultiValue queries are generally much shorter than their SQL counterparts.

And often, MultiValue can accomplish data challenges that are simply impossible in SQL.

Choose MultiValue

You may be reluctant to use MultiValue since so many applications still rely on SQL. However we have numerous examples we can share of integrating our ForeMost ERP solution – which uses a MultiValue database – with traditional relational databases.

We can help you understand why MultiValue may be the answer to your data challenges. Get in touch – we’d love to discuss your business needs with you.