NoSQL. Greater flexibility for your integrations!

In today’s integration landscape, APIs form the backbone of many applications. They deliver data in complex JSON structures, often containing deeply nested objects. Until now, this data had to be converted into a two-dimensional SQL structure – a process that is not only time-consuming but can also be prone to errors.

With LiteDB, we can store this JSON data directly and unchanged locally. This means:

• No data loss due to structural transformation
• Direct access to nested properties
• Flexible filtering and sorting options at every level

The use cases are identical to those of the previous offline solution – with one key advantage: LiteDB is optimally tailored for API-based integrations. And not just offline!

LiteDB can also be used in online mode, e.g. if you regularly work with JSON data. API results can be transferred directly into an InMemory LiteDB and processed there with high performance.

LiteDB offers an SQL-like query language that allows you to retrieve your data in a targeted and efficient manner. For example:

1 select $.id, $.firstName + ' ' + $.lastName as name, $.age, $.address.city as city, $.company.title as jobTitle
2 from users 
3 order by $.age

By combining SQLite and LiteDB, the flexmobility platform offers a hybrid data strategy that adapts to your requirements. Whether you’re using traditional table structures or dynamic JSON data – you decide how your data is processed.