Export SQLite database to .mat(.m) file

Hi Guys,

I am new at this forum and I want some help regarding a convert SQLite database into .m(matlab) file for support matlab editor as well that getting easy to understand. Would you please tell me how I convert my database(SQLite) file into .m file ? Is it direct support or shall I create first excel or in other format ?

Thanks in advance!

[Guillaume]

A database (SQLite or other) mostly consists of tables, possibly some stored queries and maybe more.

An .m file consists of program instructions.

The two are not alike. So:

a) Why would you want to convert one to the other?

b) How are you planning to map from one to the other?

[Altaf Shaikh]

Sorry it was my mistake I want to convert this into .mat file instead .m file .

 a) Why would you want to convert one to the other?
      I stored value into Sqlite database and they are calculated in numeric. 
      Actually this file support to third party application.

b) How are you planning to map from one to the other?

I want map this data in below way:

; [Match ID "-509201106"]
; [Player 1 "dummy1"]
; [Player 2 "dummy2"]

    1) 52: 24/22 13/8                    5: 13/3*                         
    2) 43: Bar/22* 13/9                  6: Bar/22 24/21 6/3*(2)          
    3) 43: Bar/21 24/21                  7: 24/16*                        
    4) 66: Cannot Move                   8: 16/11 13/11

[Jan]

The question is not clear. How exactly can the input file be access and what do you want as output file?

Answer 1

[Guillaume]

If you have the database toolbox, importing all rows of a table from an sqlite file is trivial:

conn = sqlite('yourdbfile.db');
tabledata = fetch(conn, 'SELECT * FROM sometable');

You can do that for all the tables, if that's what you mean by converting the database to a mat file. You will, of course, be missing a lot of what constitutes a database, the schema, triggers, views, indexes, etc. which I'm not sure how you'd store in a mat file.

[Altaf Shaikh]

Thanks for your support . I had figured out by creating text file at run time with some mat predefined mapping format.

[Abraham Sherura]

Hey Altaf, do you mind taking me through how you figured it out. I am in the same mix. Trying to export an SQLite database to MATLAB. Thank you