Get data from mpr sqlite

1
Hello All, I need to understand how can I get the exact data from the unit table. All the content stored is of blob type. We also have hash keys for it. Can your tell me how will I be able to read the blob data of mendix mpr in any programming language ?   Regards, Shrinivas Deshpande
asked
1 answers
1

For example; I needed the version of a project so I created a Windows batch script in combination of SQLite (https://www.sqlite.org/download.html):

ECHO get version..
@ECHO OFF
FOR %%? IN (*.mpr) DO (
	for /f %%i in ('sqlite3 "%%~f?" "SELECT _ProductVersion FROM _metadata"') do set VERSION=%%i
)

I'm sure you can use SQLite within any programming language 

answered