MATLAB: Unzipping a gzipped string

databasegzipMATLABsqlitestring

Hello, Currently, we are using PHP to read data from a gzipped, base 64 encoded database and outputting the results which is then read by Matlab and manipulated as needed.

I would like to read the database directly from Matlab. I have no problem reading the database and decoding from Base64. However, I cannot understand how to unzip (uncompress) the string.

In PHP, it is a simple function called 'gzuncompress'. However, in Matlab, the gzip function requires a file, not a string.

Any suggestions would be great. Thanks Keith

Best Answer

You could always call a PHP script from Matlab using the system() call and have it return the uncompressed string.

Related Solutions

MATLAB: Matlab GZIP http postrequest

This example of outrageous hackery does appear to do the job. A bit stinky though...

   myJson = jsonencode(toSend);
    outStream= java.io.ByteArrayOutputStream();
    gzipped = java.util.zip.GZIPOutputStream(outStream);
    gzipped.write( uint8(myJson));
    gzipped.close();
   closedBytes = outStream.toByteArray();
   messageBody.Payload = typecast (closedBytes, 'uint8');
request.Header.addFields(...
        matlab.net.http.field.GenericField('Content-Encoding', 'gzip'), ...
        matlab.net.http.field.ContentTypeField('application/json'))
response = send(request, uri, opts);
% To decode the stream to check ... 
% someStream = java.io.ByteArrayInputStream(typecast( messageBody.Payload , 'int8'));   
%    gzipInStream = java.util.zip.GZIPInputStream( someStream );
%    inReader = java.io.InputStreamReader(gzipInStream, 'UTF-8');
%    

%    aTest = char();
%    
%    data=inReader.read;
%    while data ~=-1
%         aTest = [aTest, char(data)];    
%        data = inReader.read;       
%    end

MATLAB: Does the UPDATE function in Database Toolbox 3.6 (R2009b) sometimes throw errors when used

In Database Toolbox 3.6 (R2009b) the UPDATE function invokes the EXEC function to execute a SQL query string.

The SQL query string must conform to the standard query string.

Typical errors would include

1. Table name mismatch. Cannot use any reserved keywords.

2. Column names mismatch

3. Data type mismatch (i.e. numeric, date, string)

4. SQL query string not having proper single quotes. Most Database toolbox functions require a string input argument for the SQL query string. If the SQL query also contains single quotes, additional single quotes are needed to allow MATLAB to parse the string.

Best Answer

Related Solutions

MATLAB: Matlab GZIP http postrequest

MATLAB: Does the UPDATE function in Database Toolbox 3.6 (R2009b) sometimes throw errors when used

Related Question